Data Engineer — United States — LinkedIn — 4490209955

About The Company

Education Analytics is a non-profit organization dedicated to delivering sophisticated, research-informed analytics to educators and school administrators. Our mission is to support educational professionals in improving student outcomes by providing accurate, up-to-date, secure, and easily accessible data. We leverage open data standards and open-source tools to build collaborative frameworks that enable school systems across the country to share and utilize data effectively. Our team works on innovative projects such as the Enable Data Union and Earthmover, contributing to the advancement of data infrastructure in public education.

About The Role

We are seeking a full-time Data Engineer or Analytics Engineer to join our Engineering team focused on Data & Partners. Depending on your skills and experience, you may be hired at the Data Engineer II or Senior Data Engineer level. In this role, you will design, build, and maintain automated data pipelines and analytic systems for our partner education agencies. You will work directly on projects involving data systems built with Education Analytics’ tools, and your practical experience will help shape core product development.

The ideal candidate will have strong SQL skills, a solid understanding of data warehousing concepts, and experience with complex data integration. Responsibilities include managing extract/load processes, designing data warehouses, performing data transformations, and creating data models. Our technology stack typically uses an ELT approach with Apache Airflow and dbt to build data warehouses in Snowflake and Databricks. We welcome candidates who specialize in either data engineering or analytics engineering but expect familiarity with all ELT aspects.

This role offers the opportunity to contribute to transforming the education sector by building reusable solutions and shared data infrastructure that can be adopted by multiple education agencies nationwide.

Qualifications

• Minimum of 2 years of experience designing data pipelines, systems, and warehouses

• Knowledge of best practices in cloud-based data warehouse design

• Experience with software engineering practices, especially team-based development using Git

• Fluency in SQL and experience working with real-world data

• Proficiency in Python programming

• Experience with Linux operating systems

• Database administration, security, and management skills

• Preferred skills and experience include:

• Experience with cloud-based columnar data warehouses and technologies such as Snowflake, RedShift, Databricks, Fabric, or BigQuery

• Working in environments with strict data security requirements

• Experience with dbt and Apache Airflow

• Familiarity with AWS tooling and best practices

• Experience with education data and the Ed-Fi data standard

• Interest and experience in using AI code tools for development and automation workflows

Responsibilities

• Design, build, and maintain automated data pipelines and analytic systems for partner education agencies

• Develop and manage extract/load (ELT) processes ensuring data accuracy and security

• Design and implement data warehouse architectures and data models

• Perform data transformations and integration tasks using tools such as Apache Airflow and dbt

• Collaborate with cross-functional teams to build scalable data solutions and contribute to core product development

• Maintain and improve data security and management practices in compliance with organizational standards

• Engage with open-source projects and contribute to the development of shared data infrastructure

• Participate in team meetings, code reviews, and knowledge sharing sessions

• Support onboarding and mentoring of new team members as necessary

Benefits

• Nine annual paid holidays

• 26.5 days of paid vacation per year plus paid sick time

• 12% employer 401(k) contribution with an additional 3% match

• Comprehensive and generous health benefits

• Parental leave benefit offering up to 26 weeks of paid leave

• Free Madison Metro transit pass or subsidized office parking for on-site employees

• Casual office environment located in downtown Madison, WI

• Flexible work arrangements including remote, hybrid, and on-site options

Equal Opportunity

Education Analytics is committed to fostering a diverse and inclusive workplace. We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.