Description
Position Overview:
We are seeking an experienced Data Engineer to design, build, and maintain robust data pipelines and cloud-based solutions that power analytics and reporting across our manufacturing operations. In this role you will work closely with business stakeholders, data scientists, and BI developers to turn raw data into trusted, actionable insight that drives operational excellence.
Responsibilities:
• Develop & maintain data pipelines: Design, build, and optimize ETL workflows that ingest data from on-premises and cloud sources into enterprise data platforms (SQL Server & Azure).
• Model & transform data: Create well-structured, documented data models (star/snowflake schemas, data vault, etc.) to support self-service analytics and advanced use cases.
• Administer databases: Tune, secure, and monitor Microsoft SQL Server instances-including authoring complex T-SQL queries, functions, and stored procedures-to ensure high performance and data integrity.
• Leverage cloud services: Implement Azure Data Factory, Synapse Analytics, and related services for scalable data orchestration, storage, and processing.
• Integrate ERP data: Build and maintain robust integrations with Microsoft Dynamics ERP (F&O/AX) and other manufacturing systems (MES, SCADA, historians).
• Enable BI & visualization: Partner with analysts to prepare datasets for Power BI, applying visualization best practices and ensuring semantic layer consistency.
• Ensure data quality & governance: Establish validation, monitoring, and documentation standards; champion data-driven culture and adoption of best practices across teams.
• Troubleshoot & optimize: Investigate performance bottlenecks, resolve data discrepancies, and continuously improve pipelines for speed, reliability, and cost.
• Collaborate & mentor: Share expertise with peers, lead code reviews, and contribute to team standards and technical roadmaps.
Qualifications:
• Bachelor's degree in Computer Science, Information Technology, or a closely related field.
• 7+ years of professional data engineering experience, preferably supporting manufacturing or industrial environments.
• Advanced proficiency in Microsoft SQL Server and T-SQL (query tuning, indexing strategies, partitioning, SSIS/SSRS familiarity).
• Hands-on experience architecting and operating data solutions in Azure (Data Factory, Synapse, SQL Database, ADLS Gen 2, Databricks, etc.).
• Strong Python development skills for data processing, automation, and orchestration tasks (Pandas, PySpark, etc.).
• Deep understanding of data integration patterns, CDC, batch vs. streaming, and associated tooling.
• Proven ability to analyze complex datasets, trace root causes, and deliver resilient solutions under tight deadlines.
• Experience integrating and modeling data from Microsoft Dynamics 365 / AX / NAV or other ERP systems.
• Familiarity with manufacturing domain data sources (PLC historians, MES, quality, supply-chain).
• Power BI report development and DAX optimization skills.
• Exposure to DevOps practices: CI/CD pipelines (Azure DevOps/GitHub), Infrastructure-as-Code (Bicep/Terraform).
• Knowledge of data governance frameworks (Purview, data cataloging, lineage).
• Excellent communication-able to explain technical concepts to non-technical audiences.
• Collaborative mindset and willingness to mentor junior engineers.
• Self-starter with strong organizational skills and attention to detail.
• Knowledge of data warehousing concepts and best practices.
• Data governance leadership.
• RPA experience.
What We Expect of Our Applicants and Future Employees:
• Honesty - you tell the truth, even when it's uncomfortable, and you don't hide mistakes or shortcuts.
• Integrity - you do the right thing, even when no one is watching or when it would be easier not to.
• Diversity - you respect people who look, think, and work differently than you do.
• Quality - you take pride in your work and hold yourself to a high standard, no matter the task.
• Respect - you treat everyone with courtesy, from the person next to you on the line to the person in the corner office.
• Responsibility - you follow through on what you say you'll do, without needing to be reminded.
• Accountability - when you make a mistake, you own it, learn from it, and help fix it.
Hours and Pay:
We offer a competitive base pay rate and comprehensive benefits package for full-time employees. This role works standard business hours Monday - Friday with night and weekend hours as needed to meet business needs.
Physical and Mental Demands:
• While performing the duties of this job, the employee is frequently required to sit, hear, use hands to type data, use a personal computer and telephone. This employee may occasionally have to operate business machines and lift and/move up to 50 pounds.
• Specific vision abilities required in this job include close vision and the ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Mental demands include multi-tasking, decision making, problem solving, comparing, copying, computing, compiling, analyzing, coordinating, and synthesizing data.
• Potential for exposure to chemicals, heights, loud noises, mechanical equipment, wet environments, and other potential hazards exists.
Safety Statement:
At Trilliant and Horseshoe, safety is every employee's first responsibility. We expect all employees to adhere to all safety practices, have the moral courage to stop other individuals from performing unsafe acts, and immediately report unsafe conditions.
Disclosures:
• The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
• Responsible for following food safety/regulatory policies and procedures, executing responsibilities as identified in standard operating procedures, and reporting food safety/regulatory concerns to the Production or Quality Manager.
• Trilliant Food & Nutrition and Horseshoe Beverage Company are Drug Free Workplaces. All applicants are subject to a drug screen and background check as a condition of employment.
• Trilliant Food and Nutrition and Horseshoe Beverage participate in the E-Verify process.
