Manager, MIS & Reporting

Scotiabank

Toronto

On-site

CAD 90,000 - 130,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Diversity & Inclusion
Accessibility & Accommodations
Upskilling opportunities
Rewards program

Job summary

Scotiabank is seeking a Manager, Analytics & MIS for the Real Estate Secured Lending portfolio in Toronto. You will drive data analysis, reporting, and automation to support strategic decisions and forecasting.

You will collaborate with IT and business teams to ensure data quality and timely insights. You will leverage Google Cloud, BigQuery, SAS, SQL, Python and BI tools to deliver actionable metrics, support planning, and ad-hoc requests.

Qualifications

  • 3+ years analytical experience required including statistical analysis.
  • Effective communicator with strong organizational skills.
  • Customer focused and results oriented.
  • Proficient in MS Office, SAS, SQL, VBA, Python, BigQuery, Hadoop and cloud reporting tools.
  • Familiar with big data visualization tools (Power BI, Tableau) and open-source languages (R, Python, Spark).
  • Strong prioritizing, analytical, presentation, project management and planning skills.

Responsibilities

  • Manage RESL data analysis requests, gathering business requirements and validating data sources.
  • Develop and automate reports to meet campaign and management needs.
  • Ensure data integrity, reconciliation and quality controls in analyses.
  • Work with Google Cloud based analysis and BI tools; operationalize SQL/SAS in BigQuery and Hadoop.
  • Provide insightful, decision-ready analyses and clear recommendations to stakeholders.

Skills

Analytical thinking
Effective communicator
Customer focused
Project management
Planning

Education

Bachelor's Degree in Computer Science, Finance, Mathematics, Economics or Statistics
Post Graduate degree in STEM – preferred

Tools

MS Office
SAS
SQL
VBA
Python
BigQuery
Hadoop
Power BI
Tableau
R
Spark

Job description

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Purpose

The Manager, Analytics & MIS supports the Senior Manager & Team Lead and the overall Real Estate Secured Lending (RESL) team by providing timely, relevant and accurate insights to assist in decision-making in managing the performance for the RESL portfolio. This includes detailed portfolio analysis and reporting using a wide range of data sources and analytic tools to support critical business initiatives. He/She will work closely with the product and program design team by providing timely, relevant and accurate analysis of campaigns and programs to support strategic and tactical decision-making. He/She will also assist the Senior Manager and Team Lead with planning, forecasting, ad hoc request, industry research, reporting and strategic projects as they arise.

The Manager is responsible for detailed reporting specifically as it relates to key RESL campaigns, business and customer metrics. Including collaborating with the Sr. Manager MIS & Reporting for developing business user requirements and business acceptance testing for production reports and envisioning and developing future MIS needs to ensure the ongoing quality and relevance of data and meet current and future information needs. The Manager is also responsible for analyzing statistics and evaluating the impacts that various processes have on the secured portfolio and customer behaviors.

Is this role right for you? - In this role you will:
  • Manage RESL data analysis requests, involves gathering of business requirements from stakeholders, determine/validate data sources, produce reports and ad-hoc analysis, confirm findings and present results to key stakeholders, while meeting expectations and timelines.
  • Developing new and enhancements to automate reports to meet campaign, channel and management needs as they relate to the campaigns, business and customer centric metrics.
  • Ensure integrity of data used for analysis, reconciling data sources and developing quality checks as part of the analysis development process.
  • Work with Google cloud based analysis & reporting and operationalize SQL/SAS code in Biq Query and Hadoop to gather and summarize data.
  • Become part of a high-performance team that utilizes advanced and innovative analytical and presentation tools to identify and monitor portfolio/pipeline quality, customer behaviors, patterns, trends and relationships among large datasets to proactively present value-added insights and recommendations.
  • Collaborate and provide support on the group’s annual planning process, work on subsequent re-forecasts and relative financial reporting on the portfolio and ad-hoc stress testing initiatives as required.
  • Be familiar with reporting definitions between data sources to be best positioned to understand reporting variability. Addressing data anomalies and creating resolutions to correct where necessary.
  • Provide adequate back-up for all team members as required.
  • Able to interpret data and present analysis in a concise and consistent manner.
  • Develop a customer focused culture to deepen inter-departmental relations and leverage broader Bank relationships, systems, and knowledge.
  • Work closely with IT, database managers and data developers to test new fields, connections, tables and platforms as they pertain to the RESL systems and databases.
  • Aid in providing support for time sensitive ad-hoc information requests, understanding the purpose and/or audience to be best positioned to provide the right solution every time.
Do you have the skills that will enable you to succeed in this role? - We'd love to work with you if you have:
Requirements/Qualifications
  • - 3+ years analytical experience required including statistical analysis.
  • - Effective communicator with strong organizational skills
  • - Customer focused and results oriented.
  • - Must be proficient in the use of MS Office, SAS, SQL, VBA, Python, Big Query, Hadoop and Cloud computing reporting tools.
  • - Familiar with Big Data, visualization tools (Power BI, Tableau) and open-source programming R, Python, Spark
  • - Strong prioritizing, analytical, presentation, project management and planning skills
Preferred Qualifications
  • - 3+ years experience in mortgages, secured or unsecured lending.
Education & Accreditations
  • - Bachelor's Degree in Computer Science, Finance, Mathematics, Economics or Statistics
  • - Post Graduate degree in STEM – preferred
Attendance
  • - 4+ days in the office
What's in it for you?
  • Diversity, Equity, Inclusion & Allyship-We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employees to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
  • Accessibility and Workplace Accommodations- We value the unique skills and experiences each individual brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
  • Upskillingthrough online courses, cross-functional development opportunities, and tuition assistance.
  • Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
  • Community Engagement - no matter where you choose towork from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, Humans of Digital and much more!

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Manager, Data Strategy and Operations
Senior Manager, Data Strategy and Operations

Scotiabank • Toronto

On-site
CAD 140,000 - 190,000
Diversity and inclusion programs
Professional development and upskiling
Competitive rewards and benefits
Manager, Portfolio Analytics & Insights
Manager, Portfolio Analytics & Insights

Scotiabank • Toronto

On-site
CAD 90,000 - 130,000
Performance bonus
Employee Share Ownership Program
Pension Plan Matching
+1
Technical Business Analysis Specialist - SimCorp
Technical Business Analysis Specialist - SimCorp

Scotiabank • Toronto

On-site
CAD 110,000 - 150,000
Diversity & Inclusion
Accessibility in workplace
Tuition assistance
Manager, Financial Planning, Reporting & Governance - Finance
Manager, Financial Planning, Reporting & Governance - Finance

Scotiabank • Toronto

On-site
CAD 110,000 - 150,000
Assistant Manager, Security Operations Centre
Assistant Manager, Security Operations Centre

Scotiabank • Toronto

On-site
CAD 90,000 - 130,000
Diversity & Inclusion programs
Accessible work environment
Tuition assistance
+1
Assistant Manager, Data Analytics & Reporting, Security Operations
Assistant Manager, Data Analytics & Reporting, Security Operations

Scotiabank • Toronto

On-site
CAD 90,000 - 120,000
DEI & Allyship
Accessibility & Accommodations
Upskilling via online courses
+2
Specialist Mortgage Operations
Specialist Mortgage Operations

Scotiabank • Stratford

On-site
CAD 55,000 - 85,000
Bonus
Flexible vacation
Personal days
+2
Director, Deposits Engineering
Director, Deposits Engineering

Scotiabank • Toronto

On-site
CAD 170,000 - 230,000
Diversity & Inclusion programs
Accessibility accommodations
Upskilling through courses
+1
Manager, Analytics Enablement, Global Transaction Banking Analytics - Toronto
Manager, Analytics Enablement, Global Transaction Banking Analytics - Toronto

Scotiabank • Toronto

On-site
CAD 120,000 - 180,000
Director, Engineering, Real Estate Secured Lending (RESL)
Director, Engineering, Real Estate Secured Lending (RESL)

Scotiabank • Toronto

On-site
CAD 180,000 - 260,000
Upskilling through online courses
Tuition assistance
Bonus
+1