Share this Job

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title:  Senior Manager, Data Management, GBM Financial Planning & Analysis

 

 

 

Requisition ID: 138808

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

 

Purpose


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.

 

Key Accountabilities
 

  • GBM and GBP Oracle Essbase Cubes
    • Develop and maintain scripts and coding for extracting the data from EGL/Hyperion, transforming, and loading data to the cubes
    • Identify opportunities for process improvement and operation efficiencies and build new features in the cubes 
    • Create access request form and Maxl scripts to update or grant user access to the cubes
    • Write instructions, plans, designs, and other necessary documentation
    • Provide training and coaching to GBM/GBP cube users
  • Projects
    • Design new reporting tools to enhance current monthly/quarterly/daily reporting processes
    • Design tools for regional finance groups, including legal entity reporting, expense allocation analysis and regional business line reporting inclusive of GBM and non-GBM units. 
    • Lead and participate in all aspects of a system development life cycle, including investigation, requirements documentation, design, development, test, QAT, implementation, deployment, and support. 
       

Experience / Education:

 

  • 3+ years of hands-on experience with Oracle Essbase ASO Cube development and maintenance, including designing applications and database, loading data, creating rules files, calculation scripts and creating reports with Smart View
  • 3+ years of hands-on experience with SAS Base, SQL Server Management Studio, Power BI and Python (nice to have)
  • 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.
  • Understanding of the data and sources populating the MIS (e.g. EGL, COFA, OBI, Oracle Hyperion, etc.) is desired
  • Demonstrated knowledge of GBM business lines, performance measurement systems, accounting systems and an explicit knowledge of reporting relationships within GBM
  • Good interpersonal and communication skills
  • Good written skills including documentation of processes, procedures, and training guides
  • Willing to be on-call production support as needed on the weekend
  • University degree with a major in business, finance, mathematics, computer science, or engineering
  • Experience with people management is desired 

 

This is a temporary, full time role for 18 months.

 

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.


Job Segment: Database, Data Management, Financial, Manager, Oracle, Technology, Data, Finance, Management