Bachelor's Degree in a relevant field or equivalent experience
4+ years in analytics engineering or related fields
3+ years of advanced SQL development experience
Experience with cloud-based data platforms
Strong knowledge of dimensional data modeling and data warehousing concepts
Ability to translate business requirements into technical solutions
Experience with dbt development and deployment practices
Responsibilities
Design and maintain dbt models within Snowflake
Transform source data into analytical datasets
Develop Gold-layer models for enterprise reporting
Ensure models meet architecture and documentation standards
Collaborate with stakeholders to define KPIs and metrics
Build datasets for Power BI and self-service reporting
Implement automated dbt tests and monitor data products
Benefits
Medical, Rx, Dental, and Vision Benefits on Day 1
Life Insurance and Disability Coverage
Paid Vacation and Employee Assistance Program
Tuition Reimbursement and Professional Development
401k Plan with Company Matching Contributions
Employee Stock Purchase Program
35% Discount on Cracker Barrel Food and Retail items
Full Job Description
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!
See for yourself. Apply now.
About Cracker Barrel Old Country Store, Inc
Cracker Barrel Old Country Store, Inc. is a chain of restaurants with a Southern country theme. The company operates 664 Cracker Barrel locations in 45 states. The restaurants serve breakfast, lunch, and dinner, and offer a retail store that sells various items, including rocking chairs, holiday and seasonal gifts, apparel, toys, music CDs, cookware, and various other gift items. Cracker Barrel's menu features home-style country food, including biscuits, chicken and dumplings, fried chicken, meatloaf, and pancakes. Cracker Barrel generated $2.3 billion in revenue in 2020.
