Lead Data Warehouse Architect - Greenfield, Hybrid

Prestige Staffing; Kenosha (WI); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Prestige Staffing is seeking a Data Engineer/Architect to design and implement a modern data platform in Southeast Wisconsin. The role is hybrid with three days onsite, combining data lake, pipelines, and governance.

You will work across ERP data, build semantic layers, and enable finance and operations with dashboards and predictive models. Deep cloud experience required; leadership in architecture ownership.

Qualifications

• 10+ years building enterprise data platforms with data modeling and ETL/ELT across multiple source systems.
• Deep experience with Databricks, Snowflake, BigQuery or equivalent cloud platforms.
• Experience designing semantic layers on medallion or layered architectures.
• Strong SQL and Python for data processing and analytics.
• Comfort with financial and operational data (COA, journals, invoices, orders).

Responsibilities

• Design and build the data lake and the pipelines feeding it across ERP systems.
• Build the curated and semantic layers on a medallion architecture.
• Write custom connectors for legacy source systems with no native integration.
• Build predictive and analytical models on top of curated data for cost savings and spend analysis.
• Partner with Finance and Operations on data definitions and mapping.
• Develop reporting and dashboards leadership will run the business on.

Skills

Data Platform Architecture

Data Modeling

ETL/ELT

SQL

Python

Cloud Data Platforms

Tools

Databricks

Snowflake

BigQuery

Job description

Prestige Staffing is seeking a Data Engineer/Architect to design and implement a modern data platform in Southeast Wisconsin. The role is hybrid with three days onsite, combining data lake, pipelines, and governance.

You will work across ERP data, build semantic layers, and enable finance and operations with dashboards and predictive models. Deep cloud experience required; leadership in architecture ownership.