Data Analytics Specialist 1Lod

DATA ANALYTICS SPECIALIST 1LOD/COE WHAT IS THE OPPORTUNITY? A sound internal control framework helps CNB achieve its operational and financial performance goals while operating within the parameters of applicable laws and established risk appetite.

Control testing is an integral part of the internal control framework. The Centre of Excellence (CoE) is the group responsible for CNB's control testing. This role will support the consistent and holistic execution of CNB's control testing across the enterprise through (i) the design and implementation of infrastructure and reporting solutions for CoE; (ii) querying, transforming, and documenting the data acquisition process for the team; and (iii) assisting in the development of data based key control tests.

This dynamic position provides opportunities for working across CNB, including across the business, 2LOD and internal audit. Office of the President Division Working within the Office of the President division, you will be part of the team that provides strategic support and guidance to City National's commercial lines of business with a strong focus on integrated and streamlined risk and compliance programs. What you will do Support verifying data consistency between final reports, source systems, and data input; and assist with researching and enhancing automation methodologies Responsible for analyzing data across multiple databases with a keen eye on data integrity Responsible for the design and implementation of infrastructure and reporting solutions for CoE Responsible for querying, transforming, and documenting the data acquisition process for the CoE Assisting in the development of data based key control tests Ensure a framework and governance structure is in place, to maintain key findings, reporting and access to data of file reviews for regulators Communicate with Control and Data Owners to identify data sources, systems, and requirements relevant to the CoE's testing of Key Controls Exhibit high attention to details in aggregating and communicating control testing results to CNB Senior Management and other stakeholders Enable roll out, maintenance and continuous improvement of Technology and tools to support risk and control initiatives Maintain solid working relationships with data owners across 1LOD. Must-Have

• Bachelor's Degree or equivalent Minimum 2 years experience in reporting or analytics preferably in a data-intensive financial services industry Skills and Knowledge Strong expertise in data querying tools and advance skills in SAS, SQL and/or DataMeer Proficiency in MS Excel (including Pivot Tables and data importing) and Tableau Solid communication skills, and ability to effectively converse with technical and non-technical contacts Proven analytical and problem solving experience, with a collaborative attitude Knowledge of data related to Retail and/or Commercial banking products Compensation Starting base salary: $37.96 - $60.64 per hour. 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 qualifications The 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 Perks At 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. INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT City 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 NATIONAL We 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 be at the heart of our company today. City National is a subsidiary of Royal Bank of Canada, one of North America's leading diversified financial services companies.