Data Warehouse/BI Developer 3

Mbi Llc

Chesterfield (MO)

On-site

USD 80,000 - 100,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A leading healthcare technology firm is looking for a highly skilled Senior BI Specialist to design, develop, and maintain advanced business intelligence solutions. The role involves extensive work with medical data, ensuring compliance with HIPAA regulations. Ideal candidates will have a strong background in Power BI, T-SQL, SSIS, and dimensional modeling, along with excellent problem-solving and communication skills. This position supports Electronic Health Records (EHR) requests and duties, making it vital for data-driven decision-making across the organization.

Qualifications

  • 5+ years of experience in BI development and data analytics.
  • Proficiency in Power BI (DAX, Power Query, data modeling).
  • Understanding of Microsoft ecosystem (Azure, Excel, etc.).

Responsibilities

  • Design and implement Power BI dashboards and reports.
  • Develop and optimize SQL queries for data retrieval.
  • Collaborate with stakeholders to gather requirements.

Skills

Power BI
SQL Server
SSIS
Dimensional modeling
T-SQL
Data analytics
HIPAA compliance

Education

Bachelor’s degree in computer science or related field

Tools

Azure Data Services
GIT
ADO Pipelines

Job description

- We are seeking a highly skilled Senior BI Specialist to design, develop, and maintain advanced business intelligence solutions that empower data-driven decision-making across the organization.

- The ideal candidate will have deep expertise in Power BI, T‑SQL, SSIS, dimensional modeling, and other Microsoft data tools, with a strong ability to translate complex data into actionable insights.

- Experience working with medical data and ensuring compliance with HIPAA regulations is a significant plus.

- This contractor will primarily support Electronic Health Records (HER) requests and duties.

Key Responsibilities

- Extensive work with medical data including HIPAA compliance requirements.

- Design and implement Power BI dashboards and reports to visualize key business metrics and trends.

- Develop and optimize SQL queries, stored procedures, and views for efficient data retrieval and transformation.

- Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses.

- Apply dimensional modeling techniques to design and maintain scalable data models for analytics.

- Collaborate with stakeholders to gather requirements and deliver BI solutions aligned with business objectives.

- Ensure data integrity, security, and compliance with HIPAA and other regulatory standards when handling sensitive medical data.

- Maintain clean code bases and releases using GIT and ADO Pipelines.

Qualifications

- Bachelor’s degree in computer science, Information Systems, or related field (or equivalent experience).

- 5+ years of experience in BI development and data analytics.

Proficiency in:

- Power BI (DAX, Power Query, data modeling)

- SQL Server (T‑SQL, performance tuning)

- SSIS (ETL design and implementation)

- Dimensional modeling and data warehousing concepts

- Understanding of Microsoft ecosystem (Azure, Excel, etc.).

- Excellent problem‑solving, analytical, and communication skills.

Additional “would likes”

- Knowledge of Azure Data Services (Data Factory, Synapse Analytics).

- Exposure to data governance and security best practices.

Fill the skill matrix below:

Skill

Amount

Candidate's No. of years of experience

Work with medical data including HIPAA compliance requirements

Required

2

Design and implement Power BI dashboards and reports to visualize key business metrics and trends.

Required

5

Develop and optimize SQL queries, stored procedures, and views for efficient data retrieval and transformation.

Required

5

Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses.

Required

5

Apply dimensional modeling techniques to design and maintain scalable data models for analytics

Required

2

Gather requirements and deliver BI solutions aligned with business objectives

Required

2

Maintain clean code bases and releases using GIT and ADO Pipelines

Required

1

  • Apply Now

Fields with * are required

What is your full name?

How can we contact you?

Where are you located?

What is your preferred method of communication?

File Upload: (only PDF, DOC, DOCX are accepted)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Specialist- Local to Richmond, VA only -- W2 ONLY
Business Intelligence Specialist- Local to Richmond, VA only -- W2 ONLY

HCL Global Systems Inc • Richmond (VA)

On-site
USD 90,000 - 120,000
Data Warehouse Engineer
Data Warehouse Engineer

ExpertsHub.ai • Chicago (IL)

On-site
USD 90,000 - 120,000
Business Intelligence (BI) Developer - Temporary Assignment
Business Intelligence (BI) Developer - Temporary Assignment

Health Right 360 • San Francisco (CA)

On-site
USD 120,000 - 170,000
Sr. Business Intelligence Engineer
Sr. Business Intelligence Engineer

Encore Talent Solutions • United States

On-site
USD 90,000 - 120,000
BI Developer
BI Developer

Compunnel Inc. • Pennsylvania

On-site
USD 80,000 - 120,000
Data Engineer / BI Engineer
Data Engineer / BI Engineer

Compunnel Inc. • Providence (RI)

On-site
USD 90,000 - 140,000
Power BI Developer
Power BI Developer

Medasource • United States

On-site
USD 80,000 - 100,000
Sr. Business Intelligence Developer
Sr. Business Intelligence Developer

FTS, Inc. • Herndon (VA)

On-site
USD 100,000 - 130,000
Senior BI Developer: Power BI, SQL & ETL Expert
Senior BI Developer: Power BI, SQL & ETL Expert

Compunnel Inc. • Pennsylvania

On-site
USD 80,000 - 120,000
Senior Data Engineer I
Senior Data Engineer I

Heartland Business Systems • Little Chute (WI)

On-site
USD 90,000 - 120,000