Senior IT QA Data Quality Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Define, sustain, and enhance the Data QA strategy for EDW and Data Services projects.

• Design, document, and execute data quality assessments across the delivery layers of the Enterprise Data Warehouse.

• Set criteria for testing entry, exit, suspension, and completion.

• Develop repeatable test plans that encompass mappings, business rules, transformations, referential integrity, duplicates, nulls, completeness, and accuracy.

• Validate CDC processing, incremental loads, historical processing, and source-to-target reconciliation.

• Assess data masking, sensitive data management, and privacy-related transformation rules.

• Review test coverage and evaluate production-readiness risks.

• Calculate and monitor data quality outcomes in collaboration with Data Engineers and BI Engineers.

• Write SQL queries and reports to assess data content for quality assurance purposes.

• Create Power BI dashboards to visualize data quality metrics, defect trends, testing progress, and release readiness.

• Analyze incoming data streams, data content trends, metadata gaps, reference data, standardization, business rules, and quality controls.

• Develop alert mechanisms for system and data quality issues, data receipt, completeness, and scheduling discrepancies.

• Collaborate with Product, Development, Data Engineering, DataOps, BI Engineering, UAT teams, business stakeholders, and vendors.

• Maintain requirement traceability matrices.

• Coordinate test planning, execution, defect triage, retesting, regression testing, and release readiness.

• Provide risk assessments and evidence-based recommendations for go/no-go decisions.

• Mentor QA Analysts and review test plans, SQL queries, evidence, defects, and validation methods.

• Establish reusable Data QA standards, templates, and best practices.

• Automate repeatable SQL validation, reconciliation, data comparison, regression testing, and quality reporting.

• Assist in defect analysis and root-cause investigations.

• Conduct regression testing for code releases, pipeline alterations, EDW enhancements, and reporting modifications.

• Maintain test execution, defect tracking, traceability, and evidence in qTest, Jira, or similar tools.

• Perform additional duties as assigned.

⛳️ Requirements

• Bachelor's Degree related to the position or an equivalent qualification is preferred.

• At least five years of experience with corporate data management systems in high-compliance environments.

• Understanding of data quality concepts, source-to-target mapping, reconciliation, snowflake/star schema, dimensional modeling, slowly changing dimensions, referential integrity, completeness, correctness, consistency, validity, uniqueness, and timeliness.

• Advanced SQL proficiency, including joins, aggregations, common table expressions, window functions, exception queries, reconciliation queries, duplicate analysis, null analysis, key validation, and transformation validation.

• Familiarity with Snowflake and cloud-based data warehouse or data platform concepts.

• Knowledge of AWS S3 and data formats such as Parquet and Avro, both structured and semi-structured.

• Familiarity with Informatica Data Quality and IICS.

• Experience in validating ETL/ELT pipelines, ingestion, transformation, movement, warehouse layers, dimensional models, and downstream reporting.

• Proven experience in validating CDC, incremental loads, inserts, updates, deletes, historical processing, and Type 2 slowly changing dimensions.

• Experience with source-to-target validation and reconciliation across operational systems, EDWs, cloud platforms, and reporting or analytics tools.

• Proven experience with data masking, sensitive data management, privacy rules, and their impact on reporting.

• Basic knowledge of statistical methods such as the Shewhart method and trend analysis.

• Experience in automating testing, SQL validation, data comparison, and regression testing.

• Experience in test data management and developing test data strategies.

• Experience with defect management, root-cause analysis, requirements traceability, and audit-ready evidence.

• Proficiency in using Jira and qTest or equivalent tools.

• Experience in implementing data quality metrics, dashboards, release readiness reports, and audit documentation.

• Ability to define QA strategy, establish entry and exit criteria, review test coverage, assess release risks, and provide evidence-based recommendations.

• Capability to mentor QA Analysts and foster consistent data QA practices.

• Excellent verbal and written communication skills are essential.

• Strong critical-thinking, technical problem-solving, abstract-thinking, organizational, and detail-oriented skills.

• Ability to create clear, concise, and detailed test plans, test cases, test evidence, defect documentation, and release readiness summaries.

• Proficiency in Microsoft Office Suite, including Word, Excel, Wiki, collaborative cloud-based software, and third-party applications is required.

• Commitment to the values of the company.

• Ability to learn tasks, remember processes, maintain focus, work independently, make timely decisions, adapt to workplace pressures, and adhere to established protocols.

• Availability to work Monday through Friday during regular business hours.

🏝️ Benefits

• Medical insurance.

• Dental insurance.

• Vision insurance.

• Life insurance.

• AD&D insurance.

• LTD insurance.

• 401(k) plan with employer matching.

• Remote work arrangement.

• Enjoyable work environment.

• Competitive salary.