Role Overview:

The Business Analyst will work closely with Business, Operations, Risk, Fraud, and Compliance teams to analyze high-volume financial transaction data and generate actionable insights. The role requires strong hands-on capability in SQL, Hive, Python, and dashboarding, with a clear understanding of fintech payment ecosystems and regulatory reporting requirements.

Key Responsibilities:

1. Data Analysis & Insights

• Analyze large-scale transactional datasets including payments, settlements, refunds, reversals, and failures.
• Build analytics around customer funnels, conversion metrics, drop-offs, and churn.
• Perform trend, cohort, variance, and root-cause analysis to support business decision-making.
• Provide data-driven insights for risk monitoring, fraud detection, and compliance reporting.
• Support ad-hoc deep dives for leadership and cross-functional stakeholders.

2. Reporting & Dashboards

• Design and maintain daily, weekly, and monthly MIS dashboards for:
• Business & Growth
• Operations & TAT
• Risk & Compliance
• Create management dashboards with clearly defined, actionable KPIs.
• Automate recurring reports to meet RBI, internal audit, and regulatory requirements.
• Ensure data accuracy, consistency, and reconciliation across multiple sources.

3. Data Platform & Automation

• Write optimized queries in MySQL and Hive to handle large datasets efficiently.
• Work within the Cloudera ecosystem using Hive and Hue.
• Automate recurring reports and workflows using Python and Shell scripting.
• Use Advanced Excel and Google Sheets for reconciliations, validations, and quick-turn analyses.

Tools & Technologies:

• MySQL, Hive, Hue
• Cloudera ecosystem
• Python, R Studio
• Advanced Excel, Google Sheets
• Shell scripting
• Dashboarding & reporting automation tools

Key Competencies:

• Strong analytical and problem-solving mindset
• Ability to work with ambiguous datasets and requirements
• Attention to detail, especially for financial and regulatory reporting
• Stakeholder communication and business understanding
• High ownership and execution focus in fast-paced environments