Business Intelligence Intern, Information Technology
ServiceLink IP Holding Company, LLC, Plano, TX, United States
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.
A DAY IN THE LIFE
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
WHO YOU ARE
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
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
Qualifications
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
#J-18808-Ljbffr
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
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
WHO YOU ARE
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
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
Qualifications
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
#J-18808-Ljbffr