Job ID: 128536

Position: Data Warehouse Architect 3

Duration: 12 months Contract

Location: Lansing, MI (Locals Only)

Note from the client:

Interview Process: In-person interview required. Vendor required to upload screenshot picture of candidate if interview is requested.

Interview Process: 1st round of interviews will be virtual via MS Teams video. Please use a laptop and be prepared so share screen if asked. 2nd round of interviews will be conducted in person. Candidates must be able to attend a face-to-face interview

Candidate must be available for onsite from DAY 1 in Lansing, MI there will be HYBRID work model i.e. candidate is required to work 2 days from office & 3 days remote!!!

Top Skills & Years of Experience:

. 6 Years creating Data Warehouse BI applications including ETL/data mart development, reporting, dashboards and other information analysis and delivery system.

. Experience with the State of Michigan PMM/SUITE/Agile methodology.

Experience troubleshooting on all ETL processes and effectively resolve any issues.

. SQL Assistant/Teradata Studio Experience

. Experience in Data Replication using tools like Oracle Golden Gate

. End user training experience.

Description: The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications located on the State of Michigan's Teradata Data Warehouse platform. The position will represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects. In addition, the position will work with other data warehouse developers to review existing data warehouse policies and practices, modify them as needed, or propose new polices or practices.

This position is part of Michigan Department of Health and Human Services (DHHS) Data Warehouse Team. Knowledge of SQL, Business Intelligence tools, and experience with the relational database is required to help develop and maintain DHHS data warehouse ETL and queries.