Data Quality & Transformation Analyst (SQL / Testing)

Data Quality & Transformation Analyst (SQL / Testing)

Department

None

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.

Open Positions

1

Mandatory Skills

SQL, Tableau, Pl / Sql Development, Data validation, Data quality

Education Qualification

• Bachelor’s degree in Computer Science, Information Technology, Data Science, Engineering, or a closely related field.

Experience

3 to 8 years