PL
DOC - Data Warehouse/BI Developer 3
PeopleNTech LLC
🇺🇸 United States
On-site
Senior
7 months ago
- Power BI
- T-SQL
- SSIS
- HIPAA
- SQL
- ETL
- Git
- ADO
- DAX
- Power Query
- Data Modeling
- Azure
- Excel
7 months ago
Virginia Information Technology Agency
Title/Role: DOC - Data Warehouse/BI Developer 3
Req. Status: Open
No. of Openings: 1
Start Date: 03/02/2026
End Date: 09/01/2026
Max Submittals by Vendor: 2 Per Opening
Worksite Address: 11351 Business Center Drive North Chesterfield, Va. 23236
Agency Interview Type: In Person Only
Work Arrangement: Onsite
Short Description:
Senior Business Intelligence (BI) Specialist 100% ONSITE - NO REMOTE WORK and in-person interview only.
Max Vendor Rate - 81.09.
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.
- 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.
- Knowledge of Azure Data Services (Data Factory, Synapse Analytics).
- Exposure to data governance and security best practices.
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
DOC - Data Warehouse/BI Developer 3 · PeopleNTech LLC