TM1/Planning Analytics Developer, GFT – Royal Bank of Canada

Title of the Job: TM1/Planning Analytics Developer, GFT

Location: Vancouver, BC

Job Description: Job Summary 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 RBC’s Technology and Operations division. GFT’s 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.Job DescriptionWHAT 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:

• Bachelor’s degree in Computer Science, Information Technology or a related field.
• Minimum 5 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

What’s 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-HYBRIDJob 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 DetailsAddress: 885 GEORGIA ST W:VANCOUVERCity: VANCOUVERCountry: CanadaWork hours/week: 37.5Employment Type: Full timePlatform: TECHNOLOGY AND OPERATIONSJob Type: RegularPay Type: SalariedPosted Date: 2024-08-26Application Deadline: 2024-09-27Inclusion and Equal Opportunity EmploymentAt RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.Join our Talent CommunityStay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at .

Company Name: Royal Bank of Canada

Salary:

Apply for the job!