Senior Data Analyst

Jobtailor; Pune District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Jobtailor in Pune is seeking a seasoned Data Analyst to translate business problems into analytical solutions and map data across multiple sources to support BFSI decision-making. You will deliver high-quality insights through collaborative, Agile-driven work within cross-functional teams.

The role requires 5+ years of experience with SQL, PySpark and Python, plus hands-on exposure to Hadoop, Hive and Spark. Strong data mapping and governance skills are essential.

Qualifications

• 5+ years of professional experience as a Data Analyst with good decision-making, analytical and problem-solving skills.

Responsibilities

• Translate business problems into analytical problems and craft pertinent solutions.
• Provide high-quality analysis and recommendations to business problems.
• Efficient project management and delivery.
• Conceptualize data-driven solutions for multiple businesses/regions to enable informed decisions.
• Drive efficiency gains and improve processes using data insights.
• Map business requirements to technical attributes and define data mappings across sources.

Skills

Data Analysis

SQL

Pyspark

Python

BFSI Domain Knowledge

Tools

Hadoop

Hive

Spark

HQL

Spark SQL

Job description

• 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.
• 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.

Requirements

• 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

Core Competencies

Demonstrates expertise in Data Analysis within the BFSI domain, utilizing SQL, Pyspark, and Python to drive data-driven solutions and improve customer outcomes. Proficient in project management, data mapping, and collaboration with stakeholders to ensure timely delivery of high-quality analytical insights.

Highest-signal resume keywords

• Data Analysis
• SQL
• Pyspark
• Python
• BFSI Domain Knowledge

ATS Optimization Keywords

Hard Skills

• Data Mapping
• Data Quality Validation
• Data Management
• Data Cleaning
• Data Preparation
• Data Schema Analysis
• Logical to Physical Mapping
• Agile Framework
• Big Data Frameworks
• ER Diagram Understanding

Soft Skills

• Decision-Making
• Analytical Skills
• Problem-Solving
• Project Management
• Communication

Industry Keywords

• Credit Risk Frameworks
• Basel II
• Basel III
• IFRS 9
• Stress Testing

Tools & Technologies

• Hadoop
• Hive
• Spark
• HQL
• Spark SQL