Data Warehouse Developer , 12 Months, Richmond , VA (Onsite) , Client : State of Virginia

[Kiran Abhavannagari]

Hi,

 

Please find my direct client job requirement for your consideration.

 

Title: Data Warehouse Developer (IN person interviews only)

Location: Richmond, VA (Onsite)

Duration : 12 Months

Client : State of Virginia  

 

Job Description:

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 documentation. 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 documents 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:

Skill	Required / Desired	Amount	of Experience

 

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

Required

3

Years

 

Dashboard/report creation

Desired

3

Years

If Interested, please provide me below information:

·      Full Name:

·      Email ID:

·      Phone Number:

·      SSN last 4:

·      Address:

·      Availability:

·      Availability for Interview:

·      Visa Status:

·      Passport no:

·      LinkedIn ID:

·      Visa Expiry date (MM/DD/YYYY):

·      Relocation:

·      Rate:

Professional Reference :1

·   Full Name :        

·   Company Name :            

·   Title :    

·   Telephone :       

·   Email id :

 

 

Kiran

Serenity Infotech, Inc.

950 Scales Road, Suwanee, Georgia 30024

Email: ki...@serenityinfotech.com

P Reduce, Reuse and Recycle. Go GREEN and please consider our environment before printing this email.