Back to Jobs
Operations & Project Management

Senior Business Analyst

EXLGurugram🇮🇳India

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationGurugram, India
SQL

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.
  • 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.

Haystack's AI agent can fill in and submit this application for you. How AI auto apply works

Will your resume get past this employer's screening? Check your resume against this job, free