Quality Assurance Analyst, Lead

Paycom; Arcadia (CA); Hybrid; USD 100,000 - 120,000; Full time

Job summary

Clever Care Health Plan is seeking a Lead QA Analyst to ensure the quality and reliability of enterprise data integrations, data warehouses, and analytics platforms. You will collaborate with Data Engineers, Product Managers, and stakeholders to validate ETL processes, API integrations, and reporting datasets.

You will lead test strategy design, execution, and regression testing across data integration initiatives, ensuring data quality before production deployment and driving improvements in QA

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or related field, or equivalent experience.
• Minimum four years QA experience with enterprise data integration, data warehousing, ETL, or analytics.
• Minimum two years hands-on data validation and ETL testing experience.
• Experience testing large-scale databases and data warehouse environments.

Responsibilities

• Design, develop, and execute test plans, cases, and scripts for data integration and ETL solutions.
• Validate source-to-target mappings, transformation rules, and data quality requirements.

Skills

SQL

ETL testing

Data validation

QA automation

Education

Bachelor's degree in CS/IT/Engineering

Tools

Azure DevOps

Jira

SSIS

Power BI

Job description

Job DetailsJob Location: Arcadia Office - Arcadia, CA 91007Position Type: Full TimeSalary Range: $100,179.00 - $120,000.00 SalaryThis position operates on a hybrid work schedule. This position will require 3 days onsite at the Monrovia or Huntington Beach office.

Are you ready to make a lasting impact and transform the healthcare space? We are one of Southern California’s fastest-growing Medicare Advantage plans with an incredible 112% year-over-year membership growth.

Who Are We?

Clever Care was created to meet the unique needs of the diverse communities we serve. Our innovative benefit plans combine Western medicine with holistic Eastern practices, offering benefits that align with our members’ culture and values.

Why Join Us?

We’re on a mission! Our rapid growth reflects our commitment to making healthcare accessible for underserved communities. At Clever Care, you’ll have the opportunity to make a real difference, shape the future of healthcare, and be part of a fast-moving, game-changing organization that celebrates diversity and innovation.

Job Summary

The QA Analyst, Lead is responsible for ensuring the quality, accuracy, completeness, and reliability of enterprise data integrations, data warehouse solutions, and analytics platforms. This role works closely with Data Engineers, Product Managers, Technical Data Analysts, Business Analysts, Database Administrators, and business stakeholders to validate data pipelines, ETL processes, API integrations, reporting datasets, and downstream analytics solutions.

The QA Analyst, Lead leads the planning, design, execution, and testing activities across data integration initiatives. The role is responsible for creating comprehensive test strategies, validating source-to-target mappings, performing data reconciliation, identifying defects, and ensuring enterprise data quality standards are met before deployment to production.

Functions & Job Responsibilities

• Partner with Data Engineering, Business Intelligence, Application Development, Product Management, and business stakeholders to define testing approaches and acceptance criteria.
• Design, develop, and execute comprehensive test plans, test cases, and test scripts for data integration and ETL solutions.
• Create reusable test frameworks and testing standards for data integration projects.
• Validate source-to-target data mappings, transformation rules, business logic, and data quality requirements according to business requirements for internal and external processes.
• Validate incremental loads, full refresh processes, data archival processes, and exception handling.
• Conduct regression testing following application releases, infrastructure upgrades, and data model changes.
• Perform data reconciliation and data validation between source systems, vendor partners, data warehouses, data marts, and reporting platforms.
• Validate batch processing, file transfers, API integrations, and real-time data interfaces.
• Analyze and troubleshoot data discrepancies, defects, and production issues.
• Conduct end-to-end testing across multiple systems and applications to ensure data consistency and integrity, including coordination with external vendor technical teams.
• Identify bottlenecks in large-volume data processing.
• Perform dimensional model validation, fact and dimension testing, and historical data verification.
• Identify opportunities to improve QA processes, increase test coverage, and reduce manual testing effort.
• Participate in CI/CD and release management processes to support efficient deployments.
• Contribute to the development and maintenance of data quality metrics and monitoring capabilities.
• Participate in Agile ceremonies including sprint planning, backlog refinement, daily stand-ups, and retrospectives.
• Mentor junior QA analysts and contribute to the growth of QA best practices within the Data Services organization.
• Support production validation activities and post-deployment verification.
• Other duties as assigned.

Leadership Expectations

• 1. Model the Way:

  Clarify values by finding your voice and affirming shared values

  Set the example by aligning actions with shared values

• 2. Inspire a Shared Vision:

  Envision the future by imagining and sharing exciting possibilities

  Enlist others in a common vision by appealing to shared ambitions

• 3. Challenge the Process:

  Search for opportunities by seizing the initiative and looking outward for innovative ways to improve

  Experiment and take risks by consistently generating small wins and learning from experience

• 4. Enable Others to Act:

  Foster collaboration by building trust and facilitating relationships

  Strengthen others by increasing self-determination and developing competence

• 5. Encourage the Heart:

  Recognize contributions by showing appreciation for individual excellence

  Celebrate the values and victories by creating a spirit of community

Qualifications

Education and Experience:

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field; equivalent experience may be considered.
• Minimum four (4) years of Quality Assurance experience with enterprise data integration, data warehousing, ETL, or analytics platforms.
• Minimum two (2) years of hands-on data validation and ETL testing experience.
• Experience testing large-scale databases and data warehouse environments.
• Experience working in Agile software development environments.
• Experience with cloud-based data platforms such as AWS, Azure, Snowflake, Databricks, or similar technologies preferred.
• Familiarity with a range of business areas related to healthcare (e.g., medical management, utilization management, claims management, transaction services, network operations, RAF and coding, marketing, accounting, finance) preferred.

Skills

• Strong SQL skills with the ability to create complex validation and reconciliation queries.
• Experience validating ETL/ELT workflows and data pipelines.
• Knowledge of relational databases and dimensional data modeling concepts.
• Experience with test management and defect tracking tools such as Azure DevOps, Jira, TestRail, or similar platforms.
• Familiarity with API testing, file validation, and integration testing methodologies.
• Familiarity developing automated testing scripts using SQL, Python, or other automation technologies preferred.
• Familiarity with AWS data services, SQL Server, SSIS, QuickSight, Power BI, and healthcare interoperability standards.
• Experience testing healthcare data feeds including CMS, EDI X12, FHIR, HL7, claims, membership, provider, and encounter data.
• Understanding of healthcare data domains such as claims, eligibility, providers, encounters, authorizations, pharmacy, risk adjustment, CMS and NCQA is highly desirable.
• Excellent analytical, problem-solving and critical thinking skills.
• Strong verbal and written communication skills.
• Exceptional attention to detail and accuracy.
• Continuous improvement mindset.
• Ability to manage multiple priorities and deliver high-quality work in a fast-paced environment.
• Strong collaboration and stakeholder management capabilities.
• Ability to work independently.

Physical & Working Environment.

Physical requirements needed to perform the essential functions of the job, with or without reasonable accommodation:

• Must be able to travel when needed or required
• Ability to operate a keyboard, mouse, phone and perform repetitive motion (keyboard); writing (note-taking)
• Ability to sit for long periods; stand, sit, reach, bend, lift up to fifteen (15) lbs.

Ability to express or exchange ideas to impart information to the public and to convey detailed instructions to staff accurately and quickly.

Work is performed in an office environment and/or remotely. The job involves frequent contact with staff and public. May occasionally be required to work irregular hours based on the needs of the business.

Clever Care Health Plan is proud to be an Equal Employment Opportunity and Affimative Action workplace. Individuals seeking employment will receive consideration for employment without regard to race, color, national origin, religion, age, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, gender perception or identity, age, marital status, disability, protected veteran status or any other status protected by law. A background check is required.

Salary ranges posted on the job posting are based on California wages. Salary may be higher or lower depending on the candidate’s state residency.