Summary
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 (EHR) requests and duties.Key ResponsibilitiesExtensive 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.QualificationsBachelor's degree in computer science, Information Systems, or related field (or equivalent experience).5+ years of experience in BI development and data analytics.Proficiency inPower BI (DAX, Power Query, data modeling)SQL Server (T‑SQL, performance tuning)SSIS (ETL design and implementation)Dimensional modeling and data warehousing conceptsUnderstanding 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.Experience RequirementsWork with medical data including HIPAA compliance requirements – 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 requirements and deliver BI solutions aligned with business objectives – 2 Years required.Maintain clean code bases and releases using GIT and ADO Pipelines – 5 Years required.#J-18808-Ljbffr
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 (EHR) requests and duties.Key ResponsibilitiesExtensive 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.QualificationsBachelor's degree in computer science, Information Systems, or related field (or equivalent experience).5+ years of experience in BI development and data analytics.Proficiency inPower BI (DAX, Power Query, data modeling)SQL Server (T‑SQL, performance tuning)SSIS (ETL design and implementation)Dimensional modeling and data warehousing conceptsUnderstanding 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.Experience RequirementsWork with medical data including HIPAA compliance requirements – 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 requirements and deliver BI solutions aligned with business objectives – 2 Years required.Maintain clean code bases and releases using GIT and ADO Pipelines – 5 Years required.#J-18808-Ljbffr
Government Careers
Government jobs offer stability, competitive benefits, and the chance to make a meaningful impact on your community and country.
Whether you’re starting your career or seeking new opportunities, these roles provide pathways for growth, security, and service.
Explore positions across a wide range of fields and take the first step toward a rewarding future in public service.
MORE JOBS
-
Combination Commercial Inspector I
- Charlottesville, Virginia
- ALBEMARLE COUNTY, VA
- Nov 17, 2026
-
Group Exercise Instructor
- Charlottesville, Virginia
- ALBEMARLE COUNTY, VA
- Nov 10, 2026
-
Commercial Plans Reviewer
- Charlottesville, Virginia
- ALBEMARLE COUNTY, VA
- Nov 10, 2026
-
Residential Combination Inspector I
- Charlottesville, Virginia
- ALBEMARLE COUNTY, VA
- Nov 10, 2026
-
$80,000–$90,000 - 90,000 Annually
Senior Accountant - City of Williamsburg, VA
- Williamsburg, Virginia
- City of Williamsburg, VA
- Nov 09, 2026
-
$140,000–$160,000 - 160,000 Annually
Deputy Director of Finance - City of Williamsburg, VA
- Williamsburg, Virginia
- City of Williamsburg, VA
- Nov 09, 2026