Analytics Engineer

Cracker Barrel Old Country Store, Inc.; United States; On-site; USD 110,000 - 165,000; Full time

Benefits offered by this job

Medical benefits on day 1

Dental and Vision benefits on day 1

401k with company match at 90 days

Employee Stock Purchase Program

Tuition reimbursement

Paid vacation and EAP

Job summary

Cracker Barrel Old Country Store, Inc. is seeking an experienced Analytics Engineer to design, develop, test, and maintain dbt models within Snowflake.

You will transform curated data into reusable analytical datasets and business-ready data products, and build Gold-layer models for enterprise reporting and AI use cases. The role requires collaboration with business stakeholders to translate KPI definitions into governed metrics, and building datasets that support Power BI semantic models with

Qualifications

• Bachelor's degree or equivalent in a related field.
• 4+ years in analytics engineering, BI, data warehousing, data engineering, or advanced analytics.
• 3+ years of advanced SQL development experience.
• Experience with cloud-based data platforms.
• Experience with dimensional data modeling and data warehouse concepts.
• Ability to translate business requirements into scalable data solutions.
• Strong collaboration across technical and business teams.
• Proficient at advanced SQL development and analytical problem-solving.
• Knowledge of relational data structures, data transformation, and data warehousing concepts.
• Familiarity with dbt development, testing, documentation, dependency management, and deployment practices.
• Ability to document logic, lineage, and data dependencies clearly.
• Experience with data quality controls, source control, peer reviews, and production support.

Responsibilities

• Design, build, test, and maintain dbt models in Snowflake.
• Transform data into analytics-ready datasets and business-ready data products.
• Develop dimensional models including fact and dimension tables.
• Create Gold-layer models for enterprise reporting and AI use cases.
• Ensure models meet architecture, naming, SQL, and security standards.
• Collaborate with stakeholders to define KPI calculations.
• Build datasets to support Power BI semantic models and trusted data sources.
• Document logic, lineage, and data dependencies for certifications.
• Implement automated dbt tests and validation checks.
• Monitor production data products and troubleshoot issues.
• Use GitHub for version control, code reviews, and controlled deployments.
• Contribute to CI/CD and reusable development patterns.
• Coordinate with Data Engineering on data availability and scalability.
• Participate in requirements discovery, design, testing, and release validation.
• Provide guidance on datasets, metrics, and data limitations.
• Assist with training on dbt models and data products.

Skills

SQL development

Cloud data platforms

Dimensional modeling

Data warehousing

Team collaboration

Documentation

GitHub/CI/CD basics

Education

Bachelor's degree in CS/IS/data analytics or related field

Tools

dbt

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

• 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.

Requirements

• 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.

They say you are the company you keep - And at Cracker Barrel we take that serious.

See for yourself.