What are the responsibilities and job description for the Business Intelligence Senior Analyst position at City National Bank?
BUSINESS INTELLIGENCE SENIOR ANALYST
WHAT IS THE OPPORTUNITY?
This role will be responsible for creating compelling, automated visualizations and reports, perform site administrator duties on Tableau server, draw insights from the data, and develop automated solutions to support senior leadership strategy and objectives. The Business Intelligence Senior 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 Senior Analyst will also perform data analysis by writing complex 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.This position 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
Be an expert in data visualization, data storytelling, and user-centric dashboard design
Performs statistical analysis of large data sets to better understand trends, relationships between variables, and to formulate predictive insights
Write complex queries in both Python and SQL to support visualizations, data analysis, and adhoc reports
Take ownership of 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
Minimum 5 years of experience with finance, banking and / or risk management systems
Minimum 5 years of experience in business analysis, modeling and database querying tools
Minimum 6 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
In-depth knowledge of CRM tools and Oracle / Snowflake a plus
Expert with SQL and Tableau
Proficient in one or more programming language(s) – Python preferred
Strong 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 : $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.
ABOUT CITY NATIONAL
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $92.03 billion in assets as of April 30, 2024. Founded in 1954, City National provides personalized banking, investment and trust services in select markets including Los Angeles, Orange County, San Diego, the San Francisco Bay Area, New York City, Nashville, Atlanta, Delaware, Las Vegas, Washington D.C. and Miami.
For more information about City National, visit cnb.com.
EQUAL OPPORTUNITY EMPLOYER & REASONABLE ACCOMMODATION
City National Bank is an equal opportunity employer committed to promoting and maintaining a diverse, equitable and inclusive working environment where differences are valued and encouraged. 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 the laws or regulations in the locations where we operate or in our Code of Conduct. READ MORE
If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation for any part of the employment process. Please contact us via email or leave a message at (213) 673-9139. These contact methods are dedicated to applicants whose disability prevents them from successfully applying online. Only messages left for this purpose will be returned. Responses may take up to two business days.
Salary : $92,114 - $156,880
