Data Architect

Washington County public Schools; Hagerstown (MD); Hybrid; USD 85,000 - 136,000; Full time

Job summary

Washington County Public Schools is seeking a Data Architect to lead enterprise database architecture, data modeling, and integration across district systems. You will drive ETL processes, rostering, and reporting, ensuring privacy and security per policy.

The role demands expert SQL, BI tooling, and SDLC knowledge, with collaboration across stakeholders and vendors. Hybrid schedule with standard district benefits.

Qualifications

• Four-year degree in IT, CS, math, stats, or related field, or equivalent work experience.
• Five years of database maintenance and development in MSSQL/Oracle or similar.
• Five years ETL development and maintenance experience.
• Proficiency with Visual Studio, SSIS, SSRS, and SSMS.
• BI experience for visualization, development, and implementation.
• Strong understanding of relational and dimensional database concepts and SDLC.
• Excellent communication and teamwork skills.
• Ability to work extended hours, including evenings and weekends.

Responsibilities

• Serve as the district's senior technical resource for enterprise database architecture and data management.
• Lead data integration, ETL processes, automated rostering, and reporting solutions.
• Collaborate with stakeholders to implement data integrations with privacy and security controls.
• Set technical standards, architecture patterns, and documentation.
• Provide design guidance, mentoring, and knowledge transfer to staff.
• Lead technical design reviews for complex projects and ensure security and performance.
• Develop and maintain enterprise databases, schemas, and data models with HA.
• Translate requirements into secure data integrations via ETL, APIs, and vendor interfaces.
• Monitor, reconcile, and address data integration issues and operational risks.

Skills

Advanced SQL

SSIS

SSRS

BI tools

Data modeling

PowerShell

C#

JavaScript

CSS

Azure DevOps

GitHub

SQL Server

Education

Four-year degree in IT/CS/Math/Stats or related field

Tools

Visual Studio

SQL Server Management Studio

SSIS

SSRS

Azure DevOps

GitHub

Job description

Position Type:
Administrators and Supervisors

Date Posted:
10/21/2026

Location:
Center for Education Services

Closing Date:
10/31/2026

Education: Four (4) year degree from an accredited university or college in Information Technology, Computer Science, Mathematics, Statistics, or a related field, or equivalent work experience.

Database Experience: Five (5) years of progressive, hands-on experience in maintaining and developing database environments in a Microsoft SQL Server (MSSQL, Oracle, or comparable environment.

ETL Experience: Five (5) years of progressive experience developing and maintaining ETL processes.

Technical Proficiency: Proficiency with Visual Studio, SQL Server Management Studio, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).

Business Intelligence: Experience working in business intelligence (BI), utilizing BI tools for visualization, development, and implementation.

Core Knowledge: Expert-level understanding of relational database concepts, dimensional database concepts, and database architecture and design; in-depth knowledge of the software development life cycle.

Analysis & Problem Solving: In-depth experience gathering and analyzing system requirements from end users and vendors, alongside the ability to think critically to solve complex technical concepts.

Soft Skills: Excellent communication, customer service, and teamwork skills.

Work Expectations: Ability to work extended workdays, including evenings and weekends, as necessary, and the ability to perform the essential functions of the job with or without reasonable accommodation.

Advanced SQL skills

Advanced level proficiency in database and data management with data modeling, design, development, troubleshooting, and optimization skills.

Experience with cloud and on-premises database environments, including database-as-a-service offerings.

Experience implementing automated rostering, account provisioning, APIs, secure file exchanges, and vendor integrations.

Proficiency with scripting and programming languages, including PowerShell, C#, JavaScript, and CSS.

Experience with version control systems and development platforms such as Azure DevOps (TFS) or GitHub.

Experience with Agile or other structured development methodologies.

Experience working in a K-12, college, or university setting.

Familiarity with WCPS policies, goals, programs, and enterprise applications.

Demonstrated interpersonal skills to clearly express ideas, build consensus, influence technical decisions, and engage stakeholders.

Serve as the district's senior technical resource for enterprise database architecture, data modeling, data integration, ETL processes, automated rostering, reporting, analytics, and related data-management technologies.

Collaborate with stakeholders to evaluate, implement, and support district-approved digital tools, ensuring appropriate data integration, interoperability, privacy, security, and compliance with established district standards and approval processes.

Establish and maintain technical standards, architecture patterns, development practices, and documentation requirements to ensure secure, reliable, scalable, and maintainable enterprise data solutions.

Provide technical leadership, design guidance, mentoring, and knowledge transfer to developers, administrators, analysts, and support personnel without exercising formal supervisory authority.

Lead technical design reviews and provide architectural direction for complex, high-impact, and cross-functional projects, evaluating solutions for security, performance, interoperability, reliability, and long-term sustainability.

Design, develop, administer, and maintain enterprise databases, schemas, data models, database objects, and associated infrastructure, including performance optimization, capacity planning, backup, recovery, and high availability.

Translate business and technical requirements into secure, reliable data integrations, including ETL workflows, APIs, secure file exchanges, automated rostering, identity provisioning, and vendor interfaces.

Establish and maintain monitoring, alerting, reconciliation, and exception-handling processes to identify integration failures, data discrepancies, performance issues, and operational risks.

Plan and execute complex data migrations, conversions, and system transitions, including data mapping, validation, testing, reconciliation, and post-implementation verification.

Collaborate with data owners and stakeholders to establish and maintain data governance, quality, integrity, classification, ownership, retention, access, and lineage practices consistent with district policies and applicable legal requirements.e

Implement and maintain database and integration security controls, including least-privilege access, secure authentication, encryption, audit logging, and periodic access reviews, in accordance with district policies, contractual obligations, and applicable privacy requirements, including FERPA.

Ensure database and integration solutions follow established change-management, testing, version-control, documentation, and recovery practices to support operational continuity and minimize disruption.

Serve as the senior technical escalation resource for complex database, integration, reporting, security, performance, and data-quality issues; conduct root-cause analysis and recommend corrective actions.

Collaborate with internal stakeholders and vendors to evaluate technical requirements, validate solution designs and deliverables, and support accurate reporting, analytics, and organizational decision‑making.

Partner with the Manager of Enterprise Applications to assess technical risks, conduct periodic reviews of data integrity and compliance with technical standards, identify modernization opportunities, and recommend priorities for the enterprise applications
and data architecture roadmap.

Perform other duties as assigned.

This position is eligible for a hybrid (remote / office) work schedule subject to supervisor approval and acceptance of the WCPS Telework SOP - Agreement.

Required prolonged periods sitting at a desk and working on a computer and other office equipment.

Must have the use of sensory skills in order to effectively communicate and interact with individuals as normally defined by the ability to see, read, talk, hear.

Maintain emotional control under stress.

Ability to work prolonged and irregular hours.

Data Architect

Category 4 on the Administrator & Supervisor Pay Scale, 12-month work year

Salary Range: $84,900 - $135,727

Benefits Summary

Role Overview

The Data Architect serves as an individual contributor and technical lead for WCPS enterprise data environments. The position provides technical leadership for the architecture, design, integration, security, reliability, and ongoing operation of enterprise databases, Extract, Transform, Load (ETL), automated rostering, reporting solutions, and data-quality practices. The role works collaboratively with stakeholders, vendors, developers, and other technology staff to establish technical standards, lead complex projects, mentor team members, and ensure systems deliver value to stakeholders.

Minimum Requirements

• Education: Four (4) year degree from an accredited university or college in Information Technology, Computer Science, Mathematics, Statistics, or a related field, or equivalent work experience.
• Database Experience: Five (5) years of progressive, hands-on experience in maintaining and developing database environments in a Microsoft SQL Server (MSSQL, Oracle, or comparable environment.
• ETL Experience: Five (5) years of progressive experience developing and maintaining ETL processes.
• Technical Proficiency: Proficiency with Visual Studio, SQL Server Management Studio, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Business Intelligence: Experience working in business intelligence (BI), utilizing BI tools for visualization, development, and implementation.
• Core Knowledge: Expert-level understanding of relational database concepts, dimensional database concepts, and database architecture and design; in-depth knowledge of the software development life cycle.
• Analysis & Problem Solving: In-depth experience gathering and analyzing system requirements from end users and vendors, alongside the ability to think critically to solve complex technical concepts.
• Soft Skills: Excellent communication, customer service, and teamwork skills.
• Work Expectations: Ability to work extended workdays, including evenings and weekends, as necessary, and the ability to perform the essential functions of the job with or without reasonable accommodation.

Preferred Qualifications

• Advanced SQL skills
• Advanced level proficiency in database and data management with data modeling, design, development, troubleshooting, and optimization skills.
• Experience with cloud and on-premises database environments, including database-as-a-service offerings.
• Experience implementing automated rostering, account provisioning, APIs, secure file exchanges, and vendor integrations.
• Proficiency with scripting and programming languages, including PowerShell, C#, JavaScript, and CSS.
• Experience with version control systems and development platforms such as Azure DevOps (TFS) or GitHub.
• Experience with Agile or other structured development methodologies.
• Experience working in a K-12, college, or university setting.
• Familiarity with WCPS policies, goals, programs, and enterprise applications.
• Demonstrated interpersonal skills to clearly express ideas, build consensus, influence technical decisions, and engage stakeholders.

Role Responsibilities

• Serve as the district's senior technical resource for enterprise database architecture, data modeling, data integration, ETL processes, automated rostering, reporting, analytics, and related data-management technologies.
• Collaborate with stakeholders to evaluate, implement, and support district-approved digital tools, ensuring appropriate data integration, interoperability, privacy, security, and compliance with established district standards and approval processes.
• Establish and maintain technical standards, architecture patterns, development practices, and documentation requirements to ensure secure, reliable, scalable, and maintainable enterprise data solutions.
• Provide technical leadership, design guidance, mentoring, and knowledge transfer to developers, administrators, analysts, and support personnel without exercising formal supervisory authority.
• Lead technical design reviews and provide architectural direction for complex, high-impact, and cross-functional projects, evaluating solutions for security, performance, interoperability, reliability, and long-term sustainability.
• Design, develop, administer, and maintain enterprise databases, schemas, data models, database objects, and associated infrastructure, including performance optimization, capacity planning, backup, recovery, and high availability.
• Translate business and technical requirements into secure, reliable data integrations, including ETL workflows, APIs, secure file exchanges, automated rostering, identity provisioning, and vendor interfaces.
• Establish and maintain monitoring, alerting, reconciliation, and exception-handling processes to identify integration failures, data discrepancies, performance issues, and operational risks.
• Plan and execute complex data migrations, conversions, and system transitions, including data mapping, validation, testing, reconciliation, and post-implementation verification.
• Collaborate with data owners and stakeholders to establish and maintain data governance, quality, integrity, classification, ownership, retention, access, and lineage practices consistent with district policies and applicable legal requirements.e
• Implement and maintain database and integration security controls, including least-privilege access, secure authentication, encryption, audit logging, and periodic access reviews, in accordance with district policies, contractual obligations, and applicable privacy requirements, including FERPA.
• Ensure database and integration solutions follow established change-management, testing, version-control, documentation, and recovery practices to support operational continuity and minimize disruption.
• Serve as the senior technical escalation resource for complex database, integration, reporting, security, performance, and data-quality issues; conduct root-cause analysis and recommend corrective actions.
• Collaborate with internal stakeholders and vendors to evaluate technical requirements, validate solution designs and deliverables, and support accurate reporting, analytics, and organizational decision‑making.
• Partner with the Manager of Enterprise Applications to assess technical risks, conduct periodic reviews of data integrity and compliance with technical standards, identify modernization opportunities, and recommend priorities for the enterprise applications
  and data architecture roadmap.
• Perform other duties as assigned.

Additional Notes

• This position is eligible for a hybrid (remote / office) work schedule subject to supervisor approval and acceptance of the WCPS Telework SOP - Agreement.

Environmental Factors and Physical/Mental Requirements

The Environmental Factors and Physical/Mental demands represent those that must be met by an employee to successfully perform the essential functions of this job.? Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Required prolonged periods sitting at a desk and working on a computer and other office equipment.
• Must have the use of sensory skills in order to effectively communicate and interact with individuals as normally defined by the ability to see, read, talk, hear.
• Maintain emotional control