Data Architect

Data Architect position with NYCDOE
Brooklyn, NY. Hybrid position.
Candidate must be in NY/NJ/CT/PA area and willing to relocate for this hybrid position or be within commuting distance.
Rate: competitive
No H1B, CPT
Client / Project
NYC Department of Education
The New York City Public Schools is the largest school system in the United States, with over 1.1 million students taught in more than 1,800 separate schools. They have over 80,000 employees and hundreds of thousands of vendors that interact with NYC DOE on a yearly basis.
Project Overview

• Develop a Next Generation Student Information System (NGSIS) to modernize DOE's legacy student information systems and data applications.
• Build a single online interface that presents school users and parents with biographical, academic, and programmatic data for students.
• Consolidate all data workflows in the systems that currently hold student information.
• Establish new workflows to help school administrators and teachers manage student record-keeping and other school-based academic tasks.
• Decommission legacy systems as functions are successfully deployed within the new environment
• Maintain the highest standards for data security when information accessed through the browser and when information is stored to the database.
• Provide a configurable system that allows authorized users to update important aspects of the implemented solution i.e. manage lookups, workflow, rules, role-based access levels, etc.

Role and Responsibilities:

• Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security as well as customer-defined deliverables
• Collaborate with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities, and strategize development and implementation timelines
• Develop architectural strategies for data modeling, design and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
• Create and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
• Support database administrators, network designers and IT personnel to create effective and secure methods for data backup and recovery
• Review existing Data Architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing underperforming areas and present these plans to managers and executives
• Research new technologies, data modeling methods and information management systems to determine which ones should be incorporated into company Data Architectures, and develop implementation timelines and milestones
• Oversee for the creation and quality of the following deliverables:
  • Data Mapping
  • Data Dictionary
  • Data Migration
  • Data Security
  • Technical Documentation
  • System Design Document
• Attend Client meetings as needed

Skill Sets:
Required

• 12+ years' experience as an Data Architect
• Knowledge and skills surrounding .NET platform
• Experience with SQL and Oracle
• Minimum of 10 years of technical experience data networking, storage, data management, and data migration.
• Ability to effectively partner with cyber security management to ensure the application of best practices to all designs and solutions.
• Demonstrated ability to communicate and present at technical and management levels
• Bachelor of Science degree in Computer Science, Management Information Systems, Business Administration, Engineering, or related discipline.

Nice to Have

• New York city area (NYC, New Jersey, Conn)
• Government experience (Federal, state, city)
• Education experience building applications for higher ed or department of education