Senior Data Manager

SummaryNew Visions for Public Schools develops and implements scalable approaches to achieving equitable outcomes for students in public schools across New York City and beyond. Our data and systems work supports this mission by providing staff with actionable, timely, and accessible information. We currently support over 900,000 students in nearly 1,600 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 Senior 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 everywhereYou are a strong technical mentor with a demonstrated ability to motivate and guide high-performing teamsYou enjoy working with analysts, designers and product managers to determine the best way to grow our data model to accommodate new features and toolsYou are detail oriented and enjoy organizing data in a way that will facilitate the work of team membersYou take pride in engineering resilient, high-uptime infrastructure that can scale to meet the demands of real-time data requests and mission-critical reportingYou care about creating a data model that is optimized for performance and qualityYou love working in teams to solve complex challenges. You thrive in a fast-paced, highly collaborative environment. Essential Job FunctionsPartner with Product Managers and Software Engineers to architect data solutions that align with feature development and releasesDesign, implement, and maintain high-performance PostgreSQL and Amazon Redshift clusters for responsive transactional and analytical workloads and large-scale data warehousingConduct deep-dive query optimization, vacuuming, and indexing strategies in PostgreSQL and Redshift to ensure sub-second query latency where requiredManage and enhance code pattern libraries and development and release best practices to enhance code quality, reduce technical debt, and accelerate development cyclesMonitor system health, respond to production incidents, and implement corrective actions to prevent future occurrencesOptimize, streamline and standardize data processes to decrease execution time and simplify our data modelEstablish robust validation processes to ensure that the processed data reflected in our tools is an accurate reflection of the raw data sourcesMaintain the New Visions Data Model with effective data ingestion (ETL), transformation, integration, business logic processing, and documentation Required Education and ExperienceBachelor's Degree or equivalent experience3+ years experience leading a team in data management, data analytics, or a related fieldProficiency in R, SQL databases (Redshift, PostgreSQL, etc.) and ETL/ELT developmentExpertise managing and enhancing data pipelines to support continuing increases in data volume and complexityDemonstrated ability in SQL with expertise in schema design, data modeling, and database performance tuning Required Knowledge and SkillsExperience using AI models, MCP and/or agents to support code creation, optimize databases, and protect PIIChampion technical standards and patterns to accelerate team productivityKnowledge of R and SQL requiredExperience developing for and optimizing performance of AWS Redshift and PostgreSQL database systemsKnowledge of Git and Github - including branching, merging, diffs, and hotfixesStrong analytical, critical thinking and organizational skillsClose attention to detailDemonstrated ability to prioritize, multi-task, work under pressure and meet deadlinesDemonstrated persistence and independence in learning technical subject matter, and in solving technical problems Desired Knowledge and SkillsExperience processing large datasets with libraries like R data.table and Python pandasExperience with MongoDB data ingestion, query optimization, and aggregation pipelinesExperience consuming REST APIsExperience scheduling tasks with AirflowKnowledge of public education data in New York State Our Technology StackData/DatabasesAWS (Redshift, S3, RDS), MongoDB, PostgreSQLLanguagesR, Python, SQL, Linux/BASHToolsAirflow, Docker, Kubernetes, AWS ECS, dbtDisclaimer:The statements herein are intended to describe the general nature and level of work being performed by the employee in this position. These statements are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of a person in this position.Additional Information:Our offices are currently operating in a hybrid model, with staff expected to work in person several days per week. Additional details will be shared if selected for an interview.Salary InformationWhile the majority of new hires' starting salaries shall be expected to be placed in the first half of the range(s) to allow space to grow in the job, for those who already have significant relevant experience at that level of the job, placement at the higher end of the range(s) is possible.Pay Range$109,528-$180,721 USDWho We AreFor over three decades, New Visions for Public Schools has played a central role in improving the quality of New York City public schools and removing barriers to the success of low-income students and students of color. We provide educators with the tools, resources, and supports to build and continuously improve strong and responsive systems-through investments in curriculum, technology, student planning tools, and innovative college and career preparatory programs.Equal Employment Opportunity StatementNew Visions believes that our teams are most effective when they include representation from the diverse communities we serve, as their perspectives are critical to the work we do. Diversity, equity, and inclusion do not determine who gets hired-that is based on qualifications. They ensure that people who have traditionally had less access to opportunities are considered and, once chosen, feel supported and valued as part of our team.