Lead Business Intelligence Engineer

Apex Systems; Missouri; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical benefits

401K with company match

ESPP (employee stock purchase program)

HSA (Health Savings Account)

EAP with counseling

Job summary

Apex Systems is seeking two Lead Business Intelligence Engineers to augment our reporting and analytics team. You will design, develop, and maintain enterprise Power BI dashboards and semantic models across Healthcare Quality, HEDIS, Pharmacy, and Medical Claims initiatives.

Lead the development of scalable reporting solutions, optimize DAX and SQL, and collaborate with data engineering to leverage Snowflake.

Qualifications

• Bachelor's degree required.
• Advanced Power BI development and DAX optimization.
• Data modeling with dimensional modeling and star schema design.
• Advanced SQL development and query optimization.
• Experience with large-scale analytical data warehouses.
• Experience with HEDIS/Quality reporting and Pharmacy (Rx) and Medical Claims data.
• Healthcare payer environment experience preferred.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and semantic models for Healthcare Quality, HEDIS, Pharmacy, and Medical Claims initiatives.
• Extend existing analytic products and translate stakeholder requirements into scalable reporting solutions.
• Develop and optimize DAX, SQL, and data models for performance.
• Collaborate with data engineering teams to leverage Snowflake and other enterprise data sources.
• Support testing, deployments, issue resolution, and ongoing improvements.
• Provide technical leadership, code reviews, and best practices to team members.
• Deliver high-quality reporting and analytics solutions on schedule.
• Build scalable, performant Power BI assets.

Skills

Power BI development

DAX optimization

Dimensional modeling

SQL development

Data warehousing concepts

Healthcare data analytics

Education

Bachelor's degree

Tools

Power BI

SQL

Snowflake

Job description

Lead Business Intelligence Engineer

Apex Systems is hiring a Lead Business Intelligence Engineer for a large Healthcare client.

Location: Fully remote anywhere in the US - you must be Authorized to work in the United States without sponsorship.

Role Overview

We are seeking two Lead Business Intelligence Engineers to augment our reporting and analytics team. In this role, you will be instrumental in increasing the team's delivery capacity across a growing portfolio of Power BI and analytics initiatives. You will support active project delivery, reporting modernization, and stakeholder demand by designing, developing, and maintaining enterprise reporting and analytics solutions.

Key Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and semantic models supporting Healthcare Quality, HEDIS, Pharmacy (Rx), and Medical Claims initiatives.
• Extend existing analytic products and partner with business stakeholders to gather requirements and translate them into scalable reporting solutions.
• Develop and optimize DAX, SQL, and data models for performance.
• Collaborate with data engineering teams to leverage Snowflake and other enterprise data sources.
• Support testing, deployments, issue resolution, and ongoing enhancements.
• Provide technical leadership, code reviews, and best practices guidance to team members.
• Deliver high-quality reporting and analytics solutions on schedule.
• Build scalable, performant, and maintainable Power BI assets.

Required Qualifications

Education: A Bachelor's degree is required.

Technical Skills

• Advanced Power BI development and architecture, including advanced DAX, mixed semantic models, and performance optimization.
• Proficiency in data modeling, including dimensional modeling and star schema design.
• Advanced SQL development and query optimization.
• Experience with large-scale analytical data warehouses.
• Experience with HEDIS/Quality reporting and Pharmacy (Rx) and Medical Claims data.
• Familiarity with provider, member, and measure-based reporting.

Preferred Qualifications

• Power BI certification is preferred.
• Experience with Snowflake is preferred.
• Experience within a healthcare payer environment is preferred.

Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our "Welcome Packet" as well, which an Everforth Apex team member can provide.

If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at [email protected] or 804-523-8228. Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered.

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

4400 Cox Road Suite 200 Glen Allen, Virginia 23060

Everforth Apex Systems is part of the Commercial Segment of Everforth, Inc.