Senior Data Architect - ETL/DataStage Expert

City of New York; New York (NY); On-site; USD 160,000 - 165,000; Full time

Job summary

City of New York—NYCERS IT Division is seeking a Senior ETL Engineer/Architect to lead enterprise data integration, governance, and modernization initiatives. The role emphasizes DataStage/SSIS development, MDM, data migration, and cloud adoption to strengthen data resiliency.

The candidate will design, implement, and support scalable ETL solutions, data models, and automated data quality processes, while guiding strategic roadmaps and governance across the organization.

Qualifications

• Bachelor degree plus 6+ years in enterprise/data architecture or equivalent.
• Extensive DataStage ETL development and administration experience.
• Strong SQL data validations and data quality skills.

Responsibilities

• Translate business requirements into technical specifications for data integration.
• Design, develop and support enterprise ETL solutions using DataStage/SSIS.
• Build data models, governance processes, and MDM strategies.
• Develop automated data quality and GDPR-compliant standardization processes.
• Administer DataStage installations and oversee integration architecture standards.

Skills

Integration architecture

Data governance

ETL design & development

Data migration

MDM

Cloud platforms (Azure/AWS)

SQL / Data modeling

DataStage/SSIS

Control-M/WLA

GIT version control

Education

Bachelor's degree in computer science, information systems, engineering, mathematics or related field

10+ years enterprise architecture / IT infrastructure experience

Tools

IBM DataStage

IBM Data Architect

SSIS

Control-M

Collibra / Infosphere Data Governance Catalog

Data Bricks

Semarchy / Profisee

Job description

City of New York—NYCERS IT Division is seeking a Senior ETL Engineer/Architect to lead enterprise data integration, governance, and modernization initiatives. The role emphasizes DataStage/SSIS development, MDM, data migration, and cloud adoption to strengthen data resiliency.

The candidate will design, implement, and support scalable ETL solutions, data models, and automated data quality processes, while guiding strategic roadmaps and governance across the organization.