About This Role
An Analytics Engineer helps shape how data is used across the organization by building scalable Power BI models and analytical foundations. This role focuses on designing enterprise-grade semantic models, improving Power BI performance, and creating solutions that make self-service analytics easier and more consistent. It also involves teaching and developing others, helping analysts strengthen their Power BI capabilities through training, coaching, technical communities, standards, and knowledge sharing.
Responsibilities
- Design, build, and maintain enterprise Power BI semantic models that provide trusted analytical foundations for multiple areas of the business
- Develop dimensional models, star schemas, standardized business metrics, DAX measures, calculation groups, and model relationships that are intuitive, maintainable, and high performing
- Improve refresh and query performance through incremental refresh, partitions, aggregations, and other optimization techniques for large-scale datasets
- Work closely with Data Engineering and business teams to ensure data is structured for effective analytical consumption and translate complex needs into durable analytics solutions
- Help establish and champion Power BI best practices, including modeling standards, naming conventions, row-level security, documentation, governance, and dataset lifecycle management
- Build well-documented semantic models that make it easier for analysts and business teams to confidently answer questions with data
- Develop training, certification programs, technical communities, and knowledge-sharing opportunities that grow Power BI expertise across Casey
- Coach and consult with Power BI-enabled analysts across business functions, helping them apply best practices and build stronger analytics solutions
Requirements
- 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 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
- Qualified candidates must live within a daily commutable distance of Casey's Store Support Center in Ankeny, IA and willing to work onsite 5 days per week
- Authorization to work in the U.S. without the need for employment-based immigration sponsorship now or in the future
