About this role
Role: Data Analyst Experience: 6+ Years Location: Gurgaon (Work form office 2 days in a Week)
Key Responsibilities:
• Work with large transactional datasets to perform deep-dive analysis and generate insights.
• Write and maintain complex SQL queries , stored procedures, and scripts.
• Optimize queries using performance tuning techniques and SQL best practices .
• Work extensively with Window Functions, Joins, CTEs, Subqueries etc.
• Collaborate with cross-functional teams to understand data needs and deliver analytical outputs.
• Ensure data quality, accuracy, and availability for reporting and dashboards.
• Perform query optimization and improve overall database/data process performance.
• Build reusable data models, datasets, and analytical frameworks.
Required Skills:
• 5–10 years of experience as a Data Analyst / SQL Developer .
• Strong expertise in working with Transactional Data .
• Excellent command over SQL , including Window Functions, CTEs, Aggregations , and complex logic building.
• Proven experience in Performance Tuning & Query Optimization .
• Strong analytical thinking and problem-solving abilities.
• Good understanding of relational database concepts and data warehousing fundamentals.
• Exposure to BI/reporting tools is an added advantage.
• Work with large transactional datasets to perform deep-dive analysis and generate insights.
• Write and maintain complex SQL queries , stored procedures, and scripts.
• Optimize queries using performance tuning techniques and SQL best practices .
• Work extensively with Window Functions, Joins, CTEs, Subqueries etc.
• Collaborate with cross-functional teams to understand data needs and deliver analytical outputs.
• Ensure data quality, accuracy, and availability for reporting and dashboards.
• Perform query optimization and improve overall database/data process performance.
• Build reusable data models, datasets, and analytical frameworks.
At least 5–10 years of experience as a Data Analyst / SQL Developer .
• Strong expertise in working with Transactional Data .
• Excellent command over SQL , including Window Functions, CTEs, Aggregations , and complex logic building.
• Proven experience in Performance Tuning & Query Optimization .
• Strong analytical thinking and problem-solving abilities.
• Good understanding of relational database concepts and data warehousing fundamentals.
• Exposure to BI/reporting tools is an added advantage.
Description from EXL's public careers feed, reproduced so you can read the role here. Apply on the company's own site; RealAnalystJobs never submits anything for you.
