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

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., * 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

• 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