Senior Data Engineer
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 don't get the care they need, and prices just keep rising. We started with prescriptions, and we've helped over 100 million Americans save over $15 billion to date. Now, we're aiming to tackle all of healthcare. 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 problems. If you share our belief that you can do well by doing good, let's talk.
About the Role
GoodRx is looking for extremely smart and curious Senior Data Engineers, who are deft at working with a wide variety of languages, such as Python and SQL, a variety of raw data formats, such as JSON and CSV, in a fast-paced and friendly environment. Previous work with Python-based ETL solutions, such as Luigi or Airflow, is a huge plus.
Responsibilities:
- Analyze, design, develop, test and implement data warehouse and business intelligence solutions with emphasis on data quality
- Design highly scalable ETL processes with complex data transformations
- Gather and document business requirements and translate into technical architecture/design
- Ability to understand and document data flows in and between different systems and map data from a data source to target tables in a data warehouse
- 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 an in-house data expert and make recommendations regarding standards for code quality and timeliness
Skills & Qualifications:
- Degree in Computer Science or a related field or 5+ years of professional experience in developing ETL and data warehouse solutions
- In depth knowledge of how to write and optimize SQL statements
- Deep familiarity with distributed processing (Map Reduce, MPP, etc.)
- 3+ years experience with schema design (logical and physical)
- Strong experience with data integration tool sets
- Experience with cloud solutions (AWS, Redshift, Snowflake, other) is a must
- Strong programming (Java/C# or related) and scripting skills (Python/Javascript) is a plus
- Experience with workflow management tools (Airflow, Luigi etc) helpful
- Ability to quickly learn complex domains
- Strong attention to detail with excellent analytical, problem-solving, and communication skills
About GoodRx
GoodRx is the country's leading marketplace for affordable and convenient healthcare. The company offers the most comprehensive and accurate resource for prescription medications in the U.S., gathering pricing information from thousands of pharmacies coast to coast. More than 12 million consumers use GoodRx each month to find current prices and discounts for their medications. Since 2011, Americans with and without health insurance have saved more than $15 billion using GoodRx – more than $5 billion in 2019 alone. With GoodRx Care, Americans can get an online medical visit with a skilled physician for fast and easy treatment, prescriptions, and lab tests for routine medical issues. GoodRx is the #1 medical app on the iOS and Android app stores and tens of thousands of doctors recommend GoodRx to their patients. For more information, visit www.goodrx.com.