Job no: 242094-AS
Remote, Staff Full or Part Time, Staff-Full Time,
Information Systems/Technology, Other, Computer
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.
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
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
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
- 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
- Experience with structured and unstructured data
- Experience with cloud data storage (e.g., Snowflake)
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
A530252-MEDICAL SCHOOL/ADMIN/APP&ANALYTICS DEV
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:
$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
Relay Access (WTRS): 7-1-1 (out-of-state: TTY: 800.947.3529, STS:
800.833.7637) and above Phone number (See RELAY_SERVICE
SR DATA BASE ADMINSTR(R82BN) or DATA BASE ADMINSTR(R82DN)
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
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: https://hr.wisc.edu/title-and-total-compensation-study/
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
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
Sep 24 2021 Central Daylight Time
Oct 17 2021 11:55 PM Central Daylight