MIS Specialist

Scotiabank; Bogotá; Presencial; COP 42.000.000 - 68.000.000; Jornada completa

Descripción de la vacante

Scotiabank is seeking a MIS professional to build architecture for reliable MIS delivery to support collections strategies across the International Banking division.

You will design dashboards, automate data collection, and develop scorecards to benchmark performance across multiple countries. The role requires strong SQL, R, Python, and BI tool skills plus a data-driven mindset for forecasting delinquency and capacity planning.

Formación

• Experience in MIS, reporting, data analytics, collections analytics, BI, or ops support.
• Ability to transform and analyze large datasets from multiple sources.
• Experience in report automation, dashboard creation, and KPI monitoring is desirable.
• Proficiency with relational databases and SQL.
• Hands-on programming in SQL, R and Python; adaptable to other languages.
• Strong knowledge of Excel and VBA; familiarity with BI tools.

Responsabilidades

• Assist with the design of applications and reports.
• Automate data collection and report generation for faster delivery.
• Design reports and scorecards to measure collections performance across international banking.
• Provide best-in-class scorecards to benchmark operations and KPIs.
• Perform analytics on collections and recovery trends; lead MIS team.
• Standardize reports to measure performance and ensure governance.
• Identify best practices and replicate across hubs.
• Turn data into actionable information and insights.
• Model portfolio performance and forecast delinquency and loss impacts.
• Perform capacity planning for all sites and hubs.
• Ensure COBs are signed and adhered to.
• Perform other duties as assigned.

Conocimientos

SQL

Python

R

Power BI

Excel VBA

SAS

Business Objects

Data Analytics

Data Mining

Dashboarding

Educación

Bachelor's degree in statistics, computer science, commerce or related discipline

Herramientas

Microsoft Access

Descripción del empleo

Purpose

Reporting to the MIS Manager, you will be responsible to build the architecture to deliver highly reliable MIS to drive collections strategies and actions across International Banking division. You are an analytical individual with excellent communication skills; you possess initiative and the ability to handle multiple projects simultaneously.

Accountabilities

• Assist with the design of applications & reports.
• Automate data collection from multiple sources / report generation process to make it faster and better.
• Design reports and scorecards to measure, analyze, improve, and control collections performance across international banking.
• Provide best-in-class scorecards to benchmark internally and externally operations and portfolio Key Performance Indicators.
• Perform analytics on Collections and Recovery trends and causes, lead MIS team to embrace the regional “One Best Way” approach.
• Standardize reports to measure collections performance and provide operational governance.
• Identify best practices and replicate them across Collections & Recovery Hub’s.
• Ability to turn data into information, knowledge, intelligence, and wisdom that's actionable and measurable.
• Model portfolio performance and forecast delinquency & loss impact in different roll rate scenarios.
• Model and perform capacity planning for all sites and hubs.
• Ensure all COB’s are signed, acknowledged and adhered to.
• Perform other duties as assigned.

Dimensions

Operates independently day to day and receives direction from the VP, Collections, and liaises with IB/Local Technology as needed. High level of autonomy required in assessing day to day issues to maximize efficiency and optimize costs. High database programming level to deliver information through data mining in diferent database languages. Ability to create easy to follow data views related to the data mining results and also for the reporting structure. Number of countries supported: +9 countries as at Nov'18 (ScotiaGBS Hub); ScotiaGBS hub currently has ~600FTE. Product mix: mortgages, SPLs, credit cards and small business. Growth markets with target increase in product mix; Collections/IT project work spans cross-border operations, and involves collection system migration as well as ongoing continuous improvement.

Education / Experience / Other Information

• English B1+
• 1-2 years of experience in MIS, reporting, data analytics, collections analytics, business intelligence, or operational support roles.
• Experience handling, transforming, and analyzing large datasets from multiple sources.
• Experience in report automation, dashboard creation, and KPI monitoring is desirable.
• Ability to effectively utilize relational database and SQL queries for data analysis.
• Hands on programming skills (SQL, R and Python). Ability to adapt to various programming languages and environments.
• Thorough knowledge of Microsoft Access, Excel, and VBA is a plus.
• Working knowledge of retail credit products
• Ability to take initiative & work independently
• Strong analytical & mathematical background
• Business intelligence reporting tools i.e. SAS, Business Objects, Power BI
• A degree in statistics, computer science, commerce or related discipline

Working Conditions

Work in a standard office-based environment; non-standard hours are a common occurrence. Limited international travel may be required.