SSUSA Job #815: Reference Data Manager
Job Description
REFERENCE DATA MANAGER
One of our banking clients is looking to create this role and roll out Reference Data Management processes and procedures. This job will be primarily responsible for controlling the acquisition, management and disbursement of Reference Data. This will include working with various business groups to identify reference data, its owners and stewards, where appropriate standardizing reference data and its mappings, creating quality rules about the reference data, identifying golden sources of the reference data, working with our market data personnel to identify data and reference data coming into the organization, and ensuring the reference data is properly loaded and maintained in various systems. We are a small group so you will also be required to assist in other areas of the Data Governance program, including communication, training, and data quality analysis. Candidate will be required to take on a lot of detailed analysis of data, to determine how data is being used and determining the correct reference data that should be standardized.
Responsibilities:
Position requires a results and driven data manager to work and partner with subject matter experts to elicit detailed reference data requirements and support all phases of development and validation, testing and documentation. Candidate should be able to analyze reference data, work with subject matter experts and identify any inconsistencies in order to continuously improve upon the data quality and fit for use standards established by the Enterprise Data Governance program which supports the Americas division.
Role includes:
Analyzing data - researching and documenting reference data elements (terms) used in current or new reports and any transformational activities as the data migrates and is further processed, transformed through SQL, ETL and ultimately reported (end to end) in order to implement data quality integrity checks and validations. Analyzing data and anomalies in order to recommend data quality validation checks.
Work with the data owners to support reference data quality initiatives and become an expert in our reference data in order to determine appropriateness of use and improve data quality. Eliciting and preparing documentation for data quality rule requirements and packaging for development through the normal software development life-cycle (SDLC) and any testing activities.
Working with our Market Data Manager to understand and manage what data comes into the organization and how it is being used.
Supporting our Data Quality Group to ensure correct reference data is available to be used in data quality rules.
Work with IT and the Enterprise Data Steward to load reference data into our data dictionary and the correct technical asset areas.
Summary of responsibilities includes:
- Analyzing reference data or new requirements for reports or data migration and consolidation efforts to centralized data warehouse.
- Application of reference data in data quality domain
- Manage reference data, data quality and maintenance with data owners
- Work with data quality manager to promoting data quality best practices, training and checks and validations with data owners
- Highly proactive in monitoring issues and exceptions with data owners and subject matter experts
- Support all facets of production ready reference data quality rules, exceptions, issue management and reporting.
- Focus and support all aspects of reference data quality issue management and improvement, exception handling and alerting process
- Lead Process Design of Reference data process
- Produce and distribute daily/weekly team status reports or scorecards as well as contribute to project status reporting depending on the undertaking at and assist with any management reporting
- Determine best way to control and manage reference data
- Lead product selection of Reference Data Management Tool (if determined as necessary)
- Work with end users on determining what is reference data
- Work with end users to define and manage reference data mappings and transformations
- Work with Enterprise Data Steward to properly load and manage reference data
- Participate/Lead Data Governance Communications
- Review and update Data Governance Policies and Procedures
Qualifications:
Data Detective - willing to roll up sleeves and dive into data as it is used, has dependencies upon reference data lists and ultimately transforms to front end reports for business consumption or ages in data mart.
- Business Analyst - Documenting data quality requirements, test plans and comprehensive SDLC
- Creates documentation including business requirements (BRD), determines impact assessments, functional specifications, flow charts, Root cause analysis and other diagnostic documentation
- Identify risk in process and propose / implement controls.
- Able to work as Individual contributor role or manage projects/task forces consisting of employees from multiple different areas
- Quick Learner
- Team player - able to fill in gaps, learn about data governance program, policies and tenants
- Able to work with large data in excel and suggest process enhancement ideas for some of the stakeholders working in Excel at the business unit level.
- Presenting data in PowerPoint.
- Excel (advanced if possible), MS Office Applications and Visio, (SQL or knowledge of advanced formulas & pivot tables in excel would be very positive), Toad or other SQL querying ability a +.
SEND YOUR RESUME TO JOBS@SSUSA.COM AND MENTION JOB 815 IN THE SUBJECT BOX
Job Location
New York City/White Plains, NY
Position Type
Permanent
Salary Range
TBD