Analytics Engineer

Cracker Barrel; Lebanon (TN); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Annual Bonus

Health Benefits

Paid Vacation

Tuition Reimbursement

Professional Development

401k with Match

Stock Purchase Program

Employee Discounts

Job summary

Cracker Barrel is seeking a senior analytics engineer at its Store Support Center to design, develop, and maintain dbt models in Snowflake, delivering scalable data products for enterprise reporting and AI use cases.

You will translate business KPIs into robust data solutions, collaborate across technical and business teams, and advance CI/CD practices while ensuring data quality and governance across the data platform.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 4+ years in analytics engineering, BI, data warehousing, or related areas.
• 3+ years of advanced SQL development experience.
• Experience building analytical solutions on a cloud-based data platform.
• Experience with dimensional data modeling and data warehouse concepts.
• Ability to translate business requirements into scalable, technical data solutions.
• Strong collaboration across technical and business teams.
• Excellent documentation and problem-solving skills.

Responsibilities

• Design, develop, test, deploy, and maintain dbt models within Snowflake.
• Transform data into reusable analytical datasets and business-ready data products.
• Design dimensional models including fact and dimension tables and hierarchies.
• Develop Gold-layer models for enterprise reporting, analytics, and AI use cases.
• Ensure models align with standards for architecture, naming, security, and documentation.
• Collaborate with stakeholders to translate KPI definitions into metric calculations.
• Build datasets supporting Power BI semantic models and self-service reporting.
• Document logic, lineage, dependencies, and data-product certification.
• Implement automated dbt tests and validation controls for data quality.
• Monitor production data products and troubleshoot transformations and performance.

Skills

Advanced SQL

dbt development

Snowflake

Power BI

Dimensional modeling

Data warehousing

GitHub CI/CD

Stakeholder collaboration

Data quality controls

GitHub CI/CD

Education

Bachelor's Degree in Computer Science, Information Systems, Data Analytics, Mathematics, Statistics, Engineering, or related field

Tools

Snowflake

dbt

Power BI

GitHub

Job description

They say you are the company you keep - and at Cracker Barrel, we take that seriously. At the Store Support Center, we're in the business of serving those who serve our guests. Whether you're designing solutions, telling our story, or setting our teams up for success, your work makes a difference every single day. Here, the work means more because we take pride in doing it together. So, join our team and find your place, because here...we're all in good company.

What You'll Do - You'll Make the Moment

• Design, develop, test, deploy, and maintain dbt models within Snowflake.
• Transform curated source data into reusable analytical datasets and business-ready data products.
• Design 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 align with established architecture, naming, SQL, data modeling, security, and documentation standards.
• Partner with business stakeholders and analysts to translate approved KPI definitions and business rules into governed metric calculations.
• 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 established source-control practices to manage branches, submit pull requests, participate in code reviews, and support controlled deployments.
• Contribute to CI/CD practices, reusable development patterns, technical templates, and team documentation.
• Partner with Data Engineering to address upstream dependencies, data availability, scalability, and production support needs.
• Participate in requirements discovery, solution design, user acceptance testing, and release validation.
• Provide guidance to analysts and report developers on certified datasets, model usage, metric logic, and data limitations.
• Assist with training and enablement related to dbt models, governed data products, and certified semantic datasets.
• Perform other duties as assigned in support of data and analytics initiatives.

• 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.
• Experience translating business and reporting requirements into scalable technical data solutions.
• Experience collaborating across technical and business teams.
• Advanced SQL development and analytical problem-solving skills.
• Strong knowledge of relational data structures, data transformation, dimensional modeling, and data warehousing concepts.
• Working knowledge of dbt development, testing, documentation, dependency management, and deployment practices.
• Ability to translate business definitions into consistent, reusable, and testable technical logic.
• Knowledge of data quality controls, source control, peer review, and production support practices.
• Ability to troubleshoot complex transformation logic and identify root causes across data dependencies.
• Strong attention to documentation, naming conventions, standards, and repeatable processes.
• Clear written and verbal communication skills.
• Ability to work effectively with technical and non-technical stakeholders.
• Ability to manage assigned solutions through design, development, validation, deployment, and support.
• Commitment to continuous learning and improvement of analytics engineering practices.

Focus on You

We're all about making sure you're taken care of too. Here's what's in it for you:

• Good Work Deserves Good Pay: Competitive Annual Salary | Annual Bonus Opportunities

• Support That Goes Beyond the Clock: Medical, Rx, Dental and Vision Benefits on Day 1| Life Insurance and Disability Coverage | Paid Vacation/Employee Assistance Program

• Grow and Thrive Your Way: Business Resource Groups | Tuition Reimbursement | Professional Development

• Culture of Belonging: Support that starts on day one | Onboarding, training, and development to help you thrive | Recognition programs and employee events that bring us together

• Invest in Your Future: 401k Plan with Company Matching Contributions at 90 days | Employee Stock Purchase Program

• More Perks, Just Because: 35% Discount on Cracker Barrel Food and Retail items | Exclusive Biscuit Perks like discounts on home, travel, cell phones, and more!

A Little About Us

Since 1969, Cracker Barrel has been a place to gather around delicious food, abundant servings, unexpected finds, and a warm welcome. Over time, it's become even more - somewhere folks can reconnect and feel at home. With more than 70,000 team members nationwide, we take pride in our roots -- always serving up more than a meal.

Cracker Barrel is an equal opportunity employer.

Qualified applicants are considered for all positions without regard to race, color, religion, sex, sexual orientation, genetic information, national origin, age, marital status, medical condition, disability or any other class expressly protected by law.