Senior Data Warehouse Engineer at hims & hers (Remote)

Sorry, this job was removed at 3:22 a.m. (CST) on Friday, June 24, 2022
Find out who’s hiring remotely Nationwide
See all Remote jobs Nationwide
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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.


Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

An Insider's view of hims & hers

How would you describe the company’s work-life balance?

Flexibility is a given. If you need time for family, personal commitments, or just to relax, you can take it. There's unlimited PTO and everyone is encouraged to take advantage of it. Overall, there's tremendous commitment to every employee's good health and well-being.

Chris

Director, Growth Marketing

How do you collaborate with other teams in the company?

One of the most rewarding parts of my job is collaborating with so many talented people across teams. My team works closely with other units, such as legal, comms, content and medical. I’m fortunate to work somewhere that encourages and rewards collaboration, because we build a better product, and ultimately a better company, when we work together.

April

VP of Public Policy

What makes someone successful on your team?

Good vibes and a growth mindset! We want the team to be there for one another to celebrate success and learn from mistakes. Technical awesomeness (React Native, Postgres, Kotlin, Docker) and passion for healthcare and fast-growth companies are important too :)

Vicente

Senior Engineering Lead

What unique initiatives do you have that encourage innovation?

We are passionate about doing what we can to help our employees bring their best selves to work. We encourage everyone to ask questions (even anonymously), provide work-life balance (with our permanent remote work model and unlimited PTO), and make sure everyone has the ability to make an impact and unleash their creativity—no matter their title.

Hilary

Co-Founder

What are hims & hers Perks + Benefits

hims & hers Benefits Overview

Competitive salary + stock options.
High-coverage medical (99%), dental & vision insurance for employees & family.
Flexible paid time of + generous parental leave policy.
401(k) plan, HSA & FSA.
Remote-first culture + monthly stipend for phone, internet and home office needs.
Weekly meditation sessions + monthly wellness initiatives.
Virtual team-building events (i.e. yoga, trivia, bingo) + weekly Happy Hours.
Biweekly All-Hands.
Exclusive employee discount on Hims & Hers product.

Culture
Friends outside of work
Eat lunch together
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Team workouts
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Happy Hours
Recreational Clubs
Home Office Stipend for Remote Employees
Professional Development Benefits
Lunch and learns
Promote from within

More Jobs at hims & hers

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView hims & hers's full profileSee more hims & hers jobs