Job Specifications
***PLEASE READ FIRST***
We can NOT work C2C or provide sponsorship. W2 ONLY.
This is a contract position through CDW working for our end client. The initial contract period is 2 months. I may get extended and/or convert to permanent employment with the client.
100% on-site position in San Marcos, TX 78666
Looking for someone available to start ASAP (week of Nov 13th or 20th)
JOB DESCRIPTION:
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 district’s data landscape to support data integrity, security, and accessibility across all systems.
QUALIFICATIONS:
Minimum Education/Certification:
Associate’s Degree in Computer Science, Information Systems, or related field required.
Bachelor’s 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 PowerShell, .NET, 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 in .NET 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 K–12 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