At a Glance
- Tasks: Design and maintain automated test frameworks using Python for investment data integration.
- Company: Leading organisation in the Investment Management sector with a focus on innovation.
- Benefits: Hybrid working model, competitive salary, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on data quality and automation best practices.
- Why this job: Join a dynamic team and make an impact in the financial services industry.
- Qualifications: Strong Python and SQL skills, with experience in test automation and data validation.
The predicted salary is between 70000 - 90000 £ per year.
We are supporting a leading organisation within the Investment Management sector that is looking for an Automation 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 strong Python, SQL and data testing experience, ideally gained within Asset/Investment Management or Financial Services.
Responsibilities
- Design, build and maintain automated test frameworks using Python
- 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 in Python test automation
- Good experience with Python testing frameworks such as PyTest, unittest or Robot Framework
- Strong SQL 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 including Azure Data Factory, Databricks, Data Lake or Synapse
- Exposure to tools such as Great 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
Automation Test Engineer (Python) - Asset & Investment Management | Python | SQL | ETL in London employer: Strike IT
Join a leading organisation in the Investment Management sector that values innovation and excellence, offering a dynamic work culture where your contributions directly impact the quality of investment data integration. With hybrid working options in London, you will benefit from a collaborative environment that fosters professional growth through hands-on experience with cutting-edge technologies and methodologies. This role not only provides competitive remuneration but also the opportunity to work alongside industry experts, enhancing your skills in a supportive atmosphere focused on continuous improvement.
