The New York City Employees’ Retirement System (NYCERS) is seeking an experienced Senior Data Engineer to join our IT Data Management unit in the Information Technology division. The Senior Data Engineer will design, develop, and maintain enterprise systems and data architectures supporting NYCERS pension administration system as part of ongoing Legacy Modernization and Replacement initiative. The Data Engineer will operationalize business rules, metadata, and data quality requirements into scalable ETL applications using IBM DataStage, orchestrated via Control-M, and supported by advanced SQL engineering. The Senior Data Engineer will also assist in database design of NYCERS mission critical applications and inventory of its components.
In this capacity, Data Engineer will:
- Design and implement end-to-end ETL pipelines using IBM DataStage for legacy and modern data sources.
- Develop and maintain source-to-target mappings (STTM) and translate them into DataStage jobs and SQL transformations.
- Write and optimize advanced SQL queries, stored procedures, and data validation frameworks.
- Build and maintain Control-M workflows for batch processing, dependency management, and SLA compliance.
- Perform data profiling, metadata analysis, and field-level mapping to support data migration and integration.
- Create and maintain enterprise data dictionary, including business definitions, valid values, and lineage.
- Participate in data inventory, classification, and governance initiatives for NYCERS critical data assets.
- Collaborate with SMEs and technical teams to identify and remediate data quality gaps and inconsistencies.
- Support NYCERS Reporting platform, FOILs and Office of Actuary valuations requirements.
- Troubleshoot and resolve data defects, ETL failures, and performance issues.
Key deliverables:
- Participate in identification, inventory, and classification of NYCERS critical data.
- Perform data analysis and document data quality rules and definitions.
- Actively participate in development, optimization and performance tuning of 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 solutions.
- Develop complex SQL data validations based on STTMs and target Data Models.
- Support NYCERS Data Warehouse development and implementation.
- Defect handling and problem resolution.
Mandatory Skills and Experience:
- Minimum 5+ years of source-to-target data mapping in mixed mainframe and distributed environments.
- Proven experience in VSAM data conversion to relational/dimensional SQL databases.
- Minimum 3+ years of hands-on IBM DataStage ETL development.
- Experience extracting field references and calculated data from COBOL programs.
- Experience with BMC Control-M workload automation.
- Experience with GIT version control systems.
- Experience creating and maintaining data dictionaries and metadata repositories.
- Strong analytical skills for data profiling, mapping, and transformation logic design.
- Ability to develop advanced complex SQL data validations based on STTMs and target Data Models.
- Deep understanding of data structures and their relationship to ETL applications.
- Excellent analytical and problem solving skills along with fundamental technique troubleshooting abilities.
- Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
- ETL architecture and data lifecycle management in mixed environments (IBM Mainframe, Windows Server, SQL Server).
IT INFRASTRUCTURE ENGINEER - 95714
1. A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,
2. A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,
3. Education and/or experience which is equivalent to "1" or "2" above.
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
The City of New York is the most iconic and dynamic city on the planet. With a population of more than 8.4 million people, New York is not only the largest city in the United States — it is the academic, cultural, commercial, and financial capital of the world.
City government is filled with opportunities for talented individuals seeking to improve their communities and make a meaningful difference in the lives of their fellow New Yorkers. Every day, the City’s more than 300,000 employees improve infrastructure, provide vital social services, build technology, protect health and safety, and so much more. Join us today at: http://www1.nyc.gov/jobs
The City of New York offers its employees:
• A chance to build the future of this city. New York City government is at the crossroads of where policy, great ideas, city services, and smart urban planning meet the lives and needs of every day New Yorkers.
• Competitive salary and benefits. Hiring packages include a competitive salary, health benefits, various pension plans, employee assistance programs, and individual retirement accounts.
• Diverse career opportunities. As the largest local government in the United States with more than 40 agencies, the City of New York offers a broad spectrum of opportunities — from education, housing development, and public health to sustainability, economic growth, technology, and emergency management.
• Career Satisfaction. As a City employee, you will have the chance to shape the future of New York City and improve the quality of life for your family, neighbors, and fellow New Yorkers.
• Equal Opportunity and Inclusion. The City of New York is an equal opportunity employer that prohibits discriminatory action against City employees and applicants for employment based on their actual or perceived race, color, national origin, ethnicity alienage, citizenship status, gender, religion, creed and all other protected categories.
