Analytics Engineer

Wesleyan Group

Birmingham

Hybrid

GBP 42,000 - 52,000

Full time

8 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Annual bonus
Hybrid working
28 days holiday
Company pension
Free Birmingham parking
Salary sacrifice schemes
Enhanced family leave
Volunteering days

Job summary

Wesleyan is seeking an Analytics Engineer to combine BI analysis with data engineering, building pipelines, models and semantic layers for Power BI reporting. You will partner with Data Governance, engineering and business leaders to ensure data is well‑modelled, documented and fit for purpose in support of the TDD strategy.

The role is hybrid with a Birmingham office, offering up to £47,000 salary based on skills and experience, on a 12-month FTC.

Qualifications

  • Proven experience as BI Developer, Data Engineer or similar hybrid role.
  • Strong SQL skills and experience with relational and dimensional models.
  • Hands-on data pipelines experience on Microsoft cloud data platform (Fabric, ADF, Synapse).
  • Strong Power BI development skills, including DAX and data modelling.

Responsibilities

  • Collaborate with stakeholders to translate business needs into technical specs.
  • Design and maintain scalable data pipelines and semantic models.
  • Develop Power BI reports and dashboards and support self-service analytics.

Skills

SQL
Power BI
Data modelling
Data governance
Stakeholder engagement
CI/CD
Python (optional)

Tools

Microsoft Fabric
Azure Data Factory
Azure Synapse
Databricks

Job description

Short Description

As an Analytics Engineer, you will act as the technical delivery resource for business intelligence, combining BI analysis with data engineering, build and maintain the data pipelines, models and semantic layers that underpin Power BI reporting and self‑service analytics, and also work closely with business stakeholders, engineering, architects, Data Governance team and the wider Data & Analytics function to ensure data is well‑modelled, well‑documented and fit for purpose, supporting the Tech Digital Data (TDD) strategy’s objectives.

Full Job Description
Analytics Engineer

Salary: Up to £47,000 based on skills and experience

Contract Type: 12-month FTC

Location: Hybrid working (office based in Birmingham) – typically 2 days in the office per week

Shape Brighter Futures with Wesleyan

Established in 1841, Wesleyan help trusted professionals—GPs, hospital doctors, dentists, and teachers—secure their financial future. Today,we’reproud to continue that mission with passion and purpose. Ifyou’relooking for a role where yourexpertisemakes a real impact, and you want to work in a culture that values collaboration, innovation, and integrity,we’dlove to hear from you. Find out more about who we are: careers.wesleyan.co.uk

Make a Difference

This role reports into the WFS Data & Analytics Insight Manager. Will have key relationships with the Data, Cyber, Technology Teams, Risk, Audit and Business Leaders across the Group, especially within Wesleyan Financial Services (WFS).

Your Impact

Here’s how you’ll make a difference:

Requirements and stakeholder engagement
  • Work directly with business stakeholders to understand the underlying business problem, challenge and refine requirements, and guide colleagues towards useful solutions early in the development lifecycle.
  • Translate conceptual ideas and business questions into clear technical specifications and reusable data models, documenting requirements and agreed approach.
  • Engage early in business change, projects and new system implementations to identify data and reporting needs, consolidating and prioritising demand pragmatically.
Data pipeline and platform engineering
  • Design, build and maintain scalable, metadata-driven data pipelines across the Group’s Microsoft data platform (e.g. Microsoft Fabric, Azure Data Factory, Databricks or equivalent), ingesting from source systems and line‑of‑business applications as required.
  • Apply a layered (e.g. medallion/bronze-silver-gold) architecture to ensure data is cleansed, modelled and ready for consumption.
  • Build reusable, well-tested transformation logic, favouring build‑once/use‑many approaches over bespoke, one‑off solutions, to reduce maintenance and increase delivery velocity.
  • Ensure pipelines are resilient, monitored, and include appropriate error handling, logging and documentation.
Data modelling and data products
  • Design dimensional data models (e.g. Kimball-style star schemas) and semantic models that are intuitive, performant and reusable across multiple reports and products.
  • Build and own data products — curated, trusted datasets and models — that can be consumed by multiple teams, rather than single‑use reports.
  • Apply naming conventions, documentation and metadata standards consistent with the Group’s data catalogue, glossary and lineage requirements.
BI reporting and visualisation
  • Develop Power BI reports and dashboards, including DAX measures, that are accurate, performant and visually clear, incorporating interactivity and automation where it adds value.
  • Identify opportunities to automate manual or spreadsheet-based reporting and proactively identify legacy reports that no longer serve the business for decommissioning.
  • Train and support business users in self‑service reporting, encouraging the democratisation of data and a stronger data culture.
Data quality, governance and documentation
  • Apply data quality checks and validation within pipelines, escalating material issues to Data Owners and Data Stewards in line with the Group’s data governance framework.
  • Maintain accurate lineage, metadata and documentation for the data products and pipelines owned, supporting the Group’s data catalogue.
  • Ensure all reporting and data handling complies with legal and statutory requirements, including UK GDPR, the Data Protection Act 2018, and relevant Group data security and access control standards.
Ways of working, automation and continuous improvement
  • Work within agile/DataOps ways of working, using version control and CI/CD for pipeline and report deployment.
  • Use AI‑assisted development tools responsibly to accelerate development, documentation, business analysis and testing, validating outputs against real source data before release.
  • Continuously look for opportunities to improve the reliability, performance and maintainability of existing pipelines and reports.
  • Work collaboratively with the Data Governance team, architects, engineers and business analysts across the TDD programme, including the Golden Record and Data Excellence workstreams.
  • Contribute to, and follow, the Group’s data governance policies, and support the data literacy and enablement agenda by sharing good practice with colleagues.
  • Actively take ownership of own career and stay relevant through continuous learning.
  • Undertake such other duties as may from time to time be required.
What You’ll Bring
Essential
  • Proven experience as a BI Developer, Data Engineer or similar hybrid role, combining requirements gathering and analysis with hands-on pipeline and data model development.
  • Strong SQL skills (T‑SQL or equivalent) and experience designing and maintaining relational and dimensional data models (e.g. Kimball-style star schemas).
  • Hands‑on experience building and maintaining data pipelines (ETL/ELT) on the Microsoft cloud data platform (e.g. Microsoft Fabric, Azure Data Factory, Azure Synapse, Databricks, Snowflake or equivalent).
  • Strong Power BI development skills, including DAX, data modelling, and report and dashboard design.
  • Experience applying a layered/medallion data architecture approach (bronze/silver/gold or equivalent) to manage data quality and reusability.
  • Ability to translate business requirements into technical specifications, working directly with stakeholders and constructively challenging requirements.
  • Understanding of data governance principles (data quality, lineage, metadata, master data management) and ability to apply them in day‑to‑day development.
  • Experience identifying, extracting and combining data from multiple source systems.
  • Strong attention to detail, analytical rigour, and the ability to manage competing priorities and tight deadlines.
  • Clear written and verbal communication skills, with the ability to explain technical concepts to non‑technical stakeholders.
  • Understanding of data protection and information security requirements relevant to a regulated financial services environment (UK GDPR, Data Protection Act 2018).
Preferred
  • Experience in financial services, insurance or a similarly regulated sector.
  • Experience with Python (or other scripting languages, e.g. PySpark) for data engineering and automation tasks.
  • Familiarity with DevOps/CI‑CD practices and version control (e.g. GitHub, Azure DevOps) for data and BI development.
  • Experience using AI‑assisted development tools (e.g. GitHub Copilot) to accelerate development, documentation and testing, validated against real source data.
  • Familiarity with DataOps and agile delivery frameworks.
  • Experience with Power Apps or Power Automate to extend data products beyond reporting.
  • Knowledge of data governance or catalogue tooling (e.g. Microsoft Purview, Collibra, Informatica or Alation), consistent with the Group’s wider data governance direction.
  • Relevant Microsoft certifications, such as DP‑600 (Fabric Analytics Engineer Associate), DP‑700 (Fabric Data Engineer Associate), PL‑300 (Power BI Data Analyst Associate), DP‑900 (Azure Data Fundamentals) or AZ‑900 (Azure Fundamentals).
Benefits That Work for You
  • Annual bonus to recognise your contribution.
  • 28 days holiday (plus a culture day) – rising to 30 days with service.
  • Flexible hybrid working for better work‑life balance.
  • Company pension scheme – matched plus 2% (up to 10%).
  • Free secure underground Birmingham city centre parking (subject to availability, weekend use included).
  • Salary sacrifice schemes that help you provide the things that matter – to include PMI, Electric Vehicle Leasing and cashback on everyday essentials.
  • Enhanced family leave and two volunteering days to give back to causes you care about.

Discover the full range of benefits: Wesleyan Careers Rewards

Why Wesleyan?

We’re building a culture where everyone belongs. Diversity isn’t just a policy—it’s part of who we are. Whatever your background, we want you to feel valued and empowered to thrive. We’re proud supporters of the ABI Making Flexible Work campaign, which means we’re open to discussing flexible working, job shares, and part‑time options.

If you need reasonable adjustments during the recruitment process, just let us know—we’re here to support you.

What to Know Before Applying
  • Right to Work: We’re unable to provide VISA sponsorship, so you’ll need the legal right to live and work in the UK.
  • Advert Closing: We typically advertise for two weeks but may close early if we receive a high volume of applications—apply early to avoid disappointment.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analytics Engineer
Analytics Engineer

Wesleyan • Birmingham

Hybrid
GBP 51,000 - 62,000
Annual bonus
Holiday allowance
Flexible hybrid working
+4
Group Data Enablement Lead
Group Data Enablement Lead

Wesleyan Group • Birmingham

Hybrid
GBP 86,000 - 105,000
Annual bonus
28 days holiday (+ culture day)
Flexible hybrid working
+1
Group Data Enablement Lead
Group Data Enablement Lead

Wesleyan • Birmingham

Hybrid
GBP 86,000 - 105,000
Annual bonus
Hybrid working
Pension scheme
+2
Data Engineer
Data Engineer

Wesleyan • West Midlands

Hybrid
GBP 55,620 - 67,980
28 days annual leave plus bank holidays
Company pension scheme
Free secure parking in Birmingham
+3
MI Analyst
MI Analyst

Wesleyan • Birmingham

Hybrid
GBP 31,000 - 38,000
Annual bonus
28 days holiday + culture day (30 with
Flexible hybrid working
+5
Senior Advice Optimisation Manager
Senior Advice Optimisation Manager

Wesleyan • Birmingham

On-site
GBP 90,000 - 110,000
Annual bonus
Holiday allowance
Hybrid working
+4
Senior Advice Framework & Governance Manager
Senior Advice Framework & Governance Manager

Wesleyan • Birmingham

Hybrid
GBP 72,000 - 88,000
Annual bonus
28 days holiday
Flexible hybrid working
+4
Business Analyst
Business Analyst

Wesleyan Group • Birmingham

Hybrid
GBP 50,000 - 61,000
Annual bonus
28 days leave + culture day
Company pension (matched)
+5
With Profits Bonus Actuary
With Profits Bonus Actuary

Wesleyan • Birmingham

Hybrid
GBP 70,000 - 100,000
Annual bonus
28 days holiday + culture day
Flexible hybrid working
+5
Project Manager
Project Manager

Wesleyan • Birmingham

Hybrid
GBP 57,000 - 70,000
Annual bonus
28 days holiday + culture day
Hybrid working
+4