Data Warehouse BI Developer
Job Location:
Job Location:
Richmond, VA - USA
Monthly Salary:
Not Disclosed
Monthly Salary:
Posted on:
Yesterday
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Direct End Client: Satet of Virginia Department of Corrections (DOC)
Job Title: Data Warehouse/BI Developer 3
Duration: 08/01/2026 01/29/2027
Location: 6900 Atmore Drive Richmond VA 23225
Hours Per Week: 40
Interview Type: In Person Only
Ceipal ID: SVASQL681SN
Duration: 08/01/2026 01/29/2027
Location: 6900 Atmore Drive Richmond VA 23225
Hours Per Week: 40
Interview Type: In Person Only
Ceipal ID: SVASQL681SN
Job Code: 805681
Scope of Project:
The Virginia Department of Corrections (DOC) is seeking a Data Warehouse/BI Developer who can self-manage collaborate with Business Systems Analysts (BSAs) and Project Managers (PMs) and transform business requirements into analytics-ready data solutions. The ideal candidate will have strong SQL Server data engineering expertise dimensional modeling experience using Kimball methodologies and hands-on experience developing data marts SSIS ETL pipelines and data flow design documentation.
Responsibilities:
Analyze and profile source systems to determine data availability quality and extraction logic.
Design dimensional data models and star schemas to support analytics and reporting requirements.
Create detailed data flow and mapping documents that translate business requirements into technical specifications.
Develop and optimize SQL Server tables views stored procedures and indexes for data mart solutions.
Create and maintain Visual Studio database projects for version-controlled and repeatable deployments.
Manage source code branching and collaboration workflows using GIT.
Design develop schedule and monitor SSIS ETL packages.
Perform data validation and testing to ensure data quality completeness and business rule compliance.
Assist with dashboard and report development using Power BI Tableau or similar BI tools.
Work effectively with both technical and non-technical stakeholders.
Design dimensional data models and star schemas to support analytics and reporting requirements.
Create detailed data flow and mapping documents that translate business requirements into technical specifications.
Develop and optimize SQL Server tables views stored procedures and indexes for data mart solutions.
Create and maintain Visual Studio database projects for version-controlled and repeatable deployments.
Manage source code branching and collaboration workflows using GIT.
Design develop schedule and monitor SSIS ETL packages.
Perform data validation and testing to ensure data quality completeness and business rule compliance.
Assist with dashboard and report development using Power BI Tableau or similar BI tools.
Work effectively with both technical and non-technical stakeholders.
Required/Preferred Skills:
Data Profiling Required 5 Years
Data Modeling Required 5 Years
SQL Server Data Mart Development Required 5 Years
SSIS ETL Development Required 5 Years
Source Control (GIT) Required 3 Years
Dashboard/Report Creation Desired 3 Years
Data Modeling Required 5 Years
SQL Server Data Mart Development Required 5 Years
SSIS ETL Development Required 5 Years
Source Control (GIT) Required 3 Years
Dashboard/Report Creation Desired 3 Years
V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector Enterprise Solutions Professional Services Ecommerce Projects and Products. Within Public Sector business unit we cater IT Professional Services to Federal State and Local. We have multiple awards/ contracts with 30 states including but not limited to NY CA FL GA MD MI NC OH OR CO CT TN PA TX VA NM VT and WA.
If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
