Manager – ETL Testing & Test Data Management

100 Raymond James & Associates, Inc.; Saint Petersburg (FL); Hybrid; USD 115,000 - 155,000; Full time

Job summary

100 Raymond James & Associates, Inc. is hiring for a senior QA/Data Testing lead to oversee ETL testing and test data management. The role collaborates with SQM, Development, Data, and Business partners to ensure high-quality data pipelines and robust testing frameworks.

The position emphasizes automation-first testing, data governance, and collaboration across data-centric teams. Hybrid work in St. Petersburg, FL is required with in-office presence 3 days per week.

Qualifications

• 10+ years of experience in QA/Testing.
• Strong hands-on experience in ETL/Data Testing.
• SQL and data warehousing concepts.

Responsibilities

• Lead ETL Testing and Test Data Management teams with clear priorities and career development.
• Own the end-to-end test strategy for ETL/data pipelines, including source-to-target validation and performance testing.
• Drive data lineage validation and data comparison testing using Ab Initio and ODI-based ETL jobs.
• Define and drive the Test Data Management strategy, including masking, synthetic data, and data refresh processes.
• Champion automation-first testing, evaluating, adopting, and building AI-driven tools to reduce manual testing.
• Partner with Data Engineering, BI/Analytics, and Product teams to embed quality checks early in the data pipeline lifecycle.

Skills

ETL/Data Testing

SQL

Data Warehousing

QA/Testing

Job description

Job Description Summary Note

This position will follow our hybrid work model, we expect the selected candidate to be in the office 3 days a week at the St. Petersburg, FL Corporate Office location. This role is not eligible for Work Visa sponsorship, either currently or in the future.

Job Description Leads ETL/Data Testing and Test Data Management initiatives by working closely with SQM, Development, Data, and Business Partners to ensure the delivery of high-quality data and reliable data pipelines. Acquires a deep understanding of data architecture, ETL processes, data flows, and test data requirements to ensure comprehensive and effective testing. Collaborates with development and testing teams to establish data testing strategies, standards, and reusable frameworks that support functional, integration, regression, and end-to-end testing. Identifies opportunities to improve ETL testing and Test Data Management processes and recommends enhancements to testing methods, tools, automation, and frameworks. Drives the adoption of innovative technologies, including AI agents, for test case generation, data validation, anomaly detection, and synthetic test data creation. Collaborates with SQM teams to ensure data testing and test data practices align with SDLC standards and remain reusable across projects. Collaborates with SQM leadership to ensure appropriate allocation of resources across ETL Testing and Test Data Management activities. Works closely with Development, Data, and Business teams to establish priorities and facilitate decisions pertaining to data quality and testing.

Key Responsibilities

• Lead, mentor, grow ETL Testing and Test Data Management teams, ensuring high performance, clear priorities, and career development for team members.
• Own the end-to-end test strategy for ETL/data pipelines — covering source-to-target validation, transformation logic, data completeness, accuracy, reconciliation, and performance testing.
• Drive data lineage validation and data comparison testing using Ab Initio and oversee testing of Oracle-based ETL jobs built on ODI (Oracle Data Integrator).
• Define and drive the Test Data Management strategy, including data provisioning, sub setting, masking/anonymization, synthetic data generation, and data refresh processes across environments.
• Champion automation-first testing — evaluate, adopt, and build tools/frameworks (including AI-driven/agentic solutions) to reduce manual testing effort and increase test coverage.
• Explore and implement AI agents to automate repetitive data testing tasks such as test case generation, data profiling, anomaly detection, schema drift detection, and synthetic test data creation.
• Partner closely with Data Engineering, BI/Analytics, and Product teams to embed quality checks early in the data pipeline lifecycle (shift-left testing).
• Establish metrics, dashboards, and reporting to track test coverage, defect trends, data quality KPIs, and team productivity.
• Manage stakeholder relationships, set delivery timelines, and ensure testing milestones align with overall project/program schedules.
• Stay current with emerging trends in data quality engineering, test automation, and AI/ML-based testing tools, and bring innovative ideas into the team's roadmap.

Experience and Skills

• 10+ years of overall experience in QA/Testing, with strong hands-on experience in ETL/Data Testing, SQL, data warehousing concepts, and