Senior QA Analyst

Mbi Llc; Trenton (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

Mbi Llc is seeking a Senior QA Analyst with 7+ years of experience to validate enterprise data pipelines and cloud integrations. The role balances automated testing with essential manual validation to ensure absolute data integrity across the cloud data stack.

You will own data quality and regression testing for our cloud data platform, ensuring seamless data flow and transactional consistency from source systems into our data warehouse, with a focus on automating checks and performing hands-on

Qualifications

• 7+ years of QA automation and data validation experience.
• Strong SQL skills for data reconciliation and schema validation.
• Experience with AWS core services and cloud data platforms.
• Familiarity with Snowflake or comparable data warehouses.
• Knowledge of dbt data build tool is a plus.

Responsibilities

• Validate enterprise data pipelines and cloud integrations.
• Balance automated testing with manual validation for data integrity.
• Own data quality and regression testing from source systems to data warehouse.
• Build scalable test automation frameworks and perform manual validation.
• Write complex SQL queries for data reconciliation and end-to-end checks.
• Validate data object mapping between Salesforce and downstream platforms.
• Integrate automated quality gates into DevOps and CI/CD pipelines.

Skills

Data / QA Automation

Advanced SQL querying

AWS Core Cloud Services

Snowflake

dbt Validation

Copado Robotic Testing

Tools

Copado Robotic Testing

Job description

Job Responsibilities

• Seeking a Senior QA Analyst with 7+ years of experience to validate enterprise data pipelines & cloud integrations.
• This role balances automated testing with essential manual validation to ensure absolute data integrity across our cloud data stack.
• You will own data quality and regression testing for our cloud data platform, ensuring seamless data flow and transactional consistency from our source systems into our data warehouse.
• This role requires a balance of building automated checks and performing hands‑on manual data reconciliation to quickly isolate anomalies.
• Build and maintain scalable test automation frameworks while performing strategic manual data validation across cloud data pipelines.
• Write complex, high-performance SQL queries for deep‑dive data reconciliation, schema validation, and end‑to‑end data integrity checks.
• Validate transactional consistency and data object mapping between Salesforce and downstream data platforms.
• Utilize automated testing tools to support Salesforce environments, with experience in Copado Robotic Testing considered a major plus.
• Integrate automated quality gates and data tests directly into DevOps and CI/CD deployment pipelines.
• Collaborate closely with data engineering and cloud architecture teams to troubleshoot and resolve pipeline anomalies.

Skill Matrix

• Data / QA Automation Experience – Required: 7 years
• Advanced SQL Querying – Required: 7 years
• AWS Core Cloud Services – Required: 3 years
• Snowflake (or competitor like Databrick/BigQuery/Reshift) – Required: 3 years
• dbt (data build tool) Validation – Highly desired: 2 years