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.