Senior Data Engineer
Core
Design, develop, and maintain enterprise ETL applications and data architectures supporting NYCERS pension administration and legacy modernization.
Role type
Senior Data Engineer (ETL & Data Architecture)
Builds
Scalable ETL pipelines, data validation frameworks, and enterprise data dictionaries for pension administration systems.
Domain
Public sector pension administration, legacy mainframe modernization
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
IBM DataStage, advanced SQL, Control-M workflow automation, VSAM to relational conversion, COBOL field extraction, data profiling, metadata management, data dictionary creation, data quality remediation, mixed environment engineering (Mainframe/Windows/SQL Server)
Preferred skills
GIT version control, data governance, data lineage tracking
Technologies
IBM DataStage, Control-M, SQL Server, IBM Mainframe, VSAM, COBOL, GIT
Responsibilities
Design and implement end-to-end ETL pipelines; Develop and maintain source-to-target mappings (STTM); Write and optimize advanced SQL queries and stored procedures; Build and maintain Control-M workflows for batch processing; Perform data profiling and metadata analysis; Create and maintain enterprise data dictionary; Troubleshoot and resolve data defects and ETL failures
Seniority
Senior, hands-on IC