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

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

Business Intelligence Intern, Information Technology

Key skills