Senior Data Engineer at Magic School – Remote

Job Description

MagicSchool is the premier generative AI platform for teachers. We’re just over a year and a half old, and more than 5 million teachers from all over the world have joined our platform. Join a top team at a fast growing company that is working towards real social impact. Make an account and try us out at our website and connect with our passionate community on our Wall of Love.

Role Description:

As a Senior Data Engineer – Analytics, you will own the development and maintenance of our core data warehouse on Google BigQuery, along with AWS data infrastructure for our data science team, ensuring a scalable and reliable foundation for analytics and AI evaluation. You’ll design efficient data pipelines and models to empower data-driven decisions across MagicSchool.

Responsibilities:

As a Senior Data Engineer, you will be responsible for:

• Designing, building, and optimizing our data warehouse architecture (BigQuery, Redshift).
• Designing and building data infrastructure for LLM evaluation and data science initiatives.
• Developing and maintaining efficient ETL/ELT pipelines.
• Implementing robust analytics data models and ensuring data quality.
• Optimizing data warehouse performance and cost.
• Collaborating with data scientists, analysts, and product managers on their data needs.
• Documenting data models and pipelines; creating and maintaining a data dictionary.
• Scoping and sequencing large data initiatives into tasks and shipping them quickly.

Qualifications/Competencies/Skills:

• Expert-level SQL proficiency.
• Strong work ethic and resourcefulness.
• Adaptability and a fast-learning mindset.
• Excellent communication and collaboration skills.
• Deep understanding of data warehousing principles and data modeling.
• Experience with cloud-based data warehouses (ideally BigQuery).
• Experience building and scaling data transformation pipelines.
• Familiarity with data quality concepts.
• Experience with Python for data engineering.
• Nice to have: experience with DBT or similar data transformation tools.

Experience:

• 5 years of experience as a Data Engineer or in a similar role.
• Preferred: 5+ years of experience focused on data warehousing.
• Preferred: Experience with BigQuery and cloud data platforms.
• Preferred: Startup experience.  

Notice: Priority Deadline and Review Start Date

Please note that applications for this position will be accepted until April 25th, 2025 – applications received after this date will be reviewed on an intermittent basis. While we encourage early submissions, all applications received by the priority deadline will receive equal consideration. Thank you for your interest, and we look forward to reviewing your application.