DOC - Data Warehouse/BI Developer 3

Studio 12 LLC

Richmond, VA

JOB DETAILS
SKILLS
Alliance/Partner Management, Business Intelligence, Change Management, Communication Skills, Data Analysis, Data Mart, Data Modeling, Data Profiling, Data Quality, Data Warehousing, Database Administration, Database Design, Database Extract Transform and Load (ETL), Dimensional Modeling, Engineering, Git, Loading/Unloading, Microsoft SQL Server, Microsoft Visual Studio, Power BI, Precision Testing, Reporting Dashboards, SQL Server Integration Services (SSIS), Source Code/Configuration Management (SCM), Star Schema, Stored Procedures, Tableau, Validation Testing
LOCATION
Richmond, VA
POSTED
3 days ago
805681 DOC DW BI Developer
Contract role

A Data Warehouse Developer who can self manage, partner with BSAs and PMs, and translate business needs into actionable, analytics ready data solutions. This role requires strong data engineering skills in SQL Server, data modeling using Kimball methodologies, and hands on development of data marts, SSIS ETL pipelines, and data flow design ***umentation. The developer must be able to deep-dive profile source systems, design and implement database projects in Visual Studio, manage code in GIT, and validate data accuracy through testing. Experience building dashboards is helpful but secondary.
This role is ideal for someone who thrives in a self directed environment, communicates clearly with both technical and non technical partners, and takes pride in delivering clean, well modeled, well tested data.

Key Responsibilities:

- Data profiling — Analyze and understand source systems to determine data availability, quality, and extraction logic.
- Data modeling — Design dimensional models and star schemas to support analytics and reporting needs.
- Data flow design — Produce clear, detailed mapping ***uments that translate business rules into technical specifications.
- SQL Server data mart development — Build and optimize tables, views, stored procedures, and indexes.
- Visual Studio database projects — Create and maintain database projects for versioned, repeatable deployments.
- GIT source control — Manage code changes, branching, and collaboration workflows.
- SSIS ETL development — Build, schedule, and monitor ETL packages to load data marts reliably and efficiently.
- Data validation testing — Ensure accuracy, completeness, and alignment with business rules.
- Dashboard/report creation (nice to have) — Build basic dashboards or visualizations using tools such as Power BI or Tableau.

Skills Matrix:
 SkillRequired / DesiredMin Yrs Exp RequiredActual Years ExpYear Last Used
 Data profilingRequired5  
 Data modelingRequired5  
 SQL Server data mart developmentRequired5  
 SSIS ETL developmentRequired5  
 Source ControlRequired3  
 Dashboard/report creationDesired3  

About the Company

S

Studio 12 LLC