Who you are

The ideal candidate has a strong foundation in data engineering, a go-getter attitude, and the drive to advance their career in a rapidly growing technology company. You always think like a business owner. You are excited to jump in and help your teammates, and you’re always thinking of ways to constructively challenge the status quo and improve the business. You are an A player who is inspired by the mission we are pursuing and by the opportunity to define a new category in an incredibly fast-moving market. You are excited to bring your best every day, to learn from those around you and to push hard while contributing to our powerful vision of positively impacting kids’ lives every day.

At HopSkipDrive, we know that to tackle our toughest challenges, we need different approaches, unique perspectives, and new ways of thinking. We are building a team of creative problem-solvers from many different backgrounds.

Key Responsibilities

• Perform data engineering activities initially as a team of 1 with full project responsibility.
• Tune existing Postgres RDS Aurora and Snowflake data warehouses on AWS.
• Consult with the engineering/devops team on evolving data pipeline and database system architectures.
• Improve ETL process to load data warehouses to meet stricter operating windows.
• Build out analytic data pipelines to ingest data into the data warehouses from currently siloed systems, google sheets, and external sources. 
• Build out reverse ETL pipelines to move data from the data warehouses to department systems such as Salesforce.
• Migrate a Postgres data warehouse to a high-performing analytic data warehouse such as Redshift or Snowflake to better support self-service reporting initiatives.
• Stand up additional tools for data transformation, data alerts, and data governance.
• Collaborate with DevSecOps on projects to further secure data resources.
• Gather data from a variety of sources to improve the effectiveness of marketing efforts throughout the CareDriver lifecycle.
• Ensure quality of data and robust operation of data transformation pipelines.

Skills and Experience

• Bachelor's degree in a quantitative field, such as computer science, statistics, applied mathematics, or other related areas of study, or equivalent years of experience
• 5 years of data engineering experience with emphasis on cloud-based solutions such as AWS. 
• Excellent verbal and written communication skills to convey technical concepts and their implications to non-experts with diverse backgrounds
• Experience with data warehouse design, ETL, and reporting.
• Strong experience developing solutions in SQL, scripting languages such as Python and unix shell, and infrastructure tools such as Terraform, Octa, Docker, ECS, DBT, Segment, Fivetran, AirFlow, AirByte.
• Strong experience with database management systems.
• Ability to thrive in a fast-paced work environment
• Highly self-motivated, with attention to detail
• Track record of independent work as an individual contributor on a data team.
• Nice to have experience: 

• Interest or experience hiring additional data engineers to manage.
• Marketplace company experience
• Development and administration of Postgres and Snowflake.
• Tableau experience.

What you will get

We want you to be an owner in our company and share in executing our vision, so every full-time employee has equity. In addition, we offer flexible vacation, medical, dental, vision and life insurance, 401(k), FSA, and an opportunity to work for a uniquely positioned, VC-backed company in a hugely attractive space with significant upside potential. HopSkipDrive is committed to fair and equitable compensation practices. The base salary range for this role is $135,000 - $155,000 a year. This position is remote and, as such, compensation will ultimately be in line with the location in which the position is filled. Final compensation for this role will be determined by several factors such as a candidate’s relevant work experience, skill set, certifications, and specific work location. The total compensation package for this role also includes equity stock options.