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. This role will be responsible for designing, developing, implementing, and supporting enterprise-wide ETL solutions that enable reliable and scalable data integrations across the enterprise. The ideal candidate will possess deep technical expertise in data architecture, data migration, data integration, Master Data Management (MDM), and predictive analytics. In this capacity, the Senior ETL Architect/Engineer will: Key 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 that 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 Key deliverables: - 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 - DataStage Server Maintenance, Administration, Metadata Management - Support End-to-End ETL Architecture and Automation - Integrate various sources into NYCERS Datawarehouse - 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 - Defect handling and problem resolution SENIOR IT ARCHITECT - 95711

Minimum Qualifications

1. 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 2. 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 3. Education and/or experience which is equivalent to "1" or "2" above.

Preferred Skills

Mandatory Skills: - Extensive (20+ years) experience across integration architecture, systems implementation, and enterprise-level technical solution - 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 - critical for modern enterprise architecture roles - 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 Preferred Experience: - 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

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City Residency is not required for this position

Additional Information

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.