A data management associate is required to assist with the coordination and ongoing support of data collection and consolidation within JRI-A.
The data management associate will be working within a small team of dedicated data management specialists collecting and coordinating data across SMBC's US Subsidiaries, specifically:
o Defining Data Integration Specifications
o Planning and coordinating data collection activities with one or more business units
o Acting as the Single Point Of Contact (SPOC) for one or more business units
o Preparing test scenarios and test cases for the data
o Acting as a coordinator for any day to day production issues with the data
o Liaising with the SMBC business in New York and New Jersey to ensure that their data needs are satisfied by the business unit
The data management associate will work with the Chief Data Office and other business stakeholders to elicit and analyze data requirements.
The associate will be part of the JRI-A team that is building IT capabilities to support the Enhanced Prudential Standards and the formation of a Bank Holding Company.
The data management associate is expected to carry out the following duties
· Meet with business stakeholders and other technical team members to gather and analyze application data requirements.
· Assist with the design and build data interface solutions to satisfy application (business and technical) requirements.
. Perform data analysis where requirements may need to be derived from available documentation, interviews with users, and file specifications/samples.
. Understand and facilitate team understanding of data flow across business applications and interfaces
. Assist with the definition, documentation, maintenance, implementation and compliance of data business definitions, standards, quality rules and methods
· Perform data analysis activities including data profiling, creation of data dictionaries, data transformation rules and integration requirements.
In addition experience in the following would be a plus
. Data Management and Data Governance for Enhanced Prudential Standards
. Data Management and Data Governance within a Bank Holding Company or an Intermediate Holding Company
. Collaboration with business and IT partners to refine and document system requirements.
· Coordination across organizations as required to support data integration efforts
· Thorough knowledge of the Software Development Life Cycle.
20% - Perform Data Analysis
20% - Implement and maintain data interface designs
20% - Create and maintain technical and business metadata
20% - Co-ordinate subsidiaries and JRI-A data development
20% - Assist with day to day operation of Subsidiary data transfer and integration
20% Data Governance & Strategy
20% Metadata Management
20% Data Analysis
20% Data Interface Specification
10% Data Mapping
10% Communication with management, development teams, vendors and systems administrators
2-6+ years of experience in data analysis and / or data management; experience in the securities or financial services industry is a plus
Data Management Design working with the following technology:
o Microsoft Excel
o Oracle SQL
o Oracle Database
Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required
Other Skills, Abilities and/or Training:
Reference Data Management
Master Data Management
Skills and Special Requirements (heavy lifting, excessive overtime, etc.)
Occasionally expected to work evenings and weekends in support of production or project related requirements.