STEM OPT Business Intelligence Intern Jobs
Business Intelligence Intern roles qualify for STEM OPT when your degree is in a STEM-designated field such as computer science, data science, statistics, or information systems. Your employer must be enrolled in E-Verify, and the 24-month STEM OPT extension gives you up to 36 months total to build analytics experience while on F-1 status.
See All Business Intelligence Intern JobsOverview
Showing 5 of 15+ Business Intelligence Intern 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 Intern jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new Business Intelligence Intern 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 Business Intelligence Intern jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new Business Intelligence Intern roles.
Get Access To All JobsTips for Finding STEM OPT Authorization as a Business Intelligence Intern
Verify your CIP code before applying
Pull your degree's Classification of Instructional Programs code from your transcript or DSO and cross-check it against the DHS STEM Designated Degree Program List. Business analytics and applied statistics degrees qualify; general business administration degrees typically don't.
Filter job listings by E-Verify status
Before spending time on any application, confirm the employer is actively enrolled in E-Verify. A company can claim E-Verify participation without current enrollment, so check directly through the E-Verify employer search tool rather than relying on job posting language.
Target companies with active BI tool contracts
Employers using Tableau, Power BI, or Databricks at scale have dedicated analytics teams, meaning they've hired BI interns before and understand OPT paperwork. Look for job descriptions that list specific platform certifications rather than generic 'data skills.'
Draft your I-983 training plan around BI deliverables
Your I-983 must connect your STEM degree to specific job duties. Map coursework in SQL, statistical modeling, or data warehousing directly to intern projects like dashboard builds or ETL pipeline work. Vague training plans are the most common STEM OPT compliance failure.
Use Migrate Mate to reach pre-screened BI employers
Search Business Intelligence Intern roles on Migrate Mate, where every listing is filtered for E-Verify enrollment and STEM OPT eligibility. You skip the step of manually verifying employer compliance before each application.
Benchmark prevailing wages before negotiating your offer
Look up the SOC code for Business Intelligence Analysts on the OFLC Wage Search to see the Level I prevailing wage in your metro area. Your internship offer should meet or exceed this figure, and knowing the number before negotiating puts you in a stronger position.
Business Intelligence Intern jobs are hiring across the US. Find yours.
Find Business Intelligence Intern JobsFrequently Asked Questions
Does a Business Intelligence Intern role qualify for STEM OPT?
Yes, if your degree is in a STEM-designated field such as computer science, data science, statistics, mathematics, or information systems. The role itself must involve applying STEM knowledge directly, which BI work typically satisfies through data modeling, statistical analysis, and programming. Confirm your specific degree's CIP code against the DHS STEM Designated Degree Program List before submitting your STEM OPT extension application to your DSO.
Does my employer need to be enrolled in E-Verify to hire me as a STEM OPT intern?
Yes. E-Verify enrollment is a hard requirement for all STEM OPT employers, not just a recommendation. You must confirm enrollment before accepting an offer, because starting work at a non-enrolled employer voids your STEM OPT authorization. You can verify enrollment directly through the E-Verify employer search. Migrate Mate filters all Business Intelligence Intern listings for active E-Verify enrollment so you don't have to check manually.
What goes into the I-983 training plan for a BI internship?
The I-983 requires you and your employer to document how the position applies your STEM degree. For a BI intern, that means connecting specific coursework, such as database management, statistical modeling, or data visualization, to concrete job tasks like building dashboards, writing SQL queries, or supporting ETL pipelines. USCIS expects a clear line between your academic training and the actual work, so generic descriptions of 'data analysis' without degree-level specificity are a common reason DSOs send I-983s back for revision.
Can I stay authorized if my OPT expires while an H-1B petition is pending for me?
Yes, through cap-gap protection. If your employer files an H-1B petition before your OPT EAD expires and you're selected in the lottery, your F-1 status and work authorization automatically extend through September 30 of that year. Your EAD card will show an earlier expiration date, but USCIS cap-gap rules cover the gap. Carry your OPT EAD, your I-20 with the cap-gap endorsement from your DSO, and your H-1B receipt notice as a combined authorization package.
How do I find Business Intelligence Intern roles that are open to STEM OPT students?
Search on Migrate Mate, which surfaces BI intern listings specifically filtered for STEM OPT eligibility and E-Verify enrollment. Standard job boards show all open roles regardless of work authorization compatibility, so you end up applying to positions where the employer isn't set up to hire OPT students. Targeting pre-screened listings saves weeks of back-and-forth with recruiters who don't understand STEM OPT requirements.
See which Business Intelligence Intern employers are hiring and sponsoring visas right now.
Search Business Intelligence Intern Jobs