Job Summary:
The Data Analyst will be responsible for supporting Rewards and Fuel Loyalty product teams by transforming loyalty, transaction, and app engagement data into actionable metrics, dashboards, and business insights. The role involves analyzing customer behavior, measuring app usage and member engagement, and supporting product managers and business leaders in making data-driven decisions. The candidate will own analysis tables and recurring reporting for assigned product areas, evaluate the impact of deals, rewards, and fuel offers, and collaborate closely with product, engineering, and data engineering teams.
Key Responsibilities:
• Serve as the embedded analyst for Rewards and Fuel Loyalty product teams by partnering with product managers to define KPIs, establish launch measurement strategies, and report results.
• Build and maintain master analysis tables in Databricks using SQL and Python to track loyalty, deals, rewards, and fuel program performance.
• Develop and maintain Power BI dashboards and recurring reports covering member activity, promotion performance, and other key business metrics.
• Maintain consistent metric definitions across dashboards and reporting processes.
• Measure the performance and incrementality of offers, promotions, and partner programs using test-versus-control and cohort analysis methods.
• Analyze app engagement event data using Mixpanel alongside transaction data from data lakes.
• Identify, validate, and escalate data gaps and quality issues before they impact reporting.
• Perform ad hoc analytical deep dives, including customer segmentation, member activity, and offer redemption analysis.
• Present clear and concise analytical findings to product teams and leadership stakeholders.
• Maintain analytics initiatives and backlog trackers.
• Document data tables, analytical methodologies, and metric definitions to ensure consistency and reusability.
• Follow established data governance and privacy standards when handling customer and loyalty data.
• Submit weekly timesheets against assigned projects.
• Work during core business hours in the US Central time zone and participate in team ceremonies and product meetings.
• Support occasional extended working hours during major product launches and monthly or quarterly reporting deadlines.
Required Qualifications:
• Minimum of 3-5+ years of experience in data analytics, product analytics, or business intelligence, including 3+ years of experience writing SQL queries against large datasets.
• 3+ years of advanced SQL experience, including joins, window functions, and CTEs, on large-scale cloud data platforms such as Databricks or Spark SQL.
• Experience building and maintaining dashboards and reports using Power BI or Tableau for business stakeholders.
• Hands-on experience analyzing customer, transaction, or digital product data, such as loyalty programs, promotions, and app engagement, to measure KPIs and business impact.
• Working proficiency in Python, including pandas or similar libraries, for data analysis.
• Strong attention to data quality, including data validation, source reconciliation, and discrepancy analysis.
• Strong written and verbal communication skills, with the ability to coordinate across product, engineering, and data teams.
• Ability to present analytical findings effectively to non-technical stakeholders.
• Bachelor's degree in a quantitative field such as Statistics, Mathematics, Economics, Computer Science, or Analytics, or equivalent experience.
Preferred Qualifications:
• Experience with product analytics tools such as Mixpanel, Amplitude, or Google Analytics.
• Experience with experimentation and incrementality measurement, including A/B testing and test-versus-control matching.
• Experience with loyalty, rewards, subscription, or fuel program analytics.
• Experience with Databricks notebooks, jobs, and version control tools such as Git.
• Familiarity with AI-assisted coding tools and Jira/Agile methodologies.
• Master's degree in Analytics, Data Science, or a related field.
• Databricks or Power BI (PL-300) certification.
• Industry experience in convenience retail, grocery/QSR, digital and mobile applications, loyalty and rewards programs, or fuel services.
