Insights Analyst
About The Position
Join Casey’s Analytics Solutions team as an Insights Analyst, 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 Insights Analyst 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. Based upon experience open to hiring at the Senior Insights Analyst level.
Requirements
- Authorization to work in the U.S. without the need for employment-based immigration sponsorship now or in the future.
- 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.
Nice To Haves
- 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 lake house 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
- 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.
Benefits
- Annual cash bonus based on company performance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
