Senior Data Architect

Department of Building; New York (NY); Hybrid; USD 150,000 - 190,000; Full time

Benefits offered by this job

Remote work up to 2 days/week

Job summary

The Department of Buildings Information Technology team is seeking a Senior Data Architect to design, govern, and optimize the agency’s data ecosystem across Azure, Snowflake, Oracle, and on‑premise platforms in New York City.

You will lead data modeling, ETL/ELT development, and data governance initiatives while collaborating with stakeholders to translate business needs into scalable data solutions. Remote work up to 2 days per week is available under the program.

Qualifications

• Master's degree in computer science or equivalent plus 3+ years managerial IT experience.

Responsibilities

• Design and maintain enterprise data architecture across cloud and on-premise platforms.
• Develop and optimize data models to support applications, analytics, and operational systems.
• Lead ETL/ELT development using SSIS, Snowflake, Informatica, and Azure Synapse.
• Establish data lineage, metadata standards, and governance practices for data quality and compliance.
• Architect and optimize data storage, processing, and integration across multiple platforms.
• Design and support API-based integrations ensuring secure data exchange.
• Collaborate with stakeholders to translate data requirements into technical designs.
• Evaluate new technologies to enhance the data ecosystem and support business needs.
• Partner with security teams to ensure data protection and compliance.
• Provide technical leadership to data engineers and analysts.
• Create complex Queries, Functions, Views and Stored Procedures.

Skills

Business requirements translation

Strong communication

Data architecture leadership

Data governance

Education

Master's degree in computer science

Bachelor's degree in a related field

4+ years in IT/data architecture (alternative pathways)

Tools

Azure Dataverse

Azure Synapse Analytics

Snowflake Data Cloud

Oracle Analytics Cloud

Oracle DBMS

Microsoft SQL Server/SSIS

MuleSoft

Erwin

Power BI

Job description

Department of Buildings Information Technology is responsible for the data processing functions and operations of systems that provide operational, analytical, and managerial support functions, as well as IT resource management for the agency. DOB IT develops and maintains application software for such systems. Working closely with owner/client bureaus within the agency, IT develops and implements both custom and packaged applications, and maintains the requisite technical infrastructure, using in-house project resources and hired consultants. We encourage innovation, creativity, and a think outside of the box attitude when solving complex problems and implementing new solutions.

The Department is in the process of the development, conversion, and modernization of the agency's numerous legacy systems. The successful candidate will serve as a Senior Data Architect who will support the Information Technology team in DOB’s pursuit of its consolidation of the new technology initiatives for the agency’s mission critical systems. The Data Architect is responsible for designing, governing, and optimizing the organization’s data ecosystem across cloud and on-premise platforms. This role ensures that data is structured, integrated, and accessible to support applications, analytics, operational reporting, and strategic decision-making. The ideal candidate combines deep technical expertise with strong communication skills to translate business needs into scalable data solutions.

Responsibilities include, but are not limited to:

• 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.

Business & Communication Skills:

• Ability to translate business requirements into scalable data solutions and architectural designs.
• Strong communication skills to collaborate with technical and nontechnical stakeholders.
• Experience supporting analytics, reporting, and data‑driven decision‑making across an organization.

Technical Expertise:

• Strong hands‑on experience with: Azure Dataverse, Azure Synapse Analytics, Snowflake Data Cloud, Oracle Analytics Cloud, Oracle DBMS, Microsoft SQL Server/SSIS, MuleSoft, Erwin, Power BI.
• Proficiency in data modeling, including dimensional, relational, and domain‑driven design approaches.
• Deep understanding of data lineage, metadata management, and enterprise data governance.
• Expertise in ETL/ELT development with Microsoft SSIS & Informatica.
• Experience designing and managing APIs using MuleSoft.
• Strong understanding of cloud and on‑premise architectures, hybrid data environments, and integration patterns.

ONLY CANDIDATES WITH AT LEAST 5 YEARS OF EXPERIENCE IN DATA ARCHITECTURE WILL BE CONSIDERED.

CIVIL SERVICE STATUS

Only permanent Computer Systems Managers, applicants who are reachable on the Computer Systems Manager open competitive list, and applicants as indicated below will be considered.

Candidates who are permanent in comparable civil service titles may be considered for title change under rule 6.1.9 of the Personnel Rules and Regulations of the City of New York.

REMOTE WORK

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program.

COMPUTER SYSTEMS MANAGER - 1005D

Minimum Qualifications

1. A master's degree in computer science from an accredited college or university and three (3) years of progressively more responsible, full‑time, satisfactory experience in Information Technology (IT) including applications development, systems development, data communications and networking, database administration, data processing, or user services. At least eighteen (18) months of this experience must have been in an administrative, managerial or executive capacity in the areas of applications development, systems development, data communications and networking, database administration, data processing or in the supervision of staff performing these duties; or

2. A baccalaureate degree from an accredited college or university and four (4) years of progressively more responsible, full‑time, satisfactory experience as described in "1" above; or

3. A four‑year high school diploma or its educational equivalent, and six (6) years of progressively more responsible, full‑time, satisfactory experience as described in "1" above; or

4. A satisfactory combination of education and experience equivalent to "1", "2" or "3" above. However, all candidates must have at least a four‑year high school diploma or its educational equivalent and must possess at least three (3) years of experience as described in "1" above, including the eighteen (18) months of administrative, managerial, executive or supervisory experience as described in "1" above.

In the absence of a baccalaureate degree, undergraduate credits may be substituted for a maximum of two (2) years of the required experience in IT on the basis of 30 semester credits for six (6) months of the required experience. Graduate credits in computer science may be substituted for a maximum of one (1) year of the required experience in IT on the basis of 30 graduate semester credits in computer science for one (1) year of the required IT experience. However, undergraduate and/or graduate credits may not be substituted for the eighteen (18) months of experience in an administrative, managerial, executive, or supervisory capacity as described in "1" above.

55a Program

This position is also open to qualified persons with a disability who are eligible for the 55‑a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55‑a Program.

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 https://studentaid.gov/pslf/.

Residency Requirement

New York City Residency is not required for this position

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.