BI Analyst Jobs
BI Analyst jobs are open across finance, healthcare, retail, and technology, from entry-level to senior and lead, with specializations in data visualization, SQL-based reporting, and product analytics. Find a role that fits from the openings below and apply directly.
Find BI Analyst JobsOverview
Showing 5 of 440+ BI Analyst jobs
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.
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 440+ BI Analyst Jobs
Jump back to the full list of openings and apply to any BI analyst role that fits.
Find BI Analyst JobsBI Analyst Job Market
A snapshot from current openings nationwide, updated as new roles post.
Who's Hiring
- Amazon25
- Garces, Grabler & LeBrocq12
- Cornerstone Research9
- Dana-Farber Cancer Institute9
- Geisinger9
Top Industries Hiring
- Technology & Software89
- Healthcare & Medical Services59
- Biotechnology & Pharmaceuticals33
- Consulting & Professional Services33
- Education20
What Employers Look For
The qualifications that appear most often in BI analyst jobs.
- Proficiency in SQL for querying and transforming relational data
- Experience building dashboards and reports in Tableau, Power BI, or Looker
- Ability to translate business questions into data models and analytical frameworks
- Bachelor's degree in a quantitative field such as statistics, computer science, or economics
- Familiarity with cloud data warehouses such as Snowflake, BigQuery, or Redshift
- Experience presenting data findings and recommendations to non-technical stakeholders
Tips for Your BI Analyst Job Search
Tailor your resume to the stack
BI Analyst job postings vary widely by tool. One role wants Power BI and DAX, another wants Tableau and Looker. Mirror the exact tools listed in each posting on your resume so applicant tracking systems flag you as a match.
Quantify your dashboard impact
Don't just list dashboards you built. Name the business question each one answered and the decision it drove. Hiring managers for bi analyst roles care about whether your work changed how teams operated, not how many reports you produced.
Apply early to roles that fit
Migrate Mate lists bi analyst openings from across the United States in one place, so you can find roles that match and apply directly to each listing.
Target postings by data maturity
A startup bi analyst role usually means building reporting infrastructure from scratch. An enterprise role usually means working within an existing data warehouse. Read job descriptions for signals like 'greenfield,' 'self-serve analytics,' or 'existing BI platform' to find environments that fit your strengths.
Prepare a SQL problem for the technical screen
Most bi analyst technical interviews include a live SQL exercise, not just a portfolio review. Practice writing window functions, CTEs, and aggregations under time pressure. Interviewers often care as much about how you think through the query as whether you get the exact syntax right.
Negotiate scope, not just compensation
After an offer, ask which teams you'll partner with and whether you'll have access to raw data or only pre-modeled tables. These details define your day-to-day far more than job title, and they're negotiable before you sign.
BI Analyst Jobs: Frequently Asked Questions
Which companies are hiring the most bi analysts?
The companies hiring the most bi analysts right now include Amazon, Garces, Grabler & LeBrocq, and Cornerstone Research, with the largest share of openings in California, New York, and Washington, based on current listings on Migrate Mate as of June 2026. Demand is consistently strong in financial services, healthcare systems, and enterprise software companies.
How many bi analyst jobs are remote?
About 29% of bi analyst openings are fully remote or hybrid as of June 2026, making it one of the more flexible roles in the data field. Positions focused on self-serve reporting and dashboard maintenance tend to be the most remote-friendly, while roles that require close collaboration with embedded business teams more often require in-office presence.
How do you become a bi analyst?
Start by building fluency in SQL and at least one visualization tool such as Tableau or Power BI, since those are the core technical requirements in nearly every job posting. Work through real datasets on public repositories to build a portfolio of dashboards that answer genuine business questions. A degree in a quantitative field helps, but a strong portfolio with demonstrated SQL skills often carries more weight in interviews than credentials alone.
Can you get hired as a bi analyst with little experience?
Yes, entry-level bi analyst roles exist, but they require demonstrable technical skills even without professional experience. Build two or three end-to-end projects where you pull raw data, clean it, model it, and publish a dashboard with a written summary of your findings. Roles with titles like junior bi analyst or reporting analyst are the most accessible starting points and often grow quickly into full bi analyst responsibilities.
What does the bi analyst interview process look like?
Most bi analyst interview processes include a recruiter screen, a hiring manager conversation focused on your past projects and business impact, a technical assessment involving SQL queries or a take-home dashboard exercise, and a final round with stakeholders or the data team. Some companies also ask you to present your take-home work live and walk through your reasoning, so be ready to explain every decision in your analysis.
Where can I find and apply to bi analyst jobs?
You can find and apply to bi analyst jobs on Migrate Mate, which lists current openings from across the United States. Find roles that match your skills and experience level, then apply directly to each listing that fits.
See All 440+ BI Analyst Jobs
Jump back to the full list of openings and apply to any BI analyst role that fits.
Find BI Analyst Jobs