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.
- 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.
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 experienc
📌 Senior Business Analyst (Gurugram)
🏢 EXL
📍 Gurugram