TM1/Planning Analytics Developer, GFT

What is the opportunity?
Are you a talented, creative, and results-driven professional who thrives on delivering high-performing applications? Come join us!

Global Functions Technology (GFT) is part of RBCs Technology and Operations division. GFTs impact is far-reaching as we collaborate with partners from across the company to deliver innovative and transformative IT solutions. Our clients represent Risk, Finance, HR, CAO, Audit, Legal, Compliance, Financial Crime, Capital Markets, Personal and Commercial Banking and Wealth Management. We also lead the development of digital tools and platforms to enhance collaboration.

We believe that innovation should drive all that we do, in challenging assumptions and being big and bold with our ideas. We support our people in developing the technical, business and professional skills needed to be successful. You will work with partners from across the company, participate in networking events, and have access to a wide variety of supports including mentorship. You will work directly with leaders who believe in celebrating successes and sharing learnings with other teams to promote progress.

WHAT WILL YOU DO?

• Designing, implementing and maintaining reliable, scalable and efficient TM1/Planning Analytics Solutions across areas of Finance functions.
• Developing and supporting TM1/Planning Analytics models, cubes, dimensions and hierarchies within an iterative development environment.
• Developing Complex TI Processes and Cube Rules.
• Developing advanced and dynamic Planning Analytics User Interfaces in PAW and PASS
• Working with cross-functional teams to develop solutions that accelerate cycle times and eliminate cumbersome manual processes
• Ensuring that technical software development process is followed on the projects, familiar with industry best practices for software development.
• Demonstrate the ability to adapt and work with team members pf various experience level.
• Ensuring the operating efficiency of existing application systems. Maintaining records for the documentation of systems development and revisions.
• Conducting analyses of organizational needs and goals for the development and implementation of application systems

WHAT DO YOU NEED TO SUCCEED?

Must have:

• Bachelors degree in Computer Science, Information Technology or a related field.
• 3+ years of experience in model building with industry leading EPM technologies (TM1, Anaplan, Oracle Hyperion, OneStream, Adaptive Planning etc); expert skills of Microsoft Excel and Google spreadsheet financial modelling
• Hands-on experience of financial processes, Financial Planning and Analysis, Forecasting, Cost Allocations, Financial Consolidation etc.
• In-depth knowledge of multi-dimensionality, Hierarchies, Cubes, Turbo Integrator processes, Cube Rules and Feeders, Active Forms & Websheets, MDX
• Knowledge of Planning Analytics Workspace (PAW) and Planning Analytics for Excel (PAFE)
• Ability to apply innovation and advanced technical expertise to find solutions for complex business requirements within the functionality of Planning Analytics product set; develop new design concepts when needed.
• Strong problem solving, design, and analytical skills and out-of-the-box thinking coming up with creative solutions on testing approaches in critical timelines.
• Experience working with large data sets of finance, and experience in parallel processing implementation in order to optimize performance; Familiarity with Database Development, SQL Queries, etc

Nice-to-have:

• Exposure to Finance Transformation related projects
• Experience with Python, TM1Py, REST API, VBA, Java, .NET
• IBM Planning Analytics (Cognos TM1) Certification
• Business knowledge of finance and/or accounting principles is a plus

Whats in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Work in a dynamic, collaborative, progressive, and high-performing team
• Ability to make a difference and lasting impact
• Flexible work/life balance options
• Opportunities to do challenging work
• Opportunities to take on progressively greater accountabilities

#LI-POST

#LI-HYBRID

Job Skills

Agile Methodology, Application Integrations, Business, Communication, Detail-Oriented, Enterprise Application Delivery, Enterprise Performance Management (EPM), Finance, Financial Modeling, Group Problem Solving, IBM Cognos Analytics, Ibm Planning Analytics, Innovation, Microsoft Excel, Microsoft Excel VBA Programming, Programming Languages, Python (Programming Language), Relational Database Management System (RDBMS), SQL Database Queries, Systems Development Lifecycle (SDLC)

Additional Job Details

885 GEORGIA ST W:VANCOUVERVANCOUVERCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2024-08-262024-11-29

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above