Job Position   : DOC - Data Warehouse/BI Developer 3

Job Duration  : 6 Months

Location      : 11351 Business Center Drive North Chesterfield, VA. 23236 (Onsite)

Short Description:

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

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