Data Infrastructure Architect

City Of New York • $100K — $130K *

New York, NY 10025In-Person

Education, Government & Non-Profit

Less than 5 years of experience

Today

Be an Early Applicant

By clicking Apply, I agree with Ladders' Terms of Use and Privacy Policy

Job Overview by Ladders

Qualifications

Baccalaureate degree from an accredited college or university.
Associate degree and 2 years of relevant experience in administrative, analytic, or supervisory roles.
Four-year high school diploma or equivalent with 4 years of relevant experience.
Combination of education and experience equivalent to the above qualifications.

Responsibilities

Design data models, database schemas, and enterprise data flow structures.
Support optimization of transactional databases and data warehouses.
Develop frameworks for organizing structured and unstructured data.
Document data architectures and technical standards.
Implement data normalization and validation workflows.
Define standards for data governance, security, and compliance.
Evaluate and recommend data technologies and deployment strategies.

Benefits

Opportunity to design and implement robust data systems.
Engagement in cross-functional collaboration with diverse teams.
Focus on data security and governance compliance.
Access to emerging technologies and best practices in the field.

Full Job Description

Job Description

ABOUT THE ROLE:
The Data Infrastructure Architect will design, implement, and manage MOCJ's data architecture to support secure, scalable, and reliable data access, storage, integration, and analysis. This role will help build and maintain a high-quality data ecosystem by standardizing data structures, improving data flows, supporting data warehousing, and ensuring that agency data assets are secure, consistent, accessible, and usable for analytics, reporting, and decision-making.

Responsibilities include but are not limited to:
Data Architecture and Modeling
-Design conceptual, logical, and physical data models, database schemas, and enterprise data flow structures.
-Support the architecture and optimization of transactional databases, data warehouses, data lakes, and large-scale data systems.
-Develop scalable frameworks for storing, organizing, and accessing structured and unstructured data.
-Document data architectures, system dependencies, data flows, and technical standards.
Data Integration, Standardization, and Quality
-Develop and maintain frameworks for integrating data from internal and external sources.
-Implement data normalization, transformation, and validation workflows using SQL, Python, and other scripting or automation tools.
-Support ETL/ELT processes and data quality controls to ensure reliable, consistent, and analysis-ready datasets.
-Monitor data quality, resolve inconsistencies, and recommend improvements to strengthen the agency's data ecosystem.
Governance, Security, and Compliance
-Define and support standards for data governance, metadata management, master data, access controls, and regulatory compliance.
-Ensure data assets are managed in accordance with applicable privacy, security, and compliance requirements.
-Partner with IT, legal, program, and research teams to support secure and appropriate use of agency data.
-Recommend tools, processes, and controls to strengthen data security, access management, and data integrity.
Technical Strategy and Implementation
-Evaluate and recommend database platforms, storage solutions, cloud services, and data technologies that support agency needs.
-Plan and support deployments, migrations, and modernization of data systems.
-Monitor query performance, pipeline efficiency, system scalability, and data storage practices.
-Optimize ETL pipelines, normalization scripts, data structures, and automated data processes.
Cross-Functional Coordination
-Work with internal and external data engineers, analysts, IT staff, program teams, and agency leadership to translate business needs into technical solutions.
-Provide guidance on data modeling, normalization, governance, and system design.
-Manage data infrastructure projects, timelines, resources, risks, and deliverables.
-Stay current on emerging technologies and best practices in data architecture, automation, cloud data platforms, and data quality management.

**PLEASE INCLUDE YOUR RESUME AND COVER LETTER SPECIFIC TO THIS POSITON.

RESEARCH PROJECTS COOR(MA)-MGR - 0527A

Qualifications

1. Do you have a baccalaureate degree from an accredited college or university?

2. Do you have an associate degree from an accredited college or university along with two (2) years of experience with administrative, analytic, coordinative, supervisory or liaison responsibilities?

3. Do you have a four-year high school diploma, or its educational equivalent approved by a state's Department of Education or a recognized accrediting organization along with four (4) years of experience as described in question "2" above?

4. Do you have a satisfactory combination of education and/or experience equivalent to that described in questions "1," "2," and/or "3" 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