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.