Senior Data Analyst with ETL Expertise

Senior Data Analyst with IBM DataStage ETL ExpertiseSenior Data Analyst with ETL Expertise — Location: Hybrid — Onsite required at 335 Adam Street, Suite 2300, Brooklyn, NY 11201 Engagement Type: Contract (IT Division placement) Openings: 1 References Required: Minimum of three (3) professional references, submitted with the candidate's applicationAbout the RoleSenior 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 DoPerform detailed field-level and metadata analysis of legacy VSAM files to support conversion into relational/dimensional SQL tablesConduct data profiling and source-to-target mapping across mixed Mainframe and Relational Database environmentsBuild and maintain the organization's master data dictionary, including business terms, valid values, and definitionsSupport database design for NYCERS' mission-critical applications and maintain a component inventoryExtract field references and calculated/derived data from COBOL programs to inform mapping and validation logicDevelop and execute ETL pipelines using IBM DataStage to move and transform data between legacy and target systemsDesign and run complex SQL data validations based on Source-to-Target Mapping documents (STTMs) and target data modelsCollaborate with the Data Management team on process improvement initiatives beyond the core migration effortDevelop reporting deliverables using SSRSRequired Qualifications (Mandatory)Minimum 5 years of source-to-target data mapping experience spanning mixed Mainframe and Relational Database environmentsExperience creating data dictionary documentation (business terms, valid values, definitions)Experience converting/migrating VSAM data to relational/dimensional SQL distributed databasesMinimum 3 years of recent experience developing applications using IBM DataStage ETLExperience extracting field references and calculated data from COBOL programsExperience with BMC Control-M workload automation softwareExperience with GIT version controlMinimum 3 years of recent experience with Pension Administration systemsRequired Technical AbilityStrong SQL skills, including complex queries and stored proceduresProficiency in SSRS report developmentStrong analytical skills — able to interpret requirements and propose solutions aligned with team methodologyAbility to work across multiple environments: IBM Mainframe, Windows Server, and SQL ServerProficiency in mainframe technologies: COBOL, CICS, and DB2Solid understanding of data structures and their relationship to ETL processesAbility to build complex SQL-based data validations from STTMs and target data modelsExcellent analytical, problem-solving, and information-gathering skills, plus fundamental technical troubleshooting abilityDesirable QualificationsExperience extracting business rules from existing legacy codeExperience with Data Quality / Data Profiling toolsExperience with Data Warehouses / Data MartsExperience with SQL Server Reporting Services (SSRS)