Business Systems Analyst

2 weeks ago


Calgary, Alberta, Canada Royal Bank of Canada Full time

Job Summary

Job Description

What is the opportunity?

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.

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 frameworks

What do you need to succeed?

Must-have

  • Strong business domain understanding of Wealth-Management and Trading life cycle, excellent data analysis and solid background dealing with Wealth Management application.
  • Good SQL knowledge to query databases in order to complete data analysis. Worked closely with in-memory or relational databases to provide data services to other IT partners or business.
  • Really good at creating Technical Specifications for development team to build the solution whether it's batch file extract, API real-time call or Kafka near real-time notifications.
  • Professional with experience on large projects/programs with multiple applications with multiple interfaces and/or 3rd parties.
  • Experience with Agile methodology and familiar with Confluence and Jira tools.
  • Proven leader and experienced in managing a small team that brings strong planning, estimating, budget management, reporting and coordination experience in future.

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
  • Team player known for providing creative thought leadership while also listening to and engaging others
  • Commitment to challenging the status quo is essential.
  • Working experience with SQL or In Memory databases, Front, Middle and Back office teams of Asset Management, Wealth Management, Broadridge Portfolio Management, Brokerage Institutions, Prime Brokerage Services of various asset class such as Fixed Income, Equities, Derivatives, Money Market Instrument and OTC Derivatives

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

#TECHCPJ

#LI-SP

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

Additional Job Details

Address:

888 3 ST SW:CALGARY

City:

CALGARY

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

Technology and Operations

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

Application Deadline:

Inclusion and Equal Opportunity Employment

At 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 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


  • Business Analyst

    1 week ago


    Calgary, Alberta, Canada procom Full time

    Business AnalystOn behalf of our client Procom is seeking a highly skilled and experienced Senior Business Analyst. The successful candidate will be involved in critical Finance/Treasury related initiatives, focusing on corporate banking for offshore businesses enabled by innovative solutions. This role is a 12 month contract and is 4 days in office and one...


  • Calgary, Alberta, Canada Atco Full time

    Always there. Anywhere. That's us We've got a lot of energy at ATCO, focused on creating prosperity for generations to come. A team committed to delivering inspired solutions for a better world. We care about our communities, we care about each other, and we care about showing up for those who need us. We value and encourage different perspectives and we...


  • Calgary, Alberta, Canada Petroplan Full time

    Senior Planning Business Analyst - Oil & Gas clientLocation: Calgary. 4 days from office, 1 days work home. Contract: Initially 12 months, with a likely extension Overall Job Summary Reporting to the Downstream Application Manager, the primary role of the Senior Business Analyst is to liaise with relevant business teams to gather and manage business...


  • Calgary, Alberta, Canada FGL Sports Full time

    What you'll do The Category Business Analyst plays a direct role helping equip Canadians for the jobs and joys of life in Canada, by managing vendor processes, examining new and existing product lines, and performing analysis that better prepares us to meet the evolving needs of our customers. As a key member of our buying team you will be at the hub of our...


  • Calgary, Alberta, Canada Trusscore Full time

    Salary: Your MissionYour role is crucial in ensuring seamless operations within our Trusscore team by maintaining and enhancing our IT infrastructure. You will be instrumental in providing support to team members across all locations, whether they are based locally in Calgary, in Palmerston, Ontario, or working remotely. Your responsibilities include...


  • Calgary, Alberta, Canada Cenovus Energy Inc. Full time

    Worker Type: EmployeeGroup: Transition and Integration DepartmentJob Post End Date: 04/25/2024About this opportunity:Reporting to the Sr. Manager, Downstream Business Opportunities, the Business Process Analyst works across downstream asset teams and with various supporting functions to support Downstream Value Capture work and the streamlining and...


  • Calgary, Alberta, Canada Procom Full time

    Senior Joint Interest Contract AnalystOn behlaf of our client Procom is seeking a Senior Joint Interest Contract Analyst to provide essential drafting, analytical, and administrative support within the their portfolio of jointly owned assets. This role involves drafting, analyzing, interpreting, implementing, and administering various Joint Interest and...


  • Calgary, Alberta, Canada Alberta Electric System Operator Full time

    The Alberta Electric System Operator (AESO) is responsible for the safe, reliable, and economic planning and operation of the Alberta Interconnected Electric System. We provide open and non-discriminatory access to Alberta's interconnected power grid and also facilitate Alberta's competitive wholesale electricity market. The AESO strives to foster an...

  • Transactional Analyst

    3 weeks ago


    Calgary, Alberta, Canada Petroplan Full time

    Transactional AnalystContract: Initially 12 monthsLocation: CalgaryBasic Purpose/Accountabilities Reporting to the Supply Chain Transactional Analyst Lead, the Transactional Analyst will be responsible for processing service confirmations, managing the GR/IR, creation of purchase requisitions and acting as a focal point for assisting suppliers and...


  • Calgary, Alberta, Canada University of Calgary Full time

    Description The Research Accounting team within Finance is currently seeking a Full-time Regular Financial Analyst.The Analyst, Research Accounting reports to the Manager, Research Accounting. The Analyst position plays an important role in the delivery of Research Accounting Finance support to stakeholders across campus. This position requires strong...


  • Calgary, Alberta, Canada Alberta Ltd Dba Rocky Tech Full time

    Rocky Tech adheres to the goal of the best practitioner of IT technology and a professional provider of IT services. Focus on customer needs and challenges, provide IT solutions and professional services, and continue to create value for customers.Alberta Ltd Dba Rocky Tech is looking for a Data Analyst NOC 21223 Duties and responsibilities as Data...


  • Calgary, Alberta, Canada Pembina Full time

    Job Description:Pembina Pipeline Corporation's Calgary office is recruiting for an Analyst, Corporate Planning to join the team. This position reports to the Manager, Corporate Planning in the Financial Services Service Unit (FSU) part of Pembina's Financial Services Division. The Financial Services Unit manages the finance activities for Pembina, plus...

  • Application Analyst

    4 weeks ago


    Calgary, Alberta, Canada CANADA CARTAGE Full time

    Why you'll love Canada Cartage An iconic Canadian company with over 100 years of helping companies grow and succeed in Canada, we provide national dedicated fleet solutions, general freight services, managed transportation, fulfillment & distribution, and home delivery. With a national network of terminals, cross-docks, and distribution centers, we are one...

  • Data Analyst

    4 weeks ago


    Calgary, Alberta, Canada The Acquisition Group Full time

    Position Overview: The Acquisition Group is looking for a dedicated and meticulous Data Analyst to provide support and statistical analysis for our client, TELUS Communications.You are a team player, with a passion for data, looking to drive meaningful change in a fast-paced team. As a Data Analyst, you'll be learning and working with multiple tools such as...


  • Calgary, Alberta, Canada TransAlta Corporation Full time

    ABOUT THE ROLE We are looking to hire a Cash Management Analyst to join our TransAlta team. As the Cash Management Analyst, you are responsible for maintaining and analyzing daily cash flow forecasts, managing daily banking activities, coordinating electronic funds transfers and short-term debt issuances, as well as bank balance and transaction reporting for...


  • Calgary, Alberta, Canada Alberta Electric System Operator Full time

    The Alberta Electric System Operator (AESO) is responsible for the safe, reliable, and economic planning and operation of the Alberta Interconnected Electric System. We provide open and non-discriminatory access to Alberta's interconnected power grid and also facilitate Alberta's competitive wholesale electricity market. The AESO strives to foster an...


  • Calgary, Alberta, Canada Cascade Trading Ltd. Full time

    Position: Financial and Risk Operations Analyst About Our Company: Cascade Trading Ltd., and its associated entities, is a dynamic and growing business specializing in electricity, natural gas and environmental trading. We value innovation, entrepreneurial spirit, and proactive problem-solving. We're located in the city of Calgary, AB, and offer competitive...

  • Support Analyst

    1 week ago


    Calgary, Alberta, Canada Blackline Safety Full time

    Our team at Blackline Safety is growing As a people-driven technology company, with a mission to make sure every worker returns home safely, we drive innovation, practice resiliency, demonstrate leadership, go the extra mile for our customers, and empower our people to be their best. Blackline Safety is looking for a Support Analyst to join their team. The...

  • Senior Data Analyst

    3 weeks ago


    Calgary, Alberta, Canada Olsen Consulting Full time

    Salary: Senior Data AnalystOlsen Consulting specializes in the implementation and optimization of enterprise resource management systems, particularly Vista ERP, for high-revenue construction companies across North America. As a trailblazer in the industry, our goal is to propel our clients toward digital transformation by automating and enhancing their...


  • Calgary, Alberta, Canada NES Fircroft Full time

    Requisition Title: Sr Joint Interest Contract AnalystDescription: Reporting to the Team Lead, Joint Interest, this role will provide drafting, analytical and administrative support to our client's portfolio of jointly owned assets in the Conventional business. The key activities of this position will be to draft, analyze, interpret, implement, and administer...