Data Infrastructure Architect

ABOUT THE OFFICE
The Mayors Office of Criminal Justice (MOCJ) advises the Mayor of the City of New York on criminal justice policy. MOCJ develops and implements strategies with partners inside and outside government to reduce crime and incarceration and to promote fairness and legitimacy. MOCJ works with law enforcement city agencies non-profits foundations and others to implement data-driven strategies that address current crime conditions prevent offending and build strong neighborhoods that ensure enduring safety

ABOUT THE ROLE:
The Data Infrastructure Architect will design implement and manage MOCJs 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 agencys 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 states 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 :

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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Full-time