Senior Data Analyst

EXL Service
10 Exchange Place, Suite 2200, Jersey City, NJ T: +1.201.748.4700 www.exlservice.com
Data Analyst / Senior Data Analyst
•
Data Analyst (4-6 Years)
•
Senior Data Analyst (5-7 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
Job Description:
Must-Have:
•
4+ / 5+ years of professional experience as a Data Analyst with good 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.
EXL Service
10 Exchange Place, Suite 2200, Jersey City, NJ T: +1.201.748.4700 www.exlservice.com
•
Efficient project management and delivery
•
Ability to conceptualize data driven solutions for the business problem at hand for multiple businesses/region to facilitate efficient decision making
•
Focus on driving efficiency gains and enhancement of processes.
•
Use of data to improve customer outcomes through the provision of insight and challenge
•
Understand the business requirements from the product/project stakeholders and break the requirements into simpler stories and tasks and do the necessary mapping of the tasks to the logical model of the solutions.
•
Mapping of business entities to technical attributes with the logic for transformation defined clearly.
•
Be accountable for the delivery of the tasks in the defined timelines with good quality.
•
Working with the team leads closely and contribute to the smooth delivery of the project.
•
Understand/define the architecture and discuss the pros-cons of the same with the team.
•
Involve in the brainstorming sessions and suggest improvements in the architecture/design.
•
Working with other teams leads to getting the architecture/design reviewed.
•
Keep all the stakeholders updated about the project, task status, risks, and issues if any.