City National Bank company image
City National Bank
City National Bank proudly offers services, tools and technology that put our people and communities first.
Hybrid
View Profile
Jobs//Hybrid//Los Angeles, CA//Data + Analytics//

Business Intelligence (BI) Data Senior Analyst

Sorry, this job was removed at 1:14 p.m. (CST) on Tuesday, November 9, 2021
View 10435 Jobs
Find out who's hiring in Los Angeles, CA.
See all Data + Analytics jobs in Los Angeles, CA
View 10435 Jobs
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

BUSINESS INTELLIGENCE (BI) DATA SENIOR ANALYST


WHAT IS THE OPPORTUNITY?



The Business Intelligence Senior Data Analyst is responsible for supporting the Business Intelligence team and the business users through the analysis of quantitative & qualitative data by designing database models both logical and physical for department specific projects. The position will participate and perform data analysis; develop database models, database processes and functional analysis across various database methodologies specific to Business Intelligence. This role will require the ability to lead projects as the senior data analyst related to database design in both analysis and architecture.


Technology and Innovation Division
As a member of City National's Technology & Innovation group, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our technology teams.


WHAT WILL YOU DO?



  • Work with Business Users to define and document explicit data requirements for implementing subject areas in the Operational Data Store and Enterprise Data Warehouse.
  • Perform in-depth data analysis by writing complex PL/SQL queries on various source systems, data marts 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 Operational Data Stores, Data Warehouse, Data Marts; guide the development design 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.
  • 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.).


WHAT DO YOU NEED TO SUCCEED

Must-Have*

  • Minimum of 7 years of experience working with Information technologies in a senior role required
  • Minimum of 7 years of experience as a Data Analyst
  • Minimum of 5 years of experience in advanced PL/SQL and Oracle queries and analysis.

Skills and Knowledge

  • Prior hands-on experience in using ETL tools, Business Objects or other related BI tools
  • Excellent analytical skills
  • 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.
  • Bachelor's degree in Computer Science or related technologies strongly preferred.
  • Prior experience in Financial Services industry a plus.
  • Prior hands-on experience in using ERWin a plus.
  • Proficient in designing database models (both logical and physical)



*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.


INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT
City National Bank is an equal opportunity employer committed to diversity and inclusion. 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 law.


ABOUT CITY NATIONAL



We start with a basic premise: Business is personal. Since day one we've always gone further than the competition to help our clients, colleagues and community flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues to drive phenomenal growth today. City National is a subsidiary of Royal Bank of Canada, one of North America's leading diversified financial services companies.


City National Bank requires all colleagues to be fully vaccinated against COVID-19 to work on-site at any of our locations.


See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
By clicking Apply Now you agree to share your profile information with the hiring company.
Prateechi Singh
Data Scientist
TACKLE CHALLENGES
Latitude to shake up a global industry
Prateechi Singh appreciates that City National gives her and her peers space to spark innovation in a way that feels like a startup within the company. “My job requires me to be an investigator,” she said. “There is so much to work on, so much to learn. That’s what makes fintech exciting for me.” While she notes that the banking sector can be slow to adapt to change, Singh said the opportunity to tackle challenges from scratch and figure out how to evolve alongside new technologies like cryptocurrencies is invigorating.
Prateechi Singh appreciates that City National gives her and her peers space to spark innovation in a way that feels like a startup within the company. “My job requires me to be an investigator,” she said. “There is so much to work on, so much to learn. That’s what makes fintech exciting for me.” While she notes that the banking sector can be slow to adapt to change, Singh said the opportunity to tackle challenges from scratch and figure out how to evolve alongside new technologies like cryptocurrencies is invigorating.
My team is very passionate about what we do, and I feel this is the key to success for any project. We try to solve hard problems.
Srikant Vavilapalli
Senior Software Development Manager
WORK HARD, THEN RELAX
A focus on work-life balance
Srikant Vavilapalli said City National Bank’s remote culture is defined by a palpable level of trust between teammates. “We foster open dialogue, which enables me to share expectations and deliverables with my team so that they can execute on time,” he said. Yet this common sense of respect doesn’t just make Vavilapalli’s team more efficient. It also empowers team members to set flexible working schedules. For Vavilapalli, that means he has more time to bond with his daughter or focus on his hobbies, such as cycling and photography.
Srikant Vavilapalli said City National Bank’s remote culture is defined by a palpable level of trust between teammates. “We foster open dialogue, which enables me to share expectations and deliverables with my team so that they can execute on time,” he said. Yet this common sense of respect doesn’t just make Vavilapalli’s team more efficient. It also empowers team members to set flexible working schedules. For Vavilapalli, that means he has more time to bond with his daughter or focus on his hobbies, such as cycling and photography.
I appreciate that our leaders make it a priority to encourage us to take breaks and step away from our desks during the day.
Marj Galapon
Lead Full-Stack Engineer
EVOLVE + INNOVATE
Collaborate with peers and drive progress
A mix of teamwork, autonomy and flexibility offers the perfect environment for Marj Galapon. She appreciates no-meeting Fridays, which allow time to learn something new, and the flexibility to work remotely — even before the pandemic — to avoid spending hours commuting. But perhaps the most transformative element of the engineering culture is the focus on continuous improvement. “We are encouraged to learn new technologies and challenge each other, which motivates us to do better every time,” she said. “City National recognizes all who strive to do their best.”
A mix of teamwork, autonomy and flexibility offers the perfect environment for Marj Galapon. She appreciates no-meeting Fridays, which allow time to learn something new, and the flexibility to work remotely — even before the pandemic — to avoid spending hours commuting. But perhaps the most transformative element of the engineering culture is the focus on continuous improvement. “We are encouraged to learn new technologies and challenge each other, which motivates us to do better every time,” she said. “City National recognizes all who strive to do their best.”
Sometimes I am successful; sometimes I fail — but failure does not stop me from experimenting with new things.

What are City National Bank Perks + Benefits

City National Bank Benefits Overview

We strive to be the best at whatever we do, and that includes the benefits and perks we offer our colleagues.
We understand that colleagues have different needs. As a result, we look to offer a holistic program to support and address physical, emotional, financial and social needs.

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Diversity
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Diversity employee resource groups
Our 11 Colleague Resource Groups (CRGs) help colleagues deepen their relationships and knowledge at work, encouraging more people to connect, learn and celebrate with each other.
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
FSAs allow colleagues to set aside pretax dollars to help pay for medical and/or dependent day care expenses.
Disability insurance
Coverage generally begins the first day of the month following hire date. Short- and long-term disability benefits are available to colleagues to assist with periods of injury or illness.
Dental insurance
Preventive care as well as basic and major dental services are provided through either a preferred provider plan (PPO) or a dental maintenance plan (DHMO).
Vision insurance
Coverage is available for vision exams, contact lenses, glasses and frames.
Health insurance
Coverage generally begins on the first day of the month following employment, and colleagues are able to cover spouses, domestic partners and/or dependent children.
Life insurance
When you become eligible for CNB Benefits, the company will provide you with basic life insurance equal to 1½ times your annual base salary, up to a maximum of $100,000 of coverage – at no cost to
Wellness programs
Enjoy access to a wide range of health tools and resources, including health screenings, coaching and/or fitness challenges – all kept confidential and secure.
Financial & Retirement
401(K)
401(K) matching
Pretax and Roth 401(k) - the company matches 75% of the first six percent of eligible pay a colleague contributes each pay period. Match dollars are immediately vested.
Performance bonus
Some positions may be eligible for bonus and/or commissions.
Child Care & Parental Leave Benefits
Generous parental leave
Family medical leave
Adoption Assistance
Vacation & Time Off Benefits
Paid volunteer time
Paid holidays
Paid sick days
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing education available during work hours
Customized development tracks
Paid industry certifications
View full list of perks + benefits
Photo Gallery

More Jobs at City National Bank

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about City National BankFind similar jobs like this