Job Description

Job SummaryWhat 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\xe2\x80\x99s Technology and Operations division. GFT\xe2\x80\x99s 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.AML IT Development team is looking for an experienced business Systems Analyst to support the Data Governance and reconciliation program. This position will handle data mining and engineering and analysis and reporting of all the feeds that enter into AML space. Data analysis and manual reconciliation of data within databases and raw files experience is a must. Working closely with BSAs and business to determine data issues and onboarding requirements.What will you do?

• Work closely with stakeholders to maintain existing functionalities for Data Ingestion, Data Quality Controls and downstream AML IT Application Data needs.
• Analyze data within databases and raw files and HDFS
• Maintain and update spreadsheets of all data feeds and able to articulate and find root cause for data mismatches.
• Identify area of improvement in existing processes and leverage technology to improve efficiency.

What do you need to succeed?Must Have

• Min 8+ years of experience as a Business Systems Analyst, Data analysis/mining.
• Expert in Excel Spreadsheets (Formulars pivot tables, vlookups, etc).
• Basic SQL and database queries.
• Graphical display of data results (pie charts, bar charts, etc)

Nice to Have

• Working experience with Data Integration patterns, data reconciliation, analysis
• Data Lineage expertise to trace data back to source
• Data Dictionary definition compilations and presentation.

What\xe2\x80\x99s 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 applicableLeaders who support your development through coaching and managing opportunitiesAbility to make a difference and lasting impactWork in a dynamic, collaborative, progressive, and high-performing teamA world-class training program in financial services.Opportunities to do challenging workOpportunities to take on progressively greater accountabilitiesOpportunities to building close relationships with clientsAccess to a variety of job opportunities across business and geographies.#LI-Post#LI-Hybrid#LI-PKJob Skills Agile Methodology, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Requirements AnalysisAdditional Job DetailsAddress: RBC CENTRE, 155 WELLINGTON ST W:TORONTOCity: TORONTOCountry: CanadaWork hours/week: 37.5Employment Type: Full timePlatform: Technology and OperationsJob Type: RegularPay Type: SalariedPosted Date: 2024-05-30Application Deadline: 2024-06-07Inclusion 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 .

Royal Bank of Canada