Position title
Senior Data Analyst
Description

ADVANCE are seeking an experienced and high-impact Senior Data Analyst to bridge the gap between complex data architecture and strategic business decisions.

In this role, you won't just be "pulling numbers"—you will be the architect of our data storytelling, and pivotal in providing actionable insights, and recommendations to fix and improve business operations and procedures across the business.

The ideal candidate will possess a strong understanding of how data flows and be capable of connecting the dots between our financial, payroll, CRM systems and beyond, to determine a “true reflection” of the state of play, as well as provide meaningful insights and recommendations to help the business move forward.

Purpose Of The Role

  • Advanced Analytics & Modelling: Design and execute complex data queries utilising SQL and Python scripts to extract, clean, and analyse large datasets from multiple sources.
  • Business Intelligence Architecture: Build, maintain, and optimise sophisticated Power BI dashboards that provide real-time visibility into KPIs for executive leadership.
  • Financial Insight: Partner with the Finance team to analyse departmental budgets, revenue forecasts, and fiscal performance, ensuring data integrity across financial systems.
  • CRM Housekeeping and Optimisation: Optimising, improving and ensuring our CRM is updated correctly to allow for the leveraging of our CRM data to track the customer journey, sales pipelines, and marketing attribution.
  • Strategic Advisory: Translate technical findings into plain-English recommendations for non-technical stakeholders to drive growth and operational efficiency.
  • Data Governance: Lead the charge in maintaining high standards for data hygiene, documentation, and reporting consistency across the organisation.
Key Responsibilities

Data Warehouse Maintenance and Management

  • Managing our 3rd party Data Warehouse:  ensuring all systems are running as expected
  • Maintaining Data Warehouse Systems: ensuring updates and security is optimised and performing in the most effective and efficient way possible.
  • Ensuring data is loaded and pulled from the data warehouse correctly – ensuring all API connections and various report connections via SQL/ Python are firing correctly

Financial System Integration & Reporting

  • Revenue Reconciliation: Comparing sales data from Zoho CRM against actualised revenue in the financial systems to identify leakages or reporting discrepancies.
  • Trend Analysis: Using Python to perform time-series forecasting to provide insights on prospective business opportunities
  • Cost-Benefit modelling: Analysing the ROI of marketing spend (from Google Analytics) against the actual lifetime value (LTV) of customers tracked in the CRM.

Advanced Power BI Development

  • DAX Architecture: Developing complex Data Analysis Expressions (DAX) measures to handle "What-if" parameters, allowing executives to simulate different business scenarios.
  • User-Centric Design: Creating tiered dashboards: high-level "Command Centres" for the C-suite and granular "Drill-down" reports for departmental managers.
  • Governance: Setting up Row-Level Security (RLS) so that managers only see the data relevant to their specific region or department.

Strategic "Data Storytelling" & Stakeholder Management

  • Insight Generation: Proactively identifying and communicating findings before a manager even asks for a report.
  • Requirement Gathering: Meeting with Department Heads to understand their "pain points" and designing data solutions that solve specific business problems.

Growth & Optimization (The "Advantage" Tools)

  • Customer Journey Mapping: Linking "Top of Funnel" data with "Bottom of Funnel" data to create clarity across, sales, marketing and operational activity, providing detailed insights and recommendations to improve or optimise performance.
  • Process Automation: Identifying manual tasks (like monthly financial exports) and replacing them with automated systems using such means as; API calls or Python scripts.
Qualifications
  • Hold a degree in Maths, Economics, Computer Science (or any other related field), or a qualification as a Chartered Financial Analyst would be an advantage, but not essential.
  • A high-level knowledge of Python and SQL
  • Detailed knowledge of data visualisation software Power BI
  • A working knowledge of API connections and Data Warehouse management
  • A solid understanding of data analysis techniques, probability, and hypothesis testing.
  • Advanced knowledge of ExCel (pivot tables, modelling) is expected.
  • Highly proficient with Office365 Suite
  • Strong written and verbal communication skills – comfortable presenting to leadership.
Job Benefits
  • ADVANCE Rewards – discounts on shops, cinema tickets, gym memberships etc
  • Dress down Fridays
  • Salary sacrifice EV scheme (OctopusEV / LoveElectric)
  • Subsidised Café (50% off)
  • Company pension (People’s Pension)
  • 25 days holiday + bank holidays and your Birthday off
  • Purchase additional holidays (up to 3 days)
  • Genuine road maps for progression offered.
Contacts

To register your interest in the role, please send your CV to vacancies@advance.online or fill out an enquiry form.

Employment Type
Full-time
Job Location
Ground Floor, Vista, St. David\'s Park, Ewloe, Deeside, CH5 3DT, United Kingdom
Date posted
May 3, 2026

*Required fields

Loading...

Thank you for submitting your application. We will be in touch soon.