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
Strike IT is an excellent employer that values innovation and collaboration, providing a dynamic work culture where Data Engineers can thrive. With hybrid working arrangements and a focus on employee growth, you will have the opportunity to enhance your skills in a supportive environment while contributing to impactful data solutions in the heart of London.
StudySmarter Expert Advice🤫
We think this is how you could land Automation Test Engineer (Python) - Asset & Investment Management | Python | SQL | ETL in London
✨Get Involved in Finance Communities
Join investment and asset management forums or local finance meetups. Engaging with professionals in these circles can not only help you learn the ropes but also put you in touch with potential employers like Strike IT, who often scout for talent at such events.
✨Utilise Networking Platforms
Connect with professionals already working in asset management on platforms like LinkedIn. A personal message showing your interest in their role or asking for advice can lead to significant connections that might tip the scales in your favour at companies like Strike IT.
✨Show Off Your Financial Skills
Consider contributing to investment blogs or even creating your own content. Sharing your insights and analyses can demonstrate your knowledge and passion for the industry, making you stand out when applying for roles at organisations like Strike IT.
✨Engage with Recruitment Events
Attend finance recruitment fairs and expos. These events are perfect for making a strong impression with recruiters and potentially securing interviews. Many companies, including Strike IT, attend these events to scout for fresh talent, so make sure you stand out with your enthusiasm and knowledge!
We think you need these skills to ace Automation Test Engineer (Python) - Asset & Investment Management | Python | SQL | ETL in London
Some tips for your application 🫡
Highlight Your Analytical Skills:In asset management, it's all about the numbers! Make sure your CV showcases your analytical skills, particularly any experience with financial modelling or quantitative analysis. Employers like Strike IT want to see how you can dissect data and turn it into actionable insights, so don't hold back on your achievements!
Show Off Your Relevant Qualifications:Having the right qualifications can be a game changer in investment roles. If you've got a degree in finance, economics, or a related field, flaunt it! Also, if you have any certifications like CFA or CAIA, mention those too. It’ll help demonstrate your commitment and expertise in the field to Strike IT.
Tailor Your Cover Letter to Reflect Passion for Investment:Your cover letter is your chance to express your enthusiasm for the investment world. Share why you're drawn to asset management and your understanding of market trends. The hiring team at Strike IT will be keen to see that passion and how you keep up with industry news and developments.
Quantify Your Achievements:Don’t just tell them what you did - show them! When detailing your previous experience, include quantifiable achievements to illustrate your impact. Whether it’s percentage growth on a portfolio or cost savings in a project, these figures will help your application stand out to Strike IT. Numbers speak louder than words!
How to prepare for a job interview at Strike IT
✨Brush Up on Financial Modelling
For a role in investment asset management, being well-versed in financial modelling is crucial. Make sure you can articulate your experience with tools like Excel or any specialised software you've used. Maybe even prepare a couple of examples of financial models you've built or analysed.
✨Know Your Investment Strategies
Expect questions around different investment strategies and how you would apply them in various market scenarios. Get ready to discuss current market trends and how they impact portfolio management. This shows you're not just about the theory but also keeping an eye on real-world applications.
✨Show Your Analytical Skills
Since this is a full-time role, companies like Strike IT want to see your analytical thinking in action. Prepare to solve case studies or tackle some numerical puzzles during the interview. Practicing these types of questions will boost your confidence and show off your skills.
✨Discuss Your Long-Term Career Goals
As you’re applying for a full-time position, the interviewers will be interested in your commitment to the field. Be ready to discuss how this role fits into your long-term career plans in asset management. This shows you're not just looking for any job, but you’re genuinely interested in growing withStrike IT.
