Associate Data Engineer

At Casey's, every event generates data: a pizza delivery, filling up a gas tank, a truck pulling into the lot, pouring a cup of coffee. Our mission is to use that data to generate insights and help solve the organization's biggest challenges. Our team partners with departments across Casey's to make sense of data and provide direction to decision makers. To enable our strategy, we utilize cutting edge technology tools for data collection, transformation, and analysis. Are you driven to wrangle, cleanse, and transform data? Do you want to partner with leaders to make data driven decisions? Does diving in to a wide variety of data to extract insights excite you? We're looking for innovators who can take an idea from the white board to the board room. If that's you, let's talk.

The Associate Data Engineer role will be responsible for identifying data sources, data modeling, developing data pipelines, and collaborating with other team members to troubleshoot and maintain the enterprise data platform. This role also works closely with the Insights & Data Science team to deliver insights to a wide variety of business units within Casey’s.

Key Responsibilities

• Develop end to end data pipelines using Azure Data Factory and Databricks (Python, SQL)
• Evaluates source data systems and understands how to extract and model the data for Analytics and Data Science in collaboration with other engineers/analysts
• Performs and documents thorough testing of data pipelines and data models to ensure data is accurate and pipelines are resilient and self-healing
• Pairs with more senior team members and architects to design, implement, and maintain new data products
• Collaborates with report developers and data analysts to implement use case specific data models when required
• Maintains documentation on data flows and pipelines
• Perform data analysis as required using SQL, Python, R, etc.
• Provide support for the data platform as part of an on-call rotation.
  
  

Casey's is not able to offer employment sponsorship for work authorization in the United States for this role now or in the future.

This role does not allow for 100% remote work. Qualified out of state candidates must be willing to relocate and will need to live within a daily commutable distance of Casey's Store Support Center in Ankeny, IA and be willing to work onsite 5 days a week.

Compensation

Starting pay range:‏‏‎ ‎$64,800‏‏‎ ‎-‏‏‎ ‎$89,100.‏‏‎ ‎ Actual pay may vary based on Casey’s assessment of the candidate's knowledge, skills, abilities (KSAs), related experience, education, and qualifications. Other factors impacting pay include local prevailing wages and internal equity. This position is eligible for an annual cash bonus based on company performance. Our full salary range for this role does extend beyond the hiring range listed, allowing team members the opportunity to continue to grow within the company.

Requirements

• Bachelor’s degree in Computer Science, MIS, Data Analytics, Engineering, Information Technology, or equivalent years of related work experience
• Experience writing complex SQL or Python for data analytics
• Understanding of dimensional modeling techniques (Kimball, Inman, etc.) is preferred
• Comfort with a variety of data sources including streams, events, APIs, etc.
• Strong attention to detail, with the ability to remain organized and self-motivated
• Strong interpersonal, verbal, and written communication skills
• Capable of identifying problems, analyzing, and evaluating information to determine solutions
• Experience with cloud platforms is a plus (Azure, AWS, GCP)
• Experience with Databricks including administration, security, and infrastructure features is a plus.