Data Analyst - SQL, ETL, Data Warehouse | Job Description

Coforge; New Delhi; On-site; INR 600,000 - 1,100,000; Full time

Job summary

Coforge is seeking a Data Analyst in Greater Noida with 4–8 years of experience to drive data analysis and reporting initiatives. You will work on SQL-driven data extraction, ETL processes, and DW concepts to deliver actionable insights for business stakeholders.

The role requires deep SQL proficiency, experience with ETL tools, and the ability to develop dashboards and KPIs. Collaboration with cross-functional teams and data quality advocacy are key aspects of the position.

Qualifications

• Strong SQL skills including Joins, CTEs, window functions.

Responsibilities

• Analyze and interpret large volumes of structured data.
• Write complex SQL queries for data extraction, analysis, and reporting.
• Develop and maintain ETL processes for data integration.
• Work with data warehouse architectures and data models.
• Create dashboards, reports, and KPIs for business users.
• Perform data validation, cleansing, and quality checks.
• Collaborate with business and technical teams to understand reporting requirements.
• Identify trends, patterns, and business insights from data.

Skills

SQL

ETL

Data Warehousing

Data analysis

Reporting

Excel

Problem-solving

Tools

Informatica

SSIS

Talend

DataStage

Power BI

Tableau

Job description

Position: Data Analyst
Experience: 4-8 Years
Location: Greater Noida
Notice Period: Immediate

Job Summary

We are looking for a skilled Data Analyst with strong expertise in SQL, ETL, and Data Warehousing. The candidate will be responsible for analyzing large datasets, developing reports, supporting ETL processes, and providing actionable insights to business stakeholders.

Key Responsibilities

• Analyze and interpret large volumes of structured data.
• Write complex SQL queries for data extraction, analysis, and reporting.
• Develop and maintain ETL processes for data integration.
• Work with Data Warehouse architectures and data models.
• Create dashboards, reports, and KPIs for business users.
• Perform data validation, cleansing, and quality checks.
• Collaborate with business and technical teams to understand reporting requirements.
• Identify trends, patterns, and business insights from data.

Required Skills

• Strong hands-on experience in SQL (Joins, CTEs, Window Functions, Stored Procedures).
• Experience in ETL tools such as Informatica, SSIS, Talend, DataStage, or similar.
• Good understanding of Data Warehousing Concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables).
• Experience in data analysis and reporting.
• Knowledge of Excel and reporting tools.
• Strong analytical and problem-solving skills.

Preferred Skills

• Power BI / Tableau
• Python for Data Analysis
• Azure Data Factory / AWS Data Services
• Data Modeling