Principal Python QA Engineer (Test Automation, SQL, PyTest/ ETL)

Reposted 7 Days Ago
Be an Early Applicant
Covington, KY, USA
In-Office
Senior level
Fintech
The Role
Leads the design and implementation of Python-based test automation for data quality, ETL/ELT validation, data migrations, file integrations, database validation, and large-scale data testing. Builds reusable frameworks, validates data across Snowflake, SQL Server, and Oracle, mentors QA engineers, integrates testing into CI/CD, and partners with engineering, product, and business stakeholders.
Summary Generated by Built In

Fidelity will not provide immigration sponsorship for this position.

Job Description:

The Role

Are you passionate about building scalable automation solutions that ensure the quality, accuracy, and integrity of enterprise data? Do you enjoy solving complex data validation challenges through code and creating frameworks that enable teams to test faster and smarter?

We are seeking a Principal Quality Assurance Engineer to lead the design and implementation of a modern test automation strategy focused on data quality, ETL validation, and large-scale data testing. This role is heavily focused on Python-based automation and is ideal for someone who enjoys building reusable solutions that improve testing efficiency, scalability, and coverage across complex data platforms.

This is not a traditional UI automation role. Approximately 90% of the work will be focused on validating data movement, data transformations, ETL processes, file-based integrations, database validation, and data quality controls. The ideal candidate will possess deep expertise in Python, automated testing, data analysis, and framework development.

As a Principal QA Engineer, you will serve as a technical leader, developing automation frameworks from the ground up, mentoring other QA engineers, and driving best practices across the organization. You will partner closely engineering, product, and business stakeholders, drive an automation-first culture, and deliver innovative and scalable quality engineering solutions.


The Expertise and Skills You Bring

Required Qualifications

  • 8 years of experience in Quality Assurance, Test Automation, Software Development, or Quality Engineering.
  • Expert-level Python programming skills with a proven track record of building automated testing solutions and reusable libraries.
  • Extensive hands-on experience with PyTest and modern Python testing methodologies.
  • Strong experience using Pandas and other Python data-processing libraries for data validation, reconciliation, transformation, and analysis.
  • Extensive experience testing:
    • ETL/ELT data pipelines
    • Data migrations
    • Data movement processes
    • File-based integrations
    • Data quality rules and controls
    • Database-driven applications
  • Strong expertise with database validation and data reconciliation techniques.
  • Advanced SQL skills with experience validating large data sets across Snowflake, SQL Server, and Oracle platforms.
  • Experience with Playwright for UI automation testing.
  • Experience developing automated tests for complex data workflows and business-critical data processing systems.
  • Strong communication, collaboration, and mentoring skills.

Preferred Qualifications

  • Bachelor's or Master's degree in Computer Science, Software Engineering, Information Systems, or a related field.
  • Experience designing and developing automation frameworks from scratch.
  • Experience creating scalable, reusable, and maintainable test automation architectures.
  • Experience testing cloud-based applications and data platforms running in AWS and/or Azure.
  • Experience integrating automated tests into CI/CD pipelines.
  • Experience with GitHub, GitHub Actions, Jenkins, and Artifactory.

The Team

Fidelity Workplace Consulting is a growing business that works primarily with Fidelity’s strategic clients to advise and create solutions on client workplace benefit needs. The Data Consulting Team diverse skills are leveraged to design and build customized solutions to address unique scenarios that spans across multiple product lines (i.e., Defined Benefit, Defined Contribution, Stock Plan Services, Health and Welfare, and HR/Payroll).

Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.

Certifications:

Category:Information Technology

Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.

Skills Required

  • 8 years of experience in Quality Assurance, Test Automation, Software Development, or Quality Engineering
  • Expert-level Python programming skills and experience building automated testing solutions and reusable libraries
  • Extensive hands-on experience with PyTest and modern Python testing methodologies
  • Strong experience with Pandas and Python data-processing libraries for validation, reconciliation, transformation, and analysis
  • Experience testing ETL/ELT data pipelines, data migrations, data movement processes, file-based integrations, data quality rules, and database-driven applications
  • Strong database validation and data reconciliation expertise
  • Advanced SQL skills and experience with Snowflake, SQL Server, and Oracle
  • Experience with Playwright for UI automation testing
  • Experience developing automated tests for complex data workflows and business-critical data processing systems
  • Strong communication, collaboration, and mentoring skills
  • Bachelor's or Master's degree in Computer Science, Software Engineering, Information Systems, or a related field
  • Experience designing and developing automation frameworks from scratch
  • Experience creating scalable, reusable, and maintainable test automation architectures
  • Experience testing cloud-based applications and data platforms in AWS and/or Azure
  • Experience integrating automated tests into CI/CD pipelines
  • Experience with GitHub, GitHub Actions, Jenkins, and Artifactory

Fidelity Investments Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Fidelity Investments and has not been reviewed or approved by Fidelity Investments.

  • Strong & Reliable Incentives — Bonuses, commissions, and profit-sharing are presented as generous and meaningful components of total compensation, with certain roles achieving high total earnings through multiple pay streams. Variable pay is consistently framed as a positive contributor beyond base salary.
  • Retirement Support — A 401(k) match up to 7% alongside additional profit-sharing up to 10% materially enhances long-term compensation. These retirement features are highlighted as standout strengths of the overall package.
  • Parental & Family Support — Generous paid parental leave (16 weeks maternity, 12 weeks parental), backup dependent care, and adoption assistance provide robust family support. Hybrid work and caregiving resources further ease family responsibilities.

Fidelity Investments Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Boston, MA
58,848 Employees
Year Founded: 1946

What We Do

At Fidelity, our goal is to make financial expertise broadly accessible and effective in helping people live the lives they want. We do this by focusing on a diverse set of customers: - from 23 million people investing their life savings, to 20,000 businesses managing their employee benefits to 10,000 advisors needing innovative technology to invest their clients’ money. We offer investment management, retirement planning, portfolio guidance, brokerage, and many other financial products. Privately held for nearly 70 years, we’ve always believed by providing investors with access to the information and expertise, we can help them achieve better results. That’s been our approach- innovative yet personal, compassionate yet responsible, grounded by a tireless work ethic—it is the heart of the Fidelity way.

Similar Jobs

Hometap Logo Hometap

Application Specialist - (January 2027)

Fintech • Real Estate • Software • Financial Services • PropTech
Easy Apply
Remote or Hybrid
USA
314 Employees
65K-65K Annually

BlackLine Logo BlackLine

Sales Representative

Cloud • Fintech • Information Technology • Machine Learning • Software • App development • Generative AI
Remote or Hybrid
USA
1810 Employees
85K-100K Annually

Babylist Logo Babylist

Machine Learning Engineer

eCommerce • Healthtech • Kids + Family • Retail • Social Media
Easy Apply
Remote or Hybrid
United States
300 Employees
234K-349K Annually

HiBob Logo HiBob

Account Manager

HR Tech • Information Technology • Professional Services • Sales • Software
Remote or Hybrid
US
1350 Employees
85K-100K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account