Analytics Engineer at Casey's

Ankeny, Iowa, United States -

Full Time

Start Date

Immediate

Expiry Date

16 Jun, 26

Salary

111700.0

Posted On

18 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, Semantic Models, DAX, Data Engineering, Dimensional Modeling, Star Schemas, Query Optimization, Incremental Refresh, RLS, SQL, Power Query (M), Tabular Editor, DAX Studio, ALM Toolkit, Azure DevOps, GitHub

Industry

Food and Beverage Services

Description

Join Casey’s Analytics Solutions team as an Analytics Engineer, where you’ll design, build, and operate enterprise-grade semantic models and Power BI solutions that power trusted insights across the organization. This role sits at the intersection of data engineering, analytics, and BI platform development. Rather than focusing on ad-hoc analysis, the Analytics Engineer is responsible for building scalable, high-performance Power BI semantic models, optimizing refresh and query performance, and enabling self-service analytics at scale. You’ll partner closely with Data Engineering, business stakeholders, and analytics consumers to turn complex data into durable analytical products using best-in-class Power BI modeling, DAX, and platform practices. Key Responsibilities: * Design, build, and maintain enterprise-grade Power BI semantic models that serve as trusted analytical foundations across multiple business units * Contribute to data modeling strategy for analytics use cases, including dimensional modeling, star schemas, and business metric standardization * Develop and optimize DAX measures, calculation groups, and model relationships with a focus on performance, maintainability, and semantic clarity * Implement and tune incremental refresh, partitions, aggregations, and query optimization to support large-scale datasets and enterprise workloads * Partner with Data Engineering to ensure upstream data models are optimized for analytical consumption and Power BI performance * Establish and enforce Power BI best practices across modeling, naming conventions, security (RLS), and dataset lifecycle management * Support self-service analytics by delivering well-documented, governed semantic models that minimize reporting complexity * Build and scale the enterprise analytics workforce through training, certification programs, technical communities, knowledge sharing, standards, and best practices * Provide oversight and consulting recommendations to Power BI-enabled Analysts within business unit analytics functions What you can expect when you join the Casey's Team: * A transformative culture putting service first and taking pride in caring for our guests, our communities, and each other. * Opportunities to use cutting edge technologies and enterprise-wide collaboration to enable our strategy and drive world class service. * We're here for families! Great benefits [https://www.caseys.com/careers/benefits] including choices in medical plans, dental, vision, life insurance, employee stock purchase program, charitable giving programs, parental leave and an onsite Child Development Center. * Competitive pay, 401k company match up to 6%, vacation & sick time, paid holidays, volunteer time, and an onsite cafeteria. * Dress for your day dress code, jeans are welcomed! * The opportunity to work for a big company that has not lost our small company feel. Our senior leadership team is engaged, involved and accessible! What are you waiting for? Come be a part of a company that is growing, transforming and is here for good! 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. Qualifications * Bachelor's degree in Computer Science, Analytics, Engineering, Information Technology, or equivalent years of related work experience * 3–5+ years of experience in analytics engineering, BI engineering, or semantic data modeling * Advanced Power BI expertise, with deep experience in: * Semantic model design * DAX (including performance tuning) * Power Query (M) * Row-level security (RLS) * Strong foundation in dimensional modeling (facts, dimensions, star schemas) * Proven experience optimizing Power BI performance, including query plans and refresh strategies * Proficiency with SQL and working with analytical data platforms Preferred Technical Experience: * Experience with Power BI companion tools such as Tabular Editor, DAX Studio, and ALM Toolkit * Familiarity with source control and deployment pipelines for BI assets (Azure DevOps, GitHub) * Experience working with cloud data platforms and lakehouse architectures (Databricks strongly preferred; Snowflake or BigQuery acceptable) * Understanding of CI/CD patterns and environment promotion for semantic models * Exposure to large datasets and enterprise BI governance practices

Responsibilities

The Analytics Engineer will design, build, and maintain enterprise-grade Power BI semantic models, focusing on performance optimization, dimensional modeling, and metric standardization across various business units. This role involves partnering with Data Engineering and stakeholders to deliver durable analytical products and enabling self-service analytics at scale.