Previous Job
Lead Data Integration and Mapping
Ref No.: 17-00291
Location: Charlotte, North Carolina
Position Type:Direct Placement
Start Date: 07/06/2017
Data Integration-Data Element / Instrument Mapping
Leader Position – Leader would be responsible for the accurate mapping of instruments and data elements to regulatory reporting line-items through the data warehouse and automated reporting tool.
This position is also responsible for interpretations and judgments made throughout the process along with the documentation, policy vetting, and consistent application of such interpretations and judgement.
In addition, this Leader is responsible for the integration of such interpretations and judgment communication and integration with existing regulatory reporting production.

Components of Role
Data Element Mapping: Identification of relevant data elements and determining alignment to specific regulatory report line items to generate accurate and consistent regulatory reports
Interpretations / Judgments: Formal determination of line-item interpretation, documentation, and consistent application of such interpretations within current reporting and integration within automated report production
Review and Data Approval: Review data mapping done supporting report production and opine as to the appropriateness to use such data in the production of automated regulatory reports.
Strategic Planning: Identification of SOR inconsistencies and data gaps that could impact report capability and working with all team members and report owners to ensure order and priorities are properly aligned
Support of Report Owner responsibilities, as necessary: This includes but is not limited to
  • maintaining line of sight into end to end processes
  • understanding and challenging all reported numbers, as appropriate
  • understanding and coordinating implementation of report instruction changes
  • partnering with support groups (Governance & Oversight, Data Management, Analytics, Change Management, and Technical Interpretations) to improve the control environment
Role Description
This is a new leadership position that will be responsible for reporting transformation efforts within the Enterprise Financial Reporting Change Management team responsible for the development of a system and reporting logic to produce accurate production of significant regulatory reports such as the FRY-9C, all supporting schedules, FR Y-14M, FFIEC 031/041, among many other reports.

Responsibilities may include, but not be limited to the following:
  • Research and make interpretive and judgments in guiding the mapping of instruments and data elements throughout the automated report production project
  • Identify data gaps and assist in the determination of ideal data sourcing protocol
  • Review and approval of data elements throughout the automated report inventory
  • Proactively identify and resolve data issues and reporting gaps by escalating inconsistencies and working to resolve with our report production team
  • Help with miscellaneous projects assigned by manager that require vast subject matter expertise.
  • Partner closely with the Financial Reporting, Data Quality, and Remediation Change Management team within the Financial Reporting group
The successful candidate will be a highly motivated team player and a self-starter who is accustomed to working in complex organizations, partnering with a diverse group of stakeholders, and achieving results. Additionally, the candidate should possess good professional presence and be accustomed to presenting material to senior executives and regulatory agencies. The candidate should be flexible, be able to withstand challenges and adapt accordingly.

Skillsets Needed for Success
  • Deep understanding of financial products (e.g., loans, securities, derivatives, etc.)
  • Indepth knowledge of line-item specific regulatory reporting guidance
  • Ability to document conclusions with well-founded supporting basis for policy decisions
  • Understanding of financial institution systems and general architecture
  • Analytical thinking with focus on anticipation of potential issues
Detail oriented with planning foresight across multiple functions