Job title: Senior Data Analyst
Location: Brooklyn, NY
Rate: $60/hr on W2
Type: Contract
The Senior Data Analyst will join the agency’s Data Management team to support data profiling, cleansing, conversion, migration, and validation activities for an enterprise-wide Legacy Replacement initiative. This role will also contribute to ongoing process improvement efforts focused on data integrity, data quality, and modernization of legacy data environments.
The Senior Data Analyst will be responsible for detailed field-level analysis, metadata analysis, data profiling, and source-to-target mapping of VSAM files into relational and dimensional SQL tables. This position will work across mixed mainframe and relational database environments and support conversion and validation efforts involving pension administration systems.
This role requires strong experience with mainframe data structures, IBM DataStage ETL, COBOL, CICS, DB2, SQL Server, SSRS, Control-M, Git, and complex SQL validation. The ideal candidate will have the ability to extract business rules from legacy code, document data definitions, identify data quality gaps, and collaborate with technical leads and subject matter experts to support successful legacy system replacement.
Process Improvement & Collaboration
- Contribute to ongoing process improvement programs related to data management, quality, profiling, conversion, and validation.
- Recommend solutions based on analyzed requirements and team methodology.
- Collaborate with data SMEs, technical leads, application teams, and IT partners to support legacy replacement objectives.
- Identify opportunities to improve data quality, streamline validation activities, and strengthen repeatable data management processes.
Required Qualifications
- Minimum of five (5) years of source-to-target data mapping experience in mixed mainframe and relational database environments.
- Experience creating data dictionary documentation with business terms, valid values, and definitions.
- Experience converting and migrating VSAM data to relational and 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.
- Strong SQL knowledge, including experience working with complex queries and stored procedures.
- Proficiency in SSRS report development.
- Strong analytical skills with the ability to receive and analyze requirements and propose suitable solutions aligned with team methodology.
- Ability to work across IBM Mainframe, Windows Server, and SQL Server environments.
- Proficiency with mainframe applications, including COBOL, CICS, and DB2.
- Understanding of data structures and their relationship to ETL applications.
- Ability to develop complex SQL data validations based on source-to-target mappings and target data models.
- Excellent analytical, problem-solving, information-gathering, and troubleshooting skills.
- Experience supporting data profiling, cleansing, conversion, migration, and validation efforts.
- Ability to collaborate effectively with data subject matter experts, technical leads, and IT partners.
- Ability to support defect handling and problem resolution.