Senior Data Analytics Engineer

S&W; Southampton; Hybrid; GBP 50,000 - 80,000; Full time

Benefits offered by this job

Private medical insurance

Life assurance

Pension contribution

Generous holiday package

Cycle to work scheme

Season ticket loan

Eye care support

Job summary

S&W in Southampton is seeking a passionate Data Analytics Engineer to join their team. The role involves designing and maintaining data solutions that enhance business decision-making.

Applicants should have strong experience with Microsoft Fabric, SQL, and Python, as well as the ability to drive data projects from concept to production. The position offers a competitive salary and benefits, including hybrid working and private medical insurance.

Qualifications

• Demonstrable experience leading data analytics initiatives.
• Ability to drive key data projects from concept to completion.
• Experience collaborating with stakeholders to align data solutions.

Responsibilities

• Architect and maintain scalable ETL/ELT pipelines.
• Design, implement, and maintain Lakehouse and Warehouse structures.
• Provide support for data ingestion and transformation workloads.

Skills

ETL/ELT delivery

Data architecture

SQL

Python/PySpark

Power BI

Data modelling

Tools

Microsoft Fabric

GitHub

Job description

Job Description

At S&W, we help our clients thrive by simplifying the complex, illuminating new paths, and shaping solutions that make a difference. As one of the UK’s top 10 fastest-growing accountancy firms, we have been a trusted partner since 1881—helping businesses and individuals meet challenges and seize opportunities across generations.

Built on expertise and driven by ambition, we provide a comprehensive range of services, including tax and accountancy, advisory and assurance, corporate finance, and restructuring. We are defined by our purpose—to help navigate challenges, unlock potential, and achieve the extraordinary.

What will you be doing?

We’re seeking a passionate and experienced Data Analytics Engineer to join a thriving team and help in thedesign, build and maintenance of scalable data solutions, that bring together data from across the organisation.

You’ll ensure data is well structured, reliable and easy to use for reporting, analytics and in decision‑making. Working as part of the Data Platform Team, you’ll help create a high‑quality, future‑ready data environment that supports business needs now and we continue to grow!

This is a permanent opportunity to be based at our Southampton office with office attendance expected to be 2 days per week.

Key responsibilities

• Architect and maintain scalable ETL/ELT pipelines, optimising for performance, reliability, cost, and data quality across multiple data sources
• Maintain and troubleshoot medallion architecture and dimensional modelling (star schemas) to support enterprise reporting, KPIs, and Power BI semantic models
• Design, implement, and maintain Lakehouse and Warehouse structures in Microsoft Fabric, including data modelling standards and semantic layers
• Provide operational support, monitoring, troubleshooting, and performance tuning for Microsoft Fabric ingestion, dataflows, and transformation workloads
• Identify, resolve, and prevent data quality issues through validation rules, monitoring, alerting, and root‑cause analysis with source system owners
• Design, build, and maintain enterprise‑standard Power BI reports and dashboards, aligned to agreed data models, governance, and reporting standards

Qualifications

Skills and Experience

• Demonstrable experience leading the end-to-end delivery of data and analytics initiatives, ensuring outcomes are aligned to both data strategy and broader business objectives
• Ability to own and drive key data projects from concept to production, balancing delivery pace with quality, scalability and measurable business impact
• Experience in partnering with senior stakeholders to shape priorities, translate business strategy into data solutions and ensure delivered products enable effective decision‑making
• Strong experience in designing and delivering data solutions on Microsoft Fabric (Lakehouse, Warehouse, semantic models, Power BI), with a strong focus on scalable architecture and data modelling principles
• Advanced SQL and Python/PySpark, applied across ETL/ELT development, optimisation, and automation of data pipelines
• Strong engineering practices experience including performance tuning, platform monitoring and CI/CD with version control (GitHub) within modern data workflows

Desired

• Experience working in Agile / Scrum delivery environments
• Strong collaboration/documentation skills for working with BI developers, analysts, and business stakeholders
• Define and maintain master data structures to deliver a single, accurate client view and ensure consistent data flow across applications
• Some knowledge of Web APIs and deep understanding Spark and SQL Server internals

Additional Information

• Competitive salary
• Private medical insurance
• Life assurance
• Pension contribution
• Hybrid working model (role dependent)
• Generous holiday package
• Option to purchase additional holiday
• Shared parental leave
• Cycle to work scheme
• Season ticket loan
• Eye care support

We are proud to value the differences that a diverse workforce brings, representative of society and our clients. At S&W we have a wide range of highly active employee resource groups and we’re delivering multiple diversity, equity and inclusion initiatives across the organisation. It is our commitment to provide a workplace where all colleagues, regardless of identity, background, or circumstance, feel respected as individuals and feel that they can achieve their full potential and work in a safe, supportive, and inclusive environment.

We are happy to make any reasonable adjustments to accommodate for your needs throughout the application process. Please let your Recruiter know.