Automation Test Engineer (Python) - Asset & Investment Management | Python | SQL | ETL | London, UK | Hybrid

We are supporting a leading organisation within the Investment Management sector that is looking for anAutomation Test Engineer with Python to support a major investment data integration platform.

The platform acts as an enterprise ETL and integration layer, connecting to front-to-back investment management systems and delivering standardised, high-quality investment data into a modern cloud environment.

This role would suit a hands-on test automation engineer with strongPython, SQL and data testing experience, ideally gained within Asset/Investment Management or Financial Services.

INSIDE IR35

HYBRID WORKING 2- 3 DAYS IN LONDON

MUST HAVE ASSET/INVESTMENT MANAGEMENT EXPERIENCE

Responsibilities

• Design, build and maintain automated test frameworks usingPython

• Develop automated test scripts for ETL/ELT pipelines and data integration workflows

• Validate data movement across source systems, transformation layers and target platforms

• Write complex SQL queries to test data quality, transformation rules and reconciliation logic

• Build automated data reconciliation checks across portfolio, holdings, transactions and reference data

• Support testing of integrations into investment platforms such as Aladdin, CRD, SimCorp, OMS, PMS, IBOR or ABOR systems

• Perform regression testing across new and existing data pipelines

• Work closely with Data Engineers, Data BAs and business SMEs to understand data mappings and requirements

• Identify, investigate and document data defects, root causes and test evidence

• Support automation within CI/CD pipelines using tools such as Azure DevOps, Jenkins or GitHub Actions

• Contribute to test strategy, test planning and best practice around data quality and automation

Experience Required

• Strong hands-on experience inPython test automation

• Good experience with Python testing frameworks such asPyTest, unittest or Robot Framework

• StrongSQL skills, including writing complex queries for data validation and reconciliation

• Experience testing ETL/ELT pipelines, data warehouses, data lakes or cloud data platforms

• Understanding of data quality, data mapping, reconciliation and regression testing

• Experience working with Azure-based data platforms, ideally includingAzure Data Factory, Databricks, Data Lake or Synapse

• Exposure to tools such asGreat Expectations, dbt tests, Soda, Pandas or PySpark would be beneficial

• Experience testing APIs/integrations using tools such as Postman, Swagger, requests or httpx

• Good understanding of CI/CD and automated testing within delivery pipelines

• Strong defect management, analytical and problem-solving skills

• Experience working within Agile delivery environments

• Financial Services experience is required; Asset/Investment Management experience would be highly beneficial

Investment Data Experience Beneficial

Experience testing or validating any of the following would be highly beneficial:

• Portfolio and holdings data

• Transactions and cash movements

• Security master and instrument reference data

• Positions and valuations

• Benchmarks and indices

• Client and mandate hierarchies

• IBOR/ABOR data

• Data from platforms such as Aladdin, CRD, SimCorp or other OMS/PMS platforms