SENIOR DATA ANALYST

　　WHAT IS THE OPPORTUNITY?

　　The Senior Data Analyst works within the Insights, Data Engineering & Analytics organization to meet the data pipeline strategies and objectives for the Residential Lending/Mortgage domain. The Senior Data Analyst will guide and lead end-to-end process, standards, and guidelines to ensure accurate and efficient data delivery of tasks and projects.

　　Technology and Innovation Division

　　As a member of City National's Technology & Innovation group, in the Lending Technology team, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our technology teams.

　　What you will do

　　Lead data analysis via data discovery, exploration, investigation, and impact assessments. Apply best practices and illustrate understanding via data flows of systems and processes.

　　Conduct and leads data profiling and data preparation by identifying gaps and qualifying data.

　　Validates data by verifying against requirements and success criteria.

　　Confirms understanding of requirements by modeling data with Entity Relationship diagrams and data flow diagrams

　　Assist with the coordination involving personnel from other departments and information technology groups to facilitate successful project implementations.

　　Leads understanding by researching business processes and documenting inconsistent and incomplete data, value misinterpretations and misclassified data.

　　Lead development/quality measurement, benchmarking and goal setting, performance measurement analysis

　　Identify the appropriate data sources and map the data from source to target

　　Create and manage the catalog and metadata of data related objects

　　Guide integration across data sources and targets

　　Perform one or more of the following:

　　Actively mentor other colleagues by contributing experience and insight to the team

　　Manage large programs & projects of significant complexity and risk.

　　Independently (with minimal oversight) develop and maintain trusted advisor relationships, including at the senior leadership level and with external partners, that include guidance, as appropriate, for optimizing use of analytic capabilities and deliverables, and prioritization based on strategic vision

　　Must-Have*

　　Bachelor's Degree or equivalent experience

　　7+ years of relevant experience in data analysis or analytics in the banking industry

　　Skills and Knowledge

　　Advanced senior professional with wide ranging experience using professional concepts and to resolve complex issues in creative and effective ways

　　Microsoft SQL Server

　　Expert abilitiy in creating SQL queries.

　　SharePoint and Tableau knowledge or ability to learn the tools quickly

　　Desired knowledge of the mortgage industry.

　　Compensation

　　Starting base salary: $92,114 - $156,880 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 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 (https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf) .

　　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.