About the role
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.
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 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
Requirements
•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
Nice to have
•Microsoft Fabric experience, and familiarity with wealth management platforms, investment data, portfolio reporting or pension administration
Conditions
•£450-500 per day, Outside IR35, initial 6 month contract
•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
•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
•Initial six month engagement with a target start in mid November; further work is likely beyond that, with potential to move into a permanent role
