C

Catalina

Analytics & Insights Analyst

Data Analysis +1Updated on Nov 14
Full-timeLondon, UK

About the Job

Requirements

  • Strong practical Power BI experience, including data modelling, Power Query, DAX, report design and refresh troubleshooting, with the ability to help others use it confidently.
  • Working proficiency in at least one of Python or SQL for extracting, checking, transforming and analysing data.
  • Ability to investigate unexpected results, question assumptions, validate work and connect findings to a useful recommendation.
  • Ability to explain analysis, coach nontechnical colleagues and contribute to client discussions.
  • An independent and curious approach, including developing questions, exploring alternative explanations, following patterns, challenging assumptions and turning ideas into useful, checked analysis.
  • Commercial awareness, understanding client priorities, recognizing useful pitches or recommendations, and helping Commercial turn insight into action.
  • Understanding of data flows and quality checks, and willingness to learn account operational processes and support delivery.

Responsibilities

  • Build a deep understanding of Sainsbury’s business priorities, Catalina’s offering and the retail and loyalty market; stay close to Commercial’s pipeline, upcoming client meetings and pitches so analysis addresses relevant opportunities.
  • Explore shopper and campaign data across segments, categories, stores and trends over time to identify commercial opportunities and provide evidence-backed insights, pitch hooks, ideas and recommendations or tests.
  • Own the account’s business-facing data and insight offering by developing reports, data outputs and analysis, maintaining metric definitions, encouraging self-service and helping colleagues select appropriate evidence.
  • Lead Power BI delivery by building and improving models, Power Query transformations, DAX measures and reports; monitor refreshes and data quality; investigate issues with technical colleagues; and guide users in interpreting results.
  • Coach Commercial on targeting, segmentation and measurement; help shape audience and targeting briefs, eligibility and exclusion rules, test and control approaches and success measures; run workshops and create reusable guidance.
  • Deliver targeting and performance analysis across the Sainsbury’s account, including My Favourite Deals and Nectar360 activity; validate outputs and explain customer behaviour, campaign results and incremental impact with clear limitations.
  • Turn discoveries into client stories by equipping Commercial with evidence, pitch hooks, recommendations and reusable examples; join client conversations and help develop practical next steps.
  • Own account analytics requests from initial question through checked result; coordinate delivery with offshore analysts, agree priorities and timescales, communicate progress and raise material risks early.
  • Understand the ETL, scheduled jobs, file transfers, BAU checks and automation behind the account’s data.
  • Work with offshore analysts, Operations and IT to maintain reliable delivery, investigate data or reporting problems and provide cover for essential work.
  • Handle ad hoc Sales and Operations requests, improve repeatable checks or scripts, and document changes so others can support them.

Desired Qualifications

  • Practical experience with both Python and SQL.
  • Experience with Rundeck, VS Code, ETL, data warehouses, Git, DevOps or automation.
  • Retail, loyalty or campaign analytics experience, including segmentation, targeting and test and control measurement.
  • Experience with client presentations, commercial pitches, training or analytical workshops.
  • Experience with data science or statistical methods, and curiosity about practical uses of AI in analysis, reporting and automation.

About the Company

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at Catalina

See more jobs