Data Warehouse Engineer - ETL, SQL & Data Modeling

University of Wisconsin-Milwaukee; Milwaukee (WI); Hybrid; USD 85,000 - 93,000; Full time

Job summary

The University of Wisconsin–Milwaukee is seeking a Data Warehouse Engineer to join the Enterprise Data Warehouse team. You will design and build ETL workflows, develop data models, and ensure high‑quality data pipelines that support analytics campuswide.

Candidates should have strong SQL and Informatica experience, knowledge of data warehousing concepts, and the ability to collaborate with technical and functional partners. Oracle, Redshift experience and higher‑ed familiarity are a plus.

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.

Responsibilities

• Assess source connection options and develop high‑complexity load mappings; deploy to production.
• Perform data exploration: profiling, quality checks, binning, pivoting, and cross‑source correlations.
• Design and build conceptual, logical, and physical data models per standards; include option analysis.
• Develop data cleansing, integration, and transformation against the target data model.
• Document complex data warehouse assets with descriptions for discovery by business users.
• Present results of data quality recommendations and coach staff with metrics.
• Provide code reviews and oversight of junior data modelers and curation staff.
• Collaborate with data SMEs to address data quality issues and support cleanup initiatives.

Skills

SQL

ETL development

Data warehousing concepts

Data modeling

Data profiling

Data quality

Education

Bachelor's degree

IT/CS degree

Tools

Oracle

PL/SQL

Amazon Redshift

Informatica Intelligent Cloud Services

Job description

The University of Wisconsin–Milwaukee is seeking a Data Warehouse Engineer to join the Enterprise Data Warehouse team. You will design and build ETL workflows, develop data models, and ensure high‑quality data pipelines that support analytics campuswide.

Candidates should have strong SQL and Informatica experience, knowledge of data warehousing concepts, and the ability to collaborate with technical and functional partners. Oracle, Redshift experience and higher‑ed familiarity are a plus.