Education Data Systems Specialist

At Rocketship Public Schools, we believe in the infinite possibility of human potential. We believe that every student deserves the right to dream, to discover, and to develop their unique potential and it is our responsibility and our privilege to unleash the potential inside every Rocketeer we serve. Our non-profit network of public elementary charter schools propels student achievement, develops exceptional educators, and partners with parents who enable high-quality public schools to thrive in their community. We are a collective of parents, teachers, leaders, and students working together to transform the future for underserved communities across our country. At Rocketship Public Schools, we are unleashing potential.
Position Description
The Data Analyst will work on cross-functional data streams as part of the central data analytics team at Rocketship Public schools. Initially, the data analyst will primarily support work to transition our data architecture from a vendor’s manage data warehouse to the organization's new data architecture. This will include tasks such as building data models and data sources, updating visualizations, supporting the rebuild of ETL pipeline, and  documenting systems.

Essential Functions

• Gather requirements from stakeholders and technical documentation from data vendors and provide initial data schema solutions.
• Build data models and data sources in in DBT
• Build and rebuild Looker and Tableau visualizations under the new data architecture
• Use dagster to support data orchestration and ETL pipelines
• Document data systems for internal and end user support
• Administrate security access controls to secure both data and systems

Required Qualifications

• At least one year of professional experience in a data field.
• Experience writing code to create data sources for visualization.
• An ability to critically think WITH stakeholders and iteratively create the solution they NEED (as opposed to the one they initially want).
•  Ability to clearly document data systems and organize the documentation for internal technical support and end users.

Preferred Qualifications

• Experience with K-12 Education data
• Proven success in a collaborative, team-oriented environment
• Specific coding skill in R, Python and SQL
• Experience with visualization tools Tableau and Looker
• Experience with ETL tools DBT and Dagster
• Bachelor’s degree (or equivalent) in mathematics, computer science, economics or statistics.
• Experience with Google BigQuery
• Experience using code repository software to maintain code and version control 
• Experience administrating security access controls to secure both data and systems
• Preferred location in San Francisco Bay Area, Washington DC, Milwaukee or Nashville.

Physical Demands:The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the employee is regularly required to talk, hear, and communicate with both adults and children. The employee frequently is required to use hands or fingers, handle or feel objects, tools, or controls. The employee is frequently required to stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 50 pounds and occasionally climb ladders. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is moderate to high.
Compensation:Commensurate with qualifications and experience, plus excellent health and wellness benefits, 403b retirement plan, flexible spending account (FSA), and generous paid time off.
Rocketship Public Schools provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Rocketship Public Schools complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Rocketship Public Schools expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orie