Senior Data Engineer

Who we are

HopSkipDrive’s mission is to create opportunity for all through mobility. Our innovative, supplemental school transportation solutions are used by over 400 school districts, charter schools, nonprofits, government agencies, as well as busy families to safely and reliably get kids where they need to go.

Student transportation is the largest mass transit system in the U.S. The way kids get to and from school has a direct impact on our kids, families, schools and communities. While school districts spend $28 billion annually on transportation, only 30% of kids get to school on a bus. The current system can no longer meet all the transportation needs of our districts, schools and families — and its shortcomings are causing inequities in educational access that are affecting the welfare of millions of kids each day.

HopSkipDrive is taking a different approach to arranging safe, reliable school transportation that meets needs that aren’t being addressed by the current system, helping to fill gaps and supplement the student transportation options available. We create personalized transportation solutions for the one to the many, and everything in between. 

We’re a company with heartOur partnerships with school districts, child welfare agencies and nonprofits ensure equitable educational access for the most vulnerable populations, including youth in foster care, children experiencing homelessness and students with disabilities. 

We understand that the difference between struggle and success can sometimes be as simple as the ability to show up, which is why we’re on a mission to use innovative technology — coupled with operational expertise and new ways of thinking — to help kids reach their full potential by providing a safe, dependable way to get them where they are going. 

We’re an awesome place to workOur company culture has been well-recognized — HopSkipDrive has been named to Fast Company’s Most Innovative Companies list, as well as Best Places to Work lists from Built In LA, Comparably, Inc., and the Los Angeles Business Journal. Comparably also named us a Best Company for Professional Development, as well as to its Best CEO and Best CEOs for Women lists. 

We’re growing rapidlyFounded by three moms as a solution to their own transportation challenges, we now operate across over 20 major markets and more than a dozen states across the country. We continue to expand at a rapid pace, making the Inc. 5000 list four times, as well as the Deloitte 500 Fast-Growing Technology list. HopSkipDrive has raised $100M in funding to date.

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.