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//

EDM Data Analyst

Sorry, this job was removed at 4:47 a.m. (CST) on Wednesday, March 30, 2022
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.

ENTERPRISE DATA ANALYST


WHAT IS THE OPPORTUNITY?



The Enterprise Data analyst is a key role responsible for developing and supporting the development activities of various enterprise data initiatives. The Data Analyst will the support the team by examining the data available from an existing information source (e.g. a database or a file extract from Systems of Record) and collect facts that could be used to determine how this existing data can be repurposed. The Data Analyst will also analyze and advise the team on workflow issues and data integrity problems and offers recommendations on resolution.


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?



  • Data Analysis
  • Mapping data sources leveraging both new and existing data sources
  • Documenting interfaces and data movement
  • Validate integrative views of dataDesigning canonical data views
  • Perform extensive data profiling and analysis on current data movement process and procedures
  • Identify data patterns, data cleansing, reference data design and recommend models to provide valuable data insights to business users.
  • Document related artifacts in accordance to data governance policies, controls and standards
  • Work with the data architect to load/create the data dictionary and business glossary with agreed upon terms, metadata, definitions, descriptions, and related values.
  • Support all design related activities.
  • Define best practices and standards
  • Maintain clear documentation to help increase overall productivity
  • Data as a Service
  • Investigate and prove concepts as Data technologies evolves
  • Support ad-hoc requests as requested by management and business partners


WHAT DO YOU NEED TO SUCCEED

Must-Have*

  • Bachelor's Degree or equivalent
  • 3-5 years of hands-on experience with SQL and other data profiling tools and techniques
  • 3-5 years' experience in data analysis preferably in a data-intensive financial company.

Skills and Knowledge

  • Strong SQL Skills
  • Experience with data profiling tools like Informatica DQ analyst
  • Excellent analytical and problem solving skills.
  • Excellent oral and written communication and interpersonal skills.
  • Strong organizational, multi-tasking, and time-management skills preferred.
  • Ability to work independently or within a team for problem resolution
  • Must demonstrate ability to multi-task and be flexible.
  • Ability to interface effectively with all levels of the organization
  • Ability to express complex technical concepts in business terms.



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

 

In order to be hired and work at City National Bank, you must be fully vaccinated against COVID-19. 


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