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

BI Developer Senior

Sorry, this job was removed at 1:12 p.m. (CST) on Friday, December 10, 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) SENIOR DEVELOPER


WHAT IS THE OPPORTUNITY?



The Senior Business Intelligence Developer is responsible for the development activities of various BI initiatives, which include ETL, ELT, PL/SQL, Python, and APIs, scripts, reports and dashboards. The Senior BI Developer will support project initiatives within the Operational Data Store (ODS), Enterprise Data Warehouse (EDW), various Data Marts, Master Data Management and BI Reporting. The position will perform in-depth development, data analysis, data quality, and design for quality engineering across various databases and methodologies specific to Business Intelligence. This role will provide input and oversight on development design decisions, best practices, and processes to a team of BI Developers.


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?



  • Perform in-depth development by writing complex ETL/ELT jobs, PL/SQL queries, APIs on various source systems, data marts and data warehouse support of the requirements for various strategic and/or tactical projects
  • Work with a team of developers to provide input and oversight on ETL/ELT development designs and processes.
  • Serve as Subject Matter Expert on Operational Data Stores, Data Warehouse, and Data Marts development; guide the development design activities with input and data dependencies.
  • Identify development and data quality issues and work with leads and management to mitigate
  • Conduct on-going analysis of the development process and practices within and between various systems and applications.
  • Ability to multi-task various projects and tasks with tight deliverables while keeping informed of existing and evolving development 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 users 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.). Basic


WHAT DO YOU NEED TO SUCCEED

Must-Have*

  • Minimum of 5 years of experience as a Developer, preferably in a data-intensive financial company.
  • Minimum of 5 years of experience in advanced ETL/ELT, PL/SQL, Oracle, and Reporting
  • Minimum of 5 years of experience working with Business Intelligence technologies

Skills and Knowledge

  • Bachelor's degree in computer science, engineering or equivalent
  • MS in Computer Science or a related technical field preferred.
  • Knowledge of SAP and Informatica products: SAP Data Services and Business Objects (development, migration, access, installation and upgrades); Informatica PowerCenter, Data Quality, Data Validation
  • Knowledge of Business Intelligence and Data Warehousing concepts and principles
  • Experience in Oracle databases, PL/SQL is strongly preferred
  • 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.



*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