Wesleyan logo

Analytics Engineer

WesleyanApplies on LinkedInData & Analytics
Salary
Up to £56.4K
Hiring from
United Kingdom
Work type
Hybrid
Posted

627,506 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

Analytics Engineer

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.

Collaboration

  • 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:

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

Desirable

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


Ready to Shape Your Future?

Apply today and join us in creating brighter financial futures—for our customers, our members, and you.

Similar jobs

Apply for this job100% free