CPT Business Intelligence Jobs
Business Intelligence roles, covering data warehousing, dashboard development, and analytics engineering, qualify for CPT when your program includes coursework in data management, SQL, or applied analytics. Your DSO must authorize each position individually, and the work must connect directly to your degree curriculum, not just your career goals.
See All CPT Business Intelligence JobsOverview
Showing 5 of 22+ Business Intelligence jobs
Have you applied for this role?
Have you applied for this role?
Have you applied for this role?
Have you applied for this role?
Have you applied for this role?
See all Business Intelligence Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new Business Intelligence roles.
Get Access To All JobsINTRODUCTION
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
INTRODUCTION
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
See all CPT Business Intelligence Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new CPT Business Intelligence Jobs.
Get Access To All JobsBusiness Intelligence CPT: Frequently Asked Questions
Does a Business Intelligence internship qualify for CPT?
Yes, if the role connects directly to your degree curriculum and your DSO approves it. A BI internship covering SQL, data visualization, or analytics engineering typically qualifies when your program includes coursework in those areas. The position must be a required or elective component of your curriculum, not just professionally relevant, your DSO makes that determination based on your specific program.
Can I do full-time CPT for a Business Intelligence role during the academic year?
Yes, but full-time CPT during the academic year requires your DSO's approval and carries a consequence: 12 months or more of full-time CPT eliminates your OPT eligibility. Part-time CPT, defined as 20 hours per week or fewer, doesn't affect OPT. Most BI employers who hire CPT students during the semester structure the role as part-time to protect students' post-graduation options.
What documentation does a BI employer need to verify my CPT authorization?
Your employer needs a copy of your CPT-authorized I-20, which lists the employer name, position title, and authorization dates. Some employers also request your current visa stamp and I-94 record. The employer-facing requirement is straightforward, the authorization lives entirely on your I-20, so there's no separate USCIS filing or employer petition required for CPT.
How do I find Business Intelligence jobs where employers are comfortable with F-1 CPT?
Search Business Intelligence roles on Migrate Mate, which surfaces employers with documented F-1 hiring history. Companies that have sponsored F-1 students before, particularly those enrolled in E-Verify or with active H-1B visa LCA filings in data and analytics roles, process CPT onboarding without the back-and-forth that comes from employers unfamiliar with F-1 work authorization.
Does the SOC code for my BI role affect my CPT or OPT eligibility?
The Standard Occupational Classification code matters most for OPT, not CPT. For STEM OPT extension purposes, BI roles typically fall under SOC codes 15-1211 (Computer Systems Analysts) or 15-2051 (Data Scientists), both of which appear on the DHS STEM Designated Degree Program list. Confirm your employer's intended SOC code before signing an offer if you plan to use STEM OPT after CPT. You can cross-reference job duties against O*NET occupation profiles to validate the classification.