Overview
On Site
$$80/hr on C2C or $70/hr on W2
Contract - W2
Contract - To 2025-09-30
Skills
Power BI
Data Visualization
Data modeling
Dashboard Development
Teradata Cloud
Business Objects XI
ETL Processes
Collaboration with Developers and End Users
AFCARS
NCANDS)
Data Warehouse Design
Federal Reporting (NYTD
SACWIS/CCWIS System Integration
SQL Query Optimization
Reporting Solutions
Data Extraction and Transformation
Database Documentation
Training and User Support
Microsoft Windows Server 2012
BI Application Development
Child Welfare Data Reporting
Job Details
Job Title: Data Warehouse Architect
Location: Michigan (Hybrid 2 days onsite weekly)
Interview Type: Virtual via MS Teams (screenshot required; vendor must attend start of interview)
Location: Michigan (Hybrid 2 days onsite weekly)
Interview Type: Virtual via MS Teams (screenshot required; vendor must attend start of interview)
Local Candidates Only: Must currently reside in Michigan
Job Description:
- Collaborate with State and vendor developers to ensure SACWIS/CCWIS system databases support DW needs
- Design, model, and load the Child Welfare Data Warehouse to support analytic/reporting needs
- Implement changes to the DW schema based on operational system evolution
- Support and train internal State teams to maintain and extend the DW environment
- Perform BI application development using Teradata and Business Objects/Power BI
- Create dashboards, reports, and visualizations to support data-driven decision making
- Develop and enhance ETL pipelines to consolidate data from various operational sources
- Assist federal reporting and business users in query development and optimization
- Provide one-on-one and group training to DTMB developers and end-users
Skill Matrix:
| Skill | Experience |
|---|---|
| Teradata Cloud | 3+ years |
| Business Objects XI and/or Power BI | 3+ years |
| ETL Processes | 3+ years |
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.