Senior Data Analyst

Senior Data Analyst with IBM DataStage ETL Expertise Client is seeking a Senior Data Analyst with ETL Expertise to join its Data Management team within the Information Technology (IT) Division. This role is central to NYCERS' Legacy Replacement Program, a large-scale, enterprise-wide initiative to modernize mission-critical pension administration systems currently running on mainframe/VSAM architecture. The successful candidate will provide hands-on technical expertise across the full data lifecycle — profiling, cleansing, conversion, migration, and validation — as legacy VSAM data is transformed into modern relational/dimensional SQL structures. This is a high-visibility role supporting both the Legacy Replacement effort and NYCERS' broader, ongoing process improvement programs. What You'll Do Perform detailed field-level and metadata analysis of legacy VSAM files to support conversion into relational/dimensional SQL tables Conduct data profiling and source-to-target mapping across mixed Mainframe and Relational Database environments Build and maintain the organization's master data dictionary, including business terms, valid values, and definitions Support database design for NYCERS' mission-critical applications and maintain a component inventory Extract field references and calculated/derived data from COBOL programs to inform mapping and validation logic Develop and execute ETL pipelines using IBM DataStage to move and transform data between legacy and target systems Design and run complex SQL data validations based on Source-to-Target Mapping documents (STTMs) and target data models Collaborate with the Data Management team on process improvement initiatives beyond the core migration effort Develop reporting deliverables using SSRS Required Qualifications (Mandatory) Minimum 5 years of source-to-target data mapping experience spanning mixed Mainframe and Relational Database environments Experience creating data dictionary documentation (business terms, valid values, definitions) Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases Minimum 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 Minimum 3 years of recent experience with Pension Administration systems Required Technical Ability Strong SQL skills, including complex queries and stored procedures Proficiency in SSRS report development Strong analytical skills — able to interpret requirements and propose solutions aligned with team methodology Ability to work across multiple environments: IBM Mainframe, Windows Server, and SQL Server Proficiency in mainframe technologies: COBOL, CICS, and DB2 Solid understanding of data structures and their relationship to ETL processes Ability to build complex SQL-based data validations from STTMs and target data models Excellent analytical, problem-solving, and information-gathering skills, plus fundamental technical troubleshooting ability Desirable Qualifications Experience extracting business rules from existing legacy code Experience with Data Quality / Data Profiling tools Experience with Data Warehouses / Data Marts Experience with SQL Server Reporting Services (SSRS) Prior experience in a pension system environment — New York State or New York City pension systems preferred Work Location & Schedule This is a hybrid position; onsite presence is required at: 335 Adam Street, Suite 2300, Brooklyn, NY 11201 Submission Requirements Minimum of 3 professional references required at time of submission Candidate must clearly demonstrate alignment with all mandatory skills/experience listed above; submissions lacking evidence of mandatory qualifications may not be considered RIT Solutions