What is the Opportunity?

Position is a team member in the Transformation and Data Product Internal Audit Team and responsible for implementing and executing digitally-enabled solutions using data analytics. Position will leverage expertise in advanced data analytics, data management, business strategy, and visualization techniques to support the audit function to drive continuous improvement of audits in the plan. Also responsible for leading the development and execution of analytics, and support the data ecosystem within the Internal Audit function in support of becoming an insight driven organization. Will be responsible for work across the entire data analytics process including data acquisition, preparation, reporting, and visualization.

What will you do?

• Leads the development, delivery, and utilization of data analytics during audit engagements to provide continuous improvement in the execution of the audit plan.
• Complete all audit, continuous monitoring, and project related analyticdeliverableson time according to audit phase,AIC/stakeholder requirements, and production schedule.
• Works with all Internal Audit lines of business to understand goals and align Data Analytics solutions to these goals.
• Curates, prepares, and integrates large and varied datasets to test business hypotheses with Python, Sql, and other tools like Dataiku, Snowflake, IICS, Oracle, SQL Server, and Azure ADF (Automated Data Factory)
• Implements statistical analysis using Python and R.
• Supports and maintains the internal audit data ecosystem in a Snowflake and Microsoft Azure environment by practicing appropriate data governance and management, and performing data acquisition such as writing ETL/ELT jobs, SQL queries, and APIs on various source systems, data marts and data warehouses.
• Leads and performs continuous monitoring activities periodically for the area assigned
• 100% of key relevant audit engagements reviewed for analytics opportunities and data insight objectives are achievedby the end of the audit engagement.
• Prepares and integrates large and varied datasets and deploy production grade solutions.
• Works with structured and unstructured data to further enable a risk-based audit approach and help identify impacts to the organization's internal control environment while leveraging automated and self-served capabilities.
• Builds and develops an analytics catalogue that includes automated scripts that can be used for continuous auditing.
• Develops automated business intelligence dashboards and related reports to create persuasive visuals that demonstrate impactful insights for the audit department and stakeholders.
• Works with data analytic professionals across the RBC enterprise to leverage internal audit enterprise tools, projects, and expertise.
• Design innovative approaches that assess and evaluate business processes and risk management practices.
• Keeps informed of new services, products and events that have a significant business and technology affect.
• Keeps abreast of changes in the business, regulatory, and accounting and control environments in which City National Bank operates, especially for audit areas assigned.

What do you need to succeed?

• Minimum 5 years of experience in data analytics cycle (data gathering, transformation, mining, modeling, analytics, and reporting) using data analytics tools like SAS, Alteryx, Tableau, PowerBI, SQL, R, Python and/or ACL.
• Minimum 1 years of experience in an Audit, Risk Management, and/or banking environment

Nice-to-Have

• Advanced experience working with Python, R, and SQL and strong coding abilities.
• Prefer 7+ years of experience in data analytics cycle (data gathering, transformation, mining, modeling, analytics, and reporting) using data analytics tools like SAS, Alteryx, Tableau, PowerBI, SQL, R, Python and/or ACL.
• Strong knowledge and experience with traditional and cloud database technology (e.g. SQL, Snowflake, and/or Azure) and an advanced understanding of data warehousing, data flow and handling.
• Exceptional knowledge of Extract, Transform and Load process and tools
• Familiar with a range of data tools like Microsoft Synapse, Alteryx, Tableau, PowerBI and/or ACL
• Expert experience with complex visualization of data.
• Strong knowledge for creation of automated unit tests, integration, end-to-end testing and DevOps practices (E.g. CI/CD).
• Expert technical documentation skills.
• Good grasp of data governance best practices.
• Excellent analytical and problem solving skills.
• Experience working for either internal client (cross platform) or external 3rd party client(s).
• Exhibits integrity and trust as demonstrated in the consistency in their honesty, integrity and dependability across their online footprint.
• Excellent oral and written communication and interpersonal skills.
• Has formally recommended an innovative solution to improve an inefficient process or report.
• Personal or work experience as facilitator or negotiator.
• Business experience in a financial institution dealing with multiple business platforms, business processes, geographies, and legal entities.

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 do challenging work
• Opportunities to building close relationships with clients

The good-faith expected salary range for the above position is $160,000-$250,000 depending on factors including but not limited to the candidate's experience, skills, registration status; market conditions; and business needs.This salary range does not include other elements of total compensation, including a discretionary bonus and benefits such as a 401(k) program with company-matching contributions; health, dental, vision, life and disability insurance; and paid time-off plan.

RBC's compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:

* Drives RBC's high performance culture

* Enables collective achievement of our strategic goals

* Generates sustainable shareholder returns and above market shareholder value

Job Skills

Additional Job Details