Data Warehouse Engineer

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

Position Title Data Warehouse Engineer

Job Category Academic Staff

Employment Type Regular

Job Profile DW Eng/Developer II

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

• Conduct assessments and provide recommendations of source connection options for access and optimal data pipelines for development, develop and unit‑test high‑complexity load and/or mappings across a suite of tools and deploy to production.
• Conduct complex data exploration steps, such as profiling, understanding data quality, binning, pivoting, summarizing, and finding correlations on multiple data types and sources.
• Design and/or build, test, and deploy conceptual, logical, and physical data models according to specifications and standards for document naming, security, lifecycle, and retention architectures. May provide architecture options analysis.
• Design, build, test, and deploy 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.
• Develop and document the inventory of complex data warehouse assets, including adding descriptions and making them discoverable for business use.
• Present the results of highly complex recommendations to address data quality issues, and coach 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. As the employee becomes fully established, 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

Employees are provided with a comprehensive benefits package and contributions toward 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. For summary benefits information reference the official benefit summary page.

Equal Opportunity Employer

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.