Data Warehouse Developer Iii - Madison - ref. h50910819

apartmentGoli Tech placeMadison calendar_month1/6/25

Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).

Qualifications:

Job Summary:

The Data Warehouse Developer will assist in the initial setup, configuration and modeling of a new data warehouse in Redshift or Snowflake for the School of Medicine and Public Health. The person in this role will work closely with our data warehouse team, BI developers, software engineers and external partners to build our new academic and administrative data warehouse (AADW) as part of the UW-Madison transition to Workday in July 2025.

The Data Warehouse Developer will report to the Director for Data Analytics.

Responsibilities:

50% Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation
30% Design, develop, and maintain relational databases for data storage and data mining.
15% Assist internal database team with initial data transfers into new warehouse.
5% Seek continuous improvement in performance of data warehouse and ensure security of data.

Required:

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 development, maintenance, and auditing/logging

Preferred:

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., Snowflake, Redshift)
Experience with data virtualization platform (e.g., Denodo)
Clear & effective written and verbal communication

Education:

Associate's or Bachelor's Degree preferred.

Required Skills : ETL,Data Warehouse

Basic Qualification :

Additional Skills : Data Modeler,Data Warehouse Engineer

This is a high PRIORITY requisition. This is a PROACTIVE requisition

Background Check : No

Drug Screen : No

thumb_up_altRecommended

[ref. r8673304] Project Manager III

apartmentRandstadplaceMadison

job summary: Under the general direction of the Data Warehouse and Decision Support (DWDS) Director, this position provides project management, scrum master and leadership services for the DWDS team. Technologies the team currently uses or planned...

starFeatured

Project Manager III (138534)

apartmentEXOS (formerly Sondhi Solutions)placeMadison

SummaryUnder the general direction of the Data Warehouse and Decision Support (DWDS) Director, this position provides project management, scrum master and leadership services for the DWDS team. Technologies the team currently uses or planned to use...

electric_boltImmediate start

Lead Data Modeler - Madison - ref. y3387419

placeMadison

logical and physical data models that support business intelligence, reporting, and advanced analytics within the health insurance domain. • Build and maintain data transformation pipelines within the analytics environment of the enterprise data warehouse...