Business Intelligence Senior Analyst

City National Bank • Los Angeles, CA

4h • Onsite

About The Position

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.

Requirements

• 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
• Well-rounded knowledge of commercial banking products: Treasury Services, Commercial lending, Deposits and Investments
• In-depth knowledge of the financial services industry
• 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

Nice To Haves

• In-depth knowledge of CRM tools and Oracle/Snowflake a plus

Responsibilities

• 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

Benefits

• Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date
• Generous 401(k) company matching contribution
• Career Development through Tuition Reimbursement and other internal upskilling and training resources
• Valued Time Away benefits including vacation, sick and volunteer time
• Specialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programs
• Career Mobility support from a dedicated recruitment team
• Colleague Resource Groups to support networking and community engagement

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed