Data Warehouse/BI Developer 3

- 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)