Data Engineer (Finance)

About Us:
Trilliant Food & Nutrition is a leading, vertically integrated manufacturer of premium coffees and powdered beverages, proudly headquartered in Little Chute, Wisconsin. With a legacy rooted in quality, innovation, and service, Trilliant delivers branded and private label solutions across retail, foodservice, and e-commerce channels.

Horseshoe Beverage Company, based in Neenah, WI, is a leading ready-to-drink beverage manufacturer dedicated to delivering an exceptional beverage experience. By combining industry-leading talent, cutting-edge equipment, and a vertically integrated supply chain, we drive innovation and consistently deliver the highest quality products to our customers--first and fast.

Our brand portfolio includes Victor Allen's®, Dutch Bros® beverages and Nurri™, our better-for-you protein beverage line. We are passionate about beverages - and about building a team that's just as energized. We invite you to explore opportunities at Trilliant or Horseshoe, to see if your talents and career aspirations may fit with our openings.

Our Core Values:

Diversity and Inclusion at Trilliant and Horseshoe:
We believe talented, great people are the building blocks of our success. We believe in finding the right people, with the right attitude, and providing them with opportunities to excel.

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.

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.
· EEO/AA including Vets and Disabled
· If you need a reasonable accommodation for any part of the employment process, please contact us by email at HR@trilliantfood.com and let us know the nature of your request and your contact information.
· Trilliant Food and Nutrition and Horseshoe Beverage are Equal Opportunity Employers.
· The principles of the OECD and UN have been taken into consideration and used as guidance in our human rights practices and procedures.