TITLE: Data and Analytics Lead

About You:

You have a strong sense of urgency and you thoughtfully weigh multiple options before making decisions.

You enjoy being a key part of a strong, positive and closely-knit team.

You have the ability to learn quickly and thoroughly while continually recognizing and adapting to changing conditions.

You are a problem solver and love the challenge of new problems.

You are an innovative, outside the box thinker, who is undaunted by failure.

You are task-focused who quickly notices and pushes to solve problems.

About the Role

Responsibilities & Deliverables:

The Data and Analytics Lead will drive the scope and effectiveness of data and analysis processes, while also creating a common data framework so that all organization data can be analyzed in a unified manner. This role will serve as a consultant to the Superintendent/CEO in establishing goals and directions in accordance with district policies and regulations, procedures and planning process.

• Write and run SQL queries to pull, audit, and check data from district systems.
• Clean and prepare data using R, including fixing missing values, correcting errors, and converting data into the right format (numbers, dates, text).
• Organize and manage data files, keeping data sources clear and easy to find.
• Use basic statistics to summarize data and find patterns, such as grouping similar records together.
• Build visualizations and dashboards that present data clearly for non-technical staff.
• Prepare data for deeper analysis by selecting and shaping the most useful pieces of information.
• Reduce large, complex datasets down to their most important parts to make them easier to work with.

Data Architecture and ETL:

• Design and build a data warehouse that pulls together student, assessment, finance, HR, transportation, and special education data.
• Build, schedule, and monitor automated processes that pull data from source systems, clean it, and load it into the data warehouse on a nightly or on-demand basis.
• Set up the data warehouse so it runs fast and efficiently, including organizing data for quick searches and smooth performance.
• Watch for ways to improve district data systems, and stay current on system updates and changes.

Data Quality:

• Write and keep clear rules for good data, such as no missing student information, correct course codes, and consistent grading scales.
• Regularly check data by comparing source systems to the data warehouse to catch errors or duplicate records.
• Work with staff in other departments to fix data problems at the source, such as correcting student records or finance entries.
• Keep data accurate, consistent, and secure across all district systems.
• Follow district, state, and federal rules for handling student and staff data.
• Keep clear, written procedures for how data is handled, so quality and practices stay consistent across the district.

Who We're Looking For

Minimum Qualifications:

1. Bachelor's Degree in Statistics, Mathematics, Computer Science or a related field (required).
2. Postgraduate work or equivalent experience (Master's Degree or Doctorate Degree) in a quantitative field such as mathematics, physics, computer science, statistics or related field (preferred).
3. Successful experience in a senior leadership position managing an analytics team or related team.
4. A demonstrated history of building a strong, cohesive team that excels in customer service and support.
5. Experience with open source data and analytics tools while conducting analyses on large and unstructured data sets.
6. The ability to understand the needs of our organization and how data can meet those needs.
7. Excellent computer skills and proficiency in the use of Microsoft Word, Microsoft Excel, Microsoft PowerPoint or other related software, which will be necessary in the creation of visually and verbally engaging reports and presentations for cabinet, district leaders, principals and other key stakeholders.
8. A strong commitment to service and personal accountability.
9. The ability to transform data and complex concepts into simple, easy to understand and compelling presentations.
10. Excellent organizational, written, communication and problem-solving/creative thinking skills.
11. Performs other duties/tasks as assigned by the Superintendent.

ESSENTIAL FUNCTIONS:

(Essential functions, as defined under the Americans with Disabilities Act, may include any of the following tasks, knowledge, skills, and other characteristics. This list is ILLUSTRATIVE ONLY, and is not a comprehensive listing of all duties and responsibilities performed by the incumbents of this class.)

DEPARTMENT: Community Confidence

SALARY: Commensurate with experience (aligned to district classified salary schedule)

WORK YEAR: 12 months

REPORTS TO: Superintendent/CEO or designee

EVALUATION: Classified

SUPERVISES: N/A