Data Integration and Warehouse Engineer

The Data Integration and Warehouse Engineer develops, maintains, and troubleshoots data integrations, primarily in Informatica Cloud (IICS), and supports multiple database systems for the School of Medicine and Public Health. The person in this role works closely with our data analysts, developers, system administrators, and external partners to help direct the flow of data and ensure consistency for multiple needs. This includes consulting on and supporting the availability of this data to our data visualization platform, applications, websites, and other reporting projects. Strong candidates for this role will have a good technical foundation in building and optimizing data systems, a love of learning, and an ability to develop relationships across reporting lines. Excellent candidates will be able to adapt their communication style for collaboration with technical colleagues, diverse subject matter experts, and leadership, and are excited by what a stable data ecosystem can enable.

The person in this role has primary responsibility for authoring and maintaining ETL/ELT mappings, mapping tasks, and workflows from a wide variety of sources. New or extended data models and integrations are established through working with subject matter experts and key stakeholders to acquire functional domain knowledge and understand evolving business needs. This data integration work includes support of projects addressing data quality issues.

In the data warehouse, this person monitors, responds to, and resolves existing database access and performance issues. This includes reviewing database objects, including views, triggers, stored procedures, and execution time to provide efficiency improvements, and optimizing via tablespace sizing and management. The person in this role will also assist in the initial setup and configuration of a new data warehouse as part of the UW-Madison transition to Workday in July 2025.

Collaboration is key. This person coordinates with System Operations for backups, patches, and upgrades, is expected to establish and maintain effective working relationships with data leaders and administrators from UW campus and UW Health, and collaborates across the breadth of SMPH IT.

The Data Integration and Warehouse Engineer will report to the Data & Analytics IT Director.

Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals.

The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world.

For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion

Preferred
Associate's Degree

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, etc), preferably IICS Data Integration
- Experience with structured and unstructured data
- Experience with cloud data storage (e.g., Snowflake, Redshift)
- Clear & effective written and verbal communication

Additionally required to be considered for level III:
- Demonstrated ability in mentoring colleagues in best practices regarding data use and data integrations
- Examples of a proactive approach to handling data integration issues

Full Time: 100%

It is anticipated this position will be remote and requires work be performed at an offsite, non-campus work location. An on campus location will be provided should a candidate prefer to work partially or fully onsite.

Terminal, 24 month appointment.
This position has the possibility to be extended or converted to an ongoing appointment based on need and/or funding

Minimum $90,000 ANNUAL (12 months)
Depending on Qualifications
The starting salary for this position is $90,000 but is negotiable based on experience and qualifications.

Employees in this position can expect to receive benefits such as generous vacation, holidays, and sick leave; competitive insurances and savings accounts; retirement benefits. Benefits information can be found at (https://hr.wisc.edu/benefits/).

SMPH Academic Staff Benefits flyer: (https://uwmadison.box.com/s/r50myohfvfd15bqltljn0g4laubuz7t0)

University sponsorship is not available for this position, including transfers of sponsorship. The selected applicant will be responsible for ensuring their continuous eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without the need of an employer sponsorship) on or before the effective date of appointment. This position is currently scheduled to end January 26, 2027 and will require eligibility to work until that time. UW-Madison is not an E-Verify employer, and therefore, is not eligible to employ F1 STEM OPT Extension participants. If you are selected for this position you must provide proof of work authorization and eligibility to work.

Applicants for this position will be considered for the titles listed in this posting. The title is determined by the experience and qualifications of the finalist.

To apply for this position, please click on the "Apply Now" button. You will be asked to upload a current resume/CV and a cover letter briefly describing your qualifications and experience.

Cody Roekle
croekle@wisc.edu
608-263-7676
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Technical Integration Eng II(IT042) or Technical Integration Eng III(IT043)

A53-MEDICAL SCHOOL/Informatics and IT

Academic Staff-Terminal

307812-AS