Position Type: Technology/SpecialistDate Posted: 9/10/2020Location: Central Office- 191 South East St.Date Available: ASAPClosing Date: Open until filledPROBATIONARY EMPLOYEES ARE NOT ELIGIBLE TO APPLY FOR VACANCIES DURING THEIR PROBATIONARY PERIOD. All education that is indicated on your application must be supported by attaching a scanned copy of your high school diploma, high school transcript or college transcript.Previous applicants need not reapply REQUIRED QUALFICIATIONS: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 with data analysis, database design technologies and tools. 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.) Knowledge, Skills, Abilities Working knowledge of IEPs and 504 Plans. Knowledge of SharePoint and its use for collaboration and report publishing. Knowledge of statistical software. Proficiency with all FCPS Student Information System software. Familiarity with the Maryland Student Records Manual and related student record management. Familiarity with state & federal educational reporting requirements. Bilingual skills. Familiarity with the FCPS' policies, goals and programs. Knowledge of the principles and practices associated with promoting public education. ESSENTIAL FUNCTIONS:The Data Integration Specialist has the primarily responsibility for Frederick County Public Schools' (FCPS) data integrations. Key responsibilities include, but are not limited to, the following: (1) Designing, implementing, and managing data integrations which are used in conjunction with third party vendors 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. Reporting directly to the Supervisor of Special Education Compliance, 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. Maintains database administration and other technical documentation, as required. 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. Supports the Reporting Specialist on all tasks related to Data Governance. Collaborates and communicates with the Maryland State Department of Education and other local leaders/agencies to ensure best practice implementation related to Student Data Governance. Supports the professional and accurate publication on FCPS' website regarding required documentation per Maryland Legislature including, but not limited to, lists of vendors and data elements shared and application approval processes. Other Duties: Performs other duties as assigned by the Supervisor of Special Education Compliance. HOURS: TBDSALARY: Support Salary Scale, Grade 20, 12-month position (260 days/8 hours day) Salary based on education and experience 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. FREDERICK COUNTY PUBLIC SCHOOLS IS AN EQUAL OPPORTUNITY EMPLOYER