Analytics Engineer

Cracker Barrel is investing in governed analytics that power enterprise reporting, Power BI semantic models, and certified AI use cases. In this role, you will design and deliver reliable, reusable analytics assets using dbt in Snowflake, partnering with business stakeholders and data engineering teams to turn clear KPI definitions into scalable metric calculations.

What you’ll do

• Design, develop, test, deploy, and maintain dbt models within Snowflake.
• Transform curated source data into reusable analytical datasets and business-ready data products.
• Build dimensional models including fact tables, dimension tables, conformed dimensions, hierarchies, and documented grain.
• Develop and support Gold-layer models optimized for enterprise reporting, analytics, and approved AI use cases.
• Ensure analytical models follow established architecture, naming, SQL, data modeling, security, and documentation standards.
• Translate approved KPI definitions and business rules into governed metric calculations with business analysts and stakeholders.
• Build and maintain curated datasets that support Power BI semantic models, certified data sources, and self-service reporting.
• Support metric and data-product certification by documenting technical logic, source fields, lineage, dependencies, refresh expectations, and known limitations.
• Implement automated dbt tests and validation controls for uniqueness, completeness, accepted values, referential integrity, freshness, and business rules.
• Monitor production analytical data products and troubleshoot transformation failures, data anomalies, performance concerns, and unexpected reporting results.
• Use GitHub and source-control practices to manage branches, submit pull requests, participate in code reviews, and enable controlled deployments.
• Contribute to CI/CD practices, reusable development patterns, technical templates, and team documentation.
• Collaborate with Data Engineering on upstream dependencies, data availability, scalability, and production support needs.
• Participate in requirements discovery, solution design, user acceptance testing, and release validation.
• Guide analysts and report developers on certified datasets, model usage, metric logic, and data limitations, and support training and enablement related to dbt and governed assets.
• Perform other duties as assigned in support of data and analytics initiatives.

What you bring

• Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, Mathematics, Statistics, Engineering, or a related field, OR an equivalent combination of education, certification, and relevant work experience.
• 4+ years of experience in analytics engineering, business intelligence, data warehousing, data engineering, or advanced analytics.
• 3+ years of advanced SQL development experience.
• Experience developing analytical solutions within a cloud-based data platform.
• Experience with dimensional data modeling and data warehouse concepts.
• Ability to translate business and reporting requirements into scalable technical data solutions.
• Experience collaborating across technical and business teams.
• Advanced SQL development and analytical problem-solving skills, including strong understanding of relational structures, data transformation, dimensional modeling, and data warehousing concepts.
• Working knowledge of dbt development, testing, documentation, dependency management, and deployment practices.
• Knowledge of data quality controls, source control, peer review, and production support practices.
• Strong communication skills and the ability to work effectively with technical and non-technical stakeholders.
• Ability to manage solutions through design, development, validation, deployment, and support.
• Commitment to continuous learning and improvement of analytics engineering practices.

Tools you’ll use

• dbt, Snowflake, SQL, GitHub, Power BI, CI/CD

Benefits

• Competitive Annual Salary and Annual Bonus Opportunities
• Medical, Rx, Dental and Vision Benefits on Day 1
• Life Insurance and Disability Coverage
• Paid Vacation and Employee Assistance Program
• Business Resource Groups
• Tuition Reimbursement
• Professional Development
• Support that starts on day one, including Onboarding, training, and development
• Recognition programs and employee events
• 401k Plan with Company Matching Contributions at 90 days
• Employee Stock Purchase Program
• 35% Discount on Cracker Barrel Food and Retail items
• Exclusive Biscuit Perks including discounts on home, travel, cell phones, and more