OPT Business Intelligence Intern Jobs
Business Intelligence Intern roles on OPT involve building dashboards, writing SQL queries, and translating data into actionable insights for business teams. Most positions qualify under STEM OPT, giving you up to 36 months of work authorization. CPT experience in data analytics or visualization tools strengthens your application significantly.
See All OPT Business Intelligence Intern JobsOverview
Showing 5 of 17+ 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 OPT Business Intelligence Intern Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new OPT Business Intelligence Intern Jobs.
Get Access To All JobsTips for Finding OPT Sponsorship as a Business Intelligence Intern
Lead with your technical stack
List SQL, Tableau, Power BI, or Python prominently in your resume summary. Hiring managers screen BI intern resumes by tool proficiency first. Matching the exact tools listed in the job description increases your chance of passing automated filters.
Quantify your academic or CPT project outcomes
Frame past work in measurable terms: dashboard adoption rates, query runtime improvements, or revenue insights surfaced. Concrete numbers demonstrate analytical thinking and make your resume stand out against candidates with similar tool experience.
Target employers with established data teams
Companies with dedicated BI or analytics functions are more likely to have OPT sponsorship experience. Mid-size and enterprise companies in finance, retail, and healthcare consistently hire BI interns and are familiar with OPT work authorization requirements.
Address OPT timing proactively in outreach
Mention your authorization period and STEM extension eligibility early in conversations. Employers unfamiliar with OPT often assume work authorization is complicated. A brief, confident explanation removes hesitation before it becomes a reason to pass.
Build a portfolio with real data outputs
Publish a sample dashboard or data analysis on GitHub or Tableau Public. BI hiring managers want to see how you visualize and communicate data. A visible portfolio removes doubt about your technical capability and compensates for limited work history.
Apply to roles explicitly open to OPT candidates
Use Migrate Mate to filter for Business Intelligence Intern positions where employers are already familiar with OPT authorization. This saves time and puts your application in front of companies actively willing to work with F-1 students.
Business Intelligence Intern OPT: Frequently Asked Questions
Do Business Intelligence Intern roles qualify for STEM OPT extension?
Most Business Intelligence Intern positions qualify for the 24-month STEM OPT extension because they fall under CIP codes related to Computer Science, Information Systems, or Statistics. Your degree field determines eligibility, not just the job title. Confirm your degree's CIP code with your DSO before accepting an offer, and verify the employer is E-Verify enrolled, which is required for STEM OPT.
Can I start a Business Intelligence Intern role before my OPT EAD card arrives?
No. You cannot begin work until your EAD card is in hand and your OPT start date has passed. Apply for OPT at least 90 days before your intended start date to avoid delays. If a hiring timeline is tight, communicate your EAD status early so the employer can plan accordingly. Starting work without a valid EAD violates your F-1 status.
What happens to my OPT if the Business Intelligence Internship ends early?
If your internship ends before your OPT period expires, you enter an unemployment period. F-1 students on standard OPT are allowed a maximum of 90 days of unemployment. On STEM OPT, that limit is 150 days total across the full extension. Report any job changes or unemployment periods to your DSO promptly to stay in compliance with your F-1 status.
Where can I find Business Intelligence Intern jobs that are open to OPT students?
Migrate Mate is built specifically for F-1 OPT students and lists Business Intelligence Intern roles from employers familiar with OPT work authorization. Searching general job boards often means filtering through postings that exclude candidates requiring sponsorship, which wastes time. Migrate Mate surfaces roles where your OPT status is not a disqualifier from the start.
Is a part-time Business Intelligence Internship allowed on OPT?
Yes. OPT allows both full-time and part-time employment as long as the role is directly related to your field of study. Part-time work counts toward your authorized period and also counts toward the unemployment cap if you work fewer than 20 hours per week. Confirm your DSO's definition of part-time compliance and document the job's connection to your degree in writing.