Job Title: Data Quality & Transformation Analyst (SQL / Testing)
Experience: 2–5 years of experience in data analysis or a related field, with demonstrated experience in SQL, data transformations, and data quality testing/validation.
Job Summary: Data Quality & Transformation Analyst will analyze data to understand its structure and behavior and will design transformations tailored to multiple downstream use cases. The role focuses on building SQL-based views, supporting schema design and data modeling, and implementing robust data validation checks. The analyst will develop and execute unit, integration, and regression test cases to ensure dataset reliability and to prevent inconsistencies in reporting outputs. Tableau skills are a plus (mid-level preferred), and training will be provided.
Key Responsibilities:
Understand business and technical use cases and translate requirements into appropriate data transformations.
Design and develop SQL views and queries for analytics and reporting consumption.
Support schema design decisions (tables, relationships,



data modeling considerations) to improve data usability and maintainability.
Develop test cases covering unit, integration, and regression testing for data pipelines and transformed datasets.
Create data quality checks to flag exceptions, anomalies, and outliers (e.g., missing values, unexpected distributions, referential integrity issues, threshold breaches).
Proactively identify potential data challenges (data drift, ingestion issues, schema changes, duplicates, late-arriving data, inconsistent formats) and implement preventive validations.
Collaborate with data engineers and analytics stakeholders to troubleshoot data issues and improve monitoring and data controls.
Maintain documentation of transformations, checks, and testing coverage to ensure transparency and repeatability.
Work with Tableau - Knowledgeable of dashboard performance optimization techniques
Experience leading data visualization approaches for

📌 Data Quality (Mumbai)
🏢 Crisil
📍 Mumbai