Data Analyst

Are you passionate about turning data into clear, actionable insights?

Do you enjoy working with a variety of tools to solve business challenges?

Ready to join a leading retailer where your work will make a tangible impact?

MacGregor Black is partnering with a Leading Retailer on the search for a Data Analyst. This is a hybrid role based in the London area.

As Data Analyst, you will be responsible for delivering data-driven insights across a wide range of datasets. Using tools such as Databricks, Tableau, Looker Studio, Amplitude, and DBT, you will extract, transform, and analyse data to support key business functions.

You will collaborate closely with stakeholders to understand their data needs, generate reports, and provide actionable insights that influence business decisions. Your remit will include analysing sales, customer, marketing, and operational data, as well as supporting digital analytics when required.

Key Responsibilities:

Data Extraction & Analysis

• Write SQL queries in Databricks.
• Support stakeholders with key business questions.
• Handle ad-hoc and recurring data requests.
• Validate data to ensure accuracy.
• Use GitHub via VSCode to manage code repositories.

Delivering Insights & Reporting

• Develop and maintain dashboards and reports (Tableau, Looker Studio).
• Define KPIs and track business performance.
• Present insights to stakeholders clearly and effectively.
• 3. Supporting Digital Analytics & Marketing Data
• Work with web analytics tools (Amplitude, Contentsquare, Medallia).
• Integrate digital data with business datasets.
• Support teams with self-serve analytics tools.

Performance Measurement & Business Support

• Develop performance frameworks.
• Identify trends and provide recommendations.
• Assist with forecasting, target setting, and promotional analysis.

Data Governance & Optimisation

• Conduct QA checks for data accuracy.
• Improve data architecture and integrate new data sources.
• Apply advanced analytics using SQL, Databricks, and other tools.

What are we looking for?

• 2+ years’ experience in a similar role.
• Strong analytical mindset with a passion for uncovering insights.
• Skilled in SQL and data visualisation (Looker Studio, Tableau, Power BI).
• Familiarity with Amplitude/Google Analytics/Adobe Analytics.
• Strong Excel/Google Sheets skills.
• Experience in commercial analysis (target building, forecast setting, promotional analysis).
• Strong communication skills.
• Awareness of digital marketing.
• A Level/degree in Mathematics or STEM.
• Knowledge of statistics.
• Python experience for data analysis.
• Hands-on experience with dbt.
• Awareness of data governance best practices.

This is a hybrid role requiring at least three days per week onsite.

Salary: £40,000 – £45,000

For more information, please contact Gabby Zachrisson today.