University of Wisconsin-Madison
Wisconsin, United States
Salary Not Specified
Posted date
Sep 24, 2021

View more

Position Type
Faculty Positions, Science, Technology & Mathematics, Statistics, Administrative, Academic Affairs, Institutional Research & Planning, Instructional Technology & Design (Campus), Business & Administrative Affairs, Computer Services & Information Technology, Technology Administration/Other
Employment Type
Full Time
Job no: 242094-AS
Work type: Remote, Staff Full or Part Time, Staff-Full Time, Staff-Part Time
Location: Madison
Categories: Information Systems/Technology, Other, Computer Science

Position Summary:

The Data Warehouse Engineer/Developer 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.

Strong candidates for this role will have a good technical foundation in building and optimizing data systems, a love of learning, 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 Data Warehouse Engineer/Developer II will report to Elizabeth Simcock, Manager of Applications and Analytics, School of Medicine and Public Health.

The School of Medicine and Public Health has a deep and profound commitment to diversity both as an end in itself, and also as a valuable means for eliminating health disparities. As such, we strongly encourage applications from candidates who foster and promote the values of diversity and inclusion.

Position Duties:

List of Duties

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

Degree and Area of Specialization:

Bachelor's degree required. Degree in data-related field or equivalent work experience preferred.

Minimum Years and Type of Relevant Work Experience:

- Solid working knowledge of a data integration tool such as Informatica
- 2+ years as a database administrator
- Experience with database and/or data warehouse development, maintenance, and auditing/logging
- Experience with relational database design
- Experience in data modeling

- Experience with Informatica Cloud data integration and monitoring
- Experience with structured and unstructured data
- Experience with cloud data storage (e.g., Snowflake)

Additional Information:

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.

This is a full-time position, however we are able to be flexible during the onboarding period to start someone at a minimum of 32 hours each week.

This position is currently fully remote due to the ongoing COVID-19 pandemic. In the future, we will explore the opportunity for this position to continue working remotely or on a hybrid schedule.



Work Type:

Full or Part Time: 80% - 100%

This position is remote and requires work be performed at an offsite, non-campus work location.

Appointment Type, Duration:



Minimum $70,000 ANNUAL (12 months)
Depending on Qualifications

Instructions to Applicants:

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/supervisor references during the application process.


Cody Roekle
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:


Employment Class:

Academic Staff-Renewable

Job Number:


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:

The University of Wisconsin-Madison is engaged in a Title and Total Compensation (TTC) Project to redesign job titles and compensation structures. As a result of the TTC project, official job titles on current job postings may change. Job duties and responsibilities will remain the same. For more information please visit: .

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: Sep 24 2021 Central Daylight Time
Applications Close: Oct 17 2021 11:55 PM Central Daylight Time

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert

Similar Jobs