Senior Data Engineer

Thanks for your interest in Success Academy! Running the largest, fastest-growing, and highest-performing network of public charter schools in New York City takes a village - families, children, teachers, staff and faculty, advocates and supporters alike. We would love to welcome you to our community! We work tirelessly every day to ensure each child in NYC has access to a fun, rigorous, whole-child education regardless of zip code or economic status. When you join SA, you play a part in giving every student who walks through the doors of one of our 57 schools in NYC a fair shot at reaching his or her potential.

Job Description

As the fastest-growing, highest-performing charter school network in New York State, Success Academy is reimagining K-12 public education. Nationally recognized for our innovative, whole-child school model and outstanding academic results, Success Academy educators are empowering children from all backgrounds with the knowledge, skills, and self-belief to succeed in college and in life. We now need a results-driven Senior Data Engineer to join our Engineering & Automation team.

The Technology Division at Success Academy is the chief provider of technology infrastructure, application services, security, and support. The Division partners with teams across the organization to equip students, teachers, leaders, and staff with the innovative technology tools and know-how necessary to achieve academic and operational excellence.

The Enterprise Data and Analytics department's purpose is to build a healthy data and technology culture. By focusing on the concrete educational outcomes we are trying to accomplish in our schools, the team develops technical and organizational systems that are user-friendly, scalable, and flexible. The department is responsible for all reporting, analytics, data infrastructure, training, and evangelization.

This new Senior Data Engineer we are seeking will be instrumental in designing, building, and optimizing our data pipelines and data warehouse solutions on AWS. You will leverage your deep technical expertise to solve complex data challenges, implement best practices, and contribute to the evolution of our data platform. You will collaborate closely with data analysts, data scientists, and other engineering teams to deliver high-quality data solutions that drive business value.

As a Senior Data Engineer, you will be responsible for building and maintaining the data infrastructure that powers our business intelligence and analytical insights. We work with cutting-edge cloud technologies to ensure data is accessible, reliable, and performant, enabling data-driven decision-making across the organization. We embrace DevOps practices and value innovation and continuous improvement.

Key Responsibilities:

• Design, develop, and maintain robust and scalable data pipelines using Talend ETL tool.

• Build and optimize our data warehouse on Amazon Redshift, ensuring performance and reliability.

• Develop and implement data transformation models using DBT.

• Write complex and efficient SQL queries to extract, transform, and load data.

• Collaborate with data analysts and business stakeholders to understand data requirements and deliver effective solutions.

• Implement and maintain CI/CD pipelines using GitHub for code management and deployment.

• Participate in agile development processes, utilizing JIRA for task management and tracking.

• Monitor and troubleshoot data pipelines and data warehouse performance, identifying and resolving issues proactively.

• Contribute to the design and implementation of data governance and data quality processes.

• Stay up-to-date with the latest trends and technologies in data engineering and cloud computing.

• Mentor and guide junior data engineers on the team.

Qualifications:

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field.

• 4+ years of experience in data engineering or a similar role.

• Strong proficiency in building and maintaining ETL processes using Talend.

• Extensive experience with Amazon Web Services (AWS) cloud infrastructure, particularly S3 and Redshift.

• Hands-on experience with DBT for data transformation and modeling.

• Excellent SQL skills with the ability to write complex and optimized queries.

• Solid understanding of data warehousing concepts and best practices.

• Experience with CI/CD pipelines and version control using Git (preferably GitHub).

• Familiarity with agile development methodologies and project management tools like JIRA.

• Strong problem-solving and analytical skills with a keen attention to detail.

• Excellent communication and collaboration skills.

• Ability to work independently and as part of a team in a fast-paced environment.

Preferred Qualifications:

• Experience with other AWS services relevant to data engineering (e.g., Glue, EMR, Athena).

• Knowledge of scripting languages such as Python.

• Experience with data visualization tools, particularly Looker.

• Familiarity with data governance frameworks.

• Contributions to open-source projects.

To join our team, please 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.

Compensation Range

Annual Salary:$115,000.00 - $125,000.00

Exact compensation may vary based on skills and experience.

Already an employee of Success Academies? Please go to your Okta Dashboard> Workday> Applications> Career to apply via our Internal Careers page.

We are an equal opportunity employer and value diversity at our organization. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We actively seek applications from people of all backgrounds to strengthen our community and the perspectives needed to flourish in a multicultural world. Success Academy offers a full benefits program and opportunities for professional growth.Learn more about our philosophy, benefits, and team at https://jobs.successacademies.org/working-here/.

Success Academy Charter Schools does not offer employment-based immigration sponsorship.