Data engineer in wealth management

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.