Previous Job
Previous
Data Analysts
Ref No.: 17-01521
Location: Brooklyn, New York
Client: New York City Employees' Retirement System ("NYCERS”)
Work Location: Brooklyn, NY
Duration: 12 Months (+12 months extension)
Interview: face to face
Required: 2 Candidates
 


Job Description:
Responsibility:
The Data Analyst shall provide NYCERS' Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing effort as well as NYCERS' ongoing process improvement programs. The following deliverables shall apply:
  • Participate in identification, inventory, and classification of NYCERS critical data
  • Work with data SME's to document data quality rules and definitions
  • Transform business rules into technical specifications to cleanse the data prior to the migration
  • Provide technical and analytical support to NYCERS data integrity and quality initiatives
  • Collaborate with data SME's and technical leads in identifying and addressing data quality gaps
  • Work with IT partners to remediate identified gaps using both manual and automated solutions
  • Support processes that proactively detect, correct, and prevent invalid data values.
 
Mandatory Skills:
  • Must have excellent interpersonal, communication, presentation, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.
  • Ability to facilitate sessions and one-on-one meetings with developers and managers, meet deadlines, and work well under pressure.
  • Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe, relational database and object storage environment.
  • Experience creating data dictionary documentation and data definitions/domains.
  • Experience mapping/converting VSAM data to SQL databases and object relational databases.
  • Experience extracting field references and calculated data from COBOL programs.
  • Understanding of data structures and their relationship to applications.
  • Ability to work in multiple development environments or systems: IBM Mainframe, Windows Server and SQL Server.
  • Experience extracting field references from C# and Java application code..
 
Preferred Experience:
  • Experience with legacy and unstructured data.
  • Experience with ETL and Data Quality/Profiling tools. Working knowledge of UDB or DB2 LUW is a plus
  • Experience extracting business rules from the existing legacy code.
  • Experience creating automated inventory of mainframe components.
  • Experience with MS Visual Studio and .NET.
 
Note:
Need to fill Skill Matrix
2 References Required

Mandatory Qualifications
Skills and Experience Provide Dates and Company Name where the you have demonstrated the qualification or identify how you meets the requirement
Must have excellent interpersonal, communication, presentation, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities.  
Ability to facilitate sessions and one-on-one meetings with developers and managers, meet deadlines, and work well under pressure.  
Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe, relational database and object storage environment.  
Experience creating data dictionary documentation and data definitions/domains.  
Experience mapping/converting VSAM data to SQL databases and object relational databases.  
Experience extracting field references and calculated data from COBOL programs.  
Understanding of data structures and their relationship to applications.  
Ability to work in multiple development environments or systems: IBM Mainframe, Windows Server and SQL Server.  
Experience extracting field references from C# and Java application code.  

 






















Preferred Experience
Skills and Experience Provide Dates and Company Name where the you have demonstrated the skill
Experience with legacy and unstructured data.  
Experience with ETL and Data Quality/Profiling tools.  
Experience extracting business rules from the existing legacy code.  
Experience creating automated inventory of mainframe components.  
Experience with MS Visual Studio and .NET.  
 
Reference 1
Company Name  
Company Address  
Reference Name & Title  
Reference Phone Number  
Reference Email  
Brief description of the project the resource completed.  
 
Reference 2
Company Name  
Company Address  
Reference Name & Title  
Reference Phone Number  
Reference Email  
Brief description of the project the resource completed.