Senior Data Engineer/Developer - Python, SQL, Azure & Snowflake (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 enterprise ETL and integration layer that connects to leading front-to-back investment management systems and delivers standardised, high-quality investment data into a modern cloud environment.

This role requires a highly hands-on engineer with strong Python, SQL, Azure, Snowflake, and enterprise data integration experience within Asset & Investment Management.

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 investment platforms (Aladdin, CRD, Simcorp Dimension, etc)
• Build and maintain data pipelines within Azure-based infrastructure
• Develop and optimise data models and transformations within Snowflake
• 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 experience working with Snowflake
• Experience developing within Microsoft Azure environments (Data Factory, storage, orchestration, or similar services)
• 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