Senior Data Analyst

A NYC agency located in Brooklyn, NY is looking for a Senior Data Analyst for a 12+ month contract.

• Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
• Hands-on MS Access programming (Macros, VBA, etc.).
• Experience creating data dictionary documentation with business terms, valid values, and definitions.
• Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
• Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL.
• Experience extracting field references and calculated data from COBOL programs.

• Experience extracting business rules from the existing legacy code.
• Experience with Data Quality/Profiling tools.
• Experience with Data Warehouses / Data Marts.
• Hands-on Experience with SSRS or SSIS

• The Senior Data Analyst will primarily be responsible for detailed field level analysis, profiling, and mapping of the current IBM Mainframe VSAM files loaded into SQL tables.
• The Senior Data Analyst will create and maintain the master data dictionary and mapping to agency mission critical applications and inventory of its components
• The Senior Data Analyst shall provide agency's' Data Management team with technical expertise for the completion of Data Profiling/Cleansing and Conversion/Migration efforts part of ongoing Legacy Replacement initiative
• The Senior 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 agency's ongoing process improvement programs.
• Participate in identification, inventory, and classification of agency's critical data.
• Work with data SME's to document data quality rules and definitions.
• Extract business rules from the existing Legacy code and create Source-to-Target mappings.
• Transform business and data quality rules into ETL and/or SQL technical specifications.
• Provide technical and analytical support to NYCERS data integrity and quality initiatives.
• Collaborate with 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.
• Defect handling and problem resolution