Senior Data Engineer - Analytics

MagicSchool AI; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

Join a forward-thinking company as a Senior Data Engineer, where you'll shape the future of education through cutting-edge AI technology. This role offers the opportunity to develop and maintain a robust data warehouse on Google BigQuery, ensuring that data-driven decisions empower educators and students alike. Collaborate with a passionate team dedicated to making education more equitable and efficient. Enjoy the flexibility of remote work, unlimited time off, and generous health benefits while contributing to meaningful social impact. If you're ready to innovate in the educational sector, this is the perfect opportunity for you.

Benefits

Unlimited Time Off

Employer-Paid Health Insurance

Generous Stock Options

401k Match

Monthly Wellness Stipend

Qualifications

• 5+ years of experience as a Data Engineer or similar role.
• Expert-level SQL proficiency and experience with cloud data platforms.

Responsibilities

• Design and optimize data warehouse architecture for analytics.
• Develop and maintain efficient ETL/ELT pipelines.

Skills

SQL

Python

Data Warehousing

ETL/ELT Pipelines

Data Modeling

Cloud Data Platforms

Data Quality Concepts

DBT or Similar Tools

Education

Bachelor's Degree in Computer Science or Related Field

Master's Degree (Preferred)

Tools

Google BigQuery

AWS

Redshift

Job description

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.