Business Intelligence Intern
Location
United States
Posted
28 days ago
Salary
0
Seniority
Entry Level
No structured requirement data.
Job Description
Business Intelligence Intern
ServiceLink
Role Description Are you highly motivated and looking to build deep technical expertise through hands-on, real-world data engineering and analytics work? Our Business Intelligence team is seeking a highly technical intern to support a critical modernization initiative focused on migrating legacy SSRS reports to a cloud-based data lake and modern semantic models. This internship is designed for students who want to strengthen skills in data modeling, SQL development, report migration, and analytics architecture, rather than end-user reporting or business-facing analysis. The intern will work closely with experienced BI engineers on well-defined migration and design tasks that are critical to the scalability and future-state analytics platform. If you are excited about learning modern BI architecture and contributing to foundational technical initiatives, we encourage you to apply. A Day in the Life - Support the migration of legacy SSRS reports to a data lake-centric analytics architecture - Analyze existing SSRS report logic, stored procedures, datasets, and dependencies - Re-create report logic using SQL, data lake structures, and modern semantic models - Design and implement semantic layers (Power BI datasets, tabular models, or equivalent) optimized for reuse and performance - Assist with data model normalization, star schema design, and metric standardization - Validate migrated reports and datasets for data accuracy, performance, and completeness - Document source-to-target mappings, transformation logic, and modeling standards - Collaborate primarily with BI engineers and architects; limited to no direct business user interaction - Gain hands-on experience with enterprise BI modernization initiatives - Apply academic knowledge to large-scale, real-world data systems Qualifications - Undergraduate Junior, Senior, or Graduate status in Computer Science, Information Systems, Data Analytics, or related field - Strong interest in data engineering, analytics platforms, and BI architecture - Solid understanding of SQL, including joins, aggregations, and query optimization - Familiarity with relational data models and dimensional modeling concepts - Exposure to or interest in data lakes, analytics platforms, or cloud data services - Experience with Power BI, SSRS, or other reporting tools (academic or internship experience acceptable) - Strong analytical and problem-solving skills - A desire to work on focused, independent technical projects - Attention to detail and commitment to data quality and design best practices Responsibilities - Inventory and analyze existing SSRS reports, data sources, and queries - Translate report logic and calculations into data lake–based SQL models - Design and build semantic datasets to support modern reporting and analytics - Refactor complex SQL and reporting logic for performance and scalability - Support testing and validation of migrated datasets and reports - Create clear technical documentation for data models and migration decisions - Participate in a structured intern capstone project focused on BI modernization - Attend regular team check-ins to track progress and remove technical blockers Requirements - Undergraduate Junior, Senior, or Graduate Student; IT, Computer Science, Data, or Engineering majors preferred - Strong SQL and analytical skills - Basic understanding of data modeling and reporting concepts - Comfortable working independently with clearly defined technical tasks - Working knowledge of Microsoft Office Suite - Ability to document technical work clearly - Ability to manage time effectively and meet deadlines - Ability to work in a fast-paced technical environment
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Developer Jobs
Senior Business Intelligence Developer
Mercy CorpsMercy Corps is on a mission to relieve suffering, oppression, and poverty through the development of communities that are safe, productive, and fair. Since 1979
Title: Senior Business Intelligence Developer - US or UK Location: Various, United States Department: Business Development and Fundraising Job Description: Description Location: US or UK - flexible home base Position Status: Regular, Full Time, Exempt Salary: - US: Starting salary for this role will be from $90,000 USD to $110,000 USD annually- commensurate with experience. - UK: Starting salary will be from £63,840 - commensurate with experience - Applications closing date: Please submit application including CV and cover letter by April 27th Risk Level: ☐ Level 3 ☐Level 2 X Level 1 Level 1: Likely to have no contact with participants or sensitive data) About Mercy Corps The Department: Private Giving & Engagement (PG&E) The Private Giving & Engagement (PG&E) department advances Mercy Corps’ strategic priorities by raising private funds, building meaningful relationships with supporters, and strengthening the organization’s global profile and influence. PG&E partners closely with teams across Mercy Corps to deliver innovative, ethical, and effective fundraising and engagement strategies. Within PG&E, Development Operations plays a critical role in enabling fundraising success by ensuring strong systems, sound governance, and effective operational support. The team brings together expertise in fundraising operations, compliance, analytics, systems, and project management to support high-performing fundraising teams across regions and channels. The Position The Senior Business Intelligence Developer supports and expands PG&E’s business intelligence solution(s), which includes a custom SQL Server-based data warehouse (on-premises) and a suite of reports in SQL Server Reporting Services (SSRS) and Microsoft Power BI. They play a critical role in all phases of the solution’s lifecycle, including requirements gathering, data analysis and modeling, data warehouse development, ETL design and maintenance, integrating data from disparate data sources, developing and deploying reports and dashboards. As our analytics’ needs evolve, we anticipate opportunities to streamline and modernize our environment. The Senior BI Developer will help assess improvement areas within our current architecture, optimize performance, and strengthen documentation to support future scalability and long-term data strategy. The role focuses on developing the insights, reports, and semantic models that enable analysis of fundraising performance, constituent behavior, and gift trends, with occasional use of exploratory and predictive techniques. This position engages regularly with stakeholders to understand reporting needs and validate results. Ultimately, the Senior BI Developer helps ensure the reporting and analysis needed to guide and support PG&E’s fundraising strategy and decision-making. The ideal candidate thrives in a collaborative, relationship-driven environment and brings structure, clarity, and best practices while remaining flexible and responsive to evolving business needs. Essential Responsibilities SQL development in a production environment - Develop, test and document stored procedures, views, tables, indexes, constraints, functions and T-SQL scripts. - Prepare clear and comprehensive technical documentation Interview stakeholders about reporting needs - Work regularly with the Director of Fundraising Data & Analytics and team members to identify new reports and updates, to existing ones, clearly communicate requirements and changes, and design, test, and validate report outputs. Develop and maintain standardized reports using Microsoft’s SQL Server Reporting Services and Microsoft Power BI - Create scheduled and on-demand reports for a self-service environment, support legacy MDX while focusing new development on Power BI tabular models and DAX. - Expand, assess, and maintain the SQL Server data warehouse and SSIS-based ETL processes, including improving performance, streamlining legacy workflows, and strengthening documentation Data quality and integrity - Work closely with the Donor Database Manager, Online Database Developer and Manager, and Development Operations Manager to identify data anomalies and broken business rules and support data integrity and cleanup processes. - Ensure that personally identifiable data and data analytics practices are aligned with Mercy Corp’s Responsible Data Policy. - Cross-train in essential functions to ensure business continuity. - Collaborate with the IT Department to ensure that marketing technical strategy aligns with the broader enterprise roadmap. - Development and maintain OLAP cubes as needed. - Other duties as requested or required. Supervisory Responsibility None. Accountability Reports Directly To: Director of Fundraising Data & Analytics Works Directly With: PG&E Team, Online Database Developer and Manager, IT Team, Database Manager, Development Operations Manager. Accountability to Participants and Stakeholders Mercy Corps team members are expected to support all efforts toward accountability, specifically to our program participants, community partners, other stakeholders, and to international standards guiding international relief and development work. We are committed to actively engaging communities as equal partners in the design, monitoring and evaluation of our field projects. Minimum Qualification & Transferable Skills - Bachelor’s degree or equivalent professional experience. - Demonstrated knowledge of data warehousing, database management, reporting development, data cleansing, ETL and data analysis, preferably in a non-profit fundraising environment. - Demonstrated success using T-SQL or MySQL to support data warehousing and reporting - Projects, (ideally 5+ years). - Demonstrated technical competency (ideally 3+ years) with Microsoft SQL Server 2016, including Analysis Services, Integration Services, and Reporting Services (SSAS, SSIS, SSRS) and Power BI. - Demonstrated success (ideally 2+ years) developing customized reports in Microsoft SQL Server Reporting Services and Microsoft Power BI, including multi-dimensional reports with drill-down capability. - Knowledge of The Raiser’s Edge ideal; non-profit experience preferred. - 3+ years of experience with fundraising data or other comparably complex data. - Strong written and verbal communication skills; including the ability to communicate effectively with team members of varied work styles. - Proven ability to handle confidential materials and sensitive information. - Python experience is a plus. Success Factors The successful candidate will be a highly motivated self-starter who is deeply curious about fundraising and the questions fundraisers ask. They bring an investigative and analytical approach to data and fundraising strategy and are comfortable engaging with colleagues to explore bigger questions and translate business needs into technical solutions. They can translate technical concepts into clear, accessible insights for fundraisers and non-technical colleagues, ensuring that data is understandable and actionable. The ideal candidate thrives in a collaborative, relationship-driven environment and communicates effectively with team members across varied work styles. They bring structure, clarity, and best practices to their work while remaining adaptable in a setting where needs and priorities evolve. An even temperament, a proactive and solutions-oriented approach to problem-solving, and a collaborative mindset are appreciated. Awareness of and sensitivity to multicultural and international development contexts are valued. Living Conditions / Environmental Conditions The position is remote. Ongoing Learning In support of our belief that learning organizations are more effective, efficient and relevant to the communities we serve, we empower all team members to dedicate 5% of their time to learning activities that further their personal and/or professional growth and development Team Engagement and Effectiveness Achieving our mission starts with how we build our team and collaborate. By bringing together individuals with a variety of experiences, backgrounds, and perspectives, we strengthen our ability to solve complex challenges and drive innovation. We foster a culture of trust and respect, where every team member is valued for their contributions, empowered to reach their full potential, and motivated to do their best work. We recognize that building a strong and effective team is an ongoing process, and we remain committed to learning, improving, and growing together. Equal Employment Opportunity Mercy Corps is an equal opportunity employer committed to providing equal employment opportunities to all employees and qualified applicants for employment without regard to race, color, sex, sexual orientation, religion or belief, national origin, age, disability, marital status, veteran status, or any other characteristics protected under applicable law. Safeguarding & Ethics Mercy Corps is committed to ensuring that all individuals we come into contact with through our work, whether team members, community members, program participants or others, are treated with respect and dignity. We are committed to the core principles regarding prevention of sexual exploitation and abuse laid out by the UN Secretary General and IASC and have signed on to the Interagency Misconduct Disclosure Scheme. We will not tolerate child abuse, sexual exploitation, abuse, or harassment by or of our team members. As part of our commitment to a safe and inclusive work environment, team members are expected to conduct themselves in a professional manner, respect local laws and customs, and to adhere to Mercy Corps Code of Conduct Policies and values at all times. Team members are required to complete mandatory Code of Conduct elearning courses upon hire and on an annual basis. As an applicant, if you witness or experience any form of sexual misconduct during the recruitment process, please report this to Mercy Corps Integrity Hotline ([email protected]). As a safeguarding measure, Mercy Corps screens all potential US-Based employees. This is done following the conclusion of recruitment and prior to assuming full employment. Our screening process is designed to be transparent and completed in partnership with new Team Members. You will have the opportunity to disclose any prior convictions at the conclusion of the recruitment process before the check is initiated. We ask that you do not disclose any prior convictions in your application materials or during the recruitment process.
Senior Commercial Claims Adjuster - General Liability and Auto BI
Arthur J. Gallagher & Co.Arthur J. Gallagher & Co., also known as Gallagher, is a Fortune 500 insurance company and a leading provider of risk management, insurance brokerage, and HR and benefits consultin
Title: Senior Commercial Claims Adjuster- General Liability and Auto BI Location: Rolling Meadows United States $66,000.00 - $94,500.00 Fully Remote Worker Job Description: Introduction At Gallagher Bassett, we're there when it matters most because helping people through challenging moments is more than just our job, it's our purpose. Every day, we help clients navigate complexity, support recovery, and deliver outcomes that make a real difference in people's lives. It takes empathy, precision, and a strong sense of partnership-and that's exactly what you'll find here. We're a team of fast-paced fixers, empathetic experts, and outcomes drivers - people who care deeply about doing the right thing and doing it well. Whether you're managing claims, supporting clients, or improving processes, you'll play a vital role in helping businesses and individuals move forward with confidence. Here, you'll be supported by a culture that values teamwork, encourages curiosity, and celebrates the impact of your work. Because when you're here, you're part of something bigger. You're part of a team that shows up, stands together, and leads with purpose. Overview Role specifics: - Jurisdictions: Any - Licenses: Any - Location: This position is fully remote. How you'll make an impact - Apply claims management experience to execute decision-making to analyze claims exposure, plan the proper course of action, and appropriately resolve claims. - Interact extensively with various parties involved in the claim process to ensure effective communication and resolution. - Provide exceptional customer service to our claimants on behalf of our clients exhibiting empathy through each step of the claims process - Handle claims consistent with clients' and corporate policies, procedures, and standard methodologies in accordance with statutory, regulatory, and ethics requirements. - Document and communicate claim activity timely and efficiently, supporting the outcome of the claim file. About You Ideal candidates for this position will have: - Claims Background: Commercial General Liability BI and Auto BI - Jurisdictional Experience: Any - Active Adjusters' licenses: Any As a key member of our experienced Claims Adjuster team, you will: - Investigate, evaluate, and resolve complex General Liability and Auto BI claims with moderate supervision, engaging your analytical skills to make decisions and bring claims to resolution. - Work in partnership with our clients to deliver innovative solutions and enhance the claims management process - Think critically, solve problems, plan, and prioritize tasks to optimally serve clients and claimants Required Qualifications: - High School Diploma. - Minimum of 5 years related claims experience. - Appropriately licensed and/or certified in all states in which claims are being handled. - Knowledge of accepted industry standards and practices. - Computer experience with related claims and business software. Desired Qualifications: - Bachelor's Degree - Retail Claims - Property Damage Claims - Bodily Injury Claims- Auto and GL - Litigation Management - Contractual Indemnification, Risk Transfer, Tenders #LI-WG1 Compensation and benefits We offer a competitive and comprehensive compensation package. The base salary range represents the anticipated low end and high end of the range for this position. The actual compensation will be influenced by a wide range of factors including, but not limited to previous experience, education, pay market/geography, complexity or scope, specialized skill set, lines of business/practice area, supply/demand, and scheduled hours. On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the minimum core benefits you'll get, depending on your job level these benefits may improve: - Medical/dental/vision plans, which start from day one! - Life and accident insurance - 401(K) and Roth options - Tax-advantaged accounts (HSA, FSA) - Educational expense reimbursement - Paid parental leave Other benefits include: - Digital mental health services (Talkspace) - Flexible work hours (availability varies by office and job function) - Training programs - Gallagher Thrive program - elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing - Charitable matching gift program
BI Developer
Universities of WisconsinPart of the Universities of Wisconsin, the University of Wisconsin - Madison is a public research university located in Madison, Wisconsin. Also known as UW-Mad
Collaborate with stakeholders to gather requirements and develop scalable reporting solutions. Design and maintain data visualization dashboards while ensuring alignment with data governance standards to support informed decision-making and educational...
Senior Business Intelligence Lead
NatusNatus has been working in collaboration with clinicians to deliver industry-leading neuro solutions that help providers more easily make sense of the body’s signals. Engineered with input from those who have lived the care experience, our technology simplifies complex processes and improves accuracy and efficiency.
Role Description Natus Medical Inc. is seeking a Senior Business Intelligence Lead to provide technical leadership in translating business requirements into scalable system solutions. This role will lead our analytics transformation with a strong focus on Microsoft Power BI and Microsoft Fabric. It is a critical position responsible for transitioning from legacy BI platforms (including OBIEE) to a modern, Fabric-first data and analytics architecture. The ideal candidate will partner closely with stakeholders across Sales, Service, and Finance to deliver scalable, executive-ready insights by integrating data from Oracle EBS and Salesforce into Power BI and Microsoft Fabric. Key Responsibilities - Lead the design and delivery of Power BI dashboards and enterprise analytics solutions - Drive adoption and implementation of Microsoft Fabric (Lakehouse, Warehouse, Data Pipelines, OneLake) - Define and execute the BI modernization strategy, including migration from OBIEE - Integrate data from Oracle EBS and Salesforce into unified Fabric-based data models - Enable AI-driven insights using Microsoft Copilot within Power BI and Fabric - Provide technical leadership, establish BI standards, and mentor team members Qualifications - 10+ years of experience in Business Intelligence / Data Analytics, including leadership roles - Deep expertise in Microsoft Power BI (DAX, data modeling, performance tuning) - Hands-on experience implementing Microsoft Fabric in production environments - Strong SQL expertise, particularly with Oracle EBS - Proven ability to deliver impactful analytics solutions across Sales, Service, and Finance Requirements - Expected annual base salary: $160,000 CAD - This role may also be eligible for a company bonus or commission plan, as applicable to the position - Canadian work experience is not required - Automated or artificial intelligence–assisted tools may be used in the screening or assessment of applicants - Candidates who participate in an interview will be advised whether a hiring decision has been made within 45 days of the final interview, in accordance with applicable law Benefits - Comprehensive healthcare package starting on the first day of employment - Paid statutory holidays - 3 weeks’ vacation and 7 sick days - RRSP Match - Tuition reimbursement program eligibility - And more... EEO Statement Natus Medical is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, veteran status, disability, sexual orientation, gender identity, or any other protected status. This posting is for an existing vacancy. Accessibility Natus is committed to creating an inclusive environment that accommodates all individuals, including those with disabilities. We support the goals of the Accessibility for Ontarians with Disabilities Acts (AODA) and have established policies, procedures, and practices which adhere to the accessibility standards set out in the AODA. Should you require any accommodation throughout the recruitment process please do not hesitate to contact our Human Resources Department.



