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
