Data & Reporting Specialist

Job Summary

AML IT Development team is looking for an experienced developer 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. Coding and analysis will be required, as well as working closely with BSAs and business to determine data issues and onboarding requirements. Automation and design is a must.
Tech Stack: Unix shell scripting, Front end framework (Vuejs/Angular js) + Backend Framework (nodejs) + SQL (MS SQL/DB2/Oracle) + Version Control (GitHub) + Rest api + CI/CD pipeline

Job Description

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.

This is for the role of Data & Reporting specialist. The developer will have the responsibility of data governance and development (both backend and UI).

What will you do?

• Designing and coding application programs; performing testing for developed applications.
• Reviewing, analyzing, and modifying programming systems, including encoding, testing, debugging and installing for a large-scale system.
• Developing custom reports and UI pages for reporting purposes.
• Automation of various manual processes which IT and business perform.

What do you need to succeed?

Must Have

• 4+ years of Unix Shell scripting
• 4+ years of JAVA, Hadoop development
• Spark/Hive
• Expertise with SQL/RDBMS Databases
• Hands on with Data Visualization and reporting development, statistical analysis and excel spreadsheet development
• Working knowledge of management, mapping, manipulation and wrangling of data

Nice to Have

• Python experience.
• Prior Tableau and ServiceNow Development experience
• Statistics and machine learning
• Data models and Web development, Data Warehousing experience

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, opportunities to take on progressively greater accountabilities and opportunities to building close relationships with clients
• Access to a variety of job opportunities across business and geographies.

#LI-Hybrid

#LI-Post

#LI-SP

#TechP

Job Skills

Active Learning, Application Integrations, Detail-Oriented, Group Problem Solving, IBM DB2 Database, Perl Shell, Programming Languages, Software Development Life Cycle (SDLC), UNIX AIX, Unix Shell, User Interfaces (UI)

Additional Job Details

Address:

120 WESTERN PKY:BEDFORD

City:

BEDFORD

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2024-09-24

Application Deadline:

2024-10-11

I nclusion 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 jobs.rbc.com.