Director of Analytics

Reports To: Lead Executive Officer (LEO) & Vice President of Instructional Systems & Strategy (VP ISS)

Status: Full-Time, Exempt

Location: Remote role, occasional meetings in person (not to exceed four times per year)

Director of Analytics: The Director of Analytics supports the management of all student data across the organization, maintains the organization’s data infrastructure, and develops BI tools to be used by staff. Additionally, this role supports the cluster data teams in managing and visualizing student data to help support Bright Star Schools' missions and vision.

Database Development and Maintenance

• Collaborate with 3rd party vendor (K12 Analytics) to develop and maintain Bright Stars’ Google Cloud managed data infrastructure, including coordinating weekly and monthly meetings to discuss progress and troubleshoot issues
• Perform regular system analysis on the database checking for data quality and accuracy (including scheduled queries, table views, and data connectors) as well as database debugging
• Submit tickets to K12 Analytics in response to issues with the database or submit requests for further development
• Write custom SQL queries against databases to analyze and visualize data.
• Write and create scheduled queries, table views, and custom tables to supplement the database as needed for analytics
• Create and maintain proper documentation including detailed database definitions

BI Dashboard Development, Maintenance, and Distribution

• Collaborate with end users (school leadership) to gather report/dashboard requirements and ensures proper testing and validation
• Develop Business Intelligence dashboards to be used by schools and School Support Team staff to help Bright Star Schools achieve its mission
• Maintenance of the Data Department’s DataPedia Google Site which contains, among other things, dashboards created using Google Looker Studio
• Contribute to the Data Team’s knowledge base with articles covering topics in Data Analytics including, but not limited, using Looker Studio dashboards and connected Google Sheets

Data Department Support

• Collaborate with leadership teams (such as the Instructional Leadership Team) to identify opportunities to utilize data in supporting Instruction and culture in schools.
• Identify, develop, and deliver professional development training for Data Team members, including providing remote support to all Data Team members in areas of data analysis and visualization.
• Identify, develop, and deliver professional development training where relevant, including providing remote support to team members in the areas of data analysis and visualization
• Any other duties as assigned

Qualifications:

1. Bachelor's degree, required
2. 5 years or more years’ experience in school data management and student information systems, required
3. Proficiency in Looker (Google) Data Studio, Tableau, or other similar BI Tools, required
4. Proficiency in SQL, required
5. Proficiency in Microsoft and Google Productivity Suites, including highly proficient with Microsoft Excel and Google Sheets, required
6. Experience with Google Cloud products including Google Cloud Storage and BigQuery, preferred
7. Experience with Python, preferred
8. Charter school experience, preferred

Salary and benefits:

Salary: $120,000 -135,000/year, based on experience and education

Status: Full-time, exempt

Location: This role is a remote position, but employees are required to reside within 50 miles of Los Angeles, CA.

Benefits: Medical, dental, vision, optional 403b retirement plan, paid time off (PTO), paid holidays.