Jump to main content.

The Official Careers Website of the City of New York

Search

Data Architect

  1. DEPARTMENT OF FINANCE
Posted on: 12/05/2024
  1. Full-time

Location

MANHATTAN

  1. Exam may be required

Department

Web App & Dta Wrhs Dev & Supt

$145,000.00 – $158,217.00

Job Description

This vacancy has now expired.

IMPORTANT NOTE: CANDIDATES WITH A PERMANENT CERTIFIED IT ADMINISTRATOR (DATABASE) OR COMPARABLE CIVIL SERVICE TITLE WITH SIMILAR DUTIES/RESPONSIBILITES ARE ENCOURAGED TO APPLY. PLEASE INCLUDE YOUR EMPLOYEE IDENTIFICATION NUMBER (EIN) WHEN APPLYING AND INDICATE IN YOUR COVER LETTER YOUR PERMANENT CIVIL SERVICE TITLE.

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.

The Finance Information Technology (FIT) Division designs, builds, and supports all facets of DOF’s computer systems, including hardware, software, applications, infrastructure, telephone, and data security. FIT delivers and administers tax-related payment programs for the City of New York by providing the information technology solutions needed to achieve its mission of collecting revenue while ensuring an efficient and improved customer experience. FIT is also responsible for the systems and websites which enable citywide payments, land records, property assessment, parking adjudications, customer service, and the Sheriff’s public safety work.

FIT is seeking a highly experienced IT professional to serve as Data Architect. This enterprise role will report directly to the Chief Technical Officer and be responsible for designing, creating, and managing the organization's data architecture. This role is critical in establishing a solid foundation for data management within an organization, ensuring that data is organized, accessible, secure, and aligned with business objectives. The data architect designs warehouses, file systems and databases, and defines how data will be collected and organized. The successful candidate also will recommend the most modern, secure platforms and tools appropriate to DOF's information, which includes sensitive Federal Tax Information (FTI) data.

Responsibilities include but are not limited to the following:

- Interprets and delivers impactful strategic plans improving data integration, data quality, and data delivery in support of business initiatives and roadmaps.
- Designs the structure and layout of data systems, including databases, warehouses, and lakes.
- Selects and implements database management systems that meet the organization's needs by defining data schemas, optimizing data storage, and establishing data access controls and security measures.
- Defines and implements the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms.
- Translates high-level business requirements into data models and appropriate metadata, test data, and data quality standards.
- Manages senior business stakeholders to secure strong engagement and ensures that the delivery of the project aligns with longer-term strategic roadmaps.
- Works with IT teams, business analysts, and data analytics teams to understand data consumers' needs and develop solutions.
- Simplifies the existing data architecture, delivering reusable services and cost-saving opportunities in line with the policies and standards of the company.
- Leads and participates in the peer review and quality assurance of project architectural artifacts across the EA group through governance forums.
- Defines and manages standards, guidelines, and processes to ensure data quality.
- Evaluates and recommends emerging technologies for data management, storage, and analytics.
- Establishes and manages data governance frameworks to ensure data security, quality, and compliance.
- Lead data migration efforts from legacy systems to modern cloud platforms and define a cloud strategy.
- Build data architecture that supports advanced analytics and prepares data for future integration with GenAI models.

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.

In compliance with Federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

Location:
59 Maiden Lane, New York, NY
(Current location but could be subject to change)


Minimum Qualifications

Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;

2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR

3. A satisfactory equivalent of education and/or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.


Preferred Skills

- A bachelor's degree in computer science, data science, engineering, or related field. - At least five years of relevant experience in design and implementation of data models for enterprise data warehouse initiatives. - Experience leading projects involving data warehousing, data modeling, and data analysis. - Design experience in Azure Databricks, PySpark, and Power BI/Tableau. - Strong ability in programming languages such as Java, Python, and C/C++. - Ability in data science languages/tools such as SQL, R, SAS, etc. - Proficiency in the design and implementation of modern data architectures and concepts such as cloud platforms (AWS, Azure, GCP) and hybrid cloud strategies, real-time data distribution (Kafka, Dataflow), and modern data warehouse tools (Snowflake, Databricks). - Experience with cloud-native data architecture and data migration methodologies. - Experience with database technologies such as SQL, NoSQL, Oracle, Hadoop, or Teradata. - Understanding of entity-relationship modeling, metadata systems, and data quality tools and techniques. - Ability to think strategically and relate architectural decisions and recommendations to business needs and client culture. - Ability to assess traditional and modern data architecture components based on business needs. - Ability to learn and adopt new technology, especially in the ML/AI realm. - Strong analytical and problem-solving skills. - Ability to synthesize and clearly communicate large volumes of complex information to non-technical senior management and staff. - Ability to collaborate and excel in complex, cross-functional teams involving data scientists, business analysts, and stakeholders. - Ability to guide solution design and architecture to meet business needs. - Experience working with cyber security to secure FTI data is a strong plus. - Knowledge of data governance frameworks and familiarity with compliance standards. - Understanding of data requirements for generative AI models, as well as the ability to design data pipelines to support AI/ML and gen AI models.
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.

Job ID

689246

Title code

13644

Civil service title

CERT IT ADMINISTRATOR (DB)

Title classification

Competitive-1

Business title

Data Architect

Posted until

2025-01-04

  1. Experienced (non-manager)

Job level

04

Number of positions

1

Work location

59 Maiden Lane

  1. Technology, Data & Innovation

Data Architect

Search