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.
Skills Required
- 5-10 years of experience as a Data Analyst / SQL Developer
- Strong expertise in working with transactional data
- Excellent command of SQL, including Window Functions, CTEs, aggregations, and complex logic
- Proven experience in performance tuning and query optimization
- Strong analytical thinking and problem-solving abilities
- Good understanding of relational database concepts and data warehousing fundamentals
- Exposure to BI/reporting tools
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
