Data Analyst-Data Management and Analytics-Data Ops/Data Analyst

EXL Talent Acquisition Team; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Benefits offered by this job

Tableau or Qlik Sense

Hadoop/Hive/ETL exposure

Cloud services awareness (AWS/GCP/AZ)

Job summary

EXL Talent Acquisition Team is seeking an experienced Data Analyst in Pune with 5-9 years of professional experience and strong analytical skills. The role requires hands-on work with Hadoop, Hive and Spark, plus SQL and PySpark/Python for data exploration across multiple sources.

You will contribute to data mapping and data asset design while aligning with data quality, data management and schema analysis expectations in an Agile environment. Banking domain knowledge is advantageous.

Qualifications

• 5-9 years of experience as a Data Analyst with strong analytical and problem-solving skills.
• Working knowledge of Hadoop, Hive and Spark.
• Hands-on SQL and PySpark / Python for data exploration.
• Data mapping across multiple sources and data asset design.
• Exposure to data quality validation, data management and data schema analysis.
• Experience in Agile framework and banking domain knowledge (Wholesale Banking/Credit & Lending) is a plus.
• Knowledge of Basel II/III, IFRS 9 and Stress Testing drivers is advantageous.
• Familiarity with BFSI domain concepts and related data visualization tools is beneficial.

Skills

Data analysis

SQL

PySpark

Python

Decision making

Analytical thinking

Agile

Data mapping

Tools

Hadoop

Hive

Spark

Tableau

Qlik Sense

Job description

• 5 - 9 years of professional experience as a Data Analyst with good decision-making, analytical and problem-solving skills.
• Working knowledge / experience of Big Data frameworks like Hadoop, Hive and Spark.
• Hands-on experience in query languages like HQL or SQL (Spark SQL) for Data exploration.
• Data mapping: Determine the data mapping required to join multiple data sets together across multiple sources.
• Documentation - Data Mapping, Subsystem Design, Technical Design, Business Requirements.
• Exposure to Logical to Physical Mapping, Data Processing Flow to measure the consistency, etc.
• Data Asset design / build: Working with the data model / asset generation team to identify critical data elements and determine the mapping for reusable data assets.
• Understanding of ER Diagram and Data Modeling concepts
• Exposure to Data quality validation
• Exposure to Data Management, Data Cleaning and Data Preparation
• Exposure to Data Schema analysis.
• Exposure to working in Agile framework.
• SQL,Pyspark, Python with Wholesale Banking Domain knowledge / Credit & Lending domain knowledge.
• Knowledge of Credit Risk Frameworks such as Basel II, III, IFRS 9 and Stress Testing and understanding their drivers - advantageous
• Retail Credit / Traded Credit knowledge - applications will be considered.

Good To Have:

• BFSI Domain knowledge
• Data Visualization - Tableau or Qlik Sense
• Exposure to Hadoop, Hive and ETL.
• Working knowledge of any cloud services like AWS or GCP or Azure.
• Any relevant certifications would be a plus.