Senior Data Engineer / Developer – Python & SQL (Investment Data Integration) - Strike IT

We are supporting a leading organisation within the investment management sector who are looking for a Senior Data Engineer to work on a proprietary investment data integration product. The platform is an ETL-driven data integration layer that connects to leading front-to-back investment management systems. It is already integrated with a major OMS/PMS platform and is now being extended to support additional client environments across other enterprise investment systems. This is a highly hands-on engineering role focused on building and enhancing robust Python and SQL-based ETL pipelines within complex investment data ecosystems. INSIDE IR35 THIS ROLE IS MAINLY REMOTE WITH OCCASIONAL TRAVEL TO LONDON Responsibilities : • Design, develop and optimise ETL pipelines using Python and SQL • Build new integrations into enterprise OMS / PMS platforms (Aladdin, CRD, Simcorp Dimension, etc) • Enhance and refactor existing data ingestion and transformation logic • Perform detailed data mapping across complex investment data sets • Transform and normalise portfolio, holdings, transaction, and reference data • Troubleshoot cross-system data inconsistencies • Improve performance, scalability and reliability of data workflows • Work closely with Data BAs and investment stakeholders to interpret data models and requirements Experience : • Strong hands-on development experience in Python • Advanced SQL development skills , including performance tuning and complex query optimisation • Proven experience building and maintaining ETL / data integration pipelines • Strong understanding of data modelling and relational database design • Experience working with investment management data sets such as: • Portfolio & holdings data • Transactions & cash movements • Security master & instrument reference data • Positions & valuations • Benchmarks • Client & mandate hierarchies • Experience integrating with enterprise investment platforms (OMS, PMS, IBOR, ABOR or similar) • Ability to interpret and map complex financial data structures • Strong analytical and problem-solving skills • Experience of working within Asset & Investment Management