Data Quality & Transformation Analyst (SQL / Testing)

Crisil; Mumbai; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Crisil is seeking a Data Quality & Transformation Analyst (SQL / Testing) with 2–5 years of experience to analyze data, build SQL-based views, and support schema design and data modeling. The role includes developing and executing unit, integration, and regression tests to ensure data reliability and accurate reporting outputs.

Tableau skills are a plus, and training will be provided. The candidate will collaborate with data engineers and analytics stakeholders to troubleshoot data issues,

Qualifications

• Strong SQL skills with complex queries and efficient views.
• Solid understanding of data transformation concepts for analytics.
• Experience with data testing approaches: regression, unit, integration tests.
• Knowledge of data modeling concepts (normalization/denormalization, keys, relationships).
• Ability to design robust data validation rules and detect outliers.

Responsibilities

• Translate business and technical use cases into data transformations.
• Design and develop SQL views and queries for analytics and reporting.
• Support schema design decisions for data usability and maintenance.
• Develop test cases for data pipelines (unit, integration, regression).
• Create data quality checks to flag anomalies and threshold breaches.
• Identify data challenges and implement preventive validations.
• Collaborate with data engineers and analytics stakeholders to improve monitoring.
• Maintain documentation of transformations and testing coverage.
• Work with Tableau to optimize dashboard performance.
• Lead data visualization approaches and enterprise dashboard rollouts.

Skills

SQL

Data transformations

Data validation

Data modeling

Analytical thinking

Education

Bachelor's degree in CS/IT/Data Science/Engineering

Tools

Tableau

Job description

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 projects, developing innovative approaches, and enterprise dashboard rollouts and adoption

Requirements:

• Bachelor's degree in Computer Science, Information Technology, Data Science, Engineering, or a closely related field.
• Strong SQL skills, including writing complex queries and designing efficient views.
• Solid understanding of data transformation concepts and how to adapt data for different analytical use cases.
• Experience with data testing approaches, including designing regression, unit, and/or integration tests for datasets.
• Knowledge of data modeling and schema design concepts (normalization/denormalization basics, keys/relationships, data types, constraints).
• Ability to design robust data validation rules and exception/outlier detection logic.
• Strong analytical thinking and attention to detail, with a proactive mindset toward preventing data quality issues.