Data Engineer

This role is an office hybrid role based out of our Louisville, KY office.

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 is transforming the business 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 first and foremost but will also get to help with larger scale projects and 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?

Responsibilities for this position will include, but are not limited to:

• 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
    • Sometimes helping 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.
• 2 year(s) of experience with creating and managing data pipelines (ETL).
• 2 year(s) 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
• 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 Skilled and Experience:

• SSAS experience
• Oracle database (12.1.2 and on) 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 may 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.