Automation Test Engineer (Python) - Asset & Investment Management | Python | SQL | ETL

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

1. Design, build and maintain automated test frameworks usingPython
2. Develop automated test scripts for ETL/ELT pipelines and data integration workflows
3. Validate data movement across source systems, transformation layers and target platforms
4. Write complex SQL queries to test data quality, transformation rules and reconciliation logic
5. Build automated data reconciliation checks across portfolio, holdings, transactions and reference data
6. Support testing of integrations into investment platforms such as Aladdin, CRD, SimCorp, OMS, PMS, IBOR or ABOR systems
7. Perform regression testing across new and existing data pipelines
8. Work closely with Data Engineers, Data BAs and business SMEs to understand data mappings and requirements
9. Identify, investigate and document data defects, root causes and test evidence
10. Support automation within CI/CD pipelines using tools such as Azure DevOps, Jenkins or GitHub Actions
11. Contribute to test strategy, test planning and best practice around data quality and automation

Experience Required

1. Strong hands-on experience inPython test automation
2. Good experience with Python testing frameworks such asPyTest, unittest or Robot Framework
3. StrongSQL skills, including writing complex queries for data validation and reconciliation
4. Experience testing ETL/ELT pipelines, data warehouses, data lakes or cloud data platforms
5. Understanding of data quality, data mapping, reconciliation and regression testing
6. Experience working with Azure-based data platforms, ideally includingAzure Data Factory, Databricks, Data Lake or Synapse
7. Exposure to tools such asGreat Expectations, dbt tests, Soda, Pandas or PySpark would be beneficial
8. Experience testing APIs/integrations using tools such as Postman, Swagger, requests or httpx
9. Good understanding of CI/CD and automated testing within delivery pipelines
10. Strong defect management, analytical and problem-solving skills
11. Experience working within Agile delivery environments
12. 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:

1. Portfolio and holdings data
2. Transactions and cash movements
3. Security master and instrument reference data
4. Positions and valuations
5. Benchmarks and indices
6. Client and mandate hierarchies
7. IBOR/ABOR data
8. Data from platforms such as Aladdin, CRD, SimCorp or other OMS/PMS platforms