Lead Data Analyst

EXL; Pune District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

EXL is seeking a Lead Data Analyst with 7+ years of experience to drive data-driven decision making. The role requires strong analytical and problem-solving skills, proficiency in SQL, PySpark and Python, and experience with ESG/Banking domains.

Hands-on Spark SQL for data exploration and solid documentation practices are essential. Familiarity with ER diagrams, data modeling, data management, and Agile methods is expected.

Qualifications

• 7+ years of professional experience as a Lead Data Analyst with analytical and problem-solving skills.
• SQL, PySpark, Python with ESG / Banking Domain experience.
• Hands-on experience in Spark SQL for data exploration.
• Documentation: Data Mapping, Subsystem Design, Technical Design, Business Requirements.
• Exposure to Data Processing Flow to measure the consistency, etc.
• Understanding of ER Diagram and Data Modelling concepts.
• Exposure to Data Management, Data Cleaning, Data Quality and Data Preparation.
• Exposure to working in Agile framework.

Skills

Leadership experience

Analytical skills

Problem-solving

Decision-making

Tools

SQL

PySpark

Python

Spark SQL

Job description

Must-Have:

• 7+ yearsof professional experience as a Lead Data Analyst with good decision-making, analytical and problem-solving skills.
• SQL,Pyspark, Python with ESG / Banking Domain experience.
• Hands-on experience in HQL or SQL (Spark SQL) for Data exploration.
• Documentation - Data Mapping, Subsystem Design, Technical Design, Business Requirements.
• Exposure to Logical to Physical Mapping, Data Processing Flow to measure the consistency, etc.
• Understanding of ER Diagram and Data Modelling concepts
• Exposure to Data Management, Data Cleaning, Data Quality and Data Preparation
• Exposure to working in Agile framework.