BUSINESS INTELLIGENCE ANALYST_PBB

　　WHAT IS THE OPPORTUNITY?

　　Responsible for creating compelling, automated visualizations and reports, perform site administrator duties on SharePoint sites, Tableau server, draw insights from the data, and develop automated solutions to support senior leadership strategy and objectives. The Business Intelligence Analyst will develop a deep knowledge of the datasets and subject matter to be able to develop more insightful visualizations and draw conclusions from the data. The Business Intelligence Analyst will also perform data analysis by writing queries on various source systems and data warehouses to find trends and anomalies in the data in support of the requirements for various strategic and/or tactical projects.In addition to, will use acquired experience with visualization, analysis, and data ingestion tools to find innovative ways to accomplish tasks and handle multiple projects simultaneously and independently.

　　What you will do

　　Partner with internal colleagues in other areas of the bank to build scalable solutions for data analysis and business process improvement.

　　Create information and data architectures designed to solve key business problems

　　Develop compelling, well designed, and automated dashboards (primarily in Tableau but could be others) that support business line and senior leadership strategy and objectives, using diverse sets of structured and unstructured data

　　Help create and encourage consistent dash boarding and data presentations across multiple digital delivery teams

　　Provide support in data visualization, data storytelling, and user-centric dashboard design

　　Write queries in SQL to support visualizations, data analysis, and adhoc reports

　　Responsible for visualization related projects from end to end: translating business requirements to technical requirements, designing dashboards to support the requirements, sourcing data and writing queries, assessing data quality, and monitoring performance

　　Identify data quality issues and concerns and support the data governance initiative by being involved in various data initiatives.

　　Integrates client-provided elements, research findings, and publicly available information into analytical projects

　　Must-Have*

　　Bachelor's Degree or equivalent experience

　　Minimum 3 years of experience with finance, banking and/or risk management systems

　　Minimum 3 years of experience in business analysis, modeling and database querying tools

　　Minimum 4 years of related experience as an analyst supporting medium to large size projects

　　Skills and Knowledge

　　Well-rounded knowledge of commercial banking products: Treasury Services, Commercial lending, Deposits and Investments

　　In-depth knowledge of the financial services industry

　　Advanced knowledge in Microsoft tools, especially Excel, Pivot tables, Power query, Macro

　　Intermediate proficiency with SQL, Tableau, SharePoint

　　Proficient in one or more programming language(s) – SQL preferred

　　Experienced analytical skills with the ability to extract the context of the data through standard data analysis methodologies

　　Excellent communication skills, both written and verbal

　　Excellent leadership, communication (written and oral) and interpersonal skills

　　Proven ability to work creatively and analytically in a problem-solving environment

　　COMPENSATION

　　Starting base salary: $78,970 - $126,140 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.