Data Analytics & Automation Analyst II

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

Benefits offered by this job

Healthcare coverage

401(k) matching

Tuition reimbursement

Paid time off

Fertility benefits

Career development

Employee resource groups

Job summary

City National Bank is seeking a Data Analyst II (Business Systems Analyst II) to design, develop, and support data-driven analytical solutions. You will translate business requirements into scalable, governed solutions using SQL, Python, Tableau, Snowflake, and Excel, partnering with the Credit Risk Review team to improve decision-making and efficiency.

The role focuses on data analytics, automation, and collaboration with stakeholders, with opportunities to contribute to data modernization and

Qualifications

• Bachelor’s degree in Information Systems or related field.
• 3-5 years of experience in data analytics, BI, reporting, or financial/risk analytics.

Responsibilities

• Develop and optimize SQL queries, datasets, and analytical solutions.
• Design, build, and maintain Tableau dashboards and reports.
• Validate data quality and reconcile results across data sources.
• Develop automated reporting and data pipelines; support data modernization initiatives.

Skills

Data analytics

Business intelligence

Reporting

Business systems analysis

Education

Bachelor’s degree in Information Systems / related

Tools

SQL

Tableau

Python

Snowflake

Excel

Job description

City National Bank is seeking a Data Analyst II (Business Systems Analyst II) to design, develop, and support data-driven analytical solutions. You will translate business requirements into scalable, governed solutions using SQL, Python, Tableau, Snowflake, and Excel, partnering with the Credit Risk Review team to improve decision-making and efficiency.

The role focuses on data analytics, automation, and collaboration with stakeholders, with opportunities to contribute to data modernization and