The State of Wisconsin - UW MADISON is looking for a Data Warehouse Developer III

Project Details: We are looking to pursue a short-term engagement (3-6 months for 30-40 hours a week) to have someone help us with the initial setup, configuration and modeling of a data warehouse in Redshift or Snowflake and work with our internal team to do some initial data transfers to that environment.

Top Skills & Years of Experience:

5+ years of experience in the following

\- Experience in multi-system data integration

\- Experience with data integration through extract, transform, load (ETL) & ELT patterns

\- Experience with data modeling and relational database design

\- Experience with data warehouse architecture, maintenance, and auditing/logging

Nice to Have:

\- Experience with enterprise data integration tools (e.g., Informatica Intelligent Cloud Services

(IICS) Data Integration, Informatica PowerCenter, dbt) preferably IICS Data Integration

\- Experience with structured and unstructured data

\- Experience with cloud data storage (e.g., Redshift, Snowflake)

\- Experience with data virtualization platform (e.g., Denodo)

\- Clear & effective written and verbal communication

Interview Process: First round spark hire video questions (online video answer interview program), final round full committee.

Contract Duration: Through 6/30/2025 with the possibility of extension.

Onsite or Remote? Candidate must be a CURRENT WI resident or willing to relocate. 100% remote allowed in the State of Wisconsin.

Full job description attached