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.

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.

Data Architect

Key skills