Data Engineer

Job Overview

DATA ENGINEER Education Analytics strives to deliver sophisticated, research-informed analytics to educators and school administrators so they can use information to support their work in improving student outcomes. To support them best, the data they receive must be accurate, up to date, secure, and easily accessible. The person in this role will be a critical team member who helps to make that a reality. We are seeking a full-time Data Engineer to lead the design, build, and maintenance of automated data pipelines and analytic systems. An ideal candidate has strong Python skills, familiarity with SQL and data warehousing concepts, experience with complex data integration andor analysis, and an interest in improving K-12 education. This role supports the timely delivery of data and analytics to educators and administrators who use this data to drive change and improvement in education. We are looking for candidates who are innovative, hard-working, and curious to help us continue to develop our team’s capacity in the development and use of cutting-edge data engineering tools. This position is able to work from homeremotely. Responsibilities Design and implement complex ETL pipelines to integrate data coming from a mix of flat files, APIs, or other database sources Contribute to the design and implementation of data warehousing structures for research, analytics, and reportingdashboarding Help implement code testing, continuous integration, and deployment strategies to ensure system reliability Develop and improve internal tools and systems to efficiently deliver high-quality, actionable metrics Work collaboratively within a team of analysts, school system leaders, and other engineers to create analytics solutions that are scalable, easy to maintain, and support high quality research Explore and apply new cutting-edge tools to drive innovation across a variety of projects Qualifications Experience designing, implementing, and maintaining modern ETL pipelines with a clean code-base Experience architecting data warehouse and data lake structures that are intuitive and performant Fluency in Python and SQL, experience with Linux. Knowledge of software engineering best practices, particularly in team-based development using Git Ability to be proactive in identifying and defending against potential data quality processing issues Bonus Skills Familiarity with AWS tooling and best practices Experience with Apache Airflow, or other modern data pipeline systems Experience with Postgres, Snowflake, Docker, DBT Desire to work with cutting edge tools in a fast-paced environment The weekly hour expectation is 45 hours per week at EA’s office in Madison, WI. Additional nights and weekends are sometimes required. About us Education Analytics is a non-profit organization that uses data analysis to inform education policy decisions. We work with school districts, regional offices of education, non-profits, and policymakers to identify ways to make education systems better. Benefits middot Competitive salary middot Annual merit bonuses middot Paid holidays and one month of paid vacation per year middot Generous 401k and health benefits middot Free Madison Metro transit pass or subsidized office parking middot Casual office environment middot Location right in the heart of downtown Madison, WI Remote optional