Data Integration and Warehouse Engineer

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, 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.Responsibilities:Technical Integration Engineer II (IT042)Technical Integration Engineer III (IT043)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 InclusionEducation:PreferredAssociate's DegreeQualifications: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/loggingPreferred:- 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 communicationAdditionally 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 issuesWork Type: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.Appointment Type, Duration:Terminal, 24 month appointment.This position has the possibility to be extended or converted to an ongoing appointment based on need and/or fundingSalary:Minimum $90,000 ANNUAL (12 months)Depending on QualificationsThe 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)Additional Information: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.How to Apply: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.Contact:Cody Roeklecroekle@wisc.edu608-263-7676Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.Official Title:Technical Integration Eng II(IT042) or Technical Integration Eng III(IT043)Department(s):A53-MEDICAL SCHOOL/Informatics and ITEmployment Class:Academic Staff-TerminalJob Number:307812-ASThe University of Wisconsin-Madison is an Equal Opportunity and Affirmative Action Employer.Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence through diversity and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, click hereIf 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 may require a criminal background check. It may 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.