DOC - Data Warehouse/BI Developer 3

Role: Senior Business Intelligence Specialist

Work location: North Chesterfield, VA

Duration: 6 Months

Scope of Work:

Client is 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. The candidate 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.

Required Skills:

• Work with medical data while ensuring compliance with HIPAA regulations (2+ years required)
• Design and implement Power BI dashboards and reports to visualize key business metrics and trends (5+ years required)
• Develop and optimize SQL queries, stored procedures, and views for efficient data retrieval and transformation (5+ years required)
• Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses (5+ years required)
• Apply dimensional modeling techniques to design and maintain scalable data models for analytics (2+ years required)
• Gather business requirements and deliver BI solutions aligned with organizational objectives (2+ years required)
• Maintain clean, well-documented codebases and manage releases using Git and Azure DevOps (ADO) Pipelines (1+ year required)