Business Intelligence Intern, Information Technology

Overview

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.

In this role, you will…

• 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

You possess …

• 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

• 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

• 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