Senior Data Architect

City of New York
New York, NY
Job Description
The Department of Buildings Information Technology is seeking a Senior Data Architect to support the development, conversion, and modernization of the agency's legacy systems. The ideal candidate will combine deep technical expertise with strong communication skills to translate business needs into scalable data solutions.

Requirements

  • Design and maintain enterprise data architecture spanning Azure, Oracle Analytics, Snowflake, and Oracle/SQL Server on-premise systems.
  • Develop and optimize data models (conceptual, logical, and physical) to support applications, analytics, operational systems, and integration needs.
  • Lead the design and implementation of ETL/ELT pipelines using Microsoft SSIS, Snowflake, Informatica, Azure Synapse, and other integration tools.
  • Establish and maintain data lineage, metadata standards, and data governance practices to ensure data quality, consistency, and compliance.
  • Architect, performance optimize and manage data storage, processing, and integration across Azure Dataverse, Azure Synapse, Oracle Database, Microsoft SQL Server, and Snowflake.
  • Design and support API-based integrations, ensuring secure and scalable data exchange across systems.
  • Collaborate with application solutions architects and business stakeholders to understand data requirements and translate them into technical specifications and architectural designs in support of the enterprise data architecture.
  • Evaluate new technologies, tools, and platforms to enhance the data ecosystem and support evolving business needs.
  • Partner with security teams to ensure data protection, privacy, and compliance across all environments.
  • Provide technical leadership and guidance to data engineers, analysts, and cross-functional teams.
  • Create complex Queries, Functions, Views and Stored Procedures.

Benefits

  • Generous Paid Time Off
  • 401k Matching
  • Retirement Plan
  • Relocation Assistance
]]>