Lead Assistant Manager

Ex; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Ex in Bengaluru seeks a Data Analyst with 4 to 6 years of experience to drive data insights and support decision-making using SQL, Python and PySpark in a Jupyter environment. The role emphasizes data quality, mapping, and scalable data assets for banking domains.

The position requires hands-on knowledge of Hadoop/Hive/Spark, Spark SQL, and familiarity with Agile practices; cloud exposure (GCP/AWS/Azure) is a plus.

Qualifications

• 4+ years of professional Data Analyst experience with strong analytical skills.
• Proficient in SQL, PySpark and Python with banking domain knowledge (credit & lending).
• Experience with Big Data frameworks (Hadoop, Hive, Spark) and Spark SQL.
• Hands-on data mapping and data quality validation.
• Experience in data modelling concepts and ER diagrams.
• Familiar with Agile methodologies and Jira/Confluence.
• Exposure to data management, cleaning and preparation.

Responsibilities

• Perform data mapping to join data across sources.
• Document data mappings, subsystem and technical designs.
• Design data assets and identify reusable elements.
• Validate data quality and ensure data governance.
• Analyze data schemas and map logical to physical designs.
• Work in an Agile environment.

Skills

SQL

Python

Pyspark

Jupyter Notebook

Agile / Jira / Confluence

Microsoft Excel

Banking Domain knowledge

Cloud exposure (GCP/AWS/Azure)

Tools

Hadoop

Hive

Spark

Spark SQL

Job description

Job Description Summary:

Role & Experience: Data Analyst (4 to 6 YoE)

Location - Bangalore

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+ 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