Frederick County Public Schools
Data Integration Specialist, Special Education
Frederick County Public Schools - Frederick, Maryland, United States, 21701
Work at Frederick County Public Schools
Overview
- View job
Overview
Position Type:
Technology/Data Specialist
Date Posted: 8/5/2025
Location: Central Office- 191 South East St.
Date Available: ASAP
Closing Date: Open Until Filled
Work Year Calendar and Hours 12-month position (260 days / year), 8 hours per day For more information about employee benefits please go to: https://www.fcps.org/staff/benefits
Salary
Support Salary Grade S20:
$47.98 per hour; starting
Under the Fair Labor and Standards Act this position is
exempt
from overtime. Actual salary placement will be in accordance with the salary procedures of the Frederick County Public School System. Please see linked salary scale for the full range.
Overview
The Data Integration Specialist has the primarily responsibility for Frederick County Public Schools' (FCPS) Special Education and Student Services data. Key responsibilities include, but are not limited to, the following: (1) Designing, implementing, and managing data systems and dashboards which are used in conjunction with third party vendors and internally created to support student learning; (2) supporting new/existing student data reporting systems, ad hoc data extracts, and overall data integrity; (3) participating in FCPS' data governance program; and (4) performing other duties consistent with the scope and nature of the position.
The position is responsible for all data management and application development, as needed. This position provides comprehensive data management and fulfills local, state, and federal reporting requirements relating to student information. The specialist collaborates with other departments within FCPS, state and federal agencies, and third party software vendors. This position participates in the design, development, enhancement, and maintenance of the Special Education and Student Services data warehouse and comprehensive reporting.
Essential Functions
Reporting directly to the Special Education Director, the Data Integration Specialist performs, as a minimum, the following duties:
Technical
Designs, develops, tests, debugs, deploys, and maintains a centralized student data-centric system integration framework used with third party vendors and internal FCPS systems. Designs, develops, tests, debugs, deploys, and maintains processes relating to the extraction/transformation/loading of data between FCPS' data systems/applications. Provides data integrity/quality support, including the implementation of systems and standard operating procedures, to ensure the accuracy and validity of student data. Assists the Student Information Systems team and the Reporting Specialist with the development and maintenance of student data reports and dashboards. Participates in the planning of new software releases/versions and testing of software prior to implementation.
Communication and Collaboration
Creates, maintains, and publishes system/process documentation, including user requirements, technical specifications, data process/flows, and system program/user guides, in conjunction with other System Accountability and School Improvement team members and in accordance with established standards and procedures. Collaborates with Technology Infrastructure and other FCPS departments including, but not limited to, Curriculum, Student Services, Special Education, Transportation, Food Services, and Media Services to define integration processes, data mapping, and other aspects of the integration process. Collaborates with Technology Infrastructure on data exchange and data security methods to facilitate integrations. Serves as a liaison with product leads and data owners to troubleshoot integrations that may not be functioning properly and/or may require modifications to meet functional/application changes. Assists other department staff with special projects including, but not limited to, developing necessary database structures to support Strategic Plan Reporting tools and integrating data from disparate systems. Collaborates and communicates with the Maryland State Department of Education and other local leaders/agencies to ensure accurate data reporting.
Student Data Systems and Reporting Services
Local, state, and federal reporting to include serving as point of contact for FCPS, collaboration with departments within FCPS, review and interpret report/data specifications, performing data extraction tasks, and addressing other reporting requirements. Evaluate operations and activities of assigned programs; recommend improvements and modification of programs. Perform data extraction from and data uploads to the Student Information Systems and loads of data from third party software systems where integration is not automated. Perform database administration functions such as performance, tuning, backup/recovery, and general database administration. Provide quality assurance; implementing systems and standard operating procedures to ensure the accuracy and validity of student data. Assist other staff on special projects, as directed. Continually review FCPS student data systems to ensure that the organization achieves and maintains a high level of data integrity in accordance with requirements defined by the Student Records section of the Code of Maryland Regulations (COMAR). Participate in the processes used to compile and correct student accountability data files submitted to the Maryland State Department of Education. Remain compliant with all local, state, and federal mandates relating to student confidentiality (FERPA) and the use/maintenance of electronic records. Attend workshops and training opportunities to develop and maintain skills pursuant to the duties of this position. Ability to deliver on objectives/goals of the division in a given time frame with available resources.
Other Duties Performs other duties as assigned.
Required Qualifications
Education/Training/Experience
Bachelor's degree in Information Technology (IT) or a minimum of five (5) years of experience in information technology, computer science, or related field. Three (3) years of Structured Query Language (SQL) experience, including writing stored procedures, functions, and complex queries with a large database structure. Two (2) years of experience with building and maintaining data integration processes, preferably Microsoft SQL Server Integration Services (SSIS). Experience in data reporting/visualization, preferably with Tableau and/or SQL Server Reporting Services (SSRS).
Knowledge/Skills/Abilities
Knowledge and use of culturally responsive practices. Ability to work with advanced functions of Microsoft Excel and a variety of relational databases. Knowledge of Data Warehousing, including relational data modeling (Star Schema) and Extract/Transform/Load (ETL) processing. Familiarity of data analysis, database design technologies and tools, excellent analytical ability, judgment and problem analysis techniques. Data extraction and report development experience, preferably Microsoft SSIS and SSRS. Demonstrated strong oral, written, and interpersonal communication skills. Excellent analytical ability, judgment, and problem analysis techniques. Management and organizational skills which demonstrate an ability to prioritize, work under time constraints, and demonstrate flexibility in an environment of multiple tasks and shifting priorities. Ability to handle confidential and highly sensitive information in a professional manner. Ability to build trust and maintain relationships. Advanced oral and written communications and human relations skills. Regular and predictable attendance. Capable of performing the essential functions of the position with or without reasonable accommodations.
Physical Requirements
Ability to work a flexible schedule, including evenings and weekends, as needed. Ability to speak in an understandable voice with sufficient volume to be heard in normal conversation and on the telephone and in addressing groups. Ability to travel to school and other local locations, as well as state meetings, sometimes with little notice. Ability to maintain emotional control under stress. Ability to spend long hours sitting. Ability to reach with hands and arms. Sufficient manual dexterity to grasp, handle, manipulate, and/or feel objects and use office technology. Sufficient mobility to move about the work area. Sufficient vision to read and comprehend printed materials, see distant objects with clarity, and identify and distinguish objects. Sufficient hearing to hear and comprehend conversations in person and on the telephone, as well as distinguish sounds up to twenty (20) feet. Occasionally climb or balance. Occasionally stoop, kneel, crouch, or crawl. Occasionally lift fifteen (15) pounds.
Work Environment
Moderate noise (examples: office environment with computers, printers, and telephones; regular conversations within offices, cubicles, hallways, and conference rooms; meetings one-on-one, in small groups, and large settings, etc.).
Preferred Qualifications
Education/Training/Experience:
Experience with data management in Special Education and Pre-K-12 education environments. Experience working with Application Programming Interface (API) integrations or programming experience (Java, Python, C#, etc.) Experience in data management in K-12 education environment. Proven application development experience, preferably in an object-oriented programming language (ASP.Net or Java). Knowledge of Data Warehousing including relational data modeling (Star Schema) as well as ETL processing. Knowledge of SharePoint and how it's used for collaboration and report publishing Proficiency with all FCPS Student Information System software. Familiarity with Maryland Student Records Manual and related student record management. Familiarity with state & federal educational reporting requirements. Familiarity with the FCPS policies, goals and programs.
FREDERICK COUNTY PUBLIC SCHOOLS IS AN EQUAL OPPORTUNITY EMPLOYER
THIS JOB DESCRIPTION HAS BEEN WRITTEN TO INDICATE THE GENERAL NATURE AND LEVEL OF WORK PERFORMED BY AN EMPLOYEE HOLDING THIS POSITION. IT IS NOT WRITTEN TO INCLUDE OR BE INTERPRETED TO INCLUDE A COMPREHENSIVE INVENTORY OF ALL DUTIES, RESPONSIBILITIES, AND QUALIFICATIONS REQUIRED OF THE EMPLOYEE. NOTHING IN THIS DESCRIPTION RESTRICTS MANAGEMENT'S RIGHT TO ASSIGN OR REASSIGN DUTIES AND RESPONSIBILITIES OR ADD REQUIRED QUALIFICATIONS AT ANY TIME.
Date Posted: 8/5/2025
Location: Central Office- 191 South East St.
Date Available: ASAP
Closing Date: Open Until Filled
Work Year Calendar and Hours 12-month position (260 days / year), 8 hours per day For more information about employee benefits please go to: https://www.fcps.org/staff/benefits
Salary
Support Salary Grade S20:
$47.98 per hour; starting
Under the Fair Labor and Standards Act this position is
exempt
from overtime. Actual salary placement will be in accordance with the salary procedures of the Frederick County Public School System. Please see linked salary scale for the full range.
Overview
The Data Integration Specialist has the primarily responsibility for Frederick County Public Schools' (FCPS) Special Education and Student Services data. Key responsibilities include, but are not limited to, the following: (1) Designing, implementing, and managing data systems and dashboards which are used in conjunction with third party vendors and internally created to support student learning; (2) supporting new/existing student data reporting systems, ad hoc data extracts, and overall data integrity; (3) participating in FCPS' data governance program; and (4) performing other duties consistent with the scope and nature of the position.
The position is responsible for all data management and application development, as needed. This position provides comprehensive data management and fulfills local, state, and federal reporting requirements relating to student information. The specialist collaborates with other departments within FCPS, state and federal agencies, and third party software vendors. This position participates in the design, development, enhancement, and maintenance of the Special Education and Student Services data warehouse and comprehensive reporting.
Essential Functions
Reporting directly to the Special Education Director, the Data Integration Specialist performs, as a minimum, the following duties:
Technical
Designs, develops, tests, debugs, deploys, and maintains a centralized student data-centric system integration framework used with third party vendors and internal FCPS systems. Designs, develops, tests, debugs, deploys, and maintains processes relating to the extraction/transformation/loading of data between FCPS' data systems/applications. Provides data integrity/quality support, including the implementation of systems and standard operating procedures, to ensure the accuracy and validity of student data. Assists the Student Information Systems team and the Reporting Specialist with the development and maintenance of student data reports and dashboards. Participates in the planning of new software releases/versions and testing of software prior to implementation.
Communication and Collaboration
Creates, maintains, and publishes system/process documentation, including user requirements, technical specifications, data process/flows, and system program/user guides, in conjunction with other System Accountability and School Improvement team members and in accordance with established standards and procedures. Collaborates with Technology Infrastructure and other FCPS departments including, but not limited to, Curriculum, Student Services, Special Education, Transportation, Food Services, and Media Services to define integration processes, data mapping, and other aspects of the integration process. Collaborates with Technology Infrastructure on data exchange and data security methods to facilitate integrations. Serves as a liaison with product leads and data owners to troubleshoot integrations that may not be functioning properly and/or may require modifications to meet functional/application changes. Assists other department staff with special projects including, but not limited to, developing necessary database structures to support Strategic Plan Reporting tools and integrating data from disparate systems. Collaborates and communicates with the Maryland State Department of Education and other local leaders/agencies to ensure accurate data reporting.
Student Data Systems and Reporting Services
Local, state, and federal reporting to include serving as point of contact for FCPS, collaboration with departments within FCPS, review and interpret report/data specifications, performing data extraction tasks, and addressing other reporting requirements. Evaluate operations and activities of assigned programs; recommend improvements and modification of programs. Perform data extraction from and data uploads to the Student Information Systems and loads of data from third party software systems where integration is not automated. Perform database administration functions such as performance, tuning, backup/recovery, and general database administration. Provide quality assurance; implementing systems and standard operating procedures to ensure the accuracy and validity of student data. Assist other staff on special projects, as directed. Continually review FCPS student data systems to ensure that the organization achieves and maintains a high level of data integrity in accordance with requirements defined by the Student Records section of the Code of Maryland Regulations (COMAR). Participate in the processes used to compile and correct student accountability data files submitted to the Maryland State Department of Education. Remain compliant with all local, state, and federal mandates relating to student confidentiality (FERPA) and the use/maintenance of electronic records. Attend workshops and training opportunities to develop and maintain skills pursuant to the duties of this position. Ability to deliver on objectives/goals of the division in a given time frame with available resources.
Other Duties Performs other duties as assigned.
Required Qualifications
Education/Training/Experience
Bachelor's degree in Information Technology (IT) or a minimum of five (5) years of experience in information technology, computer science, or related field. Three (3) years of Structured Query Language (SQL) experience, including writing stored procedures, functions, and complex queries with a large database structure. Two (2) years of experience with building and maintaining data integration processes, preferably Microsoft SQL Server Integration Services (SSIS). Experience in data reporting/visualization, preferably with Tableau and/or SQL Server Reporting Services (SSRS).
Knowledge/Skills/Abilities
Knowledge and use of culturally responsive practices. Ability to work with advanced functions of Microsoft Excel and a variety of relational databases. Knowledge of Data Warehousing, including relational data modeling (Star Schema) and Extract/Transform/Load (ETL) processing. Familiarity of data analysis, database design technologies and tools, excellent analytical ability, judgment and problem analysis techniques. Data extraction and report development experience, preferably Microsoft SSIS and SSRS. Demonstrated strong oral, written, and interpersonal communication skills. Excellent analytical ability, judgment, and problem analysis techniques. Management and organizational skills which demonstrate an ability to prioritize, work under time constraints, and demonstrate flexibility in an environment of multiple tasks and shifting priorities. Ability to handle confidential and highly sensitive information in a professional manner. Ability to build trust and maintain relationships. Advanced oral and written communications and human relations skills. Regular and predictable attendance. Capable of performing the essential functions of the position with or without reasonable accommodations.
Physical Requirements
Ability to work a flexible schedule, including evenings and weekends, as needed. Ability to speak in an understandable voice with sufficient volume to be heard in normal conversation and on the telephone and in addressing groups. Ability to travel to school and other local locations, as well as state meetings, sometimes with little notice. Ability to maintain emotional control under stress. Ability to spend long hours sitting. Ability to reach with hands and arms. Sufficient manual dexterity to grasp, handle, manipulate, and/or feel objects and use office technology. Sufficient mobility to move about the work area. Sufficient vision to read and comprehend printed materials, see distant objects with clarity, and identify and distinguish objects. Sufficient hearing to hear and comprehend conversations in person and on the telephone, as well as distinguish sounds up to twenty (20) feet. Occasionally climb or balance. Occasionally stoop, kneel, crouch, or crawl. Occasionally lift fifteen (15) pounds.
Work Environment
Moderate noise (examples: office environment with computers, printers, and telephones; regular conversations within offices, cubicles, hallways, and conference rooms; meetings one-on-one, in small groups, and large settings, etc.).
Preferred Qualifications
Education/Training/Experience:
Experience with data management in Special Education and Pre-K-12 education environments. Experience working with Application Programming Interface (API) integrations or programming experience (Java, Python, C#, etc.) Experience in data management in K-12 education environment. Proven application development experience, preferably in an object-oriented programming language (ASP.Net or Java). Knowledge of Data Warehousing including relational data modeling (Star Schema) as well as ETL processing. Knowledge of SharePoint and how it's used for collaboration and report publishing Proficiency with all FCPS Student Information System software. Familiarity with Maryland Student Records Manual and related student record management. Familiarity with state & federal educational reporting requirements. Familiarity with the FCPS policies, goals and programs.
FREDERICK COUNTY PUBLIC SCHOOLS IS AN EQUAL OPPORTUNITY EMPLOYER
THIS JOB DESCRIPTION HAS BEEN WRITTEN TO INDICATE THE GENERAL NATURE AND LEVEL OF WORK PERFORMED BY AN EMPLOYEE HOLDING THIS POSITION. IT IS NOT WRITTEN TO INCLUDE OR BE INTERPRETED TO INCLUDE A COMPREHENSIVE INVENTORY OF ALL DUTIES, RESPONSIBILITIES, AND QUALIFICATIONS REQUIRED OF THE EMPLOYEE. NOTHING IN THIS DESCRIPTION RESTRICTS MANAGEMENT'S RIGHT TO ASSIGN OR REASSIGN DUTIES AND RESPONSIBILITIES OR ADD REQUIRED QUALIFICATIONS AT ANY TIME.