Senior Insights Architect – Enterprise Power BI & Analytics

Casey's

Ankeny (IA)

On-site

USD 82,000 - 112,000

Full time

2 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Casey’s Analytics Solutions team seeks an Insights Analyst to design, build, and operate enterprise-grade Power BI semantic models, optimize refresh and query performance, and enable self-service analytics at scale. This role blends data engineering, analytics, and BI platform development; you will partner with data engineers and stakeholders to deliver durable analytical products using best-in-class Power BI modeling, DAX, and platform practices.

On-site in Ankeny, IA.

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 DAX, Power Query (M), Row-level security (RLS).
Proficiency with SQL and working with analytical data platforms.

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.