Prepare for and practice interview questions from Scientific Games.

Scientific Games Interview Questions

Scientific Games 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

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Scientific Games Salaries by Position

Scientific Games: Scientific Games is the global leader in lottery games, sports betting and technology, and the partner of choice for government lotteries. From cutting-edge backend systems to exciting entertainment experiences and trailblazing retail and digital solutions, we elevate play every day. We push game designs to the next level and are pioneers in data analytics and iLottery. Built on a foundation of trusted partnerships, Scientific Games combines relentless innovation, legendary performance, and unwavering security to responsibly propel the global lottery industry ever forward. Position Summary iLottery Business Intelligence Analyst The Insights Analyst will provide dedicated analytic expertise for the Lottery Insights group by supporting a specific interactive lottery customer. This role will be customer-facing and be participating in regular presentations and meetings with key stakeholders. The Insights Analyst will use data, tools, and analytic techniques to evaluate industry performance in a number of areas. This includes analysis of internet sales, products, consumers, operations and primary customer research. An in-depth knowledge of spreadsheet applications such as Microsoft Excel is required. Knowledge of SQL is required, with the ideal candidate able to independently write SQL to perform various data extraction and aggregation tasks. Demonstrated proficiency with Tableau is also required. Knowledge of A/B testing is preferred. The Insights Analyst should be naturally curious, excited about analysis, and a good data storyteller. We are looking for a problem solver that can think critically and provide data driven Insights using visualization best practices as needed to our many stakeholders. Key Responsibilities <ul> <li>Independently maintain and refine key analytic products that are relied upon substantially within the organization </li><li>Proactively generate insights based on regular evaluations of the ilottery marketplace </li><li>Answer complex ad-hoc questions that arise from internal/external stakeholders </li><li>Work to develop new KPI's that can be used by the organization and our customers </li><li>Provide regular reporting of industry trends and happenings to key stakeholders </li><li>Use Business Intelligence tools such as Tableau to create and distribute content for our many stakeholders </li><li>Support the onsite team with any validation or operations reporting they require </li><li>Develop and maintain strong working relationships with key customer stakeholders </li></ul>Required Skills and Experience <ul> <li>Critical thinker that can provide valuable business insights based on the analysis of data </li><li>Strong Tableau background is highly desirable </li><li>Willingness to own detailed data validation and routine tasks associated with data projects </li><li>Highly organized and capable of independently managing complex analytic projects and products </li><li>Strong communicator, with the ability to express findings to a variety of audiences in both written and oral forms using a combination of Tableau, Microsoft Excel, and Microsoft PowerPoint. </li><li>Deep knowledge of Microsoft Excel is required <ul> <li>This includes the use of pivot tables, vlookup or index/match, "ifs" statements, conditional formatting, array formulas, etc. </li></ul> </li><li>Desire and ability to become substantially adept at using SQL to extract and aggregate data is required; prior experience is strongly desired. </li><li>Must have a mentality that aligns with continuous learning, improvement, and personal growth </li><li>Must be a self-starter who can independently research, identify appropriate methods, and solve problems </li><li>Occasional travel is required for this role (10%) </li><li>Must have attained at least a bachelor's degree from an accredited university </li><li>Past experience with click-stream data a plus </li><li>Experience with A/B testing and associated analysis is a plus </li></ul> Supervisory Responsibilities This position has no supervisory responsibilities. Job Level Description Works on short-term assignments that often require the application of independent judgment. Fully competent, career-level individual contributor. Qualifications Education Bachelors degree in related field. Years of Related Experience Years of experience 5 to 8 years Physical Requirements The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, stand, walk, bend, use hands, operate a computer, and have specific vision abilities to include close and distance vision, and ability to adjust focus working with computer and business equipment. Work Conditions Scientific Games, LLC and its affiliates (collectively, "SG") are engaged in highly regulated gaming and lottery businesses. As a result, certain SG employees may, among other things, be required to obtain a gaming or other license(s), undergo background investigations or security checks, or meet certain standards dictated by law, regulation or contracts. In order to ensure SG complies with its regulatory and contractual commitments, as a condition to hiring and continuing to employ its employees, SG requires all of its employees to meet those requirements that are necessary to fulfill their individual roles. As a prerequisite to employment with SG (to the extent permitted by law), you shall be asked to consent to SG conducting a due diligence/background investigation on you. This job description should not be interpreted as all-inclusive; it is intended to identify major responsibilities and requirements of the job. The employee in this position may be requested to perform other job-related tasks and responsibilities than those stated above. SG is an Equal Opportunity Employer and does not discriminate against applicants due to race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. If you'd like more information about your equal employment opportunity rights as an applicant under the law, please click here for EEOC Poster.

Scientific Games Interview Questions

Scientific Games Interview Guides

Scientific Games Interview Questions

Scientific Games Salaries by Position

Scientific Games Opening Jobs