Senior Data Engineer I

GoodRx is America’s healthcare marketplace. Each month, millions of people visit goodrx.com to find reliable health information and discounts for their healthcare — and we’ve helped people save over $55 billion since 2011. We provide prescription discounts that are accepted at more than 70,000 pharmacies in the U.S., as well as telehealth services including doctor visits and lab tests. Our services have been positively reviewed by Good Morning America, The New York Times, NBC News, AARP, and many others.
Our goal is to help Americans find convenient and affordable healthcare. We offer solutions for consumers, employers, health plans, and anyone else who shares our desire to provide affordable prescriptions to all Americans.
About the Role:GoodRx is looking for extremely smart and curious data engineers, who are deft at working with a wide variety of languages, a variety of raw data formats, such as parquet, in a fast-paced and friendly environment. You will collaborate and work with teams across GoodRx to build outstanding data pipelines and processes that stitch together complex sets of data stores in order to guide business decisions.

Responsibilities:

• Collaborate with product managers, data scientists, data analysts and engineers to define requirements and data specifications.
• Plan, design, build, test and deploy data warehouse and data mart solutions. 
• Leading small to medium size projects, solve data problems through the documentation, design and creation of ETL jobs, data marts.
• Works to increase the usage and value of the data warehouse and ensures the integrity of the data delivered.
• Develops and implements standards, and promotes their use throughout the warehouse
• Develop, deploy and maintain data processing pipelines using cloud technology such as AWS, Kubernetes, Airflow, Redshift, EMR.
• Define and manage overall schedule and availability for a variety of data sets.
• Work closely with other engineers to enhance infrastructure, improve reliability and efficiency.
• Make smart engineering and product decisions based on data analysis and collaboration.
• Act as in house data expert and make recommendations regarding standards for code quality and timeliness.
• Architect cloud-based data infrastructure solutions to meet stakeholder needs.

Skills & Qualifications:

• Bachelor’s degree in analytics, engineering, math, computer science, information technology or related discipline
• 5+ years professional experience in the big data space
• 5+ years' experience in engineering data pipelines using big data technologies (Spark, Flink etc...) on large scale data sets.
• Expert knowledge in writing complex pySpark, SQL, dbt and ETL development with experience processing extremely large datasets
• Expert in applying SCD types on S3 data lake using Databricks/Delta Lake
• Experience with data model principles and data ctaloging
• Experience with job scheduler Airflow or similar
• Demonstrated ability to analyze large data sets to identify gaps and inconsistencies, provide data insights, and advance effective product solutions.
• Deep familiarity with AWS Services (S3, Event Bridge, Glue, EMR, Redshift, Lambda)
• Ability to quickly learn complex domains and new technologies
• Innately curious and organized with the drive to analyze data to identify deliverables, anomalies and gaps and propose solutions to address these findings
• Thrives in fast-paced startup environment

Good To Have:

• Experience with customer data platform tools such as Segment.
• Experience with data streaming such as Kafka.
• Experience using Jira, GitHub, Docker, CodeFresh, Terraform.
• Experience contributing to full lifecycle deployments with a focus on testing and quality.
• Experience with data quality processes, data quality checks, validations, data quality metrics definition and measurement.

Compensation decisions are determined using a variety of factors such as skill set, experience, and education or certifications. If we extend an offer for employment, we will consider all individual qualifications. Below are our salary ranges for this position based on office location:
San Francisco Office: $143,000 - $229,000New York Office: $131,000 - $210,000
GoodRx also offers additional compensation programs such as annual cash bonuses, annual equity grants for most positions, and generous benefits. Our great benefits offerings include medical, dental, and vision insurance, 401(k) with a company match, an ESPP, unlimited vacation, 11 paid holidays, and 72 hours of sick leave. GoodRx also offers additional benefits like mental wellness and financial wellness programs, fertility benefits, supplemental life insurance for you and your dependents, compan