Senior Business Analyst

EXL Talent Acquisition Team; Gurugram District; Híbrido; INR 700.000 - 1.100.000; Jornada completa

Descripción de la vacante

EXL Talent Acquisition Team in Gurugram is seeking a Data Analyst with 6+ years of experience to analyze large transactional datasets, generate actionable insights, and collaborate with cross-functional teams.

You will write complex SQL with window functions, joins, CTEs, and subqueries, optimize performance, ensure data quality, and build reusable data models for reporting and dashboards.

Formación

• Strong SQL expertise with complex queries and data modelling.
• Experience with transactional data and data warehousing concepts.
• Ability to optimize queries and improve database performance.

Responsabilidades

• Work with large transactional datasets to derive insights.
• Write and maintain complex SQL queries, stored procedures, and scripts.
• Optimize queries with performance tuning and SQL best practices.
• Utilize window functions, joins, CTEs, and subqueries.
• Collaborate with cross-functional teams to deliver analytical outputs.
• Ensure data quality and availability for reporting and dashboards.
• Build reusable data models and analytical frameworks.

Conocimientos

SQL

Transactional Data

Window Functions

CTEs

Joins

Aggregations

Performance Tuning

Analytical Thinking

Herramientas

BI Tools

Descripción del empleo

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.