Data Warehouse Engineer (Senior or Staff)

Maven is the largest virtual clinic for women's and family health, offering continuous, holistic care for fertility, pregnancy and parenting. Maven's award-winning digital programs are trusted by leading employers and health plans to reduce costs and drive better health outcomes for both parents and children. Founded in 2014 by CEO Kate Ryder, Maven has supported more than 10 million women and families to date. Maven has raised more than $200 million in funding from leading investors including Sequoia, Oak HC/FT, Dragoneer Investment Group and Lux Capital.
An award-winning culture working towards an important mission - Maven Clinic is a recipient of over 20 workplace and innovation awards, including:

• Fast Company #2 Best Workplaces for Innovators (2022)
• Fortune Best Workplaces NY (2020, 2021, 2022)
• Great Place to Work certified (2020, 2021, 2022)
• Inc. Best Workplaces (2022)
• CNBC Disruptor 50 List (2022)
• Fast Company #1 Most Innovative Company in Health (2020)
• Built In NYC Best Paying Companies (2022)
• Built In LGBTQIA+ Advocacy Award (2022)

Maven is looking for an experienced Data Warehouse Engineer to help us build out our data infrastructure and data platform as our product and user base continue to grow. This engineer will work with the Data Engineering pod at Maven to deliver data products and services to the Maven team.
As a Data Warehouse Engineer at Maven, you will:

• Help us optimize and elevate our Data Warehouse by defining methodology for the reusable data assets and increasing data availability
• Develop frameworks that support data driven decisions and allow our teams to access and prepare data sets and reports easily and reliably
• Define and implement Dev and QA environments for data warehouse development
• Own data quality and reliability, and navigate complex challenges related to healthcare data privacy
• Thrive in a collaborative face-paced environment where data expertise and responsibility are shared with teammates across disciplines

We're looking for you to bring:

• 5+ years experience as a data engineer designing and deploying data systems
• Experience in designing data warehouses using Google Big Query, Snowflake or Redshift
• Mastery of DBT as the primary data transformation tool for the entire data warehouse
• Deep knowledge of a variety of database and data warehouse methodologies and techniques
• Proficiency in SQL and Python, experience working with REST API's and deep understanding of SQL-based Big Data systems
• Experience using Airflow for job orchestration
• Advanced project management and prioritization skills
• Strong written and verbal communication
• Point of view regarding data warehouse and data platform best practices
• Leadership to drive future product and engineering decisions to deliver great data systems

Helpful experiences and skills (if you don't have them, you can learn them with us!):

• Experience with Looker from a platform perspective
• Experience with cloud platforms (Google Cloud)
• Background in a healthcare-related or other regulated field
• Experience in a startup environment

At Maven we believe that a diverse set of backgrounds and experiences enrich our teams and allow us to achieve above and beyond our goals. If you do not have experience in all of the areas detailed above, we hope that you will share your unique background with us in your application and how it can be additive to our teams.
Benefits & Perks:
We are reimagining what a supportive workplace looks like, from the inside out. On top of standards such as employer-covered health, dental, and insurance plan options, and generous PTO, we offer an all-of-you, inclusive approach to benefits:

• Maven for Mavens: access to the full platform and specialists, including care for everything from mental health, reproductive health, family planning, pediatrics.
• Whole-self care through wellness partnerships
• Weekly breakfast, lunch, and get-togethers
• 16 weeks 100% paid parental leave, flexible time upon return, and $1.5K/mo for 2 months, new parent stipend (for Mavens who've been with us at least six months)
• Udemy, annual professional development stipend, and access to a personal career coach through Maven
• 401K matching for US-based employees (immediately vesting)

These benefits are applicable to Maven Clinic Co., US-based, full-time employees only. 1099/Contract Providers are ineligible for these benefits.
Maven is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Please note that Maven Clinic interview requests and job offers only originate from an @mavenclinic.com email address (e.g [email protected]). Maven Clinic will also never ask for bank account information (routing, account numbers), social security numbers, passwords or any other sensitive information to be delivered over email, or phone. If you receive a scam issue or a security issue involving Maven Clinic please notify us at: [email protected].