Data Quality Analyst

Techblocks; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

Techblocks is seeking a Data Quality Analyst to ensure data accuracy across enterprise platforms. You will perform profiling, validation, reconciliation, and quality checks on large datasets, write advanced SQL to detect anomalies, and validate ETL/ELT pipelines.

You'll define data quality rules, monitor KPIs, support dashboards, and collaborate with Data Engineering and business teams to resolve issues. A Bachelor's degree in a related field is expected, with 5+ years of experience in data

Qualifications

• 5+ years of experience in Data Quality, Data Analysis, Data Testing, or ETL Testing.
• Strong hands-on SQL and experience with relational databases and data warehouses.
• Experience with profiling, cleansing, validation, reconciliation, and ETL/ELT testing.
• Experience with platforms such as Snowflake, Databricks, Azure Synapse, SQL Server, or similar.
• Knowledge of Python/PySpark and data quality tools is an advantage.
• Strong analytical, problem-solving, communication, and stakeholder-management skills.

Responsibilities

• Perform data profiling, validation, reconciliation, and quality checks across large datasets.
• Write advanced SQL queries to identify anomalies, duplicates, missing data, and transformation issues.
• Validate ETL/ELT pipelines and perform source-to-target testing and reconciliation.
• Define and implement data quality rules, metrics, controls, and automated checks.
• Perform root-cause analysis and work with Data Engineering and business teams to resolve data issues.
• Monitor data quality KPIs and support dashboards, analytics, reporting, and production data issues.
• Support data governance, lineage, metadata, and data quality standards.

Skills

Data Quality

Data Analysis

Data Testing

ETL Testing

SQL

Python

PySpark

Stakeholder management

Communication

Education

Bachelor’s degree in Computer Science, IT, Engineering, Data Analytics, or related field

Tools

Snowflake

Databricks

Azure Synapse

SQL Server

PySpark

Python

Job description

We are looking for a Data Quality Analyst with strong experience in SQL, data validation, ETL/ELT testing, data profiling, and reconciliation. The role will ensure enterprise data is accurate, complete, consistent, and reliable across data platforms and downstream applications.

Key Responsibilities

• Perform data profiling, validation, reconciliation, and quality checks across large datasets.
• Write advanced SQL queries to identify anomalies, duplicates, missing data, and transformation issues.
• Validate ETL/ELT pipelines and perform source-to-target testing and reconciliation.
• Define and implement data quality rules, metrics, controls, and automated checks.
• Perform root-cause analysis and work with Data Engineering and business teams to resolve data issues.
• Monitor data quality KPIs and support dashboards, analytics, reporting, and production data issues.
• Support data governance, lineage, metadata, and data quality standards.

Required Skills

• 5+ years of experience in Data Quality, Data Analysis, Data Testing, or ETL Testing.
• Strong hands-on SQL and experience with relational databases and data warehouses.
• Experience with data profiling, cleansing, validation, reconciliation, and ETL/ELT testing.
• Experience with platforms such as Snowflake, Databricks, Azure Synapse, SQL Server, or similar.
• Knowledge of Python/PySpark and data quality tools is an advantage.
• Strong analytical, problem-solving, communication, and stakeholder-management skills.

Education

Bachelor’s degree in Computer Science, IT, Engineering, Data Analytics, or a related field, or equivalent experience.