Analytics Engineer: Snowflake, dbt & Power BI Pro

Cracker Barrel Old Country Store; Lebanon (TN); On-site; USD 100,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Annual bonus

Medical benefits

Life Insurance

Paid vacation

401k with company match

Employee Stock Purchase Program

Cracker Barrel discount

Job summary

Cracker Barrel Old Country Store in Lebanon, TN is hiring an Analytics Engineer to design and maintain Snowflake-backed datasets using dbt, building governed analytics and Power BI semantic models for enterprise reporting and AI use cases. This role collaborates with business and technical partners to translate KPI definitions into reliable metric logic.

You will implement automated tests, maintain data products, and ensure security, documentation, and data quality.

Qualifications

• Bachelor's degree or equivalent with 4+ years in analytics engineering or BI.

Responsibilities

• Design, develop, test, deploy, and maintain dbt models in Snowflake.
• Transform data into reusable analytical datasets and data products.
• Build dimensional models including fact and dimension tables and hierarchies.
• Develop Gold-layer models for enterprise reporting and AI use cases.
• Ensure models follow architecture, naming, SQL, security, and documentation standards.
• Collaborate with stakeholders to translate KPI definitions into governed metrics.
• Build datasets supporting Power BI semantic models and certified data sources.
• Document data lineage, dependencies, refresh expectations, and limitations.
• Create automated dbt tests and validation controls.
• Monitor production data products and troubleshoot issues.
• Use GitHub for version control, PRs, code reviews, and deployments.
• Contribute to CI/CD practices and team templates.

Skills

SQL development

dbt development

Power BI

Snowflake data modeling

GitHub / source control

Data governance

Education

Bachelor’s Degree in Computer Science or related field

Tools

dbt

Snowflake

SQL

GitHub

Power BI

CI/CD

Job description

Cracker Barrel Old Country Store in Lebanon, TN is hiring an Analytics Engineer to design and maintain Snowflake-backed datasets using dbt, building governed analytics and Power BI semantic models for enterprise reporting and AI use cases. This role collaborates with business and technical partners to translate KPI definitions into reliable metric logic.

You will implement automated tests, maintain data products, and ensure security, documentation, and data quality.