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 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 works closely with the Analytic Solutions team to deliver insights to a wide variety of business units within Casey’s.

Key Responsibilities:

• Design end to end data pipelines using Azure Data Factory, Databricks (Python, SQL)
• Help maintain enterprise data platform
• Evaluates source data systems and understands how to extract and model the data for analytics
• Performs thorough testing of data pipelines and data models to ensure data is accurate and pipelines are resilient and self-healing
• Pairs with other data engineers and architects to design, implement, and maintain new data products
• Enable business units to leverage our new enterprise data lake by training them on best practices
• Collaborates with report developers and data analysts to implement use case specific data models when required
• Maintains documentation on data flows and pipelines
• 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 is based onsite at our Store Support Center in Ankeny, IA, working onsite 5 days per week.

Compensation

Starting pay range:‏‏‎ ‎$81,200‏‏‎ ‎-‏‏‎ ‎$111,700. 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.

#LI-CW1

• Bachelor’s degree in Computer Science, Data Analytics, Engineering, Information Technology, or equivalent years of related work experience
• At least three (3) years of experience writing complex SQL or Python for data analytics
• History of implementing dimensional modeling techniques (Kimball, Inman, etc.)
• Experience with CI/CD, unit and integration testing, automation, and orchestration
• 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