Data Warehouse BI Developer

Date Posted: 02/19/2026
Hiring Organization:
Rose International
Position Number: 497264
Industry: Government/Staffing

Job Title:

Data Warehouse BI Developer

Job Location:

North Chesterfield, VA, USA, 23236
Work Model:
Onsite

Shift: Regular Business Hours

Employment Type:

Temporary
FT/PT:
Full-Time
Estimated Duration (In months): 7
Min Hourly Rate($): 60.00
Max Hourly Rate($): 65.00
Must Have Skills/Attributes:
Data Warehouse, Power

BI, SQL Server, SSIS
Experience Desired:
State/Federal Government exp is highly desired (2 yrs)

Preferred Education:

Bachelor’s Degree
C2C is not available

PREFERRED EDUCATION/

EXPERIENCE:

• 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
• Work with medical data including HIPAA compliance requirements: 2 Years
• Design and implement Power BI dashboards and reports to visualize key business metrics and trends: 5 Years
• Develop and optimize SQL queries, stored procedures, and views for efficient data retrieval and transformation: 5 Years
• Build and maintain ETL processes using SSIS to integrate data from multiple sources into data warehouses: 5 Years
• Apply dimensional modeling techniques to design and maintain scalable data models for analytics: 2 Years
• Gather requirements and deliver BI solutions aligned with business objectives: 2 Years
• Maintain clean code bases and releases using GIT and ADO Pipelines: 1 Years

• Knowledge of Azure Data Services (Data Factory, Synapse Analytics)
• Exposure to data governance and security best practices

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.

• 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
• Only those lawfully authorized to work in the designated country associated with the position will be considered.
• Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex,…