City National Bank ยท 13 hours ago
Business Unit Data Analyst
Los Angeles, CA
Full-time
Onsite
Mid, Senior Level
$87K/yr - $139K/yr
5+ years expCity National Bank is a subsidiary of Royal Bank of Canada, committed to helping clients and communities flourish. The Business Unit Data Analyst will support the Finance group by analyzing quantitative and qualitative data, translating business problems into data-driven solutions, and ensuring data quality across various systems and applications.
BankingFinanceFinancial Services
Responsibilities
Work with Business Users to define and document explicit business requirements for implementing subject areas in the Enterprise Data Warehouse and corresponding reports
Perform data analysis by writing complex SQL queries on various source systems and data warehouse to find trends and anomalies in the data in support of the requirements for various strategic and/or tactical projects
Serve as Subject Matter Expert on a particular system and its data, and guide the development activities with assumptions and data dependencies
Identify data quality issues and concerns and support the data governance initiative by being involved in various data initiatives
Conduct on-going analysis of the business, operating practices, and data flows within and between various systems and applications
May be required to assist in maintaining the data model for both Operational Data Store (ODS) as well as the analytical Enterprise Data Warehouse (EDW)
Keeps informed of existing and evolving best practice, industry standards and technologies
Fosters and maintains good relationships with colleagues to meet expected customer service levels
Maintain all appropriate training and continuing education requirements for both internal programs and external licenses and certifications
Develop and maintain positive, productive, and professional relationships with key business partners to meet expected customer service levels
Complies fully with all Bank Operational policies and procedures as well as all regulatory requirements (e.g. Bank Secrecy Act, Know Your Client, Community Reinvestment Act, Fair Lending Practices, Code of Conduct, etc.)
Qualification
Required
Bachelor's Degree or equivalent Business, Economics, Finance, Accounting, Computer Science or related technologies strongly preferred
Minimum 5 years of experience working with Information Technologies required
Minimum 5 years of experience as an analyst, preferably in a data-intensive financial company
Minimum 3 years working in a client facing business support role
Preferred
Prior hands-on experience in using SQL, Tableau, or Business Objects is a plus
Prior experience in Financial Services industry a plus
Excellent analytical skills
Good knowledge of project management technique
Able to communicate clearly and professionally with all levels of an organization
Strong interpersonal, written and verbal communication skills with demonstrated ability to work in a team environment
Ability to express complex technical concepts in business terms
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
Company
City National Bank
City National Bank offers a full complement of banking, trust and investment services. It is a sub-organization of City National.
1001-5000 employees
H1B Sponsorship
City National Bank has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (76)
2024 (78)
2023 (145)
2022 (93)
2021 (107)
2020 (62)
Funding
Current Stage
Public CompanyTotal Funding
unknown1978-01-13IPO
Leadership Team
Howard Hammond
CEO City National Bank
Fiyaz Khan
Senior Vice President, Structured Products
Recent News
UPSTATE BUSINESS JOURNAL
2025-12-18
Venture Capital Firms
2025-11-08
Company data provided by crunchbase