Hiring: Data Warehouse Engineer Company: Prestige Staffing Location: Kenosha, WI Job Posted Time: 2026-09-16 12:28:03 Employment Type: Hybrid Target Skills & Keywords : BigQuery, Data Lake, Databricks, ELT, ETL, Machine Learning, Python, SQL, Snowflake About the job Experience: •10+ years building enterprise data platforms with hands-on data modeling and ETL/ELT across many different source systems. Required Skills: •Design and build the data lake and the pipelines feeding it, pulling Sales, Purchase, GL, Inventory, AR and AP data from multiple ERP systems. •Build the curated and semantic layers on a medallion architecture, creating one standardized data model and data dictionary across every entity. •Write custom connectors for legacy source systems that have no native integration. •Build predictive and analytical models on top of the curated data for cost savings, supplier pricing comparison, and cross-sell analysis. •Partner with Finance and Operations on how the data gets defined and mapped. •Build the reporting and dashboards leadership will actually run the business on. •Real depth in Databricks, Snowflake, BigQuery or a comparable cloud platform. This is the part we will dig into. •Comfort with financial and operational data. Chart of accounts, journal entries, invoices, sales orders, purchase orders. You do not need an accounting background, but you should have built reporting on this kind of data before. Qualifications: •AI or machine learning applied to curated data for forecasting, anomaly detection or spend analysis. •Multi-entity or M&A data integration experience. •Microsoft Dynamics AX or D365 Finance & Operations. •Power BI, including DAX and Power Query. •Distribution or manufacturing industry data. •Why this one is worth a look •Greenfield. There is no legacy platform to inherit or defend, and the budget is already approved. •You own the architecture. This is not a role where you implement someone else's design. •The office sits far enough north that if you are anywhere between Milwaukee and the north suburbs, you are looking at a short commute instead of a haul into the city. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!