Business Intelligence Solutions Coordinator

REPORTS TO: Executive Director for K-12 STEM & Literacy; Director of Information Services
LOCATION: District Office (Tech Center)

POSITION OBJECTIVE: Responsible for developing and supporting technical operations, data integrations, reporting, and analytics for the Collaborative for Curriculum (CFC), based on established priorities. CFC is an innovative, joint program between District 219 and participating K–8 elementary school districts. This position partners with district staff to translate educational and operational needs into reliable data solutions, including a shared data warehouse and actionable dashboards.

______________________________________________________________________________

MINIMUM QUALIFICATIONS:

• Bachelor's degree in information systems, computer science, data analytics, education, or a related field, or an equivalent combination of education and relevant experience.
• Demonstrated experience building and supporting SQL-based data solutions, integrations, and reports (school district or complex organizational experience preferred).
• Experience designing dashboards or reports in Tableau, Power BI, or a comparable platform.
• Experience developing, implementing, and monitoring interfaces between applications and databases, including core systems and third-party systems.
• Experience diagnosing data issues, working with stakeholders, and managing multiple priorities and deadlines.
• Ability to explain complex data clearly and create accessible visualizations for varied audiences.

REQUIRED SKILLS:

• Strong SQL skills, relational database knowledge, data modeling, and data quality practices.
• Ability to use a scripting language or integration platform to automate and troubleshoot data workflows; specific products and languages may be learned on the job.
• Experience with data file manipulation using spreadsheet formulas and pivot tables.
• Knowledge of Microsoft Office and Adobe Acrobat product suites.
• Experience with data validation and reporting; analysis of logs for errors in integrations, development of queries and reports for end-users to verify data accuracy across systems.
• Experience with student information systems and K-12 assessment data preferred (primarily K–8, proficiency with 9–12).
• Experience across a subset of the following relevant tools and technologies is useful (proficiency in every product is not required):
• Databases, analytics, and integration: Microsoft SQL Server, MySQL, SQL, Alteryx, Jedox, DataRobot, Big Squid, Cloudera, SAP BusinessObjects, Cognos, Informatica, SAS, and Hyperion.
• Programming and platforms: R, Python, PowerShell, JavaScript, Microsoft .NET, Java, Apache Spark, Apache Kafka, Scala, Apache Hive, and Amazon Web Services (AWS).
• Visualization and education systems: Tableau, QlikView, Power BI, student information systems, MasteryConnect, NWEA MAP, FastBridge, and Pearson VUE.

ESSENTIAL FUNCTIONS:

Technical Support & Onboarding

• Provides day-to-day technical support to participating districts relating to SIS, reports, data integrations, and programming.
• Serves as the main point of contact, escalation, and resolution for CFC technical support issues and coordinates with participating districts and vendors as needed.
• Manages the technical aspects of onboarding participating districts to CFC, including requirements gathering, data mapping, integration design, testing, and documentation.
• Responsible for maintaining multiple data sources and databases to support the program.

Data Integration & Engineering

• Responsible for maintaining multiple data sources and databases to support the program.
• Ensures reliable and accurate data access across participating districts through database support, monitoring, troubleshooting, and data quality checks.
• Uses SQL and appropriate scripting or integration tools to automate data extraction, transformation, validation, and delivery. Experience with Python, PowerShell, or comparable tools is valuable.

Analytics, Reporting & Stakeholder Collaboration

• Builds and manages reusable metrics, documentation, templates, reports, and dashboards for participating districts.
• Supports the District 219 SIS/Data team with business analyses and project development of administrative technology for administrative, operational, enrollment, and student services departments or strategic planning.
• Analyze, compile, and prepare confidential data, cost projections, and modeling.
• Develops and maintains detailed data maps across systems to support continuity in fields.
• Reviews current integrations and identifies opportunities to improve reliability, efficiency, and maintainability.
• Explores appropriate additional data sources to improve reporting and analysis.
• Works with educators and district leaders to define measures, develop dashboard designs, and present findings clearly to technical and nontechnical audiences.

Governance, Training & Other Duties

• Protects student and staff information and follows applicable privacy requirements and district data governance practices.
• Provides documentation and training for district staff who use CFC data tools and reports.
• Serves on institutional committees, as necessary.
• Other duties as assigned

TERMS OF EMPLOYMENT: 260 day

WORKING CONDITIONS: The position requires regular computer use and physical activity including lifting and carrying up to 50 pounds, climbing, stooping, kneeling, crouching, and use of fine motor skills. Work is performed indoors and outdoors and may involve exposure to temperature extremes and potential safety hazards. Reasonable accommodations may be made in accordance with the Americans with Disabilities Act (A.D.A.).

SALARY RANGE: Target hiring range for this position will be between $80,000 to $100,000 per year. Offered salary will be determined by the applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with market data.

Apply online at: www.niles219.org

The information contained in this job description is for compliance with the Americans with Disabilities Act (A.D.A.) and is not an exhaustive list of the duties performed for this position. Additional duties are performed by the individuals currently holding this position and additional duties may be assigned.

Niles Township High Schools District 219 is an equal-opportunity employer. It is the policy and practice of District 219 to decide all matters relating to employment solely on the basis of the applicant's ability to perform the essential functions of the position. District 219 ensures equal employment opportunities regardless of race, creed, sex, sexual orientation, color, national origin, religion, age, or handicap.

• Attachment(s):
• Business Intelligence Solutions Coordinator.pdf