Data Warehouse Engineer - ETL & Data Modeling Pro

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

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.