Data Warehouse Engineer

Data Warehouse Engineer Skip to main content# Job Opportunities Data Warehouse Engineer page is loaded## Data Warehouse Engineer Apply remote type:
Partially Remote locations:
Milwaukee, WIposted on:
Posted Yesterday job requisition :
JR##
*** 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…