Analytics Engineer

Wesleyan

Birmingham

Hybrid

GBP 51,000 - 62,000

Full time

33 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Annual bonus
Holiday allowance
Flexible hybrid working
Pension scheme
Parking (underground)
Salary sacrifice schemes
Family leave & volunteering days

Job summary

Wesleyan in Birmingham is hiring an Analytics Engineer to deliver BI analytics, build data pipelines, and manage semantic layers for Power BI reporting. You will work with stakeholders to translate business needs into scalable data models and dashboards, while championing data governance.

The role requires strong SQL, data modeling, and experience with Microsoft's data stack. Hybrid work with office days in Birmingham is available, and the team values collaboration and continuous improvement.

Qualifications

  • Proven experience as a BI Developer or Data Engineer in hybrid role.
  • Strong SQL skills and ability to design relational and dimensional models.
  • Hands-on experience building data pipelines on Microsoft cloud platform.
  • Power BI development skills including DAX and modeling.
  • Experience using a medallion data architecture (bronze/silver/gold).
  • Translate business requirements into technical specs and data models.
  • Knowledge of data governance, lineage, metadata and MDM.
  • Experience with Python or PySpark for data engineering.
  • Familiarity with DevOps/CI-CD and version control.
  • Experience with AI-assisted development tools and DataOps.
  • Knowledge of governance tools (Purview/Collibra/Informac a).
  • Microsoft certifications in Fabric/Data/Power BI domains.

Responsibilities

  • Collaborate with stakeholders to translate business questions into data solutions.
  • Design and maintain scalable data pipelines and data models.
  • Develop Power BI reports and dashboards with interactive visuals.
  • Ensure data quality, governance, and lineage across pipelines.
  • Work in agile/DataOps environments with CI/CD for deployments.
  • Train users for self-service analytics and promote data culture.
  • Partner with governance, architects and engineers on data products.

Skills

BI Developer
Data Engineer
SQL
Power BI
DAX
Data modelling
Kimball star schemas
Azure Data Factory
Databricks
Python
DevOps/CI-CD
AI-assisted development
Data governance
Power Apps/Power Automate
GitHub/Azure DevOps
Purview/Collibra

Education

Microsoft certifications (DP-600, DP-700, PL-300, DP-900, AZ-900)

Tools

Microsoft Fabric
Azure Data Factory
Databricks
Azure Synapse
Power BI
GitHub
Azure DevOps
Microsoft Purview

Job description

Salary: Up to £56,400 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’re proud to continue that mission with passion and purpose. If you’re looking for a role where your expertise makes a real impact, and you want to work in a culture that values collaboration, innovation, and integrity, we’d love to hear from you.

Find out more about who we are: careers.wesleyan.co.uk

Make a Difference

As an Analytics Engineer, you will act as the technical delivery resource for business intelligence, 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.

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

We're looking for someone with:

  • 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).
  • 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

We believe rewards should reflect the life you live. Here’s what you can expect:

  • 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 Group • Birmingham

Hybrid
GBP 42,000 - 52,000
Annual bonus
Hybrid working
28 days holiday
+5
Group Data Enablement Lead
Group Data Enablement Lead

Wesleyan • Birmingham

Hybrid
GBP 86,000 - 105,000
Annual bonus
Hybrid working
Pension scheme
+2
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
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
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
Project Manager
Project Manager

Wesleyan • Birmingham

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

Wesleyan • Birmingham

On-site
GBP 90,000 - 110,000
Annual bonus
Holiday allowance
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
Data Architect
Data Architect

Utility Warehouse • Farringdon

Hybrid
GBP 90,000 - 130,000
Hybrid working (2 days in office)
Private health insurance
Pension scheme
+5
Head of Data Platform Engineering
Head of Data Platform Engineering

Utility Warehouse Limited • Greater London

Hybrid
GBP 140,000 - 200,000
Hybrid office arrangement
Private healthcare