Data Engineer

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

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 working on large-scale projects 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. Minimum 2 years of experience 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 - writing and understanding SQL code at an intermediate level. Knowledge of SSRS and SSIS. Knowledge of MS SQL Server. Experience 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:

Basic Knowledge of MS Fabris SSAS experience Oracle database experience Interacting with and querying ERP systems (we use IFS) R and Python experience Familiarity with PowerBI and 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, the 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.