MANAGER OF AUDIT, SENIOR- DATA ANALYTICS ENGINEERINGWHAT 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 and engineering. 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, ETL, reporting, and visualization.What you will do
Leads the development, delivery, and utilization of data analytics during audit engagements to provide continuous improvement in the execution of the audit plan.
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.
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.
Curates, prepares, and integrates large and varied datasets to test business hypotheses and implements statistical analysis using Python and R.
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.
Must-Have
Bachelor's Degree or equivalent
Minimum 5 years of experience in data analytics cycle (data gathering, transformation, ETL, 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
Skills and Knowledge
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.
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.
Exceptional knowledge of Extract, Transform and Load process and tools
Advanced experience working with Python and SQL and strong coding abilities.
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.
CompensationStarting base salary: $111,408 - $189,738 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.To be considered for this position you must meet at least these basic qualificationsThe preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.Benefits and PerksAt City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our Benefits and Perks (https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf) .INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENTCity National Bank is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by law.'ABOUT CITY NATIONALWe start with a basic premise: Business is personal. Since day one we've always gone further than the competition to help our clients, colleagues and community flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues to drive phenomenal growth today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies.#LI-KTB#CA-KTB
