What are the responsibilities and job description for the Data Systems Programmer Coordinator position at WEST AURORA SCHOOL DISTRICT 129?
POSITION: Data Systems Programmer CoordinatorREPORTS TO: The Department of Data, Research & AccountabilityCONTRACT LENGTH: 12-month position/ 8 Hours Per Day (7:30 - 4:00 PM)
The Data Systems Programmer develops, validates, and maintains district data systems to ensure accurate, timely, and actionable information for decision-making and compliance. This position combines advanced programming and automation with hands-on support and data validation, serving as a key resource for internal stakeholders and external reporting. Responsibilities include designing and maintaining integrations, building dashboards, validating data across platforms, responding to data requests, and ensuring data integrity across all systems.
POSITION QUALIFICATIONS
- Bachelor’s degree in computer science, Data Science, Information Systems, or related field.
- Experience in programming, data engineering, or systems integration preferred.
- Strong proficiency in SQL and data warehousing. (preferably Snowflake)
- Experience working with Power BI, Tableau, or other visualization tools.
- Familiarity with scripting languages such as Python, R, or similar.
- Understanding of K-12 education data and reporting requirements.
- Demonstrated experience integrating with Student Information Systems. (PowerSchool preferred)
- Experience with Connected Intelligence or similar data analytics platforms.
- Knowledge of state/federal education reporting systems. (ISBE, Ed-Fi, etc.)
RESPONSIBILITIES:
Programming & Automation
- Design, build, and maintain automated data pipelines and integrations between district systems (PowerSchool, Snowflake, Connected Intelligence, and others).
- Develop and maintain scalable dashboards and reports using Power BI, Tableau, or similar tools.
- Write and optimize SQL queries and scripts for ETL workflows, data transformation, and automation.
- Document data flows, system architecture, and user-facing processes.
Data Validation & Reporting
- Validate and audit data accuracy across multiple platforms (PowerSchool, Raptor, Unify, Schoology, SeeSaw, i-Ready, IWAS, Clever, etc.).
- Support the collection, validation, and reporting of data for the Illinois School Report Card, Office of Civil Rights Data Collection, CCRI, and other compliance requirements.
- Upload and submit CSV files and other formats to external vendors and agencies.
- Run reports from IWAS and other systems as requested.
- Ensure secure and accurate directory information for assessment activities and data analysis.
End-User Support
- Provide technical assistance to district staff for data systems and related applications.
- Respond to and fulfill ad hoc data requests from central office, school staff, and administrators.
- Assist in building test coordinators with assessment platform data management.
- Develop and deliver professional development and end-user support materials.
- Serve as backup for other Information Services roles as needed (registration, level 1 tech support, application systems).
Collaboration & Continuous Improvement
- Collaborate with Assessment, Curriculum, Student Services, and Technology teams to support school improvement planning and district initiatives.
- Participate in ISBE teleconferences and stay current on best practices in education data, automation tools, and analytics.
- Monitor data integrity proactively and resolve issues to minimize disruptions to operations.
- Perform data audits and rectify errors.
- Perform other duties as assigned by supervisors.
WORK ENVIRONMENT & EXPECTATIONS
- Fast-paced environment requires attention to detail and timely delivery of solutions.
- Regular interaction with central office administrators, school leaders, and technical staff.
- Ability to manage multiple priorities and adapt to shifting organizational needs.
- Ability to visit all school locations as needed.
Job Types: Full-time, Permanent
Pay: $60,000.00 - $80,000.00 per year
Benefits:
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Parental leave
- Retirement plan
- Vision insurance
Work Location: In person
Salary : $60,000 - $80,000