Data Engineer

This can be an office/hybrid or remote position, with an ideal base location in Kentucky, Indiana, Ohio and the surrounding areas.

What the Role Is

The Data Engineer, reporting to the Director of Data Services, will use their SQL and related skills to provide data engineering support to the business, mostly at a Tier 2 Level.

IT has undergone a transformation into new ways of working, and the Data Services team is a key component of this effort. We are a team of data scientists and data engineers who are working on large scale projects that are changing how Heaven Hill does business and makes decisions.

This role will help by providing Tier 2 support, while assisting with larger scale projects, process improvement and documentation tasks. This support should lead to a deeper understanding of our process and systems, allowing this person to grow in their impact over their first year.

How You Will Spend Your Time?

• Providing support to systems users (Tier 2 Support)
  • SSRS, SSIS, & SQL
    • Troubleshooting existing views, stored procedures, and queries
    • Troubleshooting SSRS reports as well as updates and modifications therein
    • Troubleshooting SSIS packages and jobs
    • Writing new queries, views, and procedures
    • Writing code and troubleshooting historic code to fix issues or provide new features while working directly with the business.
  • Custom Applications such as BIC (Barrel Inventory Control)
• Improving our Tools and Processes
  • Helping maintain systems
    • Updating code as needed
    • Documenting and fixing processes
• Assisting as needed with project work (Tier 3)
  • Helping support data services projects, such as package development for new data flows.

Who You Are…

• Bachelor’s degree in Computer Science or related field, or may substitute equivalent experience for educational requirement.
• Minimum 2 years of experience with creating and managing data pipelines (ETL).
• Minimum 2 years of experience with database administration (SQL, Oracle)
• SQL Knowledge is a must have in this role – you should be writing and understanding SQL code at an intermediate level.
• Knowledge of SSRS and SSIS is also a must, as many of the Tier 2 items are likely to come from here
• Basic working knowledge of MS Fabric
• Knowledge of MS SQL Server
• Knowledge of working with version control
• An attitude of collaboration, continuous improvement, and eagerness to learn.
• A team player with excellent interpersonal skills

Valued but not Required Skills and Experience:

• SSAS experience
• Oracle database experience
• Interacting with and querying ERP systems (we use IFS)
• R and Python experience
• Familiarity with PowerBI
• Familiarity with R Shiny Applications
• Understanding of the RStudio Team set of applications
• Familiarity with data sources used in the spirits industry (Nielsen, NABCA, SRS, etc.)

Physical Requirements

While performing duties of job, employee is occasionally required to stand; walk; use hands and fingers to handle, or feel objects, and use of computer; reach with hands and arms. Employee must occasionally lift and/or move up to 50 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.