Data Architect

Ariel Partners

Data Architect for NYC DOE managing data integration and architecture for Special Education systems. Leading data analysis, mapping, and reporting initiatives to enhance operational effectiveness.

Posted 7/5/2026contractBrooklyn • New York • 🇺🇸 United StatesSeniorLead💰 $85 - $100 per hourWebsite

Tech Stack

Tools & technologies

MS SQL ServerSDLCSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or a related technical discipline (Master's 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.

Benefits

Comp & perks

🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account Ariel Partners Website LinkedIn All Job Openings 11 - 50 employees Founded 2000 🏛️ Government 🤖 Artificial Intelligence 🤝 B2B Government
Artificial Intelligence
B2B Ariel Partners is a technology services and product firm that helps public sector agencies and enterprises modernize mission-critical systems using Mission Critical Agile, AI, and DevSecOps practices. The company offers cloud modernization, application services, data and AI/ML solutions, managed IT operations, test automation, governance tools, and products such as Seatbelt for Jira, and holds multiple federal contract vehicles serving federal, state & local, and commercial clients. Data Architect Job not on LinkedIn 🔥 1 minute ago 🏢🏡 Brooklyn – Hybrid 💵 $85 - $100 / hour ⏳ Contract/Temporary 🟠 Senior 🔴 Lead 🚰 Data Engineer MS SQL Server SDLC SQL Apply Now Find Hiring Managers Customize resume + cover letter Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 Description
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. 🎯 Requirements
Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or a related technical discipline (Master's 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. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Find jobs using your resume Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data MappingData MigrationData ValidationT-SQLStored ProceduresDatabase DesignTest PlansTest ScriptsData AnalysisData Quality Analysis

Soft Skills

Analytical SkillsProblem-Solving SkillsWritten CommunicationVerbal CommunicationCollaboration