**Benefits and perks**:- 13 paid holidays per year- Generous PTO and sick leave- Comprehensive health plans- 403(b) retirement plan with employer match- Flexible remote work- Professional development resources- Paid, four-week sabbatical every five years- Employee assistance program- Dog-friendly Oakland, CA office- Vibrant company culture featuring happy hours, virtual book club, spontaneous.gif battles, & more!**About GreatSchools**:GreatSchools is the leading nonprofit providing high-quality information that supports **parents** pursuing a great education for their child, **schools** striving for excellence, and **communities** working to diminish inequities in education. We are the only national organization that collects and analyzes data from all 51 state departments of education and the federal government to provide analysis, insights, and school quality ratings for parents, partners, researchers, and policymakers. Over 49 million users visit GreatSchools' award-winning website annually to learn about schools in their area, explore research insights, and access thousands of free, evidence-based parenting resources to support their child's learning and well-being. We are a mission-driven team that believes all children — especially those who have been historically underserved by the education system — deserve an excellent education.**Summary**:We are looking for a colleague to join our Data Engineering Team in delivering the data and tools that allow GreatSchools to provide the most up-to-date, comprehensive, and informative lens on school quality possible. If you love working with data and want to use your talents to help tens of thousands of parents every day to find the right school for their child then this position is for you.This position reports to our Data Engineer II. It is a full time, exempt position with headquarters located in Oakland, CA (remote work within US ok).**Responsibilities include**:- Contribution to and maintenance of preprocessing and loading processes, tooling, and documentation. Including shared Python libraries, automation services, and other key infrastructure.- Contribution to loading efforts of K-12 education data into our data warehouse- Contribution to improvements of the data warehouse architecture- Contribution to the GreatSchools process and methodology documentation- Performance of QA checks and/or pull request reviews of code submitted by other Data Engineers, using and building upon QA automation efforts/tools.- Ability to perform size and difficulty assessment for acquired data loads- Support of work to answer data-related internal and external stakeholder requests, including technical support on data related issues from our Customer Service team- The responsibilities of this role may include a number of other similar or related duties which may not be specifically included within this position description, but which are consistent with the general level of the job.**You'll likely find success in this role if you have**:- 1+ years of experience with SQL- 1+ years of experience with a programming language (python, ruby, R preferred)- Experience working within an Agile Software Development framework- The ability to prioritize work, manage multiple projects and work within tight deadlines- Are a good communicator- Are a self-starter; with the ability to work independently and as a strong contributor to team projects**Nice to haves**:- 1+ years of experience as a Data Engineer or in a similar role- 2-4 years of experience with SQL, relational database management, and familiarity with working in a shell interface- 2-4 years of experience with a programming language (python preferred)- Experience with git (or another version control system or feedback-facilitator)- Experience with data processing and workflow management tools (such as Airflow, Spark, Luigi, Azkaban, etc.)- Experience working with AWS data technologies (such as S3, Glue, Lambda,Redshift, etc.)- Experience working with cross-functional teams in a dynamic environment- Clear and concise communication, ability to articulate clearly with a diverse team- Experience working with K-12 education data, working for non-profits, or a passion for the GreatSchools mission**Salary & Benefits**:GreatSchools proudly offers competitive medical, dental, and vision benefits, as well as a retirement plan with employer match. Additionally, we provide generous PTO + sick leave, thirteen paid holidays annually, and a paid four-week sabbatical every five years.**Application deadline**:- GreatSchools team members are diverse in all ways. We are committed to hiring talented staff who reflect the diversity of the communities and audiences we serve and who believe in supporting all parents, especially those who have been historically underserved. As a proud Equal Opportunity Employer, we are committed to considering applicants regardless of race, color, sex, age,
