Coordinator of Technical Systems

Scottsdale Unified School District; Scottsdale (AZ); On-site; USD 85,000 - 110,000; Full time

Job summary

Scottsdale Unified School District is seeking a Coordinator Technical Systems to design, develop, and support district information systems and a data warehouse to improve student achievement. You will manage SQL Server environments, implement ETL processes, and lead data governance and security initiatives across district apps and cloud services.

The role emphasizes data accuracy, regulatory compliance, and collaboration with IT and district departments to deliver reliable reporting and

Qualifications

• Bachelor's degree in Computer Science or related field required; Master’s preferred.
• Experience designing, implementing, and supporting enterprise database systems.
• Knowledge of FERPA, COPPA, CIPA and data governance/security best practices.

Responsibilities

• Design, implement, administer, and support enterprise database systems and data platforms.
• Maintain SQL Server environments including backup, recovery, and HA solutions.
• Develop and maintain data warehouses, data marts, dashboards, and BI solutions.
• Ensure data privacy, security, and compliance with district regulations and laws.
• Lead data integrations between district systems and cloud/services; implement ETL workflows.

Skills

SQL Server

Data warehousing

ETL

Power BI

Security and IAM

Education

B.S. in Computer Science or related field

Master’s Degree preferred

Tools

Microsoft Entra ID (Azure AD)

Microsoft 365

SSIS/SSRS

SQL Server Performance Tuning

Job description

Position Objective

The job of Coordinator Technical Systems is done for the purpose/s of designing, writing and supporting, computer database systems for district information systems, including the computerized student administration system at the district and site levels; meeting compliancy with regard to SAlS (School Accountability Information System); supporting the school sites in the management of school site data; and providing technical support, training, data oversight, and compliance with state accountability expectations. The position will also support the process in the design, development and implementation and maintenance of a data warehouse system for the purpose of supporting improved student achievement.

PAY GRADE:

Support Exempt L

FLSA STATUS:

Exempt

Position Objective

The job of Coordinator Technical Systems is done for the purpose/s of designing, writing and supporting, computer database systems for district information systems, including the computerized student administration system at the district and site levels; meeting compliancy with regard to SAlS (School Accountability Information System); supporting the school sites in the management of school site data; and providing technical support, training, data oversight, and compliance with state accountability expectations. The position will also support the process in the design, development and implementation and maintenance of a data warehouse system for the purpose of supporting improved student achievement.

DUTIES & RESPONSIBILITIES:

(These duties are a representative sample; position assignments may vary.)

• Design, implement, administer, and support enterprise database systems and data platforms that support District operations, student achievement, and business objectives.
• Administer and maintain Microsoft SQL Server environments, including configuration, performance tuning, monitoring, backup, recovery, and high availability solutions.
• Design, develop, and maintain database structures, schemas, stored procedures, views, functions, and complex T-SQL queries.
• Support and maintain data integrations between District systems, Microsoft 365 services, cloud platforms, and third-party applications.
• Develop, maintain, and optimize data warehouses, data marts, reporting systems, dashboards, and business intelligence solutions.
• Design and implement database security standards, role-based access controls, auditing, and data protection measures in accordance with District policies and regulatory requirements.
• Perform database performance analysis, capacity planning, troubleshooting, and optimization activities to ensure system reliability and availability.
• Manage data integrity, validation, quality assurance, and governance processes for District-supported applications and databases.
• Plan, coordinate, and implement database upgrades, migrations, patches, and new technology solutions.
• Provide technical leadership and recommendations regarding database technologies, cloud services, reporting platforms, and data management best practices.
• Develop and maintain automated processes for data extraction, transformation, and loading (ETL) workflows.
• Support enterprise reporting requirements, including District, State, and Federal reporting obligations.
• Collaborate with District departments, vendors, and technology teams to support application integrations, data exchange processes, and system implementations.
• Research, evaluate, and recommend emerging database, analytics, artificial intelligence, automation, and cloud technologies.
• Develop and maintain technical documentation, operational procedures, and disaster recovery plans.
• Provide technical support, training, and guidance to District personnel regarding database systems, reporting tools, data access, and data governance practices.
• Ensure compliance with applicable data privacy, cybersecurity, records retention, and regulatory requirements governing student and employee data.
• Participate in project planning, budgeting, and implementation activities related to enterprise data and reporting systems.
• Monitor system performance, security alerts, and operational metrics to proactively identify and resolve issues.
• Upgrade and maintain professional knowledge through training, certifications, conferences, and independent study.
• Design, implement, and maintain automated account provisioning, deprovisioning, and identity lifecycle management processes between student information systems, Human Resources systems, Microsoft Entra ID (Azure AD), Microsoft 365, and third-party applications.
• Develop and maintain integrations that automate user account creation, role assignment, licensing, group management, and access control based on business rules and authoritative data sources.
• Configure, manage, and troubleshoot Single Sign-On (SSO), federation, and identity management solutions utilizing SAML, OAuth, OpenID Connect, SCIM, Microsoft Entra ID, Active Directory, and related authentication technologies.
• Collaborate with application vendors and District departments to implement secure authentication, account synchronization, and identity governance solutions.
• Support and maintain roster, identity, and data exchange integrations between District systems and external educational service providers.
• Monitor and audit user access, authentication activities, and account lifecycle processes to ensure compliance with District security policies, regulatory requirements, and industry best practices.
• Design and implement automated workflows and scripting solutions to improve operational efficiency, reduce manual processes, and ensure data consistency across enterprise systems.
• Ensure compliance with applicable federal, state, and local laws, regulations, policies, and standards governing student and employee data, including FERPA, COPPA, CIPA, student data privacy requirements, records retention requirements, and information security standards.
• Collaborate with District departments, legal counsel, vendors, and technology teams to evaluate data-sharing practices, security controls, and application integrations to ensure compliance with student data privacy and cybersecurity requirements.
• Review, implement, and maintain technical controls and processes that protect sensitive student and employee information from unauthorized access, disclosure, modification, or loss.
• Conduct periodic audits of user accounts, permissions, data access, integrations, and automated provisioning processes to ensure compliance with District policies and regulatory requirements.
• Support data governance initiatives by establishing and maintaining standards for data accuracy, security, privacy, retention, and lifecycle management.
• Perform other duties as assigned.

EDUCATION & EXPERIENCE (positions In This Class Typically Require)

• B.S. in Computer Science or related field required
• Master’s Degree preferred

LICENSING REQUIREMENTS (positions In This Class Typically Require)

• None

KNOWLEDGE (position Requirements At Entry)

Required to perform mathematical and analytical functions; read, interpret, and communicate technical information; prepare, present, and maintain technical documentation; facilitate discussions with technical and non-technical stakeholders; and analyze complex situations to identify issues, evaluate alternatives, and develop effective solutions. Specific knowledge required to satisfactorily perform the functions of the job includes: database administration and management principles; data modeling, data warehousing, and data integration concepts; Microsoft SQL Server technologies; database security, performance tuning, backup, recovery, high availability, and disaster recovery practices; reporting, analytics, business intelligence, and visualization tools; Microsoft 365 applications and services, including Excel, SharePoint, Teams, OneDrive, Power Platform, Power BI, and Microsoft Entra ID; Windows Server administration; identity and access management (IAM); Single Sign-On (SSO); multi-factor authentication (MFA); SCIM provisioning; SAML, OAuth, and OpenID Connect authentication technologies; system integrations, automation, and workflow design; data governance, data quality, and records management practices; cybersecurity principles and best practices; student information systems and educational technology platforms; and applicable federal, state, and local laws, regulations, policies, and standards, including FERPA, COPPA, CIPA, student data privacy requirements, records retention requirements, and information security frameworks.

SKILLS (position Requirements At Entry)

Required to perform complex technical assignments and continuously develop skills to support changing technologies and organizational needs. Specific skills include proficiency with Microsoft 365 applications and services; Microsoft SQL Server database administration and development; database architecture, data modeling, performance optimization, backup and recovery, high availability, security, and disaster recovery; development of T-SQL queries, stored procedures, SSIS, SSRS, and Power BI solutions; Windows Server administration; data integration and automation; project management; and advanced analytical, troubleshooting, and problem-solving skills.

ABILITY (position Requirements At Entry)

Required to prioritize and coordinate multiple projects, activities, meetings, and deadlines; gather, analyze, validate, and interpret complex data from multiple sources; and evaluate technical and operational factors when implementing technology solutions. Flexibility is required to work independently and collaboratively with diverse individuals and groups in a variety of circumstances; analyze data using advanced analytical techniques; and utilize a variety of enterprise systems, applications, and technologies. Ability is also required to manage competing priorities; develop and maintain technical documentation; communicate effectively with technical and non-technical stakeholders; and support organizational objectives through data-driven decision making. Problem solving requires the ability to identify issues, evaluate alternatives, develop action plans, and implement effective solutions. Specific abilities required to satisfactorily perform the functions of the job include: effective written and verbal communication; database administration and troubleshooting; project planning and coordination; analytical and critical thinking; maintaining accurate records and documentation; meeting deadlines and schedules; training and supporting end users; managing sensitive and confidential data; and adapting to changing technologies and business requirements.

Physical Requirements

Positions in this class typically require: stooping, kneeling, crouching, reaching, standing, walking, pushing, pulling, lifting, finger dexterity, grasping, talking, hearing, seeing, and repetitive motions.

Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Incumbents may be subjected to moving mechanical parts, odors, chemicals, extreme temperatures, inadequate lighting, workspace restrictions, and intense noises.

Note

The above job description is intended to represent only the key areas of responsibilities; specific position assignments will vary depending on the business needs of the department.