Data Warehouse Engineer

Milwaukee, WI

JR10012851

Current Employees: If you are currently
employed at any of the Universities of Wisconsin, log in to Workday to apply through the internal application
process.

Position Title:
Data Warehouse Engineer

Job Category:
Academic
Staff

Employment Type:
Regular

Job Profile:
DW Eng/Developer II

Job
Duties:

School/College/Division Description

Employees at UWM in the Department of University IT Services work
in an innovative, collaborative, and casual-work environment with flexible work/life balance schedules. If you are a motivated,
results-oriented individual who wants to make a real difference with our team, community, and the campus, we encourage you to
apply!

Job Description

The University of Wisconsin-Milwaukee is seeking a skilled Data Warehouse Engineer to
join our Enterprise Data Warehouse team. In this role, you’ll design and build ETL workflows, develop data models, and ensure high-quality,
reliable data pipelines that support analytics across campus. You’ll work with Informatica, SQL, Oracle, and modern data warehousing tools
to translate business needs into effective technical solutions. Ideal candidates bring strong SQL and Informatica experience, a solid
understanding of data warehousing concepts, and the ability to collaborate with both technical and functional partners. Experience with
Oracle, Redshift, or higher-education environments is a plus.

Key Job Responsibilities:

• Conducts assessments
  and/or provides recommendations of source connections options for access and optimal data pipelines for development. Develops and unit tests
  high-complexity load and/or mappings across a suite of tools and deploys to production
• Conducts complex data exploration steps, such
  as profiling, understanding data quality, binning, pivoting, summarizing, and finding correlations on multiple data types and
  sources
• Designs and/or builds, tests, and deploys conceptual, logical, and physical data models according to specifications and
  standards for document naming, security, lifecycle, and retention architectures. May provide architecture options analysis
• Designs,
  and/or builds, tests, and deploys the data cleansing, integration, and transformation of more complex data in accordance with the defined
  target data model, based on enterprise data definitions and quality measures provided by data stewards
• Develops and documents the
  inventory of complex data warehouse assets including adding descriptions and making them discoverable for business use
• Presents the
  results of highly complex recommendations to address data quality issues, and coaches lower-level staff in performing data quality clean-up
  initiatives with metrics and reports
• May provide code review, coaching, and oversight of the activities of lower-level data modelers
  and data curation developers
• May consult with data subject matter experts to document and address data quality issues and ensure
  data is assured. May support data quality clean-up initiatives with metrics and reports

Additional Information:

• This
  position does not offer visa sponsorship. Applicants must be legally authorized to work in the United States at the time of
  hire.
• Selected candidates will be required to complete an I-9 form to verify eligibility to work in the U.S.
• This position offers a
  hybrid-flexible schedule, with a minimum expectation of one on-campus day per week during the initial training and onboarding period to
  support effective integration and collaboration. As the employee becomes fully established in the role, additional remote work options may
  be considered based on performance, operational needs, and team alignment.

Minimum Qualifications

• Bachelor’s degree
  by date of hire
• 3+ years of professional experience in data engineering, data warehousing, or a closely related
  discipline
• Proficiency in SQL, including experience writing and optimizing complex queries
• Hands-on experience developing
  ETL processes using modern tools or frameworks
• Working knowledge of data warehousing concepts, data modeling techniques, and
  standard development methodologies

Preferred Qualifications

• Bachelor’s degree in Information Technology, Computer
  Science, or a closely related field
• Experience with Oracle, PL/SQL, and/or Amazon Redshift data warehouse environments
• 3+
  years of experience designing, building, and optimizing ETL workflows and data pipelines preferably using Informatica Intelligent Cloud
  Services
• Experience with data profiling, data quality assessment, and data cleansing practices
• Experience developing
  conceptual, logical, and physical data models
• Prior IT experience in a higher-education environment

Target Salary
Range: $85,000-$93,000 annually

Benefits and Total Rewards

As part of UWM’s commitment to supporting the success of
our team members through positive experiences, employees are provided with Benefits to Benefit You and Your Life. UWM offers a comprehensive
benefits package and contributes towards the cost of several benefit plans. Employees with a qualifying position also receive an extensive leave package including vacation, sick leave (with no expiration), personal holiday, and paid
legal holidays. Please visit this link to view summary benefits information. (Compensation figures are for example purposes only.) UWM Benefits to Benefit You and Your Life

Applications Instructions

All applicants
are required to apply online and submit both a cover letter and a resume that clearly describe their professional-level experience as it
relates to the required and preferred qualifications.

Note: Applicants must complete all required fields and attach all
required documents before submitting the online application. Applications missing any required documents at the time of the deadline will be
marked as incomplete and will not be considered.

If the Search and Screen Committee is unable to determine from a candidate’s
materials whether they meet any of the stated qualifications, the candidate may be evaluated as not meeting those qualifications. Additional
documents submitted beyond a cover letter and resume will not be reviewed.

Finalist candidate(s) will be asked to provide three
professional or supervisor references through an external reference-checking tool. References will not be contacted until candidates have
been notified.

Apply electronically by the application deadline of August 16, 2026. Questions about this position should be
directed to Angelee Vang at vangap@uwm.edu.

Reasonable
Accommodations
Pursuant to university policy, UWM provides reasonable accommodations to
qualified individuals with disabilities who are employees or applicants for employment. Employment opportunities will not be denied because
of the need to make reasonable accommodations for a qualified individual with a disability. If you need assistance or accommodation in
applying because of a disability, please contact uwm-jobs@uwm.edu or 414-229-4463. This job announcement and other material on this site
will be made available in alternate formats upon request to an individual with a disability.

Confidentiality of Applicant
Materials
UWM is a State agency and subject to Wisconsin’s Open Records Law. UWM will not, however, reveal the identities of
applicants who request confidentiality in writing except as may be required by Wisconsin’s Open Records law. In certain circumstances, the
identities of “final candidates” and/or the identity of the appointed applicant must be revealed upon request.

CBC and Reference
Check Policy
Employment will require a criminal background check. UWM takes the prevention of sexual misconduct seriously. As such,
you and your references will be required to answer questions regarding any past findings of sexual violence and sexual harassment or any
pending allegations of sexual violence or sexual harassment.

Annual Security and Fire Safety Report (Clery Act)
For the UWM
Annual Security and Fire Safety Reports (i.e., Clery Report), which includes statistics about reported crimes and information about campus
security policies, see http://www.cleryact.uwm.edu/, or call UWM’s Dean of Students Office, Student Union 345 at (414)
229-4632 for a paper copy.

Employment Authorization
In compliance with federal law, all persons at the time of their start
date will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility
verification form upon hire.

UW is an Equal Opportunity Employer
Qualified applicants will receive consideration for
employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, disability,
status as a protected veteran, or any other bases protected by applicable federal or State law and UW System policies. We are committed to
building a workforce that represents a variety of backgrounds, perspectives, and skills, and encourage all qualified individuals to
apply.

To apply, visit https://wisconsin.wd1.myworkdayjobs.com/en-US/UW_Milwaukee/job/Milwaukee-WI/Data-Warehouse-Engineer_JR100
12851-1.

jeid-05f631e6bf96e54f847bdbd9a34c3e9f

Tagged as: CSS