Data Warehouse/BI Developer

Chesterfield, VA, US • Posted 4 days ago • Updated 4 days ago

Contract Corp To Corp

Contract Independent

Contract W2

No Travel Required

On-site

Depends on Experience

TriosysIT Inc.

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

ADO
DAX
Git
HIPAA
Microsoft SSIS
Microsoft SQL Server
Microsoft Power BI
Extract, Transform, Load
medical data
Data Factory
Synapse Analytics

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91162599
Position Id: BI_796238
Posted 4 days ago

Company Info

About TriosysIT Inc.

At TriosysIT, we provide affordable staffing solutions to all businesses to meet their IT staffing requirements. Our highly-trained and experienced professional staff can help your organization connect with exceptional IT professionals.

We provide various types of employees, including independent contractors, contract-to-hire and permanent placements. TriosysIT's dedicated recruiting department can meet your organization’s needs.

What Makes Us Unique

Our woman-owned minority business is built around three principles: Commitment, Performance and Results. We use these to guide the organization and allow it to provide superior IT project development and staffing services. This includes project managers, technical architects, developers and infrastructure support staff.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.