Data and Application Integration Coordinator

JOB TITLE: Data and Application Integration Coordinator WAGE/HOUR STATUS: Exempt

REPORTS TO: Exec. Dir. of Technology Services

DEPT./SCHOOL: District Wide DATE REVISED: October 2025

PRIMARY PURPOSE:

Design manage and optimize automated data integrations that connect district information systems instructional applications and identity management platforms. Oversee ETL (extract transform load) processes for all district data exchanges including student rostering account provisioning and interoperability with third-party cloud applications.

Maintain a comprehensive understanding of the districts data landscape to support data integrity security and accessibility across all systems.

QUALIFICATIONS:

Minimum Education/Certification:

• Associates Degree in Computer Science Information Systems or related field required.
• Bachelors Degree in Computer Science Software Engineering or related field preferred.
• Relevant certifications (e.g. Microsoft Google Cloud AWS or data integration tools) preferred.

Special Knowledge/Skills:

• Strong proficiency in ETL and data automation using tools such as C# SQL Server Integration Services (SSIS) or equivalent
• Proficiency in SQL Server administration: database backup restoration performance tuning and schema review
• Experience managing student rostering and data synchronization platforms (e.g. Clever ClassLink OneRoster SFTP)
• Experience with Active Directory Azure AD Google Workspace and identity lifecycle management (provisioning updates deprovisioning)
• Experience integrating applications via RESTful APIs JSON XML and webhooks
• Strong understanding of data flow across SIS HR finance and instructional systems and ability to map dependencies between them
• Experience with relational databases data warehousing and reporting tools (e.g. Power BI Cognos DecisionED Crystal Reports SSRS)
• Experience with OAuth2 SAML OpenID Connect and security protocols for authentication and authorization
• Familiarity with data governance principles including concepts of data ownership data stewardship and system of record identification
• Knowledge of FERPA data security and privacy best practices
• Familiarity with the Ed-Fi ODS and standards
• Ability to develop scripts and automations for process efficiency and system interoperability
• Ability to rapidly develop small applications stack or Windows Server environments using C# or PowerShell with SQL Server is desirable

Minimum Experience:

Three (3) years of experience in application integration data systems management or software development preferably in K12 or public-sector environments.

MAJOR RESPONSIBILITIES AND DUTIES:

1. Design develop and maintain automated ETL workflows to synchronize data across SIS HR finance and instructional systems.
2. Manage student and staff rostering for all instructional applications using platforms such as Clever or ClassLink.
3. Conduct detailed systems and process analysis to define application integration or software configuration requirements.
4. Communicate with district and campus staff to define data processing and integration needs.
5. Coordinate with vendors and service providers to resolve data integration and authentication issues.
6. Perform basic DBA tasks including SQL Server backups database restores performance tuning and maintenance.
7. Maintain and optimize identity management systems for user account creation updates and deactivation across local and cloud environments.
8. Build and maintain custom data exchange solutions (APIs scripts or middleware) to support district initiatives.
9. Maintain visibility of all major data sources and destinations in the district; document data ownership stewardship roles and data lineage.
10. Serve as the liaison between data owners and consuming systems to ensure accuracy integrity and accountability in all data exchanges.
11. Ensure data accuracy consistency and compliance with FERPA state requirements and district data governance policies.
12. Create and maintain technical documentation diagrams and data flow maps.
13. Support data-driven decision-making through reporting dashboarding and analytics support.
14. Train and support technical staff as needed in integration procedures and tools.
15. Monitor and enforce security practices and access control standards in coordination with district cybersecurity policies
16. Comply with policies established by federal and state law State Board of Education rule and local board policy
17. Perform other duties as assigned.

SUPERVISORY RESPONSIBILITIES:

None

WORKING CONDITIONS:

Mental Demands:

Ability to communicate effectively (verbal and written); interpret policy procedures and data; maintain control under stress.

Physical Demands/Environmental Factors:

Frequent district and occasional statewide travel in personal vehicle; Work is performed in an office setting; May require occasional prolonged and irregular hours; Frequent repetitive hand motions; frequent keyboarding and use of mouse; moderate lifting and carrying.

The foregoing statements describe the general purpose and responsibilities assigned to this job and are not an exhaustive list of all responsibilities duties and skills that may be required.

Required Experience:

IC