Senior IT Architect

NYCERS IT Division is seeking a Senior ETL Engineer/Architect to join our IT Data Management unit in the Information Technology division. The Sr. ETL Engineer/Architect will support various enterprise data integration initiatives directly supporting NYCERS’ strategic priorities, including ongoing modernization initiatives, strengthened data governance and improved system resiliency.

Responsibilities

• Translate intricate business requirements into detailed technical specifications, encompassing data access patterns, data streams, integrations, transformations, and robust data modeling and database design
• Design, develop, and implement ETL solutions using IBM DataStage and SSIS
• Design and develop reusable ETL job templates using IBM DataStage
• Provide end-to-end automated ETL solutions using DataStage ETL tool
• Create logical and physical data models using IBM Data Architect
• Provide comprehensive support and input to the NYCERS Data Governance process
• Build data extracts from Salesforce using SOQL, DataStage, and SSIS
• Develop strategy and build processes to maintain data integrity during/post migration from NYCERS legacy to target LRP system
• Build and maintain Control-M workflows for batch processing, dependency management, and SLA compliance
• Design, develop, and support automated data conversion validation process
• Develop automated data standardization process compliant with GDPR rules
• Develop automated data quality process
• Develop strategies for data acquisitions of vendor’s data sources hosted on various platforms
• Fully, clearly, and comprehensively document all key work and activities
• Apply hands-on experience with cloud platforms such as Azure and/or AWS to support cloud adoption and modernization initiatives
• Define technology roadmaps and recommend solutions that strengthen IT capabilities and advance digital transformation
• Administer DataStage installations, patching, load balancing, configuration, and user management as well as parameter and IMAM repository management
• Establish and uphold NYCERS’ integration architecture methodology, principles, standards, and guidelines to ensure security, reuse, and automation
• Collaborate effectively with business stakeholders to ensure that technical solutions align seamlessly with business objectives
• Work in partnership with vendors to design, develop, and implement NYCERS Data Warehouse solution
• Support DataStage server maintenance, administration, and metadata management
• Support end-to-end ETL architecture and automation
• Integrate various sources into NYCERS Data Warehouse
• Actively participate in development, optimization, and performance tuning of ETL and SQL processes
• 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
• Handle defect resolution and problem management

Requirements

• A baccalaureate degree from an accredited college in computer science, information systems, engineering, mathematics, or related field and six years of satisfactory full-time experience related to enterprise architecture, solutions architecture, network architecture, and/or IT infrastructure systems; or
• A baccalaureate degree from an accredited college and ten years of satisfactory full-time experience related to enterprise architecture, solutions architecture, network architecture, and/or IT infrastructure systems; or
• Education and/or experience equivalent to the above.

Skills

• Extensive (20+ years) experience across integration architecture, systems implementation, and enterprise-level technical solutions
• Extensive (20+ years) experience with data warehouses and data marts modeling
• Expert knowledge of DataStage stages (e.g., CFF) as well as partition techniques
• Expertise in Data Lake, Data Vault, and Data Mesh methodologies, and ability to create and maintain data processing solutions
• Experience with Agile Methodology including Scaled Agile Framework (SAFe)
• Strong knowledge of IT infrastructure, cloud computing, AI trends, and modern architectural patterns
• Hands-on experience designing and deploying applications in public cloud environments such as Azure or AWS
• Strong competency in database technologies (SQL Server, Oracle, Snowflake)
• Proven experience in VSAM data conversion to distributed SQL databases
• Minimum 15+ years of hands-on IBM DataStage ETL development, installation, and administration
• Experience with BMC Control-M workload automation
• Experience with GIT version control systems
• Experience in MDM architecture, implementations, and tools such as SEMARCHY, PROFISEE
• Excellent influencing and business-engagement skills
• Demonstrated capability in creating technology roadmaps and future-state architecture recommendations
• Ability to translate complex business needs into scalable, secure, and integrated technical solutions
• Ability to develop advanced complex SQL data validations based on STTMs and target data models
• Working knowledge with Data Governance tools like Collibra and Infosphere Data Governance Catalog
• Experience in end-to-end MDM design and development
• Experience with data profiling and data quality tools
• Experience with DataBricks
• Experience supporting enterprise data governance frameworks
• Experience in large-scale legacy modernization or data migration programs
• Prior experience working in pension administration systems

Pay

$160,000.00 – $165,000.00

New York City residency is not required for this position.