Analytics Engineer II

Analytics Engineer II at Texas Roadhouse responsible for designing, building, and optimizing enterprise analytics using Microsoft Fabric and Power BI, enabling self-service insights from the Louisville Support Center with a hybrid work arrangement.

Responsibilities

• Design, build, and maintain domain-specific semantic models in Power BI and Fabric.
• Craft business metrics in DAX, including advanced measures and calculation groups.
• Apply dimensional modeling best practices to boost performance, usability, and consistency.
• Own data governance tasks such as row-level security, dataset certification, and access controls.
• Create and sustain high-impact Power BI reports and applications.
• Troubleshoot model and report issues related to performance, data refresh, and logic.
• Collaborate with Data Engineering to shape analytics-ready data models.
• Monitor analytics asset performance, reliability, and usage.
• Participate in CI/CD workflows using Git and Power BI deployment pipelines.
• Enable self-service analytics through certified datasets and reusable assets.
• Work with stakeholders to gather requirements and validate outcomes.

Requirements

• High School diploma or GED required; Bachelor's degree in Computer Science or a related field preferred, with relevant experience substituting for the degree.
• 4–6 years of experience in Analytics Engineering, BI, or advanced Power BI roles.
• Required certifications: DP-600 (Fabric Analytics Engineer) and PL-300 (Power BI Data Analyst).
• Proven ownership of production semantic models and governed metrics.
• Strong expertise in DAX, dimensional modeling, and performance optimization.
• Experience delivering production-grade analytics solutions used by the business.
• Solid SQL and data modeling skills.
• Hands-on experience with the Microsoft Fabric / Power BI ecosystem aligned to DP-600.
• Experience with Git and CI/CD practices.
• Experience with Fabric components (Lakehouse, Warehouse, Direct Lake) preferred.
• Familiarity with product-oriented analytics teams is a plus.
• Experience with tools such as Tabular Editor is preferred.

Technologies

• Microsoft Fabric
• Power BI
• DAX
• SQL
• Git
• PBIP (Power BI deployment pipelines)
• Tabular Editor
• Fabric Lakehouse
• Fabric Warehouse
• Fabric Direct Lake

Benefits

• Health insurance coverage
• Maternity leave
• Vacation time
• Parental leave
• Donor leave
• Bereavement leave
• Wellness program
• Car detailing services
• Dry cleaning benefits
• Spray tan services
• 401(k) retirement plan
• Tuition reimbursement
• Stock units
• Holiday bonuses
• Willie’s Joynt on-site cafe perks

What’s on Your Plate

• Design, build, and maintain domain-aligned semantic models in Power BI and Fabric
• Develop business metrics in DAX, including complex measures and calculation groups
• Apply dimensional modeling best practices for performance, usability, and consistency
• Own data governance: RLS, dataset certification, and access controls
• Build and support high-impact Power BI reports and apps
• Troubleshoot issues across models and reports (performance, refresh, logic)
• Partner with Data Engineering to shape analytics-ready data models
• Monitor performance, reliability, and usage of analytics assets
• Contribute to CI/CD processes (Git, PBIP, deployment pipelines)
• Enable self-service analytics through certified datasets and reusable assets
• Collaborate with stakeholders to gather requirements and validate outcomes

Your Recipe for Success

• High School diploma or GED required, bachelor's in Computer Science or related field preferred; experience can substitute for the degree
• 4–6 years in Analytics Engineering, BI, or advanced Power BI roles
• DP-600 and PL-300 certifications required
• Proven ownership of production semantic models and governed metrics
• Strong DAX, dimensional modeling, and performance optimization skills
• Experience delivering production-grade analytics solutions used by the business
• Solid SQL and data modeling skills
• Hands-on experience with Microsoft Fabric / Power BI ecosystem
• Experience with Git and CI/CD practices
• Fabric experience (Lakehouse, Warehouse, Direct Lake) preferred
• Familiarity with product-oriented analytics teams preferred
• Experience with Tabular Editor preferred

Why You’ll Love Your Job

• Competitive benefits including medical, dental, vision, and fully paid maternity leave
• Generous time off: vacation, parental, donor, and bereavement leave
• Wellness perks: on-site fitness resources, massages, gym facilities, and a nurse on site
• Convenience services such as car detailing and dry cleaning, plus spray tan options
• Retirement and education support: 401(k), tuition reimbursement, stock units, and holiday bonuses
• On-site cafe perks at Willie’s Joynt