Data Infrastructure Architect

About The Office The Mayor’s 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 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 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. Minimum Qualifications Baccalaureate degree from an accredited college or university. Associate degree from an accredited college or university plus two (2) years of experience with administrative, analytic, coordinative, supervisory or liaison responsibilities. Four‑year high school diploma or equivalent approved by a state Department of Education or a recognized accrediting organization plus four (4) years of experience as described in the previous item. A satisfying combination of education and/or experience equivalent to the above descriptions. Preferred Skills Strong experience with SQL, NoSQL, Python, R, or other scripting languages. Experience with ETL/ELT processes and data modeling tools such as ERwin, ER/Studio, or similar platforms. Experience with data integration and transformation tools such as Azure Data Factory, Informatica, Talend, Alteryx, or comparable tools. Familiarity with Snowflake, Redshift, BigQuery, Synapse, distributed storage, data lakes, and large‑scale data ecosystems. Strong understanding of data governance, metadata management, access controls, data quality, and normalization practices. Ability to translate business requirements into technical data solutions. Strong analytical, problem‑solving, documentation, and project management skills. Ability to communicate complex data concepts clearly to technical and non‑technical stakeholders. 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 Residency Requirement New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for two continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview. 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. #J-18808-Ljbffr City of New York