Rodeo
ResourcesPartnersSign in

MacGregor Black

Senior Data Analyst

Northamptonshire, England, United Kingdom
£55k/yr
Posted 6 days ago
Sign up to applySee more jobs like this

How your CV stacks up

1Upload CV
2Analyse CV
3Improve CV

Upload your CV to see how well it fits this job role

?%

Senior Data Analyst (Partnered with MacGregor Black)

MacGregor Black are partnering with a leading UK business to appoint an experienced Senior Data Analyst to join a growing Data Engineering and Analytics function.

This hands-on role will play a key part in enhancing business decision-making, operational efficiency, and reporting capability across the organisation through the development of:

  • Scalable data models
  • Dashboards
  • Reporting solutions
  • Automation processes

The successful candidate will blend strong technical capability with a business-focused approach, improving visibility, streamlining reporting, and driving data-led decision-making.


Key Responsibilities

  • Design, develop, and maintain dashboards, reports, and analytical outputs across the business
  • Translate complex data into meaningful commercial and operational insights
  • Conduct in-depth analysis to identify trends, risks, anomalies, and improvement opportunities
  • Support stakeholders with self-service reporting and analytical capability
  • Design and maintain scalable data models and reporting pipelines
  • Integrate and prepare data from multiple systems and sources
  • Develop and automate recurring reports and workflows using SQL, Python, and automation tools
  • Support continuous improvement in:
    • Reporting processes
    • Data quality
    • Automation capability
  • Ensure accuracy, consistency, and integrity of reporting outputs
  • Support data cleansing, reconciliation, and governance processes
  • Maintain documentation across reporting structures, models, and analytical processes
  • Work closely with operational, commercial, and technical stakeholders to translate business requirements into reporting and analytical solutions
  • Support adoption of data-led decision-making across the organisation

Reasons to use Rodeo

I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?

Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.

Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.

Start with a chat, not a search bar

Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.

P

Graduate Consultant — 2026 Scheme

PwC·London, UK
£35,000/yr

Why you're a good match

Strong

Your economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.

See breakdown
Save jobNot relevant
View details

It searches the market for you

Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.

Why you're a good match

You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.

See breakdown
Strong

Experience fit

Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.

See breakdown
Strong

Only hits

No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.


What We’re Looking For

Core Requirements

  • Proven experience within a Data Analyst or data-focused analytical role
  • Strong experience building:
    • Dashboards
    • Reports
    • Data models using modern BI tools
  • Experience with:
    • Power BI
    • Oracle Analytics Cloud
    • Business Objects (SAP Crystal Reports preferred)
  • Advanced SQL capability across:
    • Microsoft SQL Server
    • Oracle environments
  • Experience supporting:
    • Operational reporting
    • Commercial reporting environments
  • Ability to manage multiple priorities in fast-paced business environments
  • Advanced proficiency in:
    • Power BI
    • Excel (advanced features, data modelling, dashboards)
  • Strong SQL and data modelling expertise
  • Experience with reporting automation and workflow tools
  • Analytical mindset with strong problem-solving capability
  • Ability to communicate technical information to non-technical stakeholders
  • Excellent organisational and documentation skills

Get help with your application

Your very own career expert that helps elevate your application to the next level.

Get help applying for this job

Highly Desirable

  • Microsoft Power Platform experience
  • Azure Data & Integration Services experience
  • Knowledge of Oracle Integration Cloud (OIC) or Oracle Data Integrator (ODI)
  • Python experience with reporting automation
  • Data or BI certifications (e.g., Microsoft Certified: Power BI Data Analyst)
  • Experience in:
    • Operational
    • Manufacturing
    • Supply chain
    • FMCG (Fast-Moving Consumer Goods) environments
  • Commercially aware and insight-driven
  • Hands-on and delivery-focused
  • Curious and continuously improving
  • Collaborative with strong stakeholder engagement skills
  • Comfortable operating across both technical and business teams

Salary: £50,000 - £55,000 per annum

For more information, please contact Scott McGowan.

Trusted by 25,000+ job seekers

“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”

Jessica, London

Get help applying for this job

Skills

Data Analysis
Dashboard Development
Reporting Solutions
SQL
Python
Data Modeling
Power BI
Oracle Analytics Cloud
Business Objects
Data Automation
Stakeholder Engagement
Data Quality
Continuous Improvement
Analytical Mindset
Problem Solving
Documentation Skills

Location

Northamptonshire, England, United Kingdom

Sign up to applySee more jobs like this