This role is an office position based in Louisville, Kentucky.

What the Role Is

The Data Engineer will build and manage data pipelines from both primary external and internal sources into central data repositories, and from there to usable, business-facing, enterprise-ready data sources.

The Data Engineer is expected to understand large language models and have experience using them to drive data engineering solutions, including IDE-integrated and external LLM-based coding tools. This position may also design and support language-model-driven solutions for end-user reporting and analytical needs in partnership with our AI program.

How You Will Spend Your Time? Build, maintain, and optimize data products and models to be processed and served up by AI. Collaborate with IT and business stakeholders to define requirements, prioritize work, and deliver high-quality data products. Plan and document work using Asana and GitHub. Enterprise Ready Data Sources Curate enterprise-ready data sources for consumption by Power BI for self-service analytics in the business. Focus on data products that can be used by LLMs to support forecasting, performance measurement, and decision-making.

Data Pipelines (ETL/ELT) Write data pipelines from external and internal commercial data sources into central data locations (data lake / Fabric lakehouse) using SQL and/or Python. Transition legacy OLAP-based and SSIS-based workflows into well-documented, transparent, and fully reproducible ETL/ELT environments, likely driven by notebook (code + text) solutions within Fabric and related tooling. Write data pipelines from central repositories to enterprise-ready data sources for consumption by MCP servers, web apps, data scientists, analyst professionals, and Power BI semantic models. Work with transparency, best practices, and documentation as guiding principles. Leverage integrated large language models (LLMs) and AI-assisted tooling to accelerate coding, documentation, testing, and ideation of data and analytics solutions.

Other duties as required to support changing business needs. Who You Are...

Required Skills and Experience: Bachelor's degree in computer science or related field, or may substitute equivalent experience for educational requirements. Minimum 4 years of experience creating and managing robust data pipelines (ETL/ELT) that follow best practices, including medallion architecture, unit testing, and related standards. Minimum 4 years of experience with databases (SQL Server, Oracle, or similar relational databases). Programming languages: SQL (required); Python (required) and/or R (preferred). Knowledge of MS SQL Server, SQL, Reporting Services, Analysis Services, and Integration Services for historical workloads. Knowledge of version control systems (Git) and collaboration services (GitHub). Experience with Microsoft Fabric, Power BI, and notebook-based development, or a demonstrated ability to learn these quickly. An attitude of continuous improvement and learning. A team player with excellent interpersonal skills who is comfortable working with a business-integrated scrum to plan and complete work. Comfortable with "change as the only constant" and willing to flex as priorities shift; understands that 'other duties as required' is part of the core role. The use of AI-assisted development tools (eg, integrated LLM copilots). Valued but not Required Skills and Experience: R/ Shiny experience. Familiarity with Power BI and semantic model design. Understanding of the Posit Team set of applications. Familiarity with data sources used in the spirits industry (Nielsen, NABCA, SRS, distributor data, etc.). Experience working with time series data (manufacturing line data, chemical processing, etc.). Physical Requirements While performing duties of the job, the employee is required to: Stand; walk; use hands and fingers to handle, or feel objects, and use of computer; reach with hands and arms. Lift and/or move up to 30 pounds. Benefits Paid Vacation 11 Paid Holidays Health, Dental & Vision eligibility from day one FSA/HSA 401K match EAP Maternity/Paternity Leave

Heaven Hill and its affiliates are committed to fostering a diverse workforce as an Equal Employment Opportunity company. We invite applications from candidates of all backgrounds, without regard to race, religion, color, sex, sexual orientation, natural origin, gender identity or expression, age, disability, veteran status, or any other legally protected characteristic.