City Of New York

Senior IT Architect

City Of New York • $125K — $150K *
New York, NY 10025In-Person
Information Technology
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Bachelor's degree in computer science, information systems, engineering, mathematics, or related field with 6+ years of relevant experience.
  • Alternatively, a Bachelor's degree with 10+ years of experience in enterprise or solutions architecture.
  • Deep technical expertise in data architecture, data migration, and data integration.
  • Familiarity with Master Data Management (MDM) and predictive analytics is preferred.
  • Experience using IBM DataStage and SSIS for ETL solutions.

Responsibilities

  • Translate complex business requirements into detailed technical specifications.
  • Design, develop, and implement ETL solutions using IBM DataStage and SSIS.
  • Create reusable ETL job templates using IBM DataStage.
  • Provide end-to-end automation of ETL solutions with DataStage tool.
  • Build data extracts from Salesforce utilizing SOQL, DataStage, and SSIS.

Benefits

  • Opportunities for professional development and career growth.
  • Collaborative work environment supporting IT modernization initiatives.
  • Participation in strategic projects directly affecting enterprise data integration.
  • Support for cloud platform adoption, specifically Azure and AWS.
  • Focus on enhancing data governance and resiliency within the organization.
Full Job Description
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 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. Additional Information

About City Of New York

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.

City of New York Careers

There has never been a better time to explore the diverse job opportunities at the City of New York—the hub of professional growth and innovation in the public sector.

Work You’ll Do

Join the City of New York’s dynamic team to contribute to the community and enhance the city’s services across a broad spectrum of disciplines. The City of New York offers a unique opportunity to engage in meaningful work that impacts the lives of millions while navigating through a career filled with learning and growth. Transform the metropolitan landscape and enrich the lives of its residents with the best minds in public administration, urban planning, and community services. The City of New York stands at the forefront of urban management and innovation. Lead with a unique position in public service, at the intersection of technology, community needs, and sustainable development. Work alongside a diverse team of professionals dedicated to improving city operations and enhancing the quality of urban life. Collaborate with the largest network of public service experts in the nation, fostering leadership, diversity training, and professional development.

Introducing the City of New York Public Service Careers

The team is building a market-leading public service career path to help professionals master their roles and contribute effectively to the city’s development.

Do Innovative Work

Join a vast network of experts—dedicated professionals at the intersection of governance, community service, and urban innovation.

Drive Change in Public Service

Deliver targeted solutions and policies that enhance city living and maintain New York as a leading global city through a depth and breadth of expertise that’s second to none.

Be Part of a Great Team

Engage in a wide range of city projects utilizing cutting-edge technology and strategies, harnessing the unparalleled capabilities, scale, and collaborative spirit of a dedicated public service team.

Future-proof Your Career

Advance your career with limitless opportunities in the public sector, supported by unmatched training, development programs, and certification support.

Explore

From improving city infrastructure to enhancing public safety, the City of New York offers a platform for professionals to apply their skills, innovate, and lead.

The City of New York Public Service Initiative

The combined efforts of various departments help overcome urban challenges and lead transformation in city management. Professionals around the globe look to the City of New York for new strategies and solutions to drive significant change and growth in urban living. ## Stay Connected

Join the Team

Search open positions that match your skills and interests. The City of New York looks for passionate, curious, creative, and solution-driven team players. SEARCH CITY OF NEW YORK JOBS

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who serve here.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover what exciting and rewarding opportunities await in the City of New York.
Learn more about City Of New York
Industry
Education, Government & Non-Profit
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at City Of New York

More Information Technology Jobs

Find similar Senior IT Architect jobs:

NationwideNew York, NY