Role - Data Analyst/Senior Data Analyst/Lead Data Analyst
Experience - 5-12 Years
Location - EXL India Location - Preferred Pune/Bangalore
Job Description Summary:
Key Skills: Strong SQL, Python, Pyspark, Jupyter Notebook, Agile / Jira / Confluence, Microsoft Excel, Banking Domain knowledge, Exposure to any cloud (GCP / AWS / Azure) would be a plus
Must-Have:
4+/5+ years of professional experience as a Data Analyst with positive decision-making, analytical and problem-solving skills.
SQL, Pyspark, Python with Banking Domain knowledge - Credit & Lending.
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 Modelling 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.
Knowledge of Credit Risk Frameworks such as Basel II, III, IFRS 9 and Stress Testing and understanding their drivers - advantageous
Good To Have:
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.
Role & Responsibilities:
Ability to convert business problem to an analytical problem and then finding pertinent solutions
Overall business understanding of BFSI domain
Providing high-quality analysis and recommendations to business problems
📌 Data Analyst (India)
🏢 EXL
📍 India