Role: Senior Data Analyst - Exp with Pension Administration systems

Role: Senior Data Analyst - Exp with Pension Administration systems & (3 official references) Mandatory
Location: 335 Adams Street, Brooklyn, NY 11201. Hybrid schedule combining in -office and remote workday
Duration: 1+ Year Contract with likely Extension

Scheduled Work Hours: Monday through Friday, 40 hours per week. 8:00 AM - 4:45 PM EST

Mandatory Skills/Experience
 
• Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
• 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 with BMC Control-M workload automation software.
• Experience with GIT version control software.
• Minimum of three (3) years of recent experience with Pension Administration systems.

ROLE

The Senior Data Analyst shall provide NYCERS’ Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts part Legacy Replacement initiative 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.
• Actively participate in optimization and performance tuning of existing ETL and SQL processes.
• Extract business rules from the existing Legacy code and create Source-to-Target mappings.
• Transform business rules and data quality rules into ETL and/or SQL technical specifications.
• Develop complex SQL data validations based on STTMs and target Data Models.
• 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.
• Experience extracting business rules from the existing legacy code.
• Experience with Data Quality/Profiling tools.
• Experience with Data Warehouses/Data Marts.
• Experience with SQL Server Reporting Services (SSRS).

Special Requirements
Background check and employment verification required.
Three (3) references are required for each candidate.
This is a hybrid position. 
In accordance with NYCERS' hybrid work policy, the candidate must be able to work three (3) days per week in NYCERS' Brooklyn office and two (2) days per week remotely. 
This schedule is subject to change.

Thanks
Kushal Lade