Prepare for and practice interview questions from Grayce.

Grayce Interview Questions

Grayce 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?

Grayce Salaries by Position

Job Position: Graduate Business Analyst - Accelerated Lab Data Program Location: Gaithersburg, Maryland Starting Salary: $52,500 Additional Information: A medical or scientific background and experience within a lab setting is advantageous Please note that Grayce is unable to sponsor work visas for International applicants. Change and transformation for the world's most ambitious organizations Grayce partners with some of the world's most ambitious organizations to help deliver change and transformation. With over a decade's experience developing and deploying high-performing talent, Grayce delivers a low-risk and scalable solution and enables long-term capability build. Our Accelerated Development Program has enabled thousands of talented individuals to launch successful careers. The Role Project: Producing automized data workflows across multiple laboratory locations throughout the US, with the goal to deliver a simple and effective system Accreditations: Agile PM foundation and practitioner, IIBA, CMI level 3 Skill Set: Strong stakeholder management, confident communicator, adaptable and proactive, JIRA, diagramming tools e.g. Visio Progression: Within this role you will transition to working for the end user client at the end of the two-year development program Why Grayce? Our Analysts are actively involved in major global transformation programmes across diverse industries. Opportunity: You'll embark on a journey of continuous learning, gaining industry-accredited qualifications, whilst getting hands-on experience working full time on site directly with prestigious FTSE100, 250, and 500 organisations. Delivery: You will work with one client, delivering high quality outcomes during your Grayce tenure, before transitioning to working directly for them. The skills required for exceptional client delivery include natural curiosity, proactivity, adaptability, effective communication and problem solving. Mentoring: Thrive under the guidance of our experienced Delivery Managers and Technical Trainers. They'll be your go-to, offering support, insights, sharing experiences. What makes a great Grayce Analyst? 3.3/4 GPA or higher: Within a Scientific or Medical focused pathway. Right to Work in the US: Unfortunately, we are unable to sponsor visas, so please make sure you have everything sorted before applying! Effective communication: Communication is key in change and transformation. We value those who can express themselves clearly, whether it's chatting with the team, updating stakeholders, or putting thoughts on paper. Being precise and persuasive with your words is one of your greatest tools. Organizational and planning skills: Time management, task prioritization, and structured working are your bread and butter. You'll be the project-focused expert who keeps timelines and resources in check, ensuring everything runs like clockwork. Proactivity and Creativity: Creativity is essential for driving innovation. Product managers need to come up with new ideas and solutions to meet customer needs and stay ahead of the competition. Creativity enables them to think outside the box and develop novel features, products, and strategies. Adaptability: Markets, technologies, and customer preferences are constantly evolving. Creative product managers are better equipped to adapt to change, pivot when necessary, and seize new opportunities. Why Work for Us? Starting Salary: $52,500, and it gets even better after your first year! PTO: You start off with 12 days, and it goes up by one day every year you're with us. Medical, Vision & Dental: We've got you covered. Grayce covers 60% of the medical, vision and dental gold package. 401(k) Personal Pension: For every 1% you contribute, Grayce chips in 0.5% (with a max 7% employee contribution).

Grayce Interview Questions

Grayce Interview Guides

Grayce Interview Questions

Grayce Salaries by Position

Grayce Opening Jobs