Overview
Skills
Job Details
Job Title: SCC - Data Warehouse/BI Developer 4 (778616)
Location: Richmond, VA Hybrid (2 days onsite/week; parking not provided)
Employment Type: Contract W2 Only
Interview Mode: Initial Web/Virtual interview; follow-up IN PERSON interview may be required
About the Role:
We are seeking a Data Warehouse/BI Developer 4 to support the SCC division by executing existing metric procedures for statutory and ad hoc reporting, resolving data discrepancies, and developing end-to-end automation frameworks. You will design, validate, document, and implement processes to load vendor-provided and division data, calculate metrics, perform quality checks, and train staff on automation framework usage and maintenance.
Key Responsibilities:
Execute existing metric procedures and data discrepancy resolution.
Develop end-to-end automation frameworks for SQL Server using Microsoft products.
Build, validate, document, and implement processes to load and transform data.
Train division staff on framework use and maintenance.
Create data quality checks and address geography coding issues.
Required Skills & Experience:
Skill | Required / Desired | Years of Experience |
---|---|---|
BS/MS degree in Computer Science, Engineering, or related field | Required | 4 |
Software development/programming experience | Required | 8 |
SQL, SQL Server, Microsoft products | Required | 8 |
ETL development & Microsoft Visual Studio | Required | 8 |
Python & BI tools | Required | 8 |
Project leadership | Required | 8 |
Clear, concise, comprehensive documentation | Required | 8 |
Training team members of varying experience levels | Required | 8 |
Data quality checks creation | Required | 8 |
High-level planning & estimation | Required | 8 |
Strong analytical & attention to detail | Required | 8 |
Effective team collaboration & communication | Required | 8 |
Data analysis & validation | Required | 8 |
Ability to work under pressure & meet deadlines | Required | 8 |
Census Geocoder | Desired | 8 |
API usage | Desired | 8 |