Website Education Analytics

Education Analytics strives to deliver sophisticated, research-informed analytics to educators and school administrators 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 Data Engineer to help us build data systems for analytics in K12 Education. For this role, we are seeking candidates who may not yet have a lot of experience in the data engineering field but have demonstrated strong programming skills and an interest in working with data. In this role, a successful candidate will build skills in data engineering and analytics engineering. We’re looking for someone who is interested in learning data modeling concepts and building data systems and data products that are user-friendly and reliable.

This role could be a good fit for:

A software engineer hoping to transition to working more with data
An analyst or data scientist with strong programming skills looking to transition to creating usable data analytics infrastructure
Someone who has programming skills and has worked with data and wants to get into a professional data role
Please tell us about your interests and aspirations in your cover letter. We are encouraging candidates without a lot of experience in the data engineering field to apply, so the cover letter will help us understand why you are a good candidate for this position.

In this role you will be a part of a team that 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 tools. Our team is consistently evaluating tools for new projects and looking for the best tools for the job. Our current stack uses an ELT approach via Apache Airflow and dbt to create data warehouses in Snowflake or Postgres, depending on the scale of the data. These blog posts on our website illustrate some projects that someone on our team might work on.

Responsibilities

  • Implement and design data warehousing structures for research, analytics, and reporting/dashboarding
  • Apply best practices from software engineering to building data pipelines
  • Help implement code testing, continuous integration, and deployment strategies to ensure system reliability
  • Implement complex pipelines to integrate data coming from a mix of APIs, flat files, or other database sources
  • 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

Qualifications

  • Programming experience, python preferred
  • Knowledge of databases and SQL, and common formats like JSON, CSV, or XML data
  • Knowledge of software engineering best practices, particularly in team-based development using Git
  • Ability to proactively identify and defend against potential data quality & processing issues

Bonus Skills

  • Knowledge of cloud-based columnar data warehouses (Snowflake, RedShift, BigQuery)
  • Familiarity with Data Build Tool (dbt)
  • Experience with Apache Airflow, or other modern data pipeline systems
  • Familiarity with AWS tooling and best practices

Additional details

The weekly hour expectation is 45 hours per week, and nights and weekends are sometimes required. This position is required to primarily work from EA’s office in Madison, WI.

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

Competitive salary
Annual merit bonuses
Paid holidays and one month of paid vacation per year
Generous 401k and health benefits
Parental leave benefit of up to 26 weeks of paid leave
Free Madison Metro transit pass or subsidized office parking
Casual office environment
Location right in the heart of downtown Madison, WI
Education Analytics is committed to creating a diverse environment and is 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.

Tell us about the interview process for this job

Hiring team reviews resumes and cover letters Selected candidates invited to 30-minute interview with Data Engineering team managers to discuss skills and experience alignment Selected candidates invited for full day final interview. Candidates are sent a skills exercise in advance that will be discussed in the interview. This doesn’t require any coding, it’s about concepts and planning of data systems, and doesn’t require any pre-submitted work. In addition to discussing the exercise, there will be another approximately 2 hours of interviews to meet other Data Engineering team members and key members of other teams and to help candidates learn more about Education Analytics & the role. How you will successfully onboard in this role In your first few weeks, you will work through a training exercise our team has developed that familiarizes our new hires with our development setup & tooling, and join team meetings and 1-1 check-ins. From there, you will likely work on 1-2 projects and begin joining project meetings to gain familiarity with the context of the work we do. Next you will start to take on smaller tasks in those projects, and by 3-6 months in, begin to take the lead on larger initiatives.

Tell us about your diversity and inclusion efforts

DEI is essential for the work we do and the culture we are building as an organization. We have active efforts to continue our DEI journey and learning. We have Employee Resource Groups, DEI Team, and goals set from the leadership level to push us forward.

Do you have an active contract with ICE?

No

To apply for this job please visit education-analytics.breezy.hr.