Data Architect at Ariel Partners | NY, US | Rezi

Data Architect at Ariel Partners

Data Architect

Ariel Partners · NY, US

1 months ago

Data Architect

Ariel Partners · NY, US

2 months ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The NYC DOE seeks a contractor to provide project management, business analysis, application support, testing, training, data management, business intelligence, and reporting services for its Special Education systems. This role supports the implementation and enhancement of the ATLAS platform, modernization of Special Education applications, development of regulatory and operational reports, maintenance of data repositories, user training, and continuous operational support. The contractor will provide a team of experts to ensure successful delivery of system enhancements, data integration, reporting solutions, quality assurance, and end-user support while maintaining compliance with Special Education requirements.

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.

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

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

Experience Level

  • 7 years of experience

Education Level

  • Bachelor's degree
  • Master's degree preferred

About the Company

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

Equal Opportunity

  • Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.