Job Description
As a Data Analyst within Consumer Banking team in Bengaluru, you will perform foundational analysis across branch performance data to identify trends, surface anomalies, and inform new questions and actions. You partner with finance and business stakeholders to define data requirements, ensure data quality and integrity across sources, and translate business definitions into durable datasets. Using strong SQL and Python skills, you support the development of standardized metrics, recurring reporting, and dashboards that enable consistent, timely, and well-governed insights for Branch Performance.
Job responsibilities
- Gather, extract, and prepare branch network and occupancy cost data from legacy sources and Databricks for finance reporting and analysis.
- Develop and maintain SQL queries and Python-based workflows to support recurring reporting, ad-hoc analysis, and data validation.
- Understand and document data definitions, business rules, and source-to-target mappings to support legacy-to-Databricks transition and ongoing lineage clarity.
- Perform reconciliations between legacy outputs and Databricks datasets; investigate and explain variances, identify root causes, and track issues through resolution.
- Support finance partners by translating questions into clear analytical requirements and producing accurate, explainable outputs aligned to finance definitions.
- Contribute to dashboards and visualization deliverables where needed (e.g., ThoughtSpot), and support process improvements to reduce manual reporting effort.
- Apply data controls and governance standards, including documentation, validation checks, and change traceability.
Required qualifications, capabilities, and skills
- ~2 years of experience in data analysis, reporting, business intelligence, or an analytical finance support role.
- Strong proficiency in SQL and Python (data extraction, transformation, reconciliation, and analysis).
- Demonstrated experience working with complex datasets across multiple systems and resolving inconsistencies in definitions and outputs.
- Ability to structure and communicate analysis clearly to finance and non-technical stakeholders.
- Strong Microsoft Excel skills for analysis and validation.
- Experience with one or many Intelligent Automation tools
- Exposure to financial cost concepts such as P&L Statement, occupancy cost components, allocations, cost center structures, and reporting hierarchies.
- Bachelor’s degree or equivalent experience.
