ETL Engineer

At Success Academy, we are redefining what’s possible in public education. Since opening our first school in Harlem in 2006, we have swiftly grown to 41 high-performing schools, from Bed-Stuy to the Bronx, serving approximately 14,000 kids. We are scaling to 100 great schools serving 50,000 children across New York City, bringing transformational change here and across the country. We believe all children, regardless of zip code or family income, deserve the life-changing opportunities that a world-class education brings.

Our Data Science and Information Systems (DSIS) department ensures we all work collaboratively and more efficiently to support our growing network of schools. By implementing cutting edge technology, built in-house and from 3rd party vendors, we are able to help the organization scale by streamlining processes and making sure everyone has access to mission-critical information 24/7. In effect, the DSIS department's goal is to help everyone at Success work better, more efficiently, and with access to all available sources of information. We’re looking for a tactical, organized, and detail-oriented ETL Engineer to help manage initiatives for our Data Science team.

Our ETL Engineer will be responsible for implementing aspects of our enterprise data warehouse that have an immediate effect on our organization and scholars. Reporting directly to our Managing Director, s/he will be comfortable jumping in the deep end and learning new skills, and should be someone who...

- Can effectively construct complex SQL queries (mostly Postgres and MS SQL Server, but some MySQL as well);
- Possesses a high level of comfort using Python data libraries, particularly Pandas and SQLAlchemy;
- Possesses knowledge of data warehouse systems, structures, and approaches;
- Is experienced in using third-party APIs to collect data from various sources into a central database;
- Works comfortably in Linux environments with some bash scripting and light administration;
- Seeks a fast paced, collaborative environment with capacity to work with multiple teams on completing a variety of projects; and
- Has a strong interest in education reform and working for a mission driven organization.

Preferred (but not required) qualifications also include:
- Experience with Python web development frameworks (Flask or Pyramid);
- Experience with data analysis and visualization methods;
- Experience creating PDFs, PowerPoints files, or other documents programmatically.

To join our team, upload a cover letter and resume that outlines your candidacy. Your cover letter should explain in detail your qualifications for the position. Resumes without cover letters will not be reviewed.

Success Academy Charter Schools is an equal opportunity employer and actively encourages applications from people of all backgrounds. Compensation is competitive and commensurate with experience. Success Academy offers a full benefits program and opportunities for professional growth.

Back to top