Who we are
HopSkipDrive’s mission is to create opportunity for all through mobility. Our innovative, supplemental school transportation solutions are used by over 600 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 heart
Our 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 work
Our 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 rapidly
Founded by three moms as a solution to their own transportation challenges, we now operate across over 13 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 Senior Data Engineer should be seen as an experienced data engineer who is a master of data processing, data modeling, and data storage technologies. The Senior Data Engineer is capable of owning the technical design for data projects of moderate complexity and understands the tradeoffs in creating effective data solutions. They hold a depth of knowledge in data systems that enables them to debug those systems effectively. In addition to designing and implementing consistently high-quality data pipelines, they are aware of industry best practices and trends, and have acquired at least one major specialty such as data warehousing, big data processing, data analytics, or sql optimization.
The Senior Data Engineer gets a lot done. They are responsible for complex tasks and complete them despite roadblocks, grabbing others for help or insight as necessary. The Senior Data Engineer requires very little oversight beyond high-level direction; they can take a complex data requirement, break it down into sub-tasks, and complete their sub-tasks with relative ease. The Senior Data Engineer shows initiative beyond knocking tasks off a list; they are able to identify and suggest areas of future work for themselves or their teams. They seek evidence to support their ideas and start to build cases for these ideas. They deliver data products that they believe are well-structured and reliable.
The Senior Data Engineer has end-to-end responsibility for data projects of increasing complexity that encompass more than their own development. They contribute to the common data architecture and standards for the team. They understand the business that their data solutions support, and possess empathy for the users of their data; they use this understanding to influence their task prioritization. They assist in identifying and validating data quality metrics and can identify data regression risks in their features. In general, they can identify risks in data pipelines, data models, and design, and communicate these to the appropriate parties.
The Senior Data Engineer is known outside of their core team as a data technology leader. They participate extensively in data architecture reviews and mentor others via code reviews, pairing, and sharing best practices. They work effectively with non-tech members of the company, such as data analysts and business stakeholders. They are able to identify problems with data requirements and help their team course-correct around these issues.
Above all, they want to build data solutions that fundamentally improve the lives of families.
What you'll need:
- 5+ years of professional data engineering experience with emphasis on cloud-based solutions such as AWS
- 3+ years experience with SQL, preferably PostgreSQL
- 2+ years experience with Snowflake or Redshift
- 2+ years experience with python
- Experience with Tableau a plus
- Excellent verbal and written communication skills to convey technical concepts and their implications to non-experts with diverse backgrounds
- Expertise with data warehouse design, ETL, and reporting
- In-depth knowledge of complex data transformations at scale
- A thirst for knowledge and continuous learning
- Past success when presented with projects of increasing complexity over time across multiple areas or domains
- Previously earned a high level of trust amongst team to own a task/project without needing much supervision
- A high level of craftsmanship about your work, the end experience of the user, and impact on overall product
- A connection to HopSkipDrive’s mission and values
What you will do:
- Be the first data engineer on a growing team. Lay a solid foundation and set a high standard for those that follow
- Lead the project to migrate a Postgres data warehouse to a high-performing analytic data warehouse such as Redshift or Snowflake to better support self-service reporting initiatives.
- 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.
- Stand up additional tools for data transformation, data alerts, and data governance.
- Collaborate with DevOps 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.
- Deconstruct a problem into an executable action plan for yourself and other engineers - also perform them to high quality
- Own and complete full projects beginning with identifying and communicating the problems to be solved, getting and incorporating feedback on proposed architectural solutions, and making a final decision as the owner of a project.
- Lean into challenges when they offer the potential to create large impact, and do so with productivity and positivity
- Be highly productive - have a reputation for getting things done quickly and efficiently
- Be a mentor for other data engineers
- Show curiosity to not only learn new things but fully understand how they work
- Interview prospective candidates and provide thoughtful evaluations and feedback
** This role will be fully remote in one of the following states AZ, CA, CO, DC, FL, IL, IN, KS, MD, MI, MO, NC, NJ, NM, NV, NY, OK, OR, SC, TN, TX, UT, VA, WA, WI**
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 $150,000 - $180,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.
Equal Opportunity Employer
HopSkipDrive 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, veteran status, or any other protected class. HopSkipDrive is also proud to operate as a drug-free workplace.
