Data and Analytics Lead
Job Summary
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 Us:
Established in 1874 we have grown to 21 schools serving over 10000 students with over 50 languages spoken by our students.
Our organization is centered around our values and beliefs that our students are confident self-advocates with interpersonal and critical thinking skills who productively and innovatively make a positive impact in their current and future communities.
We are proud of the family-like culture that permeates our system. Our system boasts award winning faculty and principals high achieving students signature programs and unparalleled parental and community support.
We take our mission and vision seriously and we are committed to inspiring excellence in every child and every adult so that our students are prepared to embrace the opportunities of tomorrow. At TD3 you have an opportunity to change the world and life trajectory of over 10000 students
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 Were Looking For
Minimum Qualifications:
- Bachelors Degree in Statistics Mathematics Computer Science or a related field (required).
- Postgraduate work or equivalent experience (Masters Degree or Doctorate Degree) in a quantitative field such as mathematics physics computer science statistics or related field (preferred).
- Successful experience in a senior leadership position managing an analytics team or related team.
- A demonstrated history of building a strong cohesive team that excels in customer service and support.
- Experience with open source data and analytics tools while conducting analyses on large and unstructured data sets.
- The ability to understand the needs of our organization and how data can meet those needs.
- 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.
- A strong commitment to service and personal accountability.
- The ability to transform data and complex concepts into simple easy to understand and compelling presentations.
- Excellent organizational written communication and problem-solving/creative thinking skills.
- 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
Required Experience:
Senior IC