About The Opportunity

GreatSchools is seeking an experienced Data Engineer II 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 everyday find the right school for their child, then this position is for you.

This is a fully remote position that can be based anywhere in the United States, requiring travel several times a year. This position reports to the Manager of our Data Engineering team.

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 45 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.

Key Responsibilities

• 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
• Design and Development of new ETL and data governance tools
• 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.

Qualifications

You’ll likely find success in this role if you have:

• 3-5 years of experience as a Data Engineer or in a similar role
• 3-5 years of experience with SQL (including complex query writing, and storage and query performance tuning)
• 3-5 years of experience with a programming language (python preferred)
• Experience with git (or another version control system or feedback-facilitator)
• Experience building large-scale projects from conception to completion
• The ability to apply a detail-oriented, critical eye to data quality
• Strong organizational, problem-solving, and analytical skills.
• Experience working with cross-functional teams in a dynamic, remote environment
• Self-starter; with the ability to work independently and as a strong contributor to team projects
• Commitment to GreatSchools' mission and values; ability and excitement to work with a diverse group of people.

Nice to haves:

• Experience with relational database management
• 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 K-12 education data and/or working for non-profits

Location

• Anywhere in the United States
• Travel up to 3 to 4 times annually primarily to the San Francisco Bay Area

Salary & Benefits

Base compensation for this role ranges from $100,000 to $110,000 for candidates residing in the Bay Area; salaries are dependent upon candidate location and experience.

Our wide-ranging benefits are some of the best you’ll find out there. They include:

• Comprehensive medical, dental, and vision benefits with range of PPO, HMO, HSA-eligible accounts,
• Retirement plan with employer match;
• 15 days of vacation, 9 days of sick leave, and 13 paid holidays annually; and
• Every five years, employees can rest and recharge with a paid four-week sabbatical.

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, ancestry, national origin, religion, creed, age, disability (mental and physical), sex, gender (including pregnancy, childbirth, breastfeeding or related medical conditions) sexual orientation, gender identity, gender expression, medical condition, genetic information, marital status, military or veteran status,  or any other federal, state or local protected class. 

Employment Fraud Notice: GreatSchools cautions job seekers of potential scammers attempting to impersonate our organization during the hiring process. All communications related to application submissions, interviews, and applicant selection are sent via our secure hiring portal, BambooHR. We will never ask you for financial information or payment and do not utilize any third-party recruiting services. You can verify our current employees here. Data privacy and security are critically important to us, so please note we are taking all available precautions to avoid fraudulent activity. Any questions or suspicious activity can be reported to hr@greatschools.org.