DOC Data WarehouseBI Developer 3

Chesterfield County, VA - USA

Monthly Salary: Not Disclosed

Posted on: 11 hours ago

Vacancies: 1 Vacancy

Job Summary

Senior Business Intelligence (BI) Specialist 100% ONSITE - NO REMOTE WORK and in-person interview only.

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

Bachelors 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.

Required/Desired Skills

Skill	Required /Desired	Amount	of Experience
Work with medical data including HIPAA compliance requirements	Required	2	Years
Design and implement Power BI dashboards and reports to visualize key business metrics and trends.	Required	5	Years
Develop and optimize SQL queries stored procedures and views for efficient data retrieval and transformation.	Required	5	Years
Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses.	Required	5	Years
Apply dimensional modeling techniques to design and maintain scalable data models for analytics	Required	2	Years
Gather requirements and deliver BI solutions aligned with business objectives	Required	2	Years
Maintain clean code bases and releases using GIT and ADO Pipelines	Required	1	Years

Questions

No.	Question
Question1	Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment
Question2	Please list candidates email address.
Question3	What city and state is your candidate currently located
Question4	Does your candidate agree to work on site and understand this is NOT a remote role
Question5	Does your candidate agree to interview in person

Senior Business Intelligence (BI) Specialist 100% ONSITE - NO REMOTE WORK and in-person interview only. 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. T...