Prepare for and practice interview questions from Abt Associates.

Abt Associates Interview Questions

Abt Associates Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Abt Associates Salaries by Position

Job Description The World at Abt Solving the world's most pressing issues and improving the quality of life for people worldwide is what we do every day at Abt Global. Creating a more equitable world is no small task, but we are driven by big challenges. We are a team of 3,000+ people in over 50 countries working in unison and focused on the bigger picture. Only by sharing our commitment, energy, and innovation do we affect change and push the boundaries of what's possible. We welcome diverse ideas, backgrounds, and viewpoints - joining Abt means access to exceptional thinkers at the top of their game. To thrive at Abt is to embrace flexibility and collaboration. Our open culture allows you to balance your work and personal life as needed to optimize personal well-being. Creating a more equitable world starts from within - we look after people around the world, and we'll do the same for you. Ready to embrace rewarding and meaningful work? Now's your chance. The Opportunity Abt Global is seeking a data scientist to join its growing team in the Digital and Data Services (DDS) Division. This division plays a key role within Abt providing data science methods, artificial intelligence (AI), and automation tools to a broad range of U.S. government agencies. Much of this work is focused on data modernization and analysis in areas such as healthcare, public health, housing, the environment, and human services. The Medicaid Data Scientist works with internal colleagues and external clients to answer complex technical questions. They will perform data cleaning and automated scripts, analyze textual and numerical data, and may utilize various tools to deploy generative AI, natural language processing, and machine learning workflows. This specialized Medicaid position will work in the CMS data ecosystem, with much analysis occurring in the CMS Cloud and CMCS's DataConnect environment. The selected candidate must be experienced in data science methods, with preference given to experience with Python. Experience with TMSIS data or other types of healthcare claims or electronic health record (EHR) data is preferred. The Medicaid Data Scientist may work on-site in Abt's offices in any of Atlanta, GA, Cambridge, MA, Durham, NC, or Rockville, MD in a hybrid remote/in-person status, or full-time remote from within the US. Core Responsibilities The successful hire will be able to perform the following functions and have the following mix of experience and skills: <ul> <li>Lead tasks, including organizing work plans and delegating work, with minimal supervision.</li> <li>Develop technical solutions to complex problems through ingenuity and innovation.</li> <li>Collect data from various sources, such as APIs, and perform data management tasks.</li> <li>Support data modernization efforts and develop/improve automated data workflows.</li> <li>Experience with generative AI, natural language processing, and/or machine learning methods.</li> <li>Programming proficiency in Python, SQL, and version control (git) software.</li></ul> What We Value <ul> <li>PhD in Health Informatics or similar degree with 0 years experience, or Masters + 3 years experience or Bachelors + 5 years experience, OR the equivalent combination of education and experience.</li> <li>Experience working with healthcare claims data, EHR data, or TMSIS data.</li> <li>Must have a current CMS PIV card or the ability to successfully obtain one.</li> <li>CMS experience, or other government or public sector experience strongly preferred.</li> <li>Experience with TMSIS data (Medicaid data) is strongly preferred.</li> <li>Strong writing, presentation, and interpersonal communication skills.</li></ul> What We Offer We foster an environment where you can Thrive Your Way. Our innovative total rewards programs are designed to help balance your work and personal life. The approach toward your wellbeing centers around comprehensive benefits, flexible schedules, and professional development. Abt Global is an Affirmative Action/Equal Opportunity employer committed to fostering a diverse workforce. Abt Global provides market-competitive salaries and comprehensive employee benefits. Local candidates strongly encouraged to apply. This position offers an anticipated annual base salary range of approximately $83,000 to $132,000 and may vary by ten percent depending on candidate geographic location. Salary offers are made based on internal equity and market analysis. Disclaimer: Abt Global will never ask candidates for money in exchange for an offer of employment. #LI-Remote #LI-Hybrid

Abt Associates Interview Questions

Abt Associates Interview Guides

Abt Associates Interview Questions

Abt Associates Salaries by Position

Abt Associates Opening Jobs