Data Integration Specialist- Information Services

Position: Information Services Data Integration Specialist

Category: Classified Exempt

Location: Technology Center

Reports to: Educational Systems Supervisor

This position primarily rosters all district apps, supports district-wide data systems by maintaining queries, reports, and data extracts, while serving as the primary point of contact for multiple educational applications and assisting with state and federal reporting. Strong technical skills in SQL and Microsoft applications, experience with data systems, and the ability to collaborate, train others, and uphold data integrity across platforms are essential.

• Responsible for rostering of all apps using SQL as well-being as being an IT admin in systems including Power School, Traversa, Parent Square, Mosaic, and Classlink
• Responsible for creation and maintenance of SQL queries created to build reports when requested
• Responsible for creation and maintenance of extracts to feed data to other education systems
• Responsible for creation, maintenance and updating scripts for vendors systems and staff requests
• Responsible for reviewing and requesting copies of vendor documentation to ensure data security
• Working, understanding, and seeking clarification of appropriate data sharing
• Collaborate and provide excellent customer service while meeting with all stakeholders
• Perform light server maintenance tasks relative to the role, including basic troubleshooting and routine updates
• Assist with state and federal reporting
• Assist with support and training on Business Intelligence toolset(s)
• Serve as the primary point of contact for applicable NSD applications/systems and is responsible for the upkeep of those applications/systems
• Collaborate with the Microsoft Specialist for Teams and group hygiene management
• Assist with Data Retention in applicable systems
• Responsible for processing the Monthly Enrollment Report for Board Meetings
• Representative/advocate of data team
• Assume responsibility for his or her continuing professional growth and development by attendance at professional meetings, membership in professional organizations, enrollment in advanced courses, and by reading professional journals and other publications
• Seek assistance should emergencies arise
• Represent the school district in a positive manner
• Know and follow school district policy and chain of command
• Perform other duties as assigned

None.

To perform the job successfully, an individual must be able to perform each essential duty listed above, satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job.

• High School Diploma required
• One to two years of related data quality experience or equivalent combination of education and experience required
• Experience with Microsoft Applications required
• Knowledge and experience of SQL(intermediate level) required
• Experience with R, SQL, Python preferred

• Experience with SQL for creating queries
• Ability to maintain and create automation using R or Python
• Strong positive customer service experience
• Ability to create process documentation and maintain change log
• Collaborate and seek understanding of existing scripts, processes and procedures
• Proficiency in system analysis to become familiar with systems and applications for generating reports upon request
• Ability to process help tickets in a timely manner
• Excellent organizational and interpersonal skills
• Excellent verbal and written communication skills
• Able to maintain a positive environment and high standards of conduct with stakeholders and peers
• Able to work under pressure and meet deadlines
• Maintain confidentiality of staff and students
• Ability to work effectively as a team member
• Skilled in the use of internet, email, Microsoft Suite
• Capable of interpreting policy, procedures, and data
• Ability to listen to others and remain receptive to new ideas
• Willingness and ability to create a team-oriented atmosphere…