Job Description*
- The candidate will be responsible for delivering complex and time critical data mining and analytical request for the Consumer & Small Business Banking, lending products such as Credit Cards and in addition will be responsible for analysis of data for decision making by senior leadership.
- Candidate will be responsible for data management, data extraction and upload, data validation, scheduling & process automation, report preparation, etc.
- The individual will play a key role in the team responsible for data analytics and would manage 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 comprehend & evaluate the strategic business drivers to 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.
- The core responsibility of this individual is process management to achieve sustainable, accurate and well controlled results.
- 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.
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 rewards reporting, data mining & analytics.
- 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, SAS, Emerging technologies like Tableau and Alteryx.
- Design solutions, generate actionable insights, optimize existing processes, build tool-based automations, and ensure overall program governance.
- Managing and improve the work: develop full understanding of the work processes, continuous focus on process improvement through simplification, innovation, and use of emerging technology tools, and understanding data sourcing and transformation.
- 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.
Education* -
- Masters/Bachelor’s Degree in Information Technology/Computer Science/ MCA or MBA finance with 7-10 years of relevant work experience.
Experience Range*
7-10 years of relevant work experience in data analytics & reporting in banking or credit card industry. Exposure to Consumer banking businesses would be an added advantage.
Foundational skills*
- Strong abilities in data extraction, data manipulation and analysis and strong financial acumen.
- Strong computer skills, including MS excel, SQL, SAS and emerging technologies like Alteryx, Tableau.
- Prior Banking and Financial services industry experience, preferably Retail banking, and Credit Cards.
- 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.
- Proficiency in Base SAS, Macros, SAS Enterprise Guide
- Querying data from multiple source
- Experience in data extraction, transformation & loading using SQL/SAS.
- Proven ability to manage multiple and often competing priorities in a global environment.
- Manages operational risk by building strong processes and quality control routines.
- SQL: Querying data from multiple source
- Job Scheduling: Experience in setting up, monitoring, and troubleshooting Autosys jobs.
- Data Warehousing: Knowledge of relation database and modeling (SQL, Teradata)
- Data Quality and Governance: Ability to clean, validate and ensure data accuracy and integrity.
- Automation and scripting: Experience with automation of data processes using SAS Macros, Unix scripting.
- 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)