Data engineer in wealth management

Cloud People; Greater London; Hybrid; GBP 111,000 - 166,000; Full time

Job summary

Cloud People is seeking a Senior Data Engineer to empower a wealth management client with sharper, reliable data insights. You will own the end-to-end data flow from pipelines to semantic models and dashboards, delivering trusted analytics.

You will work on Power BI, DAX, SQL and PySpark within a modern Fabric-powered platform, ensuring governance, security and regulatory alignment. Remote with one on-site day weekly in London or Birmingham.

Qualifications

• Strong hands-on experience with Power BI, semantic modelling and DAX.
• Advanced SQL development and query optimisation.
• Hands-on experience building data pipelines in PySpark.
• Familiarity with data governance and regulatory considerations in financial services.

Responsibilities

• Design and maintain semantic models and build Power BI dashboards and reports with well optimised DAX.
• Develop complex SQL, stored procedures and transformation logic to support reporting and analytics.
• Build and maintain scalable PySpark pipelines for large-scale data integration and processing.
• Support the development of a modern data platform with Fabric, Lakehouse, data pipelines and analytics.

Skills

Power BI

Semantic modelling

DAX

SQL development

PySpark

Data pipelines

Microsoft Fabric

CI/CD

Regulatory awareness

Tools

Microsoft Fabric

CI/CD tooling

Git

Job description

This contract sits with a specialist digital consultancy focused entirely on the wealth and investment sector, delivering programmes, products and data solutions for firms in that space. They are bringing in a Senior Data Engineer to support a wealth management business that wants sharper, more reliable insight from its data.

• Design and maintain semantic models, and build Power BI dashboards and reports with well optimised DAX
• Develop complex SQL, stored procedures and transformation logic to support reporting and analytics
• Build and maintain scalable PySpark pipelines for large scale data integration and processing
• Support the development of a modern data platform on Microsoft Fabric, covering Lakehouse, data pipelines and analytics
• Implement and maintain CI CD, version control and testing so data releases are reliable and controlled
• Apply wealth management knowledge across portfolios, investment products, pensions and financial reporting so the numbers are accurate, consistent and trusted
• Strong hands on experience with Power BI, semantic modelling and DAX
• Advanced SQL development and query optimisation
• Practical experience building data pipelines in PySpark
• CI CD experience across data engineering and BI solutions
• A good grasp of data quality, governance, security and regulatory considerations within financial services
• Comfortable taking business requirements and turning them into sound technical solutions
• Remote, with one day per week on site in London (preferred) or Birmingham, expenses covered
• Outside IR35, with expenses covered for the one day a week on site
• Genuine end to end ownership, from pipeline through to semantic model and the dashboards the business relies on
• Hands on exposure to Microsoft Fabric, including Lakehouse and pipelines, as the data platform moves forward
• You will be working with sector specialists who understand wealth management, so the business context makes sense from day one
• Six months to start, with further work likely and a route to permanent for the right person
• It is an initial six month engagement with a target start in mid November. Further work is likely beyond that, and there is potential for the right person to move into a permanent role.