Senior Data QA Engineer

Pantheon has been at the forefront of private markets investing for more than 40 years, earning a reputation for providing innovative solutions covering the full lifecycle of investments, from primary fund commitments to co-investments and secondary purchases, across private equity, real assets and private credit.

We have partnered with more than 650 clients, including institutional investors of all sizes as well as a growing number of private wealth advisers and investors, with approximately $65bn in discretionary assets under management (as of December 31, 2023).

Leveraging our specialized experience and global team of professionals across Europe, the Americas and Asia, we invest with purpose and lead with expertise to build secure financial futures.

For further details please visit www.pantheon.com

Company Profile:

Pantheon is an international investor in private equity, infrastructure & real assets, and debt, managing investments on behalf of over 680 institutional investors as of June 30, 2021. Our clients include public and private pension plans, insurance companies, endowments, and foundations. Pantheon's investment strategies span primary fund programs, secondaries, co-investments, infrastructure, real assets, real estate, private debt, and customized programs. Additionally, Pantheon manages and advises Pantheon International Plc. (PIP), listed on the London Stock Exchange. Headquartered in London, we have offices in San Francisco, Hong Kong, Bogotá, Seoul, Tokyo, New York, Dublin, and Berlin, employing over 383 staff including 113 investment professionals.

For more information, visit our website: www.pantheon.com.

Purpose of Position:

Pantheon is undergoing a multi-year program to build a new best-in-class Data Warehouse using cloud-native technologies hosted in Azure. This role is integral to the success of this program and establishing Pantheon as a data-centric organization. You will work with the Azure tech stack alongside existing ETL pipelines built with SAP Business Objects Data Services. Proven experience in testing ingestion and transformation of data from various internal and external systems is essential. The Senior Data QA Engineer will be a key member of the data team, working closely with peers to ensure solutions are delivered efficiently and to the highest quality.

Key Responsibilities:

• Plan, design, and execute testing activities for new features and changes to existing systems.
• Create and execute test cases, both manual and automated, to verify functional and non-functional requirements at various development stages.
• Advocate for test automation and deliver working CI/CD solutions.
• Identify and verify critical bugs, determining their underlying causes and ensuring resolution through collaboration with other teams.
• Produce clear and concise bug reports evidencing solution functionality.
• Communicate status information and issues to stakeholders, adapting communication based on the audience.

Knowledge and Experience Required:

• Extensive experience in testing software systems and Data Warehouses.
• Ability to create, adapt, and execute effective test strategies.
• Creative problem-solving and innovation skills.
• Experience in creating and maintaining automated test frameworks.
• Advanced SQL skills with a solid understanding of database structures.
• Experience testing data and storage services in Azure (Azure SQL Database, Data Lake, Data Storage).
• Extensive experience in testing BI reports, dashboards, datasets, and data models.
• Experience with agile software development methodologies, including BDD and TDD.
• Proficiency in different test automation tools and technology.
• Solid understanding of the testing pyramid and experience implementing it at various levels.
• Experience working in a continuous integration and delivery environment.
• Hands-on experience with the Azure Data Integration toolset.
• Working knowledge of product/defect/test case management systems.
• Attention to detail and a thorough approach to testing.

Essential Technical Skills:

• Advanced SQL
• Automated Test Framework design and build using SQL, Python
• Azure Databricks, SQL Database, Azure Data Lake, Azure Data Factory
• Traditional ETL tools (SAP Business Objects Data Services, INFORMATICA, SSIS, etc.)
• Azure DevOps, Git, Pipelines

Desired Technical Skills:

• Business Objects
• Crystal Reports
• Power BI

Experience in financial services, particularly in private equity, infrastructure & real assets, or private debt, is ideal but not required.

Pantheon is an Equal Opportunities employer.

This job description is not to be construed as an exhaustive statement of duties, responsibilities, or requirements. You may be required to perform other job-related duties as reasonably requested by your manager.

Pantheon is an Equal Opportunities employer, we are committed to building a diverse and inclusive workforce so if you're excited about this role but your past experience doesn't perfectly align we'd still encourage you to apply.