Consumer Credit Data Lead - City National Bank
Irvine, CA
About the Job
*CONSUMER CREDIT DATA LEAD*
WHAT IS THE OPPORTUNITY?
The Consumer Credit Data Lead is responsible for oversight of data quality strategies in Consumer Credit Products team. Consumer Credit Products is responsible for underwriting and portfolio management of consumer, small business, Small Business Administration and business banking loans. The Consumer Credit Data Lead will manage the design and implementation of processes to streamline and/or automate loan data reviews, support data remediation activities and identify areas for and methods of continuously improving data quality. They will collaborate with leaders in Consumer Credit Products and other stakeholders across the Enterprise to ensure the team's data quality management is in alignment and compliance with Enterprise policies and frameworks and will create and execute corresponding business plans and initiatives as appropriate. The primary focus of this role will be to enable process improvement and implement a streamlined and scalable approach to data quality management. The role will also be responsible for the development of reports to support the team's ongoing credit portfolio management.
What you will do
* Develop data rules and write SQL queries to identify potential credit data inconsistencies in the loan system for further review and remediation by Consumer Credit Products colleagues.
* Design and implement streamlined and/or automated credit data quality control process for monitoring and oversight.
* Execute credit portfolio reporting and data governance including product, risk rating, segmentation, credit behavioral data management, trends and vintage analysis.
* Identify opportunities to embed and enhance credit data management practices into daily operations and business processes across the team.
* Detect data anomalies, identify source of data problems, and recommend data quality solutions.
* Support data governance strategy by being involved in data initiatives and projects.
* Create credit data and loan portfolio architectures designed to solve key credit issues.
* Write queries to support data analysis and ad hoc reports to support team and bank initiatives.
* Partner with internal colleagues in other areas of the bank to build scalable solutions to ensure data quality.
* Maintain current knowledge of related regulatory and bank policies and procedures and establish new processes or enhancements to existing processes to address changing requirements
*Must-Have
* Bachelor's Degree or equivalent
* Minimum 10 years of experience in banking or finance services.
* Minimum 8 years of experience in data quality management and processes.
* Minimum 8 years of experience with SAS or SQL, or other data management, reporting and query tools (Sharepoint, SAP, Business Objects, Tableau, Crystal reports/Dashboard, etc).
* Minimum of 4 years of credit portfolio reporting.
*Skills and Knowledge*
* In-depth knowledge of the financial services industry
* Must have working knowledge of bank processes and controls.
* Emphasis in Regulatory Reporting experience preferred.
* Experience working in a formal risk controls environment with strong understanding of scheduled deliverables.
* Experience in operationalizing data governance, data quality and infrastructure
* In-depth knowledge of Oracle/Snowflake a plus
* Expert with SQL and Tableau
* Strong analytical skills with the ability to extract the context of the data through standard data analysis methodologies
* Excellent leadership, communication (written and oral) and interpersonal skills
* Proven ability to work creatively and analytically in a problem-solving environment
* Well versed in Microsoft Office products including Word, Excel, Visio, SharePoint and PowerPoint.
*Compensation*
Starting base salary: $111,408 - $189,738 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
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.
*Benefits and Perks*
At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our [ Benefits and Perks](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf).
ABOUT CITY NATIONAL
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $92.03 billion in assets as of April 30, 2024. Founded in 1954, City National provides personalized banking, investment and trust services in select markets including Los Angeles, Orange County, San Diego, the San Francisco Bay Area, New York City, Nashville, Atlanta, Delaware, Las Vegas, Washington D.C. and Miami.* In addition, the company and its investment affiliates manage or administer $96.83 billion in client investment assets. City National is dedicated to strengthening communities, and in 2023 alone, the company made more than $11 million in charitable contributions to nonprofits that support the communities it serves.
*City National Bank does business in Miami and the state of Florida as CN Bank.
For more information about City National, visit [cnb.com](https://www.cnb.com/).
*EQUAL OPPORTUNITY EMPLOYER & REASONABLE ACCOMMODATION*
City National Bank is an equal opportunity employer committed to promoting and maintaining a diverse, equitable and inclusive working environment where differences are valued and encouraged. 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 the laws or regulations in the locations where we operate or in our Code of Conduct. [READ MORE](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/1/159726e0-aeb1-4058-9052-d7a2d69626b8.pdf)
If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation for any part of the employment process. Please contact us via [email](mailto:TalentAcquisition@cnb.com) or leave a message at (213) 673-9139. These contact methods are dedicated to applicants whose disability prevents them from successfully applying online. Only messages left for this purpose will be returned. Responses may take up to two business days.
WHAT IS THE OPPORTUNITY?
The Consumer Credit Data Lead is responsible for oversight of data quality strategies in Consumer Credit Products team. Consumer Credit Products is responsible for underwriting and portfolio management of consumer, small business, Small Business Administration and business banking loans. The Consumer Credit Data Lead will manage the design and implementation of processes to streamline and/or automate loan data reviews, support data remediation activities and identify areas for and methods of continuously improving data quality. They will collaborate with leaders in Consumer Credit Products and other stakeholders across the Enterprise to ensure the team's data quality management is in alignment and compliance with Enterprise policies and frameworks and will create and execute corresponding business plans and initiatives as appropriate. The primary focus of this role will be to enable process improvement and implement a streamlined and scalable approach to data quality management. The role will also be responsible for the development of reports to support the team's ongoing credit portfolio management.
What you will do
* Develop data rules and write SQL queries to identify potential credit data inconsistencies in the loan system for further review and remediation by Consumer Credit Products colleagues.
* Design and implement streamlined and/or automated credit data quality control process for monitoring and oversight.
* Execute credit portfolio reporting and data governance including product, risk rating, segmentation, credit behavioral data management, trends and vintage analysis.
* Identify opportunities to embed and enhance credit data management practices into daily operations and business processes across the team.
* Detect data anomalies, identify source of data problems, and recommend data quality solutions.
* Support data governance strategy by being involved in data initiatives and projects.
* Create credit data and loan portfolio architectures designed to solve key credit issues.
* Write queries to support data analysis and ad hoc reports to support team and bank initiatives.
* Partner with internal colleagues in other areas of the bank to build scalable solutions to ensure data quality.
* Maintain current knowledge of related regulatory and bank policies and procedures and establish new processes or enhancements to existing processes to address changing requirements
*Must-Have
* Bachelor's Degree or equivalent
* Minimum 10 years of experience in banking or finance services.
* Minimum 8 years of experience in data quality management and processes.
* Minimum 8 years of experience with SAS or SQL, or other data management, reporting and query tools (Sharepoint, SAP, Business Objects, Tableau, Crystal reports/Dashboard, etc).
* Minimum of 4 years of credit portfolio reporting.
*Skills and Knowledge*
* In-depth knowledge of the financial services industry
* Must have working knowledge of bank processes and controls.
* Emphasis in Regulatory Reporting experience preferred.
* Experience working in a formal risk controls environment with strong understanding of scheduled deliverables.
* Experience in operationalizing data governance, data quality and infrastructure
* In-depth knowledge of Oracle/Snowflake a plus
* Expert with SQL and Tableau
* Strong analytical skills with the ability to extract the context of the data through standard data analysis methodologies
* Excellent leadership, communication (written and oral) and interpersonal skills
* Proven ability to work creatively and analytically in a problem-solving environment
* Well versed in Microsoft Office products including Word, Excel, Visio, SharePoint and PowerPoint.
*Compensation*
Starting base salary: $111,408 - $189,738 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
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.
*Benefits and Perks*
At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our [ Benefits and Perks](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf).
ABOUT CITY NATIONAL
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $92.03 billion in assets as of April 30, 2024. Founded in 1954, City National provides personalized banking, investment and trust services in select markets including Los Angeles, Orange County, San Diego, the San Francisco Bay Area, New York City, Nashville, Atlanta, Delaware, Las Vegas, Washington D.C. and Miami.* In addition, the company and its investment affiliates manage or administer $96.83 billion in client investment assets. City National is dedicated to strengthening communities, and in 2023 alone, the company made more than $11 million in charitable contributions to nonprofits that support the communities it serves.
*City National Bank does business in Miami and the state of Florida as CN Bank.
For more information about City National, visit [cnb.com](https://www.cnb.com/).
*EQUAL OPPORTUNITY EMPLOYER & REASONABLE ACCOMMODATION*
City National Bank is an equal opportunity employer committed to promoting and maintaining a diverse, equitable and inclusive working environment where differences are valued and encouraged. 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 the laws or regulations in the locations where we operate or in our Code of Conduct. [READ MORE](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/1/159726e0-aeb1-4058-9052-d7a2d69626b8.pdf)
If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation for any part of the employment process. Please contact us via [email](mailto:TalentAcquisition@cnb.com) or leave a message at (213) 673-9139. These contact methods are dedicated to applicants whose disability prevents them from successfully applying online. Only messages left for this purpose will be returned. Responses may take up to two business days.
Source : City National Bank