Quality Check Analyst (SQL + Python)

Role Overview: You will be working as a Data Quality Analyst / Quality Check Analyst with 14 years of experience in the Data / Analytics / Engineering department. Your primary responsibility will be ensuring the accuracy, consistency, and reliability of data within SQL databases. You should have a strong background in data cleaning, validation, standardization, and automation using SQL and Python scripts. Key Responsibilities: - Identify and remove duplicate records in SQL databases. - Detect and correct inconsistent, missing, or mixed-format data. - Standardize data fields such as dates, phone numbers, addresses, and names. - Write and optimize SQL queries, stored procedures, and scripts for data validation and correction. - Automate data quality checks using Python libraries like pandas and SQLAlchemy. - Perform data audits and reconciliation to uphold data accuracy. - Collaborate with data engineers and analysts to enhance data pipelines. - Generate data quality reports and dashboards. - Maintain documentation for data cleaning and quality standards. Qualification Required: - Strong SQL knowledge including DDL, DML, JOINs, CTEs, and Window Functions. - Hands-on experience in data cleaning, deduplication, and transformation. - Proficiency in Python libraries such as pandas, numpy, and SQLAlchemy for data quality automation. - Experience with ETL or data validation scripts. - Familiarity with data profiling and quality metrics. - Good understanding of relational databases like MySQL, PostgreSQL, and MS SQL Server. - Strong analytical and problem-solving skills with attention to detail and documentation skills. Additional Details: The job is full-time and located in Bangalore. Preferred skills include experience with data pipelines, Airflow, Power BI, Excel validation tools, familiarity with data warehousing concepts, and understanding of data governance and data accuracy KPIs.,