Senior Business Systems Analyst

RBC - Royal Bank
Calgary, AB
90K $ / an (estimé)
Temps plein

Job Summary

A key IT role within Wealth Management Technology & Solutions, Data Services Canada team, you will be a Sr. Business System Analyst that will act as an SME for Global Wealth Management Data Hub and provide leadership covering a range of data analysis functions.

These include data mapping, data profiling, data quality, extract-transform-load (ETL) requirements, metadata enrichment and management, data provenance and lineage and other specialized data management functions.

You will work in collaboration with IT and Business Partners to assess, research, and analyze data needs in order to support business insights and strategy.

Job Description

What will you do?

  • Work with IT and Business Partners to understand the business meaning of data, provide analysis and requirements so that data design is fully understood and the development initiatives are in line with intended design and standards
  • Develop and maintain knowledge of data available from upstream sources and data within various data platforms and provide expert counseling to application development community
  • Elicit, analyze, interpret business and data requirements to develop complete solutions, including data mapping, business rules and system specifications
  • Contribute to process standardization and creation of Wealth Data Hub scalable solutions
  • Provide guidance to colleagues and clients related to gathering and assessing data to ensure that appropriate data-management practices are known and complied with
  • Lead complex group meetings (including business partners) for technical design, decision making, problem solving, implementation and strategic planning
  • Monitor work processes and client satisfaction, recommend changes for continuous improvement
  • Engage with data managers, stewards and owners to implement, maintain, and enhance data governance, quality and related policies, aligning with RBC standards and framework

What do you need to succeed?

Must-have :

  • Strong business domain understanding of Wealth-Management and Trading life cycle.
  • Excellent data analysis skills and solid background dealing with other IT applications. Good SQL knowledge to query databases in order to complete data analysis.
  • Proficient at creating Technical Specifications for the development team to build the solution whether it's batch file extract, API real-time call or Kafka near real-time notifications.
  • 5+ years of experience working closely with in-memory or relational databases to provide data services to other IT partners or business.
  • Professional with experience on large projects / programs with multiple internal applications and / or 3rd party vendors.
  • Experience with Agile methodology and familiar with Confluence and Jira tools.

Nice to have :

  • Knowledge of key Databases, primarily dealing with large data volume, database schema design and exposure to enterprise reporting and analytic tools based on Hadoop / HDFS sourced data like Tableau.
  • Experience with Front, Middle and Back office teams of Asset Management, Broadridge Data Services, Brokerage Institutions, Prime Brokerage Services, Canadian Registered Products and Regulatory rules.
  • Dealt with different instrument types such as Fixed Income, Equities, Derivatives, Money Market Instruments and OTC Derivatives.
  • Proven leader and experienced in managing a small team that brings strong planning, estimating, budget management, reporting and coordination experience in future.

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
  • Opportunities to take on progressively greater accountabilities

LI-HYBRID

LI-POST

Job Skills

Agile Methodology, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Requirements Analysis

Il y a plus de 30 jours
Emplois reliés
TechVest Global Solutions Inc.
CA

Design, develop and implement information systems business solutions. Provide advice on information systems strategy, policy, management and service delivery. Conduct reviews to assess quality assurance practices, software products and information systems. ...

BMO
Canada, Canada

The Business Technology Senior Analyst is responsible for assisting the Business Technology Leads in organizing, delivering & executing on strategic initiatives, preparing test cases and conducting ad-hoc activities related to the bank's commercial loan systems including but not limited to RRT (ris...

S.i. Systems
Calgary, Alberta

Senior Cutover Manager to work with business and IT to ensure risks, gaps and changes are addressed/implemented for an enterprise wide integration program. This role requires you to be onsite M-F, working core business hours of 8-5pm. Identifying and documenting dependencies between technology and b...

0000050007 Royal Bank of Canada
Calgary, Alberta

As the Senior Technical Systems Analyst, you will be responsible for deploying and supporting Authentication Services, protocols and technologies such as SSO, OAuth, OpenID Connect, SAML, Federation and MFA. Technical System Analyst experience with strong knowledge in the installation, configuration...

S.i. Systems
Calgary, Alberta

The Senior Business Analyst will also lead the development of strategies for the replacement and management of these incompatible devices, ensuring alignment with organizational requirements and operational efficiency. Senior Business Consultant (10+ Years) to support a Windows 11 upgrade project. C...

Donna Cona
Remote, Canada
Télétravail

Senior Business Analyst, for one of our key government clients. Identification of outage response: Communication plans, backup systems in the event of an outage. Comprehensive reporting on: Emergency systems in the territory, communications around emergencies lines;. ...

Procom
Calgary, Alberta

Requirements gathering of data and analysis of business needs. Makes technical recommendations for business functional areas. Stay abreast of industry technical and business trends (association, practice, learning). Works on complex matters and assignments of large scope, impact, and importance, whe...

Critical Mass
Calgary, Alberta

As a Marketing Science Senior Analyst, you'll be sleuthing through piles of data to uncover valuable insights that inform our strategies and drive our digital customer experiences to success. Mentor and support junior team members including Analysts and Associate Analysts. You have experience using ...

Farm Credit Canada
Calgary, Alberta

Join us as mentor and subject matter expert within the most complex business domains. Use your experience as a Chartered Professional Accountant (CPA) to perform complex business analysis and evaluate forecasts. Prepare and distribute analytics and reports targeted to senior management. Provide doma...

S.i. Systems
Calgary, Alberta

Senior Payroll Analyst to manage time and scheduling in SAP and perform audits for compliance. ...