Skip to main content

Description

This role supports automation initiatives for the US Finance team, including Financial Control, Regulatory Reporting, and FPM. It involves leveraging tools such as Alteryx, Dataiku, and Tableau to streamline processes, enhance data integrity, and deliver actionable insights. The Senior Analyst will assist in designing, implementing, and maintaining automated solutions to improve efficiency, reduce manual effort, and ensure compliance with regulatory requirements under the guidance of senior leadership. Key responsibilities include developing automated workflows, creating Tableau dashboards, identifying automation opportunities with finance teams, implementing data validation, automating regulatory reporting processes, documenting solutions, and contributing to training and ad hoc projects.

What We're Looking For

Assist in designing and developing automated workflows using Alteryx/Dataiku to replace manual processes (e.g., data extraction, reconciliation).,Support the creation and maintenance of Tableau dashboards and reports for financial and regulatory data visualization.,Collaborate with US Finance teams to identify automation opportunities and contribute to project prioritization.,Help implement data validation checks and controls within automated workflows.,Aid in automating data aggregation and validation processes for regulatory reporting (e.g., Federal Reserve, OCC).,Document automation solutions, including process flows and user guides.,Participate in training and mentoring team members on automation tools.,Assist in monitoring and optimizing existing automated processes.,Contribute to ad hoc projects addressing emerging automation needs or regulatory changes.

Ideal Candidate

3+ years of experience in financial reporting, data analytics, or process automation.,Proficiency in Alteryx or Dataiku (workflow design, data blending, macro creation) and Tableau (dashboard development, data visualization, calculated fields).,Knowledge of US GAAP or IFRS.,BBA/MBA in Accounting, Finance, or related field; CPA or equivalent preferred.,Experience with financial systems (e.g., SAP, IBM Cognos, PeopleSoft).,Knowledge of banking industry and US IHC reporting requirements and structures.,Programming skills (e.g., Python, SQL) for advanced data manipulation.,Ability to translate business needs into technical solutions.,Good project management and stakeholder communication skills.,Process-oriented with great documentation skills.,Detailed oriented, driving data analytics to improve current state of business operations.,Problem-solving and troubleshooting skills with the ability to identify and solve complex business needs.

Minimum Education

Bachelor's Degree, Master's Degree

Hard Skills

Accounting
Alteryx
Data Extraction
Dataiku Data Science Studio (DSS)
Financial Planning and Analysis (FP&A)
Financial Reporting and Analysis
Python
SQL
Tableau
SAP
IBM Cognos
PeopleSoft

Soft Skills

Decision Making
Results-Oriented
Project Management
Stakeholder Communication
Process-oriented
Documentation
Detail-oriented
Data Analytics
Problem-solving
Troubleshooting

Work Hours

40 hours/week

Benefits

Comprehensive Total Rewards Program (performance-based bonuses
flexible benefits
competitive compensation)
Leaders who support development (coaching and managing opportunities)
World-class training program in financial services
Collaborative dynamic culture
Personal initiative and hard work recognized and rewarded

Special Commitments

Knowledge of US IHC reporting requirements and structures.

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.