Data Quality Analyst (SQL & Python) — ETL Validation

KMC Solutions; Metro Manila; On-site; PHP 480,000 - 720,000; Full time

Job summary

KMC Solutions in the Philippines is seeking a Data QA / Data Analyst to ensure data quality across multiple databases and cloud platforms. The role requires strong SQL skills, knowledge of Python for testing, and experience with ETL/ELT processes.

You will collaborate with cross-functional teams to identify issues and implement improvements. The candidate should be comfortable reporting onsite 1–2 times per month and working with structured and unstructured data in data pipelines.

Qualifications

• Minimum 2 years of experience in Data Quality, Data QA, or Data Analysis.
• Strong SQL skills for data validation, querying, and analysis.
• Working knowledge of Python for data testing and automation.
• Solid understanding of data quality principles: Accuracy, Consistency, Validity.
• Experience working with ETL / ELT processes and data pipelines.
• Familiarity with structured and unstructured data.
• Knowledge of cloud platforms such as AWS or Azure.
• Experience with MongoDB databases.

Responsibilities

• Perform data quality validation to ensure data accuracy, completeness, consistency, and validity.
• Validate datasets using SQL and identify data issues, discrepancies, and anomalies.
• Develop and execute basic Python scripts for data testing and automation.
• Support validation of structured and unstructured datasets.
• Review and validate ETL/ELT data pipelines and data transformations.
• Work closely with cross-functional teams to resolve data quality issues.
• Ensure data integrity across databases and cloud-based platforms.
• Document findings, recommend improvements, and support continuous data quality initiatives.

Skills

Data QA / Data Quality

SQL

Python

Data validation principles

ETL/ELT

Structured and unstructured data

Cloud platforms (AWS/Azure)

MongoDB

Tools

Great Expectations

dbt Tests

Vector databases

RAG pipeline evaluation

Job description

KMC Solutions in the Philippines is seeking a Data QA / Data Analyst to ensure data quality across multiple databases and cloud platforms. The role requires strong SQL skills, knowledge of Python for testing, and experience with ETL/ELT processes.

You will collaborate with cross-functional teams to identify issues and implement improvements. The candidate should be comfortable reporting onsite 1–2 times per month and working with structured and unstructured data in data pipelines.