Transportation Analyst

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 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 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 You are looking for a challenging and rewarding experience. You are inspired by our vision and the opportunity to define a new category in an incredibly fast-growing market. You are excited to learn, grow and collaborate so we can achieve our mission of creating opportunity for all through mobility. At HopSkipDrive, we know that challenges require different approaches, unique perspectives and new ways of thinking.  We are building a team of creative problem-solvers from many different backgrounds.You’re a passionate team builder enthusiastic about finding, engaging and scaling a high performing distributed team. You’ll find energy telling HopSkipDrive’s story to diverse candidates across functions and will thoughtfully assess their backgrounds and expertise to match them with the right role on our team. Your role:   As a Transportation Analyst you will own the end-to-end strategic routing process for a collection of school district clients and contribute in diverse ways to the broader team mission.  What You'll Do: Run the end-to-end strategic routing process for a collection of school district clients.  Each engagement is unique, and our service delivery model is always evolving, but can be described generally in three phases:     Phase I.  Pre-Work.  Gather, understand, clean and prepare a client’s data for the strategic routing model. Engage directly with transportation teams, asking questions about their data access and quality. Walk transportation teams through our custom data intake form, ask for feedback, and customize it as needed. Support transportation teams in the extraction and transfer of data from their systems; understand nuances in the data, surface questions and potential errors, and troubleshoot directly with transportation teams; clean the data set and transfer it into the required format . Depending on the client’s data-readiness this may look like simply ingesting an intake form they have populated, or like traveling to the client site, sitting side-by-side with a member of the transportation team and helping them find/export the right data.    Phase II.  Strategic Routing.  Configure, execute and iterate on multiple runs of the strategic routing model. Translate qualitative district priorities and constraints into model values.   Execute the model, populate output analysis, and evaluate success. Iterate on the priorities and constraints based on your own perspective as well as feedback from internal and external stakeholders.   Compile a final client-facing packaged output and share it with transportation teams. Support district Transportation teams in evaluating the operational impact of various strategic decisions.  Phase III.  Post-Work.  Ensure successful execution of strategic routing recommendations  As we get new information about who needs to be routed, or as new constraints or priorities arise,  adjust and re-run the strategic routing model. Support a wide range of  implementation initiatives with both internal and client teams to ensure success.   You’ll also “wear the hat that needs a head.”  We are a small, entrepreneurial team and so you’ll find yourself supporting a wide range of other workstreams needed for the business to succeed.  This may include things like contributing to board or pitch decks, supporting the core development of the technology, building new visualizations for the output, participating in cross-functional working teams, and much, much more.  What you’ll need: 3-5+ years experience turning data into actionable insights.  Advanced Excel, SQL and data visualization required; Tableau preferred. Ability to quickly evaluate, clean and transform large, messy datasets.    You take accuracy seriously, frequently double and triple checking your analysis. You ask “why” and then you ask it again, returning to first principles and what will have the greatest impact for our clients and for our business.  You are a strong communicator.  You tell good, true stories with data that help people see the world differently.  You have an entrepreneurial mindset. You like building things without a blueprint. No challenge is too big or task too small and you thrive in a fast-paced ever-changing environment. ** This role will be fully remote from a state where we do business  AZ, CA, CO, FL, IL, KS, MD, WI, OK, UT, TN, NC, SC, NV, NM, NJ, NY, OR, TX, VA, WA, MO, MI* 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 salary range for this role is $90,000-100,000 a year.  This 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.