Data Warehouse Engineer

About the role

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.

Responsibilities

• Counsels data subject matter experts to document and address data quality issues and ensure data is assured.
• Develops and unit tests high-complexity load and/or mappings across a suite of tools and deploys to production.
• Designs and/or builds, tests, and deploys conceptual, logical, and physical data models according to specifications and standards.
• 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.

Requirements

• 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

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-ed environment

Skills

• Strong SQL and Informatica experience
• Solid understanding of data warehousing concepts
• Collaboration with both technical and functional partners

Benefits

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.

Pay

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

Schedule

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.