Subscribe:   RSS  RSS   Mail Alerts  Mail Alerts  

Data Steward Analyst - Credit

Job Category:
Financial Services
Career Level:
Mid Career (2+ years of experience)
Job Type:
Full Time/Permanent
Company Name:
City National
Los Angeles
Description: Job ID BIS-7146CityLos AngelesStateCaliforniaExempt/Non ExemptExemptShiftDayWork ScheduleM-F, 8-5

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


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


*Minimum 2 years of financial reporting experience, preferably in regulatory reporting or data management environment required
*Minimum 2 years working in a data analysis role required
*Minimum 2 years of Microsoft Excel experience required (with knowledge of vlook-up, iferrors, pivot tables, macros)

Skills and Knowledge

~Bachelor 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

*Represents the basic qualifications for the position. To be considered for this position you must at least meet the basic qualifications.

City National Bank is an Equal Opportunity Employer -- Minorities/Females/Individuals with Disabilities/Veterans.

Note: 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.

Note: Candidates should be advised that City National Bank does not pay interviewee travel expenses or relocation expenses for candidates who are hired unless previously agreed.


Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled