Senior Data Warehouse Engineer

Hims & Hers Health, Inc. (better known as Hims & Hers) is a multi-specialty telehealth platform building a virtual front door to the healthcare system. Hims & Hers connects consumers to licensed healthcare professionals, enabling people to access high-quality medical care—from wherever is most convenient—for numerous conditions related to primary care, mental health, sexual health, skincare, and more. Launched in November 2017, the platform also offers thoughtfully created and curated health and wellness products. With products and services available across all 50 states and Washington, D.C., Hims & Hers’ mission is to make it easier for all Americans to access affordable care and treatment for conditions that impact their daily lives. In January 2021, the company was listed on the NYSE at an initial valuation of $1.6 billion and is traded under the ticker symbol “HIMS”. To learn more about our brand and offerings, you can visit forhims.com and forhers.com.

We're looking for a savvy, experienced Senior Data Warehouse Engineer to facilitate seamless data processes in collaboration with our engineering and product management teams.

Responsibilities:

• Take the data warehouse to the next level by increasing data timeliness and solidifying the reusable data assets
• Define the processes and frameworks allowing the Analytics team to prepare enriched and aggregated data assets for reporting and data science
• Design and implement QA environment and processes allowing end to end testing of proposed changes from data ingestion to visualization
• Collaborate with Engineering, PM, and Business stakeholders to evaluate the impact of the upcoming features on data warehouse and reporting
• Be part of a talented data engineering team that ships new code every day in a fast-paced work environment

Experience and Skills:

• 7+ years experience as a data warehouse engineer/architect designing and deploying data systems in a startup environment
• Mastery of database and data warehouse methodologies and techniques from transactional databases to dimensional data modeling, to wide denormalized datamarts
• Deep understanding of SQL-based Big Data systems and experience with modern ETL tools
• Expertise in designing data warehouses using Google Big Query (Snowflake and Redshift will be considered)
• Fluency in different SQL techniques for data transformation and data analysis
• Experience developing data pipelines in Python
• Familiarity with software engineering best practices as they apply to the data engineering domain

Hims is an Equal Opportunity Employer and considers applicants for employment without regard to race, color, religion, sex, orientation, national origin, age, disability, genetics or any other basis forbidden under federal, state, or local law. Hims considers all qualified applicants in accordance with the San Francisco Fair Chance Ordinance.

Hims & Hers Employee Benefits

• Remote-first work environment
• High energy, low-ego co-workers
• An open and honest culture where we constantly seek improvement and cherish your input
• Competitive pay with equity compensation (RSU, Options, ESPP 15% discount)
• 401(k) match (50% employer match up to $3000 annual maximum)
• High-coverage medical, dental & vision (FSA & HSA plans)
• Generous parental leave after 1 year of service
• Unlimited PTO (10 holidays off)
• Holiday Break for the whole team, the last week of the year (December 27-31 appreciation week)
• Mental health & wellness benefits (1 mental health day off each quarter, optional weekly mindfulness & meditation sessions)
• Offsite team retreats
• Virtual team-building events: monthly All-Hands (our entire company), lunch'n'learns, and fireside chats
• Opportunities to socially connect with team members across the org in varying capacities
• Access to Amazon HIMS Store to order any additional equipment to ensure you have the gear you need
• Employee discounts (60% off hims & hers online products, 10% off onsite @ the Apple Store, PerkSpot, Classpass)
• $500 work-from-home stipend, automatically added to your first pay cycle
• $75 monthly connectivity stipend (phone/internet), automatically applied on the last pay check of each month, no need to show proof