Lead Data Analyst

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 $60 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 curious data analysts who are deft at working with SQL and who are comfortable with a variety of databases and raw data formats. We function in a fast-paced and friendly environment. You will collaborate and work with teams across the organization to ensure our data standards, pipelines and processes are held to high standards in order to guide finance, product, and marketing decisions. 
The duties and responsibilities of a data analyst include more than collecting and analyzing data. They also have to make this data accessible to those who need the information to streamline business processes. In general, the day-to-day activities of a data analyst may include the following: 

Responsibilities:

• Monitor database content and provide recommendations to ensure that data quality, sanity, and accuracy are upheld 
• Collaborate with a range of cross-functional stakeholders in multiple departments to understand data content, clarify business requirements, and formulate recommendations
• Collaborate with Data Engineering to create Enterprise level data sets
• Perform intensive investigation and analysis of data anomalies and determine root causes
• Perform statistical analysis of large datasets
• Develop and manage monthly reporting for a range of internal customers
• Develop reporting tools & content to identify data outliers and issues
• Build valuable insights for our stakeholders by performing the analytical work to enable fast and accurate attribution and adjudication of prescription claims and coupons as well as improve vendor & pharmacy relationships and maximize patient savings
• Analyze utilization patterns of GoodRx’s core product to inform product and marketing decisions and strategic planning
• Monitor transaction performance, implement automated reporting and conduct deep dives on drivers behind trends and anomalies that impact GoodRx’s top key results dramatically 

Skills & Qualifications:

• The ideal candidate for this role is someone who enjoys both being in-the-weeds with data and synthesizing analyses for non-technical collaborators and product leadership
• Ability to work extensively with SQL
• Proven ability to manipulate and interpret data to produce insights and recommendations across large/diverse datasets
• Ability to communicate complex ideas clearly and concisely, verbally and in writing
• Presentation-building skills (PowerPoint, Google Slides, etc.) and a good eye for concise data visualization (Excel, Google Charts, etc)
• Ability to triage suspected inconsistency with data and work through SQL scripts to determine root cause
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Ability to define and manage overall schedule and availability for a variety of data sets
• Use of data mining techniques to extract information from data sets and identify correlations and patterns to help build and improve our products
• Knowledge of statistics and experience using one or more statistical packages for analyzing datasets (Excel, SPSS, SAS, etc.)
• Proven working experience as a Data Analyst or Business Data Analyst

Nice to Have:

• Experience with writing LookML and Looker and/or Tableau
• Experience with DBT

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