Business Data Analyst

Fa Ewjt Saasfaprod1 Open

Hybrid Pune Full-time Mid-level Data Analysis & BI

At a glance

Mid-level Data Analysis & BI role at Fa Ewjt Saasfaprod1. Pune · full-time.

Pay not stated Business Data Analyst salary

RoleData Analysis & BI

SeniorityMid-level

LocationPune

WorkplaceHybrid

EmploymentFull-time

PostedSep 28, 2026

Role brief

dataroles summary, based on the employer's posting.

What you'll do

Gather Finance, Risk and regulatory reporting needs, then turn them into mappings, transformations and business rules
Build finance, risk and regulatory data marts with dimensional models and ER diagrams for reporting and analytics
Profile data, investigate anomalies, and set reconciliation checks, validation rules and exception handling
Trace data from source through reports, maintaining lineage, metadata and transformation records
Coordinate testing and release sign-off with business and technical teams through Agile delivery cycles

What you bring

A bachelor’s degree in computer science, IT, finance or a related discipline
Five to eight years in banking data, warehousing or data engineering
Strong banking knowledge across finance, risk and regulatory reporting, plus data mart and warehouse design skills
Advanced SQL and practical ETL/ELT experience, with reconciliation, controls and validation expertise

Who this fits

This role suits a mid-level analyst who can connect banking stakeholders with data engineers and architects. The position is based in Pune and follows a hybrid arrangement.

From the employer

We are seeking a Business / Data Analyst with Data Engineering expertise to support the design and development of banking data marts for regulatory reporting, analytics, and downstream consumption. The role will focus on translating business requirements into scalable data models, ensuring data quality, reconciliation, and traceability across enterprise data platforms.

Key Responsibilities

Business & Data Analysis

Engage with business stakeholders (Finance, Risk, Regulatory teams) to gather and document data mart requirements
Translate requirements into data mappings, transformation logic, and business rules
Define KPIs, metrics, and regulatory data elements (e.g., capital, liquidity, exposure)
Perform data profiling and analysis to identify gaps, inconsistencies, and anomalies
Design and develop subject-oriented data marts (Finance, Risk, Regulatory Reporting)
Build dimensional data models (fact/dimension tables) optimized for analytics and reporting and create ER Diagram
Work with enterprise platforms such as Oracle, Netezza, or cloud data warehouses
Optimize queries and data structures for performance and scalability
Define control totals, data validation rules, and exception handling mechanisms
Document and maintain data lineage (source to report) at table and column level
Support integration with lineage/governance tools (e.g., MANTA, Collibra)
Ensure adherence to data governance policies and regulatory standards (BCBS 239, SOX, etc.)
Maintain metadata, data dictionaries, and transformation documentation
Work closely with data engineers, architects and business users
Participate in Agile delivery cycles (sprint planning, UAT, defect management)
Ensure proper testing, validation, and sign-off for data mart releases
Act as a bridge between business stakeholders and technical teams

Required Skills

Strong understanding of banking data domains (Finance, Risk, Regulatory Reporting)
Expertise in data warehousing and data mart design (star/snowflake schema)
Advanced SQL skills (query optimization, performance tuning) in TOAD, etc
Hands-on experience with ETL/ELT tools (Informatica, etc)
Experience working with databases such as Oracle, Netezza, or similar platforms
Strong knowledge of data reconciliation, controls, and validation frameworks
Familiarity with data lineage and governance practices
Understanding of file-based and API-based data integration

Preferred Skills (Good to Have)

Exposure to BCBS 239, CCAR, Basel, or other regulatory frameworks
Experience with cloud data platforms (AWS, Azure, GCP)
Familiarity with BI/reporting tools (Tableau, Power BI)

Qualifications

Bachelor’s degree in Computer Science, Information Technology, Finance, or related field
5–8 years of experience in banking data, data warehousing, or data engineering roles

Engage with business stakeholders (Finance, Risk, Regulatory teams) to gather and document data mart requirements
Translate requirements into data mappings, transformation logic, and business rules
Define KPIs, metrics, and regulatory data elements (e.g., capital, liquidity, exposure)
Perform data profiling and analysis to identify gaps, inconsistencies, and anomalies
Design and develop subject-oriented data marts (Finance, Risk, Regulatory Reporting)
Build dimensional data models (fact/dimension tables) optimized for analytics and reporting and create ER Diagram
Work with enterprise platforms such as Oracle, Netezza, or cloud data warehouses
Optimize queries and data structures for performance and scalability
Define control totals, data validation rules, and exception handling mechanisms
Document and maintain data lineage (source to report) at table and column level
Support integration with lineage/governance tools (e.g., MANTA, Collibra)
Ensure adherence to data governance policies and regulatory standards (BCBS 239, SOX, etc.)
Maintain metadata, data dictionaries, and transformation documentation
Work closely with data engineers, architects and business users
Participate in Agile delivery cycles (sprint planning, UAT, defect management)
Ensure proper testing, validation, and sign-off for data mart releases
Act as a bridge between business stakeholders and technical teams

Bachelor’s degree in Computer Science, Information Technology, Finance, or related field
5–8 years of experience in banking data, data warehousing, or data engineering roles

Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.

Each morning you get everything that fits, strongest first.

Data Analysis & BI

Find me work

By the team behind dataroles.

Find me work