Analyst, Digital & Loyalty Analytics

Panera LLC; United States; Hybrid; USD 84,000 - 95,000; Full time

Job summary

Panera LLC is seeking an Analyst, Digital & Loyalty Analytics in Newton, MA. The role focuses on hands-on data analytics, SQL querying, and dashboard development to support the MyPanera loyalty program and digital channels.

You will measure CRM campaign performance, build automated dashboards in Power BI, and work with cross-functional partners to derive insights from guest data and campaign results. This hybrid role requires strong technical execution and curiosity about consumer behavior.

Qualifications

• 1-3 years of hands-on data analytics or BI experience (Retail/QSR/e-commerce preferred).
• Strong SQL skills with joins, window functions, and complex aggregations.
• Experience with BI tools (Tableau/Power BI) and cloud data platforms (Snowflake/BigQuery).
• Analytical mindset with understanding of loyalty metrics and A/B test lift.

Responsibilities

• Write clean SQL queries to extract and transform guest, transaction, and campaign data.
• Analyze loyalty campaign performance and measure redemption, incremental sales, and lift.
• Design and maintain Power BI dashboards for loyalty KPIs and customer lifecycle trends.
• Support A/B testing readouts and evaluate marketing test results.
• Perform segmentation and behavioral analyses to understand guest patterns and risks.

Skills

SQL

Power BI

Tableau

Snowflake

BigQuery

Excel

Education

Bachelor's degree in Analytics/Statistics/CS

Tools

Tableau

Power BI

Snowflake

BigQuery

Excel

Job description

Analyst, Digital & Loyalty Analytics

Job Purpose

The Analyst, Digital & Loyalty Analytics is the hands-on quantitative engine for Panera's loyalty and customer intelligence team. Sitting within the Business Analytics organization, you will write complex queries, analyze guest transactional data, measure CRM campaign performance, and build automated dashboards that drive decision-making across the MyPanera Loyalty program and digital channels. This role requires strong technical execution in SQL and visualization tools, combined with a natural curiosity for consumer behavior and digital product performance.

Location: Newton, MA (Hybrid - 3 days per week in-office)

Key Responsibilities

• Data Extraction & SQL Execution: Write clean, efficient SQL queries to extract, transform, and aggregate guest, transaction, and campaign data across large-scale enterprise data environments.
• CRM & Loyalty Campaign Measurement: Analyze the performance of loyalty offers, email/app messaging, and personalized promotions to measure redemption rates, incremental sales, transaction lift, and margin impact.
• Dashboard & Visualization Development: Design, deploy, and maintain high-impact Power BI dashboards tracking key loyalty KPIs, including active member growth, subscription retention (Unlimited Sip Club), and customer lifecycle trends.
• A/B Testing & Experimentation Support: Execute readout evaluations for marketing tests and digital feature rollouts, applying statistical methods to measure baseline vs. test performance and incremental lift.
• Customer Segmentation & Behavioral Analysis: Perform ad-hoc exploratory analysis to understand guest frequency patterns, lapsed behavior, category affinity, and trade‑down risks.
• Data Integrity & Validation: Partner with data engineering teams to validate data pipelines, test tracking schemas, and resolve data quality issues across CRM and loyalty databases.

Qualifications

• Experience: 1-3 years of hands‑on experience in data analytics, business intelligence, or marketing analytics (Retail, QSR, E-commerce, or agency background preferred).
• Technical Skills: Strong hands‑on SQL skills required (joins, window functions, complex aggregations). Experience with business intelligence and data visualization tools (Tableau, Power BI, or similar). Familiarity with cloud data platforms (Snowflake, BigQuery) and Excel.
• Analytical Mindset: Foundational knowledge of digital/loyalty metrics (e.g., offer redemption, customer retention, A/B test lift, conversion rates).
• Communication: Ability to summarize analytical findings clearly in slide format and discuss results with cross‑functional partners.
• Education: Bachelor’s degree in Analytics, Statistics, Industrial Engineering, Computer Science, Finance, Business, or a related quantitative field.

Competitive Pay: $83,686 - $95,402 annually

Equal Opportunity Employer: Disabled/Veterans The actual pay offered will be determined by multiple factors, including but not limited to the candidate’s relevant experience, job-related knowledge, skills, and geographical location. Individual compensation decisions are dependent upon the facts and circumstances of each position and candidate.

Newton Support Center

With more than 2,000 Panera LLC and independent franchise bakery-cafes in the Panera Bread family, and more locations opening all the time, it’s no wonder our company has been an excellent source of career and personal growth opportunities for more than 25 years. In neighborhoods across the U.S. and Canada, customers enjoy flavorful, handcrafted meals centered around freshly baked artisan bread. To us, that means serving food like we serve our own families – free of any 'No No' List. Along the way, we also like to give back to our community. We enjoy working together, shoulder to shoulder with our customers, to confront a serious problem plaguing communities across this country – Hunger. Through our Panera Cares community cafes, we offer a dignified dining experience in an uplifting environment. In addition, we support our communities through day-end donations at our bakery-cafe locations and partner with local non‑profit organizations. It’s this warmth that you’ll find when you join Panera Bread. From our competitive compensation and benefits packages to our unique cultural values, we’re confident you’ll find us a rewarding and fun place to work.