City National Bank
Data Steward Analyst CR
City National Bank, Los Angeles, California, United States, 90079
DATA STEWARD ANALYST CR
WHAT IS THE OPPORTUNITY?
This position is responsible for the execution and support of data governance requirements and critical business elements within the assigned lines of business (LOBs) to align with the objectives of RBC's Data Governance Approach. This position, as applicable, is responsible for producing and submitting manual data templates to the Reporting and Business Intelligence teams for integration into the reporting platforms. Primary responsibilities include: providing attestation for LOB specific data elements to the lending division/team's Quality Assurance Manager(s) including validation of the quality of source loan data provided for reporting; ownership of the quality of specific data elements (including pre- and post-booking reviews of loan approval and boarding documents); review, research and resolve edit check failures within established reporting timeframes in conjunction with the Quality Assurance Manager and loan support areas of the Bank; executing effective controls to ensure responsibility and accountability for all business data across the monthly FR Y-14 M and the quarterly Q submissions. Responsibilities also include: data validation (ensuring data input is equal to the output), data profiling; understanding of data lineage and data process flow; review and development of internal edit check reports, and maintaining other data quality monitoring processes in partnership with the Data Management Officers (DMOs).
What you will do
The Data Steward is responsible for development, implementation, and maintenance of quality assurance (QA) processes, including internal controls, governing Critical Data Elements (CDEs) for the assigned Lines of Business.
Provides data elements that are manual sources within the data template to the Business Architect / Business Intelligence Development teams who will integrate the manual templates into the staging and production areas.
Responsible for attestation for line of business specific critical data elements to the Division Credit Manager or Quality Assurance Manager corroborating to the quality of source data provided for reporting, including compilation and documentation of specific action plans to remediate data errors / failures.
Ensuring accountability and ownership of the data quality for specific data elements, partnering with QA manager to resolve edit check failures.
By implementing the QA processes the Data Steward is responsible for pre-boarding review and remediation (if required) of any errors in CDEs for all line of business credit transactions.
Conducts data profiling activities including review and development of internal edit check reports. The Data Steward also monitors evolving error trends in CDEs and provides information to Quality Assurance Manager(s) on key trends and issues related to key data accuracy.
Ensure compliance with CCAR data governance policies, standards and operational procedures.
Must-Have *
Minimum 2 years of financial reporting experience, preferably in regulatory reporting or data management environment required
Minimum 2 years of Microsoft Excel experience required (with knowledge of vlook-up, iferrors, pivot tables, macros)
Minimum 2 years working in a data analysis role required
Skills and Knowledge
Bachelor's Degree preferred
Prefer 1-3 years of banking experience, preferably in regulatory reporting or credit.
Strong understanding and background of the FR Y-14M and FR Y-14Q CCAR reporting preferred
Experience with CCAR reporting and/or credit risk analytics preferred.
Experience working and effectively collaborating with reporting, operations and technology teams.
Familiarity with operational and support environment issues.
Must be driven, operationally savvy, action-oriented who continually strives for improvement
Must have excellent written and verbal communication and interpersonal skills
Strong ability to communicate effectively including problem resolution skills
Ability to work independently with light to moderate supervision in various areas of responsibility
Technical Competencies: * Understanding and background of CCAR reporting * Background and experience with credit risk * Strong excel skills * Familiarity with operational and support environment issues
Behavioral Competencies: * Organizational awareness * Independent thinker * Effective communication * Collaboration
Compensation
Starting base salary: $34.55 - $55.19 per hour. 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.
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.
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
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 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?
This position is responsible for the execution and support of data governance requirements and critical business elements within the assigned lines of business (LOBs) to align with the objectives of RBC's Data Governance Approach. This position, as applicable, is responsible for producing and submitting manual data templates to the Reporting and Business Intelligence teams for integration into the reporting platforms. Primary responsibilities include: providing attestation for LOB specific data elements to the lending division/team's Quality Assurance Manager(s) including validation of the quality of source loan data provided for reporting; ownership of the quality of specific data elements (including pre- and post-booking reviews of loan approval and boarding documents); review, research and resolve edit check failures within established reporting timeframes in conjunction with the Quality Assurance Manager and loan support areas of the Bank; executing effective controls to ensure responsibility and accountability for all business data across the monthly FR Y-14 M and the quarterly Q submissions. Responsibilities also include: data validation (ensuring data input is equal to the output), data profiling; understanding of data lineage and data process flow; review and development of internal edit check reports, and maintaining other data quality monitoring processes in partnership with the Data Management Officers (DMOs).
What you will do
The Data Steward is responsible for development, implementation, and maintenance of quality assurance (QA) processes, including internal controls, governing Critical Data Elements (CDEs) for the assigned Lines of Business.
Provides data elements that are manual sources within the data template to the Business Architect / Business Intelligence Development teams who will integrate the manual templates into the staging and production areas.
Responsible for attestation for line of business specific critical data elements to the Division Credit Manager or Quality Assurance Manager corroborating to the quality of source data provided for reporting, including compilation and documentation of specific action plans to remediate data errors / failures.
Ensuring accountability and ownership of the data quality for specific data elements, partnering with QA manager to resolve edit check failures.
By implementing the QA processes the Data Steward is responsible for pre-boarding review and remediation (if required) of any errors in CDEs for all line of business credit transactions.
Conducts data profiling activities including review and development of internal edit check reports. The Data Steward also monitors evolving error trends in CDEs and provides information to Quality Assurance Manager(s) on key trends and issues related to key data accuracy.
Ensure compliance with CCAR data governance policies, standards and operational procedures.
Must-Have *
Minimum 2 years of financial reporting experience, preferably in regulatory reporting or data management environment required
Minimum 2 years of Microsoft Excel experience required (with knowledge of vlook-up, iferrors, pivot tables, macros)
Minimum 2 years working in a data analysis role required
Skills and Knowledge
Bachelor's Degree preferred
Prefer 1-3 years of banking experience, preferably in regulatory reporting or credit.
Strong understanding and background of the FR Y-14M and FR Y-14Q CCAR reporting preferred
Experience with CCAR reporting and/or credit risk analytics preferred.
Experience working and effectively collaborating with reporting, operations and technology teams.
Familiarity with operational and support environment issues.
Must be driven, operationally savvy, action-oriented who continually strives for improvement
Must have excellent written and verbal communication and interpersonal skills
Strong ability to communicate effectively including problem resolution skills
Ability to work independently with light to moderate supervision in various areas of responsibility
Technical Competencies: * Understanding and background of CCAR reporting * Background and experience with credit risk * Strong excel skills * Familiarity with operational and support environment issues
Behavioral Competencies: * Organizational awareness * Independent thinker * Effective communication * Collaboration
Compensation
Starting base salary: $34.55 - $55.19 per hour. 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.
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.
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
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 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.