Senior Data Engineer - Azure/SQL ETL for Manufacturing

Trilliant Food and Nutrition, LLC; Little Chute (WI); On-site; USD 110,000 - 170,000; Full time

Job summary

Trilliant Food and Nutrition, LLC is seeking an experienced Data Engineer to design, build, and maintain robust data pipelines powering analytics across manufacturing operations.

You will collaborate with stakeholders, data scientists, and BI developers to deliver trusted insights that drive operational excellence. This role requires advanced SQL Server skills, Azure data services, and ERP integration experience.

Qualifications

• 7+ years in data engineering, preferably in manufacturing/industrial settings.
• Strong SQL Server and T-SQL with performance tuning and indexing strategies.
• Hands-on Azure data services experience (Data Factory, Synapse, ADLS Gen2).
• Proficient in Python for data processing and automation (Pandas, PySpark).
• Experience modeling data from ERP systems (Dynamics 365/AX/NAV).
• Power BI report development and DAX optimization skills.
• Familiar with data governance, lineage, and cataloging concepts.
• Excellent communication and mentoring abilities.

Responsibilities

• Design, build, and maintain robust data pipelines across on-prem and cloud sources.
• Create structured data models (star/snowflake, data vault) for analytics.
• Administer and optimize SQL Server instances and T-SQL workloads.
• Leverage Azure Data Factory and Synapse for scalable data orchestration.
• Integrate ERP data from Microsoft Dynamics and other systems (MES, SCADA).
• Prepare datasets for Power BI and ensure semantic layer consistency.

Skills

SQL Server

T-SQL

Azure Data Factory

Azure Synapse

Databricks

Python

ETL

Data Modeling

Power BI

Data Governance

SQL performance tuning

ERP integration

DevOps CI/CD

DAX

Education

Bachelor's degree in Computer Science / IT

Tools

SSIS/SSRS

Azure Data Factory

Azure Databricks

Power BI

SQL Server Management Studio

Job description

Trilliant Food and Nutrition, LLC is seeking an experienced Data Engineer to design, build, and maintain robust data pipelines powering analytics across manufacturing operations.

You will collaborate with stakeholders, data scientists, and BI developers to deliver trusted insights that drive operational excellence. This role requires advanced SQL Server skills, Azure data services, and ERP integration experience.