17 Aug
|
EXL Service
|
Gurugram
17 Aug
EXL Service
Gurugram
Job Description: 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 .
Solid 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 .
Solid 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.
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.
Qualifications: 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 .
Robust 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.
📌 Senior Business Analyst Gurugram
🏢 EXL Service
📍 Gurugram