Sr Data Warehouse Engineer, Brand Savings at GoodRx

| Santa Monica
Sorry, this job was removed at 3:07 a.m. (PST) on Thursday, February 4, 2021
Find out who's hiring in Los Angeles.
See all Data + Analytics jobs in Los Angeles
At GoodRx, we believe that all Americans should have access to convenient and affordable healthcare. As a nation, we spend about $3.5 trillion annually on our healthcare, but too many Americans struggle to get the care they need, and prices just keep rising. Our marketplaces for prescription medicines and telehealth have helped Americans save $20 billion since 2011. GoodRx is a profitable business funded by top-tier investors; we're based in Santa Monica with additional offices around the country. We're a low-key and tight-knit group that likes to find new ways to fix big problems. If you share our belief that you can do well by doing good, let's talk.
We’re committed to growing and empowering a more inclusive community within our company and industry. That’s why we hire and cultivate diverse teams of the best and brightest from all backgrounds, experiences, and perspectives. We believe that true innovation happens when everyone has room at the table and the tools, resources, and opportunity to excel.
About the Role
The Data Warehouse Engineer serves as an analytics specialist in the business, focusing on the management of data from various sources. In this position, the Data Warehouse Engineer gains exposure to almost all departments of the business, client services, marketing, account management, and IT among others. The Data Warehouse Engineer aids by providing various departments with data modeling, data analysis, reporting, and dashboard solutions that will enable the achievement of the business’s overall goals.
The role involves the definition and execution of detailed requirements, the analysis of the business’s needs, and the validation of reporting solutions within the business. The role additionally entails working with internal applications in an effort to enable high-quality products/services for the business’s clients leading to customer satisfaction and the ultimate achievement of goals.

Responsibilities:

  • Experience in gathering requirements and formulating business metrics for reporting
  • Work with technical and business stakeholders to capture requirements related to data and data solutions
  • Develop and maintain logical and physical data models using best practices and company standards to ensure high data quality, reduced data redundancy, and good query performance
  • Optimize and update logical and physical data models to support new and existing projects and ensure business users are working in a clean safe data environment
  • Document database processes that currently extract the data from the existing system for reporting purposes
  • Define and document the technical architecture of the data warehouse, including the physical components and their functionality, data models and data dictionaries
  • Assist in the definition of enterprise wide data models that drive clarity and ease of use for analysts throughout the organization
  • Design and build data models or information marts that will meet business requirements and align with our enterprise architecture
  • Get a deep understanding of business rules and transformations logic used by various groups within the company
  • Provide solution expertise to cross functional delivery teams and domain Product Owners
  • Work with Product Owners and stakeholders to scope projects and conceptualize project plans
  • Provide architecture thought leadership and actively participate in the design, implementation, and roll-out efforts
  • Experience as an ETL engineer with a track record of delivering design solutions
  • Troubleshoot data integrity issues, analyze data for completeness to meet business needs, and propose solutions and recommendations
  • Understand and implement best practices in managing enterprise data including master data, data quality, lineage and security
  • Using Looker, develop LookML models, dashboards and reports for both internal and external use

Skills & Qualifications:

  • Degree in Computer Science or a related field or a minimum of 3 year’s working as a Data Engineer
  • 2+ years professional experience in the data warehouse space
  • Expert Proficiency with Python and AWS Services (e.g. Redshift, S3)
  • 2+ years’ experience in custom ETL design, implementation and maintenance
  • In depth knowledge of how to write and optimize SQL statements.
  • Deep familiarity with distributed processing (Map Reduce, MPP, etc.)
  • 2+ years’ experience with schema design (logical and physical)
  • Ability to quickly learn complex domains
  • Innately curious and organized with the drive to analyze data to identify deliverables, anomalies and gaps and propose solutions to address these findings
  • Ability to manage and communicate data warehouse plans
  • Thrives in fast-paced startup environment

GoodRx is America's healthcare marketplace. The company offers the most comprehensive and accurate resource for affordable prescription medications in the U.S., gathering pricing information from thousands of pharmacies coast to coast, as well as a telehealth marketplace for online doctor visits and lab tests. Since 2011, Americans with and without health insurance have saved $20 billion using GoodRx and 15 million consumers visit goodrx.com each month to find discounts and information related to their healthcare. GoodRx is the #1 most downloaded medical app on the iOS and Android app stores. For more information, visit www.goodrx.com.

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

Technology we use

  • Engineering
    • GolangLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • SwiftLanguages
    • ReactLibraries
    • ReduxLibraries
    • PyramidFrameworks
    • MySQLDatabases
    • PostgreSQLDatabases

Location

Our brand new office is located at the Pen Factory. Onsite parking is provided. Also accessible by the light rail Metro Expo Line.

An Insider's view of GoodRx

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

GoodRx hires team members we can trust and empower. With thoughtful hiring, we have assembled a team that is inherently self-motivated, driven and doesn't require (or want) micromanagement.

Reena Scoblionko

Vice President of People

How does the company support your career growth?

GoodRx has been like a family to me. I started as an intern while finishing grad school and never left. I’ve been fortunate to be surrounded by some inspiring and talented leaders who have given me the opportunity to work on a multitude of engineering projects across the business. I’ve now come full circle, managing a team where I first started on!

David Pair

Engineering Manager

What’s the vibe like in the office?

GoodRx provides an awesome laidback culture and happy and energetic office vibe. We believe in working hard and playing harder. The company offers Happy Hour once a week, catered lunches three days a week, an awesome ocean-front office location and events to celebrate small wins - all which make GoodRx a unique place to work.

Priyanka Halder

Agile Delivery Lead

What are GoodRx Perks + Benefits

GoodRx Benefits Overview

- Medical, vision, dental, STD, LTD and AD&D to all full-time employees
- The company offers one (great) PPO Medical plan at NO COST to employees AND dependents
- 4% 401k match
- Meaningful stock options
- Discretionary leave
- Classpass Membership
- Onsite Parking
- Dog friendly office

Culture
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Open office floor plan
Diversity
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
- Medical & Dependent Care FSA available $2,700 pre-tax per calendar year $5,000 pre-tax per calendar year
Disability Insurance
Covered @ 100%
Dental Benefits
Offered through Anthem Employees covered @ 100% Dependents covered @ 50%
Vision Benefits
Offered through Anthem Employees and Dependents covered @ 50% Monthly costs range from $3.24 (self) - $9.87 (family)
Health Insurance Benefits
Offered through Anthem Anthem Blue Cross Classic 500 PPO - employees AND dependents covered @ 100% Anthem Classic 250 PPO - monthly cost ranges from $60 (self) - $187 (family) Kasier
Life Insurance
STD, LTD, LIfe & AD&D - ALL covered @ 100%
Wellness Programs
Retirement & Stock Options Benefits
401(K) Matching
4% 401k match - no vesting period
Company Equity
Stock Options available to full-time employees
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
3 months fully paid with at least 90 days of service
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
And Cold Brew and Kombucha!
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Catered lunches on Tuesdays, Wednesdays & Thursdays Bagel Fridays Snacks and Drinks that put the freshman 15 to shame!
Game Room
Stocked Kitchen
Happy Hours
Weekly Thursday Happy Hours
Parking
Company paid parking onsite or $100/mo parking waiver
Pet Friendly
Your pets can work alongside David Bowie (dog)
Recreational Clubs
We offer a variety of clubs like our dodgeball league, monthly book club, hiking club, and more
Relocation Assistance
Fitness Subsidies
- ClassPass Membership
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Promote from within

Additional Perks + Benefits

Working at GoodRx means you can take pride in knowing that your work has a direct and meaningful impact on our users day to day lives. We are disrupting the healthcare space by making prescription drugs accessible and affordable to Americans.

Aside from a great office environment and "perks", the real benefit is working alongside an empowering leadership team, wickedly smart colleagues all while providing a service that helps its customers.

Social Good + Successful Business Model + Great Colleagues = GoodRx

More Jobs at GoodRx66 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Marketing
new
Santa Monica
Project Mgmt
new
Santa Monica
Developer
new
Santa Monica
Marketing
new
Santa Monica
Operations
new
Santa Monica
Design + UX
new
Santa Monica
Sales
new
Santa Monica
Sales
new
Santa Monica
Developer
new
Santa Monica
Marketing
new
Santa Monica
Data + Analytics
new
Santa Monica
Data + Analytics
new
Santa Monica
HR + Recruiting
new
Santa Monica
Finance
new
Santa Monica
Developer
new
Santa Monica
Marketing
new
Santa Monica
Content
new
Santa Monica
Content
new
Santa Monica
Content
new
Santa Monica
Content
new
Santa Monica
Content
new
Santa Monica
Developer
new
Santa Monica
Content
new
Santa Monica
Marketing
new
Santa Monica
Project Mgmt
new
Santa Monica
Data + Analytics
new
Santa Monica
Design + UX
new
Santa Monica
Developer
new
Remote
Product
new
Santa Monica
Developer
new
Santa Monica
Operations
new
Santa Monica
Design + UX
new
Santa Monica
Developer
new
Santa Monica
Data + Analytics
new
Santa Monica
Project Mgmt
new
Santa Monica
HR + Recruiting
new
Santa Monica
Product
new
Santa Monica
Developer
new
Santa Monica
HR + Recruiting
new
Santa Monica
Product
new
Santa Monica
Marketing
new
Santa Monica
Design + UX
new
Santa Monica
Design + UX
new
Santa Monica
Design + UX
new
Santa Monica
Data + Analytics
new
Santa Monica
Developer
new
Santa Monica
Data + Analytics
new
Santa Monica
Design + UX
new
Santa Monica
Developer
new
Santa Monica
Developer
new
Santa Monica
Design + UX
new
Santa Monica
Design + UX
new
Santa Monica
Data + Analytics
new
Santa Monica
Data + Analytics
new
Santa Monica
Marketing
new
Santa Monica