Title:  Senior Manager, MIS, GBM Financial Planning & Analysis

Requisition ID: 249621

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

The Role

The incumbent has responsibility for the technical design, development, and optimization of GBM finance MIS applications and continuing support related thereto. These applications provide necessary financial and management information to assist and support users in managing their businesses and in performing reporting, financial planning, and analytics functions.

Is this role right for you? In this role, you will:

Until such time as the following is completed, the incumbent will be primarily accountable for working collaboratively with GBM and other stakeholders to accomplish the following.

GBM and GTB Essbase Cubes

• Develop and maintain scripts and SAS programs to extract data from OBI and Hyperion, transform and load to the cubes.
• Identify opportunities for process improvement, operation efficiencies and new data and/or function development.
• Create documentation for reporting and data processing workflows to support audit requirements, data validation, and business logic compliance.
• Provide training and coaching to GBM & GTB Essbase cube users.
  
  

Automation & Process Optimization

• Lead process automation to improve efficiency in financial reporting, forecasting and planning.
• Utilize Power BI and other automation tools to create reports and dashboards.
  
  

Reporting

• Design new reporting tools to enhance current monthly/quarterly reporting processes.
• Design tools for regional finance groups which are region specific such as legal entity reporting and regional business line reporting inclusive of GBM and non-GBM units.
• Oversight in all GBM Finance reporting tools and ensures consistency and optimization of data.

Other Projects

• Lead and participate in all aspects of a system development life cycle, including investigation, requirements documentation, design, development, test, QAT, implementation, deployment and support. 
• Develop and co-ordinate testing and data validation procedures for each of the above.

Data Management & Analysis

• Demonstrate strategic thinking, with the ability to align data analytics with business objectives and drive decision making.
• Establish standards, controls and processes to ensure data accuracy, completeness, consistency and integration.
• Design and implement data validation, reconciliation and improvement practices to support department priorities.

Coaching and people management

• Lead a team of 2 direct reports, building a high performance and inclusive environment and culture.

Do you have the skills that will enable you to succeed in this role? – We’d love to work with you if you have:

• University degree in accounting, finance, business, mathematics or computer science.
• Understanding of the data and sources populating the MIS (e.g. EGL, COFA, OBI, Hyperion , etc.).
• Strong knowledge of Oracle Essbase Administration Services Console and MaxL scripts.
• Strong knowledge and experience with programming languages (SAS, SQL, Python, VBA). SAS is preferred.
• Proficiency in Power BI, Power Query and DAX.
• Experience with database and report development and understanding of user reporting needs.
• Results oriented, detail oriented, excellent analytical and problem-solving skills with proven ability to apply this knowledge to the resolution of complex business issues related to the MIS.
• Good interpersonal, communication and written skills including documentation of processes, procedures and training guides.
• Demonstrated knowledge of GBM business lines, performance measurement systems, accounting systems and an explicit knowledge of reporting relationships within GBM.
• Proven capability to analyze data and translate insights into actionable recommendations.

.

What’s in it for you?

• A rewarding career path with diverse opportunities for professional development
• An organization committed to making a difference in our communities – for you and our customers.
• A competitive rewards program including bonus, flexible vacation, personal and sick days, and comprehensive benefits that start on your first day. 
• 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 every 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. 

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. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.