Senior Data Engineer - Analytics

WHO WE ARE: 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.

Why Join Us?

• Work on cutting-edge AI technology that directly impacts educators and students.

• Join a mission-driven team passionate about making education more efficient and equitable.

• Flexibility of working from home, while fostering a unique culture built on relationships, trust, communication, and collaboration with our team - no matter where they live.

• Unlimited time off to empower our employees to manage their work-life balance. We work hard for our teachers and users, and encourage our employees to rest and take the time they need.

• Choice of employer-paid health insurance plans so that you can take care of yourself and your family. Dental and vision are also offered at very low premiums.

• Every employee is offered generous stock options, vested over 4 years.

• Plus a 401k match & monthly wellness stipend

Our Values:

• Educators are Magic:  Educators are the most important ingredient in the educational process - they are the magic, not the AI. Trust them, empower them, and put them at the center of leading change in service of students and families.

• Joy and Magic: Bring joy and magic into every learning experience - push the boundaries of what’s possible with AI.

• Community:  Foster community that supports one another during a time of rapid technological change. Listen to them and serve their needs.

• Innovation:  The education system is outdated and in need of innovation and change - AI is an opportunity to bring equity, access, and serve the individual needs of students better than we ever have before.

• Responsibility: Put responsibility and safety at the forefront of the technological change that AI is bringing to education.

• Diversity: Diversity of thought, perspectives, and backgrounds helps us serve the wide audience of educators and students around the world.

• Excellence:  Educators and students deserve the best - and we strive for the highest quality in everything we do.