The GoodRX Business Intelligence interview guide, interview questions, salary data, and interview experiences.

GoodRX Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at GoodRX? The GoodRX Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for GoodRX Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at GoodRX.</li>
<li>Practice real GoodRX Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the GoodRX Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at GoodRX? The GoodRX Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for GoodRX Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at GoodRX.
- Practice real GoodRX Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the GoodRX Business Intelligence interview.
        

Overview

GoodRX Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

GoodRX Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

<p><strong>Input:</strong></p>

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

GoodRX Business Intelligence Interview Questions

<p><b>GoodRx is the leading prescription savings platform in the U.S. </b>Trusted by more than 25 million consumers and 750,000 healthcare professionals annually, GoodRx provides access to savings and affordability options for generic and brand-name medications at more than 70,000 pharmacies nationwide, as well as comprehensive healthcare research and information. Since 2011, GoodRx has helped consumers save nearly $75 billion on the cost of their prescriptions.<br><br>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.<br><br><b>About the Role:</b><br><br>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.<br><br><b>Responsibilities:</b><br><br><ul><li>Collaborate with product managers, data scientists, data analysts and engineers to define requirements and data specifications.</li><li>Plan, design, build, test and deploy data warehouse and data mart solutions.</li><li>Leading small to medium size projects, solve data problems through the documentation, design and creation of ETL jobs, data marts.</li><li>Works to increase the usage and value of the data warehouse and ensures the integrity of the data delivered.</li><li>Develops and implements standards, and promotes their use throughout the warehouse</li><li>Develop, deploy and maintain data processing pipelines using cloud technology such as AWS, Kubernetes, Airflow, Redshift, Databricks, EMR.</li><li>Define and manage overall schedule and availability for a variety of data sets.</li><li>Work closely with other engineers to enhance infrastructure, improve reliability and efficiency.</li><li>Make smart engineering and product decisions based on data analysis and collaboration.</li><li>Act as an in house data expert and make recommendations regarding standards for code quality and timeliness.</li><li>Architect cloud-based data pipeline solutions to meet stakeholder needs.</li></ul><br><b>Skills & Qualifications:</b><br><br><ul><li>Bachelor's degree in analytics, engineering, math, computer science, information technology or related discipline.</li></ul><ul><li>8+ years professional experience in the big data space.</li><li>8+ years' experience in engineering data pipelines using big data technologies (Spark, Flink etc...) on large scale data sets.</li><li>Expert knowledge in writing complex pySpark, SQL, dbt and ETL development with experience processing extremely large datasets.</li></ul><ul><li>Expert in applying SCD types on S3 data lake using Databricks/Delta Lake.</li></ul><ul><li>Experience with data model principles and data cataloging.</li><li>Experience with job scheduler Airflow or similar.</li><li>Demonstrated ability to analyze large data sets to identify gaps and inconsistencies, provide data insights, and advance effective product solutions.</li><li>Deep familiarity with AWS Services (S3, Event Bridge, Kinesis, Glue, EMR, Lambda).</li><li>Experience with data warehouse platforms such as Redshift, Databricks, Big Query, Snowflake.</li><li>Ability to quickly learn complex domains and new technologies.</li><li>Innately curious and organized with the drive to analyze data to identify deliverables, anomalies and gaps and propose solutions to address these findings.</li><li>Thrives in a fast-paced startup environment.</li></ul><br><b>Good To Have:</b><br><br><ul><li>Experience with customer data platform tools such as Segment.</li><li>Experience with data streaming such as Kafka.</li><li>Experience using Jira, GitHub, Docker, CodeFresh, Terraform.</li><li>Experience contributing to full lifecycle deployments with a focus on testing and quality.</li><li>Experience with data quality processes, data quality checks, validations, data quality metrics definition and measurement.</li><li>AWS/Kafka/Databricks or similar certifications.</li></ul><br>Engineering teams are responsible for supporting appropriate security controls, including management, operational, and technical controls in addition to general GoodRx best practices, such as reading and adhering to the security policies and procedures, being vigilant and observant of potential security threats, etc.<br><br>At GoodRx, pay ranges are determined based on work locations and may vary based on where the successful candidate is hired. The pay ranges below are shown as a guideline, and the successful candidate's starting pay will be determined based on job-related skills, experience, qualifications, and other relevant business and organizational factors. These pay zones may be modified in the future. Please contact your recruiter for additional information.<br><br>San Francisco and Seattle Offices:<br>$161,000.00 - $257,000.00<br><br>New York Office:<br>$147,000.00 - $235,000.00<br><br>Santa Monica Office:<br>$134,000.00 - $214,000.00<br><br>Other Office Locations:<br>$121,000.00 - $193,000.00<br><br>GoodRx also offers additional compensation programs such as annual cash bonuses and annual equity grants for most positions as well as generous benefits. Our great benefits offerings include medical, dental, and vision insurance, 401(k) with a company match, an ESPP, unlimited vacation, 13 paid holidays, and 72 hours of sick leave. GoodRx also offers additional benefits like mental wellness and financial wellness programs, fertility benefits, generous parental leave, pet insurance, supplemental life insurance for you and your dependents, company-paid short-term and long-term disability, and more!<br><br>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 a seat at the table and the tools, resources, and opportunities to excel.<br><br>With that said, research shows that women and other underrepresented groups apply only if they meet 100% of the criteria. GoodRx is committed to leveling the playing field, and we encourage women, people of color, those in the LGBTQ+ communities, individuals with disabilities, and Veterans to apply for positions even if they don't necessarily check every box outlined in the job description. Please still get in touch - we'd love to connect and see if you could be good for the role!<br><br>GoodRx is committed to providing reasonable accommodations for candidates with disabilities during our recruiting process. If you need any assistance or accommodations due to a disability, please reach out to us at <a href="mailto:accommodations@goodrx.com">accommodations@goodrx.com</a>.<br><br>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 tele-health marketplace for online doctor visits and lab tests. Since 2011, Americans with and without health insurance have saved $60 billion using GoodRx and million consumers visit <a href="http://goodrx.com/">goodrx.com</a> 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 <a href="http://www.goodrx.com/">www.goodrx.com</a>.</p>

GoodRX Business Intelligence Interview Guide

Overview

GoodRX Business Intelligence Salary

GoodRX Business Intelligence Interview Process

GoodRX Business Intelligence Interview Questions

GoodRX Business Intelligence Jobs