Data Analyst

Zoho; Dadri; On-site; INR 450,000 - 850,000; Full time

Job summary

Arting Digital Private Limited in Noida (Sec- 62) is seeking a Data Analyst with 1–6 years of experience to design and maintain ETL pipelines, perform data extraction, transformation and loading, and ensure data quality across systems.

The ideal candidate will write and optimise complex SQL queries, monitor data flows, troubleshoot issues, and collaborate with technical and business teams to deliver reliable, scalable data insights.

Qualifications

• 2+ years of relevant experience in Data Analytics, ETL Development, Data Engineering, or similar data-focused roles.
• Strong ETL concepts and pipeline development knowledge.
• Experience with relational databases, data validation, and troubleshooting.

Responsibilities

• Develop, maintain, and optimise ETL pipelines for data extraction, transformation, and loading.
• Write and optimise complex SQL queries, joins, subqueries, CTEs, stored procedures, and analytical queries.
• Perform data transformation, cleansing, validation, and quality checks.
• Monitor data pipelines and troubleshoot data quality and processing issues.
• Analyse large datasets to identify trends, patterns, and discrepancies.
• Ensure data accuracy, consistency, and integrity across multiple data sources.
• Optimise SQL queries and database performance.
• Collaborate with technical and business teams to understand data requirements.
• Troubleshoot ETL and data pipeline failures and ensure timely resolution.
• Maintain technical documentation for data processes and pipelines.

Skills

SQL

ETL pipelines

Data extraction

Data transformation

Data validation

Troubleshooting

Query optimization

Tools

ETL tools

Job description

Arting Digital Private Limited | Full time

Position -Data Analyst Exp -1-6 yrs Location -Noida (Sec- 62) Notice Period - Immediate joiner- 15 days Skills -Data Analyst, ETL Developer, SQL skills (mandatory), ETL concepts, data validation, quality checks, and troubleshooting, data extraction, transformation, loading, and monitoring

About the Role

We are looking for a Data Analyst with strong hands-on experience in SQL and ETL pipelines . The ideal candidate should be proficient in data extraction, transformation, loading, validation, monitoring, and troubleshooting, with the ability to work with large datasets and optimise query performance.

Key Responsibilities

• Develop, maintain, and optimise ETL pipelines for data extraction, transformation, and loading.
• Write and optimise complex SQL queries, joins, subqueries, CTEs, stored procedures, and analytical queries .
• Perform data transformation, cleansing, validation, and quality checks.
• Monitor data pipelines and troubleshoot data quality and processing issues.
• Analyse large datasets to identify trends, patterns, and discrepancies.
• Ensure data accuracy, consistency, and integrity across multiple data sources.
• Optimise SQL queries and database performance.
• Collaborate with technical and business teams to understand data requirements.
• Troubleshoot ETL and data pipeline failures and ensure timely resolution.
• Maintain technical documentation for data processes and pipelines.

Required Skills

• 2+ years of relevant experience in Data Analytics, ETL Development, Data Engineering, or similar data-focused roles .
• Good understanding of ETL concepts and pipeline development .
• Experience in data extraction, transformation, loading, and pipeline monitoring.
• Strong understanding of relational databases and data structures .
• Experience with data validation, quality checks, and troubleshooting.
• Strong analytical and problem-solving skills.
• Ability to work independently as well as collaboratively.