DATA INTEGRATION AND WAREHOUSE ENGINEER

Salary:

Minimum $80,000 ANNUAL (12 months)
Depending on Qualifications
The minimum pay rate for a Technical Integration Engineer II is $80,000, depending on qualifications.

The minimum pay rate for a Technical Integration Engineer III is $90,000, depending on qualifications.

Job Summary:

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, and system administrators 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, 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 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.

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 Elizabeth Simcock, Analytics Manager.

The Analytics group provides data infrastructure, integration, and reporting to the University of Wisconsin School of Medicine and Public Health (SMPH). We partner with our project stakeholders long-term and have a mindset of continuous process improvement, with goals of improving data literacy and expanding data-informed decision-making. All projects are done with an eye toward future sustainability and sharing of effort across multiple data domains. We also partner closely with both campus and UWHealth in support of both institution-wide and cross-institution data stability. We are looking for a Data Integration and Warehouse Engineer who can play a key role in how educational and administrative data flows and is stored at SMPH. This person will have primary responsibility for our integration platform, Informatica Intelligent Cloud Services (IICS) and our Oracle warehouse.

SMPH is committed to being a diverse, equitable, inclusive and anti-racist workplace and is an Equal Employment Opportunity, Affirmative Action employer. Applications from Black, Indigenous and People of Color (BIPOC) individuals, LGBTQ+ and non-binary identities, women, persons with disabilities, military service members and veterans are strongly encouraged.

Responsibilities:

Technical Integration Engineer III (IT043)
Technical Integration Engineer II (IT042)

Institutional Statement on Diversity:

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

Education:

Preferred
Bachelor's Degree

Qualifications:

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
- 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

Preferred:
- Experience with an enterprise data integration tool like Informatica Intelligent Cloud Services (IICS) Data Integration, Informatica PowerCenter, Mulesoft, Boomi, Talend, etc), especially IICS Data Integration
- Experience with structured and unstructured data
- Experience with cloud data storage (e.g., Snowflake, Azure)
- Clear & effective written and verbal communication

COVID-19 Considerations:

UW-Madison continues to follow necessary health and safety protocols to protect our campus from COVID-19. All employees remain subject to the COVID-19 Workplace Safety Policy: https://policy.wisc.edu/library/UW-5086 . Please visit https://covidresponse.wisc.edu for the most up-to-date information.

Work Type:

Full Time: 100%

This position can be performed fully remote. We have an on campus location should a finalist prefer to work onsite.

Appointment Type, Duration:

Ongoing/Renewable


Additional Information:

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.

The School of Medicine and Public Health will not sponsor work visas for this position, thus, in compliance with federal law, all persons hired will be required to verify eligibility to work in the United States by completing the required I-9 form upon hire.

How to Apply:

Please click on the "" button to start the application process. Please upload a resume and cover letter. In your cover letter, please address your experience with the required and preferred criteria of the position. You will also be asked to provide three professional references, which must include your current or most recent supervisor. We will not contact references without providing you advanced notice.

Contact:

Cody Roekle
croekle@wisc.edu
608-263-7676
Relay Access (WTRS): 7-1-1 (out-of-state: TTY: 800.947.3529, STS: 800.833.7637) and above Phone number (See RELAY_SERVICE for further information. )

Official Title:

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

Department(s):

A530252-MEDICAL SCHOOL/ADMIN/APP&ANALYTICS DEV

Employment Class:

Academic Staff-Renewable

Job Number:

258005-AS



The University of Wisconsin is an Equal Opportunity and Affirmative Action Employer. We promote excellence through diversity and encourage all qualified individuals to apply.

If you need to request an accommodation because of a disability, you can find information about how to make a request at the following website: https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/

Employment will require a criminal background check. It will also require you and your references to answer questions regarding sexual violence and sexual harassment.

The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7).

The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department .

Applications Open: May 20 2022 Central Daylight Time
Applications Close: Jun 12 2022 11:55 PM Central Daylight Time