Data Warehouse Engineer

The Chronicle Of Higher Education, Inc.; Milwaukee (WI); Hybrid; USD 85,000 - 125,000; Full time

Job summary

UW–Milwaukee seeks a Data Warehouse Engineer to design and build ETL workflows, develop data models, and ensure reliable data pipelines for analytics across the campus. The role involves hands-on work with Informatica, SQL, Oracle, and modern warehousing tools.

You will assess data sources, prototype high-complexity loads, model data conceptually to physically, and lead data quality initiatives with metrics. A Hybrid schedule includes one on-campus day per week during onboarding.

Qualifications

• Bachelor's degree by date of hire or equivalent.
• 3+ years in data engineering, warehousing, or related field.
• Strong SQL skills, including optimization of complex queries.
• Hands-on ETL development using modern tools/frameworks.
• Knowledge of data warehousing concepts and modeling.

Responsibilities

• Design and build ETL workflows and data models for analytics across campus.
• Collaborate with Informatica, SQL, Oracle and warehousing tools to meet needs.
• Assess source connections and develop high-complexity loads and mappings; deploy to production.
• Perform complex data profiling across multiple data types and sources.
• Create conceptual, logical, and physical data models with standards for security and lifecycle.
• Cleanse, integrate, transform data per enterprise definitions and quality measures.
• Inventory and document data warehouse assets for discoverability and use.
• Present recommendations on data quality issues and mentor junior staff.
• Provide code reviews and oversight of junior data modelers and data curation staff.
• Consult with subject matter experts to document data quality improvements with metrics.

Skills

SQL

ETL development

Data warehousing

Data modeling

Oracle

Informatica

Data quality

Education

Bachelor's degree

Bachelor's degree in Information Technology or Computer Science

Tools

Informatica Intelligent Cloud Services

Job description

Overview

Data Warehouse Engineer – Milwaukee, WI. Job ID JR10012851. Regular employment in the Academic Staff category. Job profile: DW Eng/Developer II.

Job Duties / Responsibilities

• Design and build ETL workflows, develop data models, and ensure high-quality, reliable data pipelines that support analytics across the campus.
• Work with Informatica, SQL, Oracle, and modern data warehousing tools to translate business needs into technical solutions.
• Assess source connections and options for access and optimal data pipelines; develop and unit test high-complexity load and/or mappings and deploy to production.
• Conduct complex data exploration (profiling, data quality, binning, pivoting, summarizing, finding correlations) on multiple data types and sources.
• Design, build, test, and deploy conceptual, logical, and physical data models in accordance with standards for naming, security, lifecycle, and retention; provide architecture options analysis as needed.
• Cleanse, integrate, and transform complex data according to the target data model and enterprise data definitions and quality measures from data stewards.
• Inventory and document complex data warehouse assets for discoverability and business use.
• Present recommendations to address data quality issues and coach lower-level staff on data quality clean-up with metrics and reports.
• Provide code reviews, coaching, and oversight of lower-level data modelers and data curation developers as needed.
• Consult with data subject matter experts to document and address data quality issues and 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.
• Hybrid-flexible schedule with a minimum of one on-campus day per week during initial training and onboarding. More 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 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 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

Benefits and Total Rewards

UW–Milwaukee offers a comprehensive benefits package and contributes toward the cost of several benefit plans. Eligible employees receive paid leave and holidays. Detailed summary of benefits is provided by the university.

Applications Instructions

All applicants must apply online and submit a cover letter and a resume that clearly describe their professional-level experience as it relates to the required and preferred qualifications. Ensure all required fields and documents are completed and attached before submitting the online application.

Equal Employment Opportunity

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.

Note

To apply, visit the university job site for this posting and reference the JR10012851 job ID.