Job Description
What is the opportunity?
Partners across IT and with assigned business line(s) to assess, research, and analyze business, technical and system needs in order to resolve business systems issues by recommending and owning technology solutions that meet sponsor/stakeholder needs. Will work on large projects/programs with multiple applications with multiple interfaces and/or 3rd parties.
What will you do?
Technical Analysis, Design and Consulting
Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers.
Manages detailed design phases for large projects/ programs identifying, tracking and resolving technical issues and ensuring solution meets sponsor needs. These include Alternative investments, Order Entry and Performance Reporting data file creation process.
Provide quality and timely support to our business partners through contributions to mid-size, heavily integrated programs through building and running SQL queries to perform data analysis, impact analysis, and/or building ad hoc report
Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies
Provides input and co-ordinates with technical team members in creating new and modifying existing database structures using different types of databases and recommending appropriate DB based on required functionality across multiple systems.
Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers.
System Implementation
Provides or participates in technical liaison between business the project or support team for project installations.
Partners with development and support team in release activities and Post Implementation Validation activities for the application(s) supported.
Testing & Documentation
Partners with Quality Engineering team and manage User Acceptance testing and verification ensuring all tasks are performed for all interfaces.
Ensures adequate technical documentation and training.
Planning, Implementation & Support
Manages all aspects of implementation planning & coordination.
Develops detailed plans and accurate estimates for the design, build, implement and stabilize phases of the project.
Performs database/ disaster recovery planning for multiple systems.
Relationships & Communication
Acts as primary IT liaison with multiple interfacing applications, 3rd party vendors, IT Executive and/or Project Managers.
Effectively communicates and builds rapport with team members, stakeholders and interface groups using a variety of techniques and collaboration from initiation to close.
Facilitates complex group meetings (including business partners) for technical design, decision making, problem solving, implementation and strategic planning.
Prepares and delivers presentations to business and technology partners, senior management and executives, selecting the appropriate approach based on the audience.
What do you need to succeed?
Must-have
Position requires 7+ years of experience in IS/IT performing business/systems & data analysis.
Experience working with product owner, business analysts and developer
Creating presentation, flow charts, business process documents with appropriate level of details and abstractions
Translating requirements into technical solutions
Understand business requirements
Working knowledge and experience with cloud services – SaaS, preferred IaaS, PaaS
Experience with building / running SQL query at an advanced level to perform data analysis, impact analysis, and/or producing ad hoc report
Good understanding of data models and large data analysis
Nice-to-have
Hands on experience with Informatica MDM (Master Data Management)
Experience working in Agile development setting & familiarity with Jira
Experience working in an enterprise environment and Service Oriented Architecture with multiple integration with upstream & downstream systems.
Experience with financial industry and / or customer data / client information
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.
Ability to make a difference and lasting impact.
Work in a dynamic, collaborative, progressive, and high-performing team.
A world-class training program in financial services.
Flexible work/life balance options.
Opportunities to do challenging work.
The expected salary range for this particular position is $70,000-$130,000, depending on your experience, skills, and registration status, market conditions and business needs.
You have the potential to earn more through RBC’s discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.
RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:
Drives RBC’s high-performance culture.
Enables collective achievement of our strategic goals.
Generates sustainable shareholder returns and above market shareholder value.
#TechPJ
#LI-Post
Job Skills
Agile Methodology, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Data Analysis, Data Architecture, Data Modeling, Decision Making, Detailed Design, ETL Processing, Group Problem Solving, Informatica MDM, Interpersonal Relationship Management, Microsoft SQL Server, Requirements Analysis, SQL Database Queries, Technical DocumentsAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Inclusion and Equal Opportunity Employment
At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.
Join our Talent Community
Stay 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 jobs.rbc.com.
RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.