New Visions works to make the public education system in New York City a place where students from every background can graduate high school and successfully transition into their post-secondary future. The School Systems and Data Analytics Department aims to accomplish this mission by creating a comprehensive data management ecosystem to support school and district users in making decisions that maximize their students’ likelihood of graduating and succeeding beyond high school. We currently support over 900,000 students in nearly 1600 schools, working with teachers and administrators to help students progress towards graduation and beyond into post-secondary success.

The School Systems and Data Analytics department is at the core of supporting New Visions staff and schools in translating data into action. Multiple times per day, we manage the processing of data from multiple internal and external source systems into New Visions databases and into live tools, providing staff with actionable, timely, and accessible information to make data-informed decisions. 

We are looking for a thoughtful Data Manager to join our growing Data Architecture team and to help fundamentally shape our product. Your work will help massive numbers of students, teachers, and parents across New York and beyond.

Who You Are

You are excited about public service and the prospect of solving problems that are challenging and affect urban schools everywhere.

You are detail oriented and enjoy organizing data in a way that will facilitate the work of team members.

You care about creating a data model that is optimized for performance and quality

You enjoy working with analysts, designers and product managers to determine the best way to grow our data model to accommodate new features and tools.

You love working in teams to solve complex challenges.  You thrive in a fast-paced, highly collaborative environment. 

What You’ll Do

• Incorporate new data sources and scripts into data pipelines to support new features and tools
• Streamline data to decrease processing time and simplify our model
• Script quality assurance procedures to ensure that the processed data reflected in our tools is an accurate reflection of the raw data sources
• Maintain the New Visions Data Model with effective data ingestion (ETL), transformation, integration, and business logic processing
• Create documentation to support further development of the model and related processes
• Collaborate with software developers, data analysts and product managers to support feature development

Required Knowledge and Skills

• Bachelor’s Degree or equivalent experience 
• 2+ years experience working in data management, data analytics, or a related field
• Knowledge of Python and/or R and SQL required
• Strong analytical, critical thinking and organizational skills
• Close attention to detail
• Demonstrated ability to prioritize, multi-task, work under pressure and meet deadlines
• Demonstrated persistence and independence in learning technical subject matter, and in solving technical problems

Desired Knowledge and Skills

• Knowledge of Git and Github - including branching, merging, diffs, and hotfixes
• Experience with AWS Redshift, MongoDB, and PostgreSQL
• Experience consuming REST APIs
• Experience developing scalable and high performing systems
• Knowledge of public education data in New York State

Our Technology Stack

• Data/Database Layer 
• AWS (Redshift, S3, RDS), MongoDB, PostgreSQL 
• Code 
• R, Python, SQL, Linux/BASH
• Orchestration Layer
• Apache Airflow, Docker, AWS ECS