Data Analyst

City National Bank; Los Angeles (CA); On-site; USD 61,000 - 105,000; Full time

Benefits offered by this job

Healthcare coverage

401(k) match

Career development

Time away

Tuition reimbursement

Diversity groups

Job summary

City National Bank in Los Angeles, CA is seeking a data analytics professional for the Credit Risk Review team in an onsite role. You will develop data-driven analytics, optimize SQL queries, and build Tableau dashboards to surface actionable insights.

You will collaborate with business stakeholders, validate data quality, and contribute to automation using Python and Snowflake, while aligning with regulatory requirements and bank policies.

Qualifications

• Bachelor’s degree required in a related field.
• 3-5 years of data analytics, BI, reporting, or financial/risk analytics experience.
• Proficiency in SQL, Tableau, and Advanced Excel.
• Experience in commercial banking or financial services.
• Ability to translate business needs into analytical solutions.

Responsibilities

• Develop and optimize SQL queries and datasets.
• Design, build, and maintain Tableau dashboards and reporting.
• Analyze data to surface trends, exceptions, and insights.
• Validate data quality across data sources.
• Automate reporting and data preparation processes.
• Develop data pipelines and workflow automation.
• Create scalable analytical solutions to reduce manual effort.
• Support modernization using Python, Snowflake, and cloud analytics.
• Design and develop AI agents to automate workflows.
• Gather and document business requirements and translate into solutions.
• Collaborate with users through design, testing, implementation, and support.
• Provide training on data and productivity tools.
• Participate in software implementation and enhancements.
• Identify opportunities to improve reporting and data management.
• Utilize internal AI tools to boost productivity with governance.

Skills

SQL

Tableau

Advanced Excel

Python

Snowflake

Education

Bachelor’s degree in Information Systems / Analytics / CS / Finance

Tools

Tableau Desktop

Job description

Build and support data-driven analytics for the Credit Risk Review team in an onsite role in Los Angeles.

Responsibilities

• Develop and optimize SQL queries, datasets, and analytical solutions
• Design, build, and maintain Tableau dashboards and reporting
• Analyze data to surface trends, exceptions, and actionable business insights
• Validate data quality and reconcile results across multiple data sources
• Design and implement automated reporting and data preparation processes
• Develop and enhance data pipelines and workflow automation
• Create scalable, reusable analytical solutions to reduce manual effort and improve efficiency
• Support modernization initiatives using Python, Snowflake, and cloud-based analytics technologies
• Design and develop AI agents and agentic solutions to automate workflows
• Gather, clarify, and document business requirements
• Translate business needs into technical and analytical solutions
• Partner with business users through solution design, testing, implementation, and ongoing support
• Provide basic to intermediate training on data and productivity tools to support team efficiency
• Participate in software implementation and enhancement projects
• Identify opportunities to improve reporting, automation, and data management processes
• Use RBC’s internal AI tools to improve productivity, code development, documentation, and analysis, with appropriate validation and governance
• Continuously develop technical knowledge and stay current on emerging analytics technologies and best practices
• Maintain current knowledge of related regulatory and bank policies and procedures
• Adhere to all Bank Administrative, Operational and Credit policies and procedures, and relevant regulatory and compliance requirements for Credit Risk Review

Requirements

• Bachelor’s degree in Information Systems, Business Analytics, Data Analytics, Computer Science, Business, Finance, Economics, or Statistics (or related field)
• 3-5 years of experience in data analytics, business intelligence, reporting, business systems analysis, or financial/risk analytics
• SQL, Tableau, and Advanced Excel
• Commercial banking or financial services experience
• Experience working with business stakeholders to deliver analytical solutions
• Credit Risk, lending, portfolio management, or regulatory reporting experience
• Software implementation or business process improvement initiative experience
• Strong SQL skills
• Tableau Desktop (or similar business intelligence platform)
• Advanced Microsoft Excel
• Python and Snowflake (or other scripting languages) preferred

Compensation

• Starting base salary: $60,500 - $104,500 per year
• Exact compensation may vary based on skills, experience, and location
• Eligible for bonus and/or commissions

Benefits

• Comprehensive healthcare coverage including Medical, Dental, and Vision plans available the first of the month following the 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 for networking and community engagement

Technology

• SQL, Python, Tableau, Snowflake, Excel
• AI tools, AI agents, agentic solutions
• Tableau Desktop

Location: Los Angeles, CA (onsite)

Reporting structure: Reporting to the Data Analytics Manager

Inclusion and Equal Opportunity Employment

• City National Bank fosters an inclusive environment where all forms of diversity are valued and leveraged
• Equal opportunity employer: consideration without regard to race, color, religion, sexual orientation, gender identity, national origin, disability, veteran status, or other protected basis
• Massachusetts applicants: unlawful to require or administer a lie detector test as a condition of employment or continued employment
• To be considered, you must at least meet the required qualifications; applications accepted on an ongoing basis until filled via careers.cnb.com
• Unless otherwise indicated as fully remote, reporting into a designated City National location is an essential function of the job