Data Quality Analyst

EXL; Dadri; On-site; INR 600,000 - 900,000; Full time

Job summary

EXL in India is seeking a Quality Analyst / Data Quality Analyst to validate healthcare data, focusing on SQL, data validation, reconciliation, and data integrity across systems. The role requires collaboration with Business Analysts, Data Analysts, Developers, Product Owners, and other stakeholders to identify root causes and ensure data meets defined quality requirements.

You will perform data validation and testing, develop SQL queries for extraction and reconciliation, and contribute to data

Qualifications

• Experience with SQL for data extraction, validation, and reconciliation.
• Knowledge of data quality concepts and data reconciliation.
• Familiarity with ETL/data warehouse testing is a plus.

Responsibilities

• Analyze healthcare data to identify data quality issues and discrepancies.
• Perform database testing and data validation using SQL.
• Develop and execute queries to extract, compare, reconcile, and validate data across systems.
• Validate data accuracy, completeness, and integrity against business rules.
• Prepare data quality reports and communicate findings to stakeholders.
• Collaborate with cross-functional teams to resolve data-related issues.

Skills

SQL

Data Validation

Data Quality

Analytical

Communication

Agile/Scrum

Jira

Tools

SQL tools

Job description

Quality Analyst / Data Quality Analyst

Job Summary

We are looking for a Quality Analyst / Data Quality Analyst with strong experience in SQL, database testing, data validation, data reconciliation, and data. The candidate will be responsible for validating the accuracy, completeness, consistency, and integrity of healthcare data and identifying and investigating data quality issues.

The role requires close collaboration with Business Analysts, Data Analysts, Developers, Product Owners, and other business and technical stakeholders to identify root causes, resolve data discrepancies, and ensure data meets defined business and quality requirements.

Key Responsibilities

• Analyze healthcare data to identify data quality issues, inconsistencies, anomalies, and discrepancies.
• Perform database testing and data validation using SQL.
• Develop and execute SQL queries to extract, compare, reconcile, and validate data across databases and systems.
• Validate data for accuracy, completeness, consistency, integrity, and conformity with defined business rules.
• Perform source-to-target data validation and reconciliation.
• Validate data transformation and mapping logic between source and target systems.
• Investigate data discrepancies and perform root cause analysis to determine the underlying cause of data quality issues.
• Identify data defects and work with technical teams to track, troubleshoot, and resolve issues.
• Review business requirements, functional specifications, data mappings, and business rules and translate them into data quality and validation requirements.
• Design and execute data validation and testing scenarios based on business requirements.
• Prepare data quality reports, validation results, defect reports, and reconciliation reports and communicate findings to stakeholders.
• Maintain documentation related to data validation procedures, business rules, test scenarios, data quality processes, and defect resolution.
• Collaborate with Business Analysts, Data Analysts, Developers, Product Owners, and other stakeholders to understand requirements and resolve data-related issues.
• Participate in Agile ceremonies, including daily stand-ups, sprint planning, backlog refinement, sprint reviews, and retrospectives.
• Contribute to continuous improvement of data quality, validation, and testing processes.
• Required Skills
• Strong hands-on experience with SQL for data extraction, comparison, validation, and reconciliation.
• Experience in database testing / data testing / ETL testing / data validation.
• Strong understanding of data quality concepts and data reconciliation.
• Experience identifying and analyzing data discrepancies and anomalies.
• Good understanding of source-to-target validation and data mapping.
• Ability to understand business requirements and convert them into test and validation scenarios.
• Experience working in Agile/Scrum environments.
• Strong analytical, problem-solving, and communication skills.
• Experience working with cross-functional business and technical teams.

• Experience with ETL/data warehouse environments is preferred.
• Familiarity with defect management and Agile tools such as Jira is desirable.

Key Competencies

• Data Quality & Validation
• SQL & Database Testing
• Data Reconciliation
• Source-to-Target Validation
• Root Cause Analysis
• Healthcare Data
• ETL/Data Warehouse Testing
• Requirements Analysis
• Defect Management
• Agile/Scrum
• Stakeholder Management
• Analytical & Problem-Solving Skills

Experience

Typically 3- 7 years of relevant experience in Data Quality, Data Testing, Database Testing, ETL Testing, or Quality Assurance,