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

Job Description

What will you be doing?

We’re seeking a passionate and experienced Data Analytics Engineer to join a thriving team and help in the design, 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.

As a Data Analytics Engineer your responsibilities will include among others,

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

To be successful in this role, you should have,

Experience with Microsoft Fabric, including Lakehouse, Data Engineering, semantic modelling components and Power BI
Advanced SQL and strong proficiency in Python / PySpark
Strong understanding of relational, dimensional, and semantic data modelling principles
Solid experience with ETL/ELT patterns, optimisation, and automation
Experience in performance tuning and monitoring of data platforms and pipelines
CI/CD, version control, and GitHub practices within data engineering 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

As a colleague here at S&W you will have access to benefits that include

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.

Office Location: Southampton

Apply Now