Data Engineer - Manufacturing ETL & Data Warehouse
Core
Design, build, and optimize ETL/ELT pipelines for an enterprise data warehouse to power company-wide reporting.
Role type
Senior Data Engineer (ETL & Data Warehouse)
Builds
Enterprise data warehouse pipelines integrating ERP and operational data
Domain
Manufacturing / Industrial Data
Required skills
SQL development, performance tuning, Oracle databases, ETL/ELT, data warehousing, pipeline troubleshooting, dimensional modeling
Preferred skills
WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, Dataverse, D365 F&O, SSIS, Informatica, Power BI, database administration, manufacturing domain knowledge
Technologies
Oracle, Ross ERP, D365 F&O, Microsoft Fabric, Informatica, Power BI, SQL, SSIS
Responsibilities
Design and optimize ETL/ELT pipelines; Integrate data from Oracle, Ross ERP, and D365 F&O; Develop and tune complex SQL and stored procedures; Monitor data loads and resolve discrepancies; Contribute to warehouse architecture and code reviews; Collaborate with BI team for reporting support