Enter a job title or keyword
Data Architect
Job Location:
Job Location:
New York City, NY - USA
Monthly Salary:
Not provided by the employer
Monthly Salary:
Posted:
18 July 2026 (30+ days ago)
Posted:
Application Deadline:
15 October 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
The New York City Department of Education (NYC DOE) seeks a qualified contractor to provide comprehensive project management business analysis application support testing training data management business intelligence and reporting services for its Special Education systems. The project supports the implementation and ongoing enhancement of the ATLAS platform modernization of Special Education applications development of regulatory and operational reports maintenance of enterprise data repositories user training and continuous operational support. The Contractor will provide a multidisciplinary team of technical and functional experts to ensure the successful delivery of system enhancements data integration reporting solutions quality assurance and end-user support while maintaining compliance with federal state and NYC DOE Special Education requirements.
The Data Architect is responsible for designing analyzing and optimizing enterprise data structures and integration solutions supporting the NYC Department of Educations Special Education systems. This role leads data mapping and integration efforts across multiple applications analyzes complex data to improve system performance supports testing and validation activities and develops technical documentation to ensure accurate reliable and compliant reporting.
RESPONSIBILITIES
REQUIRED SKILLS & QUALIFICATIONS
PREFERRED QUALIFICATIONS
Required Technical Skills
The Data Architect is responsible for designing analyzing and optimizing enterprise data structures and integration solutions supporting the NYC Department of Educations Special Education systems. This role leads data mapping and integration efforts across multiple applications analyzes complex data to improve system performance supports testing and validation activities and develops technical documentation to ensure accurate reliable and compliant reporting.
RESPONSIBILITIES
- Perform complex analysis of data generated by Special Education applications to identify trends inconsistencies and opportunities for system improvements.
- Lead data mapping and integration efforts between ATLAS SESIS COMPASS SEO MART and other enterprise data sources.
- Design and maintain conceptual logical and physical data models to support operational and regulatory reporting.
- Analyze data quality issues and recommend corrective actions to improve system effectiveness.
- Utilize data analysis results to prioritize software defects enhancements and business requirements.
- Develop automated and manual test cases to validate system functionality data integrity and user requirements.
- Support system integration user acceptance testing (UAT) and data validation activities.
- Develop and maintain technical documentation data dictionaries mapping documents process flows and system documentation.
- Create workflow diagrams data flow diagrams and process documentation using Microsoft Visio.
- Collaborate with business analysts developers testers database administrators and DOE stakeholders to ensure successful implementation of system enhancements.
- Support Business Intelligence and reporting initiatives through data architecture and reporting design.
- Ensure compliance with DOE data governance standards security policies and SDLC best practices.
REQUIRED SKILLS & QUALIFICATIONS
- Bachelors degree in Computer Science Information Systems Data Management Engineering or a related technical discipline (Masters degree preferred).
- Minimum of 7 years of experience in data architecture data modeling database design or enterprise data integration.
- Experience designing enterprise data models and data integration solutions for large-scale applications.
- Strong expertise in Microsoft SQL Server T-SQL stored procedures and database design.
- Experience performing data mapping data migration and data validation activities.
- Experience supporting software development lifecycle (SDLC) Agile and Waterfall methodologies.
- Experience developing test plans test scripts and validating application functionality.
- Strong analytical and problem-solving skills with the ability to analyze complex business and technical requirements.
- Excellent written and verbal communication skills with experience preparing technical and functional documentation.
- Experience working collaboratively with cross-functional technical and business teams.
PREFERRED QUALIFICATIONS
- Experience supporting K-12 education government or public-sector information systems.
- Experience with Special Education applications student information systems or regulatory reporting.
- Experience with Power BI or other Business Intelligence reporting platforms.
- Knowledge of data governance metadata management and enterprise reporting environments.
Required Technical Skills
- Microsoft SQL Server Microsoft SQL (T-SQL)
- Microsoft Visio Microsoft Project
- Power BI Jira
- Application Lifecycle Management (ALM) tools
- Data Modeling Data Mapping
- ETL Concepts Database Design
- System Integration Data Analysis
- Test Planning and Validation
- Technical Documentation
If you are interested in getting more information about this opportunity please contact Irina Rozenbergat your earliest convenience.
At Ariel Partners we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions so when they have their biggest challenges we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers our people and our partners; Courage to take on difficult challenges accept new ideas and accept incremental failure; and the constant pursuit of Excellence.
Ariel Partners is an Equal Opportunity Employer in accordance with federal state and local laws.
At Ariel Partners we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions so when they have their biggest challenges we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers our people and our partners; Courage to take on difficult challenges accept new ideas and accept incremental failure; and the constant pursuit of Excellence.
Ariel Partners is an Equal Opportunity Employer in accordance with federal state and local laws.
Required Experience:
Staff IC
About Company
Ariel Partners is an IT software consulting firm with experience executing some of the largest and most difficult technology projects.
