Data engineer in wealth management
Posted 61
views
Summary
Contract role for a senior data engineer supporting a wealth management business via a specialist consultancy: building Power BI dashboards with optimised DAX, advanced SQL, PySpark pipelines, and a Microsoft Fabric data platform with CI/CD. Remote with one on-site day per week in London or Birmingham; six-month initial engagement, outside IR35.
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.