Job Description*
- The candidate will be responsible for delivering complex and time critical data mining and analytical projects for the Consumer & Small Business Banking products, credit lending products such as Credit Cards and in addition will be responsible for data & business analysis for decision making by onshore line of business.
- Candidate will be responsible for ETL related data activities, data management, data extraction & summarization, data validation, scheduling & process automation, dashboard & report preparation, etc.
- The individual will play a key role in the team responsible for FP&A data reporting, adhoc reporting & analysis and would be required to work on multiple projects in parallel by ensuring adequate understanding of the requirements and deliver data driven insights and solutions to complex business problems.
- These projects would be time critical which would require the candidate to understand key business levers & metrics for accurate & well controlled reporting.
- Candidate will be required to understand the process and bring in efficiencies through automation of existing reporting packages or codes.
- The work would be a mix of standard and ad-hoc deliverables based on dynamic business requirements.
- Technical competency is essential to build processes which ensure data quality and completeness across all projects / requests related to business.
- Candidate should have a clear understanding of the end-to-end process (including its purpose) and a discipline of managing and continuously improving those processes.
- Robust process documentation & timely updates would also be part of the core work responsibilities.
Responsibilities*
- Preparation and maintenance of various KPI reporting (Consumer lending such as Credit Cards) including performing data or business driven deep dive analysis.
- Credit Cards related metrics reporting through data extraction, validation, data summarization, variance analysis, dashboarding, etc.
- Understand business requirements and translate those into deliverables. Support the business on periodic and ad-hoc projects related to consumer lending products.
- Develop and maintain codes for the data extraction, manipulation, and summarization on tools such as SQL Teradata, SAS, Emerging technologies like Tableau, Alteryx, Power Query, etc.
- Design solutions, generate actionable insights, optimize existing processes, build tool-based automations, and ensure overall program governance.
- Managing risk: managing and reducing risk, proactively identify risks, issues and concerns and manage controls to help drive responsible growth (ex: Compliance, procedures, data management, etc.), establish a risk culture to encourage early escalation and self-identifying issues.
- Effective communication: deliver transparent, concise, and consistent messaging while influencing change in the teams.
- Extremely good with numbers and ability to present various business/finance metrics, detailed analysis, and key observations to Senior Business Leaders.
- Perform weekly/monthly/quarterly end review and controls.
Requirements*
MCA / MBA finance with 7 - 10 years of relevant industry work experience.
Experience Range*
- 7 - 10 years of relevant work experience in Data Mining, Analytics & reporting in Banking or financial services industry. Prior experience into Banking and Financial services industry preferably Consumer/Retail banking, Small Business banking, Credit cards businesses would be an added advantage.
Foundational skills*
- Strong abilities in data extraction, data manipulation and business analysis and strong financial acumen.
- Excellent computer programming skills, including MS excel, Teradata SQL, SAS, VBA and emerging technologies like Alteryx, Tableau, Power Query, MicroStrategy, etc.
- Strong business problem solving skills, and ability to deliver on analytics projects independently, from initial structuring to final presentation.
- Strong communication skills (both verbal and written), Interpersonal skills and relationship management skills to navigate the complexities of aligning stakeholders, building consensus, and resolving conflicts.
- Manages operational risk by building strong processes and quality control routines.
- Data Quality and Governance: Ability to clean, validate and ensure data accuracy and integrity.
- Troubleshooting: Expertise in debugging and optimizing SAS and SQL codes.
Desired skills
- Ability to effectively manage multiple priorities under pressure and deliver as well as being able to adapt to changes.
- Able to work in a fast paced, deadline-oriented environment.
- Stakeholder management
- Attention to details: Strong focus on data accuracy and documentation.
Work Timings*
11:30 pm to 8:30 pm (will require to stretch 7-8 days in a month to meet critical deadlines)