Senior Data Engineer

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.