STEM OPT Business Intelligence Engineer Jobs
Business Intelligence Engineer roles in data warehousing, ETL pipeline development, and analytics platforms qualify for the STEM OPT extension, giving you up to 24 additional months of work authorization beyond your initial OPT. Your employer must be enrolled in E-Verify, and your degree must align with an approved STEM CIP code to qualify.
Find STEM OPT Business Intelligence Engineer JobsOverview
Showing 5 of 89+ Business Intelligence Engineer jobs
See all 89+ Business Intelligence Engineer Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new Business Intelligence Engineer roles.
Get Access To All JobsJob Title: SQL Database and Business Intelligence Developer II
Department: Information Technology
Reports To: Senior SQL Database and Business Intelligence Developer
FLSA: Exempt
Status: Full-Time
Grade: 12
Position Description And Scope
The SQL Database and Business Intelligence Developer II is responsible for the development, testing, implementation and support of Microsoft SQL-based relational databases. The databases are used to collect and analyze data gathered through the Authority’s custom web applications that are both internal and client-facing. This position is also responsible for developing and supporting data sets and visualizations utilizing various business intelligence and reporting platforms. This position will ensure the database is well maintained, scalable and available to all users. This position will also administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database and Business Intelligence Developer II will participate in the full development life cycle to meet the objectives of the MSBA.
Essential Functions And Responsibilities
- Design, develop, test, and implement changes and enhancements to SQL Databases as required
- Maintain and develop OLAP reporting data schemas and provide support for BI visualizations and dashboards as assigned, using various BI reporting platforms including, but not limited to, Tableau and Power BI
- Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows
- Maintain and implement database objects, including tables, views, keys, indexes, constraints, defined types, functions, stored procedures, etc
- Code stored procedures of high complexity to meet product requirements
- Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
- Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various issues as they arise
- Maintain and manage database schemas, SQL agent jobs and user’s roles with proper permissions
- Troubleshoot database performance issues to ensure optimizations in system designs
- Manage code migration to various environments according to software development life cycle
- Maintain and write comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents
- Support the operational strategies and priorities of the Authority
- Able to independently work with internal stakeholders to identify, gather business requirements, propose analytical report solutions and implement the proposed solutions
- Troubleshoot and resolve outages from existing applications
- Maintain quality service through IT policies and standards
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; benchmarking state-of-the-art practices; participating in professional societies
- Perform other duties as assigned
Required Knowledge And Skills
- Four-year degree in technical discipline and 5+ years of relevant professional experience in SQL database development and BI reporting
- Strong SQL Server 2016 (and above) and BI reporting tools such as Tableau and Power BI in a large-scale production environment
- Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Strong knowledge of relational and dimensional data modeling
- Highly experienced in writing and optimizing database scripts, SQL stored procedures, functions and other SQL database objects that assist in the implementation and maintenance of business logic and data flows through MSBA data and application infrastructure
- Experience analyzing and driving reporting requirements to design and implement complex static and dynamic BI reporting and ad-hoc query reports
- Experience in code migration, database change management and data management through the various stages of the development lifecycle
- Thorough understanding with hands-on skills of MS SQL Server 2016 (and above) and SSRS Server installation and configurations. Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
- Work with our team members and in-house QA to resolve bugs and issues
- Follow proper application, operations, standards, policies and procedures. Ensure that the integrity and consistency of company databases is maintained
- Experience with versioning control environments including Azure DevOps and/or GIT
- Strong communication skills and the ability to work both independently and as part of a team
- Excellent analytical, technical, problem solving and project management skills with ability to coordinate complex projects with competing priorities and deadlines
- Professional interpersonal style; ability to work and build trust with a diverse range of people
- Ability to work in an Agile environment
- Ability to work creatively, learn quickly and solve complex problems in high-pressure situations
- Exhibit a professional ‘can-do’ attitude and flexible work style approach
- Ability and willingness to proactively research and/or resolve issues
Preferred Knowledge And Skills
- Relevant Microsoft Certifications
- Masters in technical discipline
- Experience in Database Design and administration
- Experience with cloud-based solutions
- Experience with VB.Net, ASP.Net and C#
- Experience with network/storage architecture
This job description is intended to be general and will evolve over time. The description is subject to periodic updating. At management’s discretion, the employee may be assigned different or additional duties from time to time.
Job Title: SQL Database and Business Intelligence Developer II
Department: Information Technology
Reports To: Senior SQL Database and Business Intelligence Developer
FLSA: Exempt
Status: Full-Time
Grade: 12
Position Description And Scope
The SQL Database and Business Intelligence Developer II is responsible for the development, testing, implementation and support of Microsoft SQL-based relational databases. The databases are used to collect and analyze data gathered through the Authority’s custom web applications that are both internal and client-facing. This position is also responsible for developing and supporting data sets and visualizations utilizing various business intelligence and reporting platforms. This position will ensure the database is well maintained, scalable and available to all users. This position will also administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database and Business Intelligence Developer II will participate in the full development life cycle to meet the objectives of the MSBA.
Essential Functions And Responsibilities
- Design, develop, test, and implement changes and enhancements to SQL Databases as required
- Maintain and develop OLAP reporting data schemas and provide support for BI visualizations and dashboards as assigned, using various BI reporting platforms including, but not limited to, Tableau and Power BI
- Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows
- Maintain and implement database objects, including tables, views, keys, indexes, constraints, defined types, functions, stored procedures, etc
- Code stored procedures of high complexity to meet product requirements
- Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
- Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various issues as they arise
- Maintain and manage database schemas, SQL agent jobs and user’s roles with proper permissions
- Troubleshoot database performance issues to ensure optimizations in system designs
- Manage code migration to various environments according to software development life cycle
- Maintain and write comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents
- Support the operational strategies and priorities of the Authority
- Able to independently work with internal stakeholders to identify, gather business requirements, propose analytical report solutions and implement the proposed solutions
- Troubleshoot and resolve outages from existing applications
- Maintain quality service through IT policies and standards
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; benchmarking state-of-the-art practices; participating in professional societies
- Perform other duties as assigned
Required Knowledge And Skills
- Four-year degree in technical discipline and 5+ years of relevant professional experience in SQL database development and BI reporting
- Strong SQL Server 2016 (and above) and BI reporting tools such as Tableau and Power BI in a large-scale production environment
- Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Strong knowledge of relational and dimensional data modeling
- Highly experienced in writing and optimizing database scripts, SQL stored procedures, functions and other SQL database objects that assist in the implementation and maintenance of business logic and data flows through MSBA data and application infrastructure
- Experience analyzing and driving reporting requirements to design and implement complex static and dynamic BI reporting and ad-hoc query reports
- Experience in code migration, database change management and data management through the various stages of the development lifecycle
- Thorough understanding with hands-on skills of MS SQL Server 2016 (and above) and SSRS Server installation and configurations. Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
- Work with our team members and in-house QA to resolve bugs and issues
- Follow proper application, operations, standards, policies and procedures. Ensure that the integrity and consistency of company databases is maintained
- Experience with versioning control environments including Azure DevOps and/or GIT
- Strong communication skills and the ability to work both independently and as part of a team
- Excellent analytical, technical, problem solving and project management skills with ability to coordinate complex projects with competing priorities and deadlines
- Professional interpersonal style; ability to work and build trust with a diverse range of people
- Ability to work in an Agile environment
- Ability to work creatively, learn quickly and solve complex problems in high-pressure situations
- Exhibit a professional ‘can-do’ attitude and flexible work style approach
- Ability and willingness to proactively research and/or resolve issues
Preferred Knowledge And Skills
- Relevant Microsoft Certifications
- Masters in technical discipline
- Experience in Database Design and administration
- Experience with cloud-based solutions
- Experience with VB.Net, ASP.Net and C#
- Experience with network/storage architecture
This job description is intended to be general and will evolve over time. The description is subject to periodic updating. At management’s discretion, the employee may be assigned different or additional duties from time to time.
See all 89+ STEM OPT Business Intelligence Engineer Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new STEM OPT Business Intelligence Engineer Jobs.
Get Access To All JobsTips for Finding STEM OPT Authorization as a Business Intelligence Engineer
Verify your CIP code before applying
Pull your degree's CIP code from your I-20 and cross-reference it against the STEM Designated Degree Program List published by USCIS. Computer Science, Information Systems, and Statistics codes typically qualify for BI Engineer roles, but Data Analytics programs vary by institution.
Confirm E-Verify enrollment before accepting offers
Ask your recruiter for the employer's E-Verify Company ID or look up their participation status through the E-Verify employer search. A company that isn't enrolled can't legally sign your I-983 training plan, which voids your extension eligibility entirely.
Align your I-983 training goals to BI deliverables
When drafting your I-983, map each learning objective to specific BI outputs: dashboard builds, data model design, or SQL pipeline work. DSOs flag vague training plans, and a well-structured I-983 tied to real project milestones speeds DSO approval significantly.
Target employers with active DOL LCA filings for BI roles
Search Migrate Mate to filter employers by verified DOL Labor Condition Application filings in BI-related SOC codes. Employers with recent LCA history for data or analytics roles have already navigated STEM OPT hiring and are far less likely to withdraw offers over authorization complexity.
Check prevailing wage requirements for your target market
Use the OFLC Wage Search to look up the prevailing wage for your SOC code and the metro area where the role is based. BI Engineer salaries vary sharply by region, and knowing the DOL wage floor helps you identify whether an offer is structured to support future H-1B visa sponsorship.
Use O*NET to substantiate your specialty occupation argument
Pull the O*NET occupation profile for Business Intelligence Analysts or Data Engineers and note the listed education requirements. This documentation strengthens your case if an employer's HR team questions whether your BI role qualifies as a specialty occupation for cap-gap or H-1B transition purposes.
Frequently Asked Questions
Does a Business Intelligence Engineer role qualify for the STEM OPT extension?
Yes, provided two conditions are met. First, your degree must be listed on the STEM Designated Degree Program List maintained by USCIS, which includes most Computer Science, Information Systems, Engineering, and Statistics programs. Second, the BI Engineer role must directly relate to your degree field. Your DSO makes the final determination when approving your I-983 training plan.
What E-Verify requirement applies to my STEM OPT employer?
Your employer must be actively enrolled in E-Verify before you begin STEM OPT employment. This isn't optional. If they enroll after you start, the extension is still invalid for that period. Confirm enrollment before signing an offer by asking for the company's E-Verify Company ID, or verify their status directly through E-Verify's employer search tool.
How do I find Business Intelligence Engineer jobs where employers are already set up for STEM OPT?
Browse Business Intelligence Engineer listings on Migrate Mate, which filters employers by verified E-Verify enrollment and DOL Labor Condition Application filing history. Targeting employers with existing LCA filings in data and analytics roles means the hiring team has already worked through STEM OPT paperwork and won't need to build the process from scratch around your offer.
What should my I-983 training plan include for a BI Engineer position?
Your I-983 must describe specific training goals tied to your BI work, not just your job title. List concrete deliverables such as building dimensional data models, developing ETL pipelines, or designing executive dashboards. Each goal should connect back to your STEM degree field. Your employer's supervisor signs off on the plan, and your DSO reviews it before authorizing the extension.
What happens to my work authorization if my STEM OPT expires while an H-1B petition is pending?
If your employer filed an H-1B petition on your behalf before your STEM OPT end date and the petition is still pending, cap-gap protection extends your OPT authorization through September 30 of that fiscal year. If the H-1B is selected and approved, your status transitions on October 1. USCIS publishes cap-gap guidance each registration cycle confirming the specific conditions that apply.