Senior Data Warehouse Engineer

Job Description

Company Overview: Age of Learning® is the leading developer of engaging and effective Pre-K through 5th grade learning resources that help children build a strong foundation for academic success and a lifelong love of learning. The company’s research-based curriculum, developed by education experts, includes the award-winning programs ABCmouse.com ® Early Learning Academy and Adventure AcademyTM, as well as the adaptive, personalized school solutions, My Math Academy®, My Reading Academy®, and My Reading Academy Español. Having served over 50 million children worldwide, Age of Learning is a global leader in efforts to advance equity, access, and opportunity for all children. To learn more about Age of Learning, visit www.AgeofLearning.com . Summary: Our Data and Analytics team is seeking a full-time Data Engineer with specialization in Data Warehouse Architecture. This person will primarily focus on supporting data products by building elegant, scalable data warehouses, and evolving self-serve analytics solutions. Your efforts will be critical in driving data-driven decision-making and enhancing our overall data infrastructure.

Responsibilities:

• Design, build, and maintain a simple, effective, and scalable data warehouse infrastructure using Snowflake.
• Develop and optimize data models to support various business needs, ensuring data consistency and accuracy across the organization.
• Implement and manage ELT processes with dbt to ensure reliable data pipelines.
• Work closely with product development teams, data analysts and business stakeholders to understand their requirements and deliver actionable insights.
• Mentor and support analysts and peers, fostering a culture of learning and continuous improvement.
• Monitor and tune transformations and queries for maximum performance.
• Proactively identify and resolve operational issues with evolutionary recommendations.
• Ensure testing and validation mechanisms are in place so that data transformations are verified, complete, documented, and meet SLAs.

Required Qualifications:

• 5+ years of data engineering and warehousing experience
• Able to leverage abstraction to solve complex problems
• Excellent SQL, data modeling skills
• Experience with dbt and Snowflake (or other modern data warehousing solutions)
• Experience designing and building scalable data warehouses for access across the organization
• Experience implementing data validation and monitoring systems
• Excellent communication skills
• Prior experience with communicating with technical and non-technical audiences
• Experience managing projects and delivering results within set timelines
• Can work iteratively, defining requirements as needed

Preferred Qualifications:

• Extensive experience with dbt
• Extensive experience with Snowflake
• Experience with Python
• Experience data modeling clickstream data generated from website and app traffic
• Experience with real-time data processing and streaming platforms.
• Experience building data systems that adhere to data government principles
• Familiarity with DevOps practices and tools for managing data infrastructure
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform
• Understanding of machine learning and data science concepts
• Experience working in an agile environment
• Experience and preference to be a part of a team
• Strong product sense and commitment to data quality

Total Compensation: The estimated salary range for a new hire in this position is $150,000 USD to $175,000 USD. Salary may vary depending on job-related factors, including knowledge, skills, experience, and location. Age of Learning currently provides: • 90% of employee health and welfare benefits premiums & 65% of dependent benefits premiums • A 401(k) program with employer match • 15 paid vacation days (increases to 20 days on your 3-year anniversary), 12 observed national paid holidays plus 9 sick days • Our flexible work culture means 2 or more days in the office (hybrid) or 100% fully remote options available for most positions Security Advisory At Age of Learning, we prioritize a safe recruitment process. Communication will come solely from official Age of Learning email addresses, @aofl.com, or our verified LinkedIn Recruiter accounts — be cautious of deviations. We will never request sensitive personal information during the early application stages. Interviews are conducted via phone, in person, or Zoom — never through messaging apps. Job offers are communicated verbally and followed by written documentation via Docusign. Any requests for personal information will occur through secure channels only. An Equal Opportunity Employer Age of Learning, Inc. (the “Company”) is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin or ancestry, sex, gender expression, age, physical or mental disability, medical condition, pregnancy, veteran or military status, marital status, sexual orientation, gender identity, domestic partner status, genetic information, or any other legally-recognized protected basis under federal, state, or local laws, regulations, or ordinances. Age of Learning, Inc. (the “Company”) will consider qualified applicants with criminal histories pursuant to EEOC requirements and state applicable laws, e.g. New York City Fair Chance Act. Employee/Applicant Privacy Notice Apply for this job