Prepare for and practice interview questions from System One.

System One Interview Questions

System One Interview Guides

Machine Learning

How would you encode a categorical variable with thousands of distinct values

Encoding Categorical Features

Which model would perform better and why?

Booking Regression

How do we deal with the missing square footage data to construct our model

Missing Housing Data

How would we build a model to detect fraud and text customers to approve or deny fraudulent transactions

Bank Fraud Model

How would we know if we have enough data to create an accurate enough model?

One Million Rides

Data Structures & Algorithms

Given two sorted lists, write a function to merge them into one sorted list.

Merge Sorted Lists

Find the missing integer from a array of consequtive integers

Find the Missing Number

Write a function n_frequent_words that returns the top N frequent words and their frequencies, and state its run-time

Get Top N Frequent Words

Write a function to return the names and resume IDs for resumes whose IDs have not already been scraped

New Resumes

Given an integer N, write a function that returns all of the prime numbers up to N

Prime to N

Write a query to select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Employee Salaries

Select the 2nd highest salary in the engineering department

2nd Highest Salary

Calculate the first touch attribution for each `user_id` that converted.

First Touch Attribution

Write a query to return the two students with the closest test scores and the score difference

Closest SAT Scores

Write a query to get the total three-day rolling average for deposits by day

Rolling Bank Transactions

Probability

First to Six

What is the probability that each subsequent card is larger than the previous drawn card when picking three cards from a shuffled deck of 500 cards

500 Cards

What is the probability that it's actually raining in Seattle?

Raining in Seattle

What is the probability that item X would be found on Amazon's website?

Found Item

Given three uniform(0,4) random variables, what is the probability that the median of them is greater than 3?

Median Probability

Data Modeling

Design a data warehouse for a new online retailer

Retailer Data Warehouse

Design a database schema for a Tinder-style dating app and discuss needed optimizations

Swiping App Design

System design for a digital classroom service.

Digital Classroom System Design

Use of foreign key constraints instead of BIGINTS

Foreign Key Constraints

Design a database for a stand-alone fast food restaurant

Fast Food Database

<p>Write a SQL query to select the 2nd highest salary in the engineering department.</p>

<p><strong>Note:</strong> If more than one person shares the highest salary, the query should select the next highest salary.</p>

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

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

<p><code>employees</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>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>departments</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>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


<p>Given the <code>employees</code> and <code>departments</code> table, write a query to get the top 3 highest employee salaries by department. If the department contains less that 3 employees, the top 2 or the top 1 highest salaries should be listed (assume that each department has at least 1 employee). </p>

<p><em>Note: The output should include the full name of the employee in one column, the department name, and the salary. The output should be sorted by department name in ascending order and salary in descending order.</em> </p>

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

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

<p><code>employees</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>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>departments</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>employee_nam</code>e</td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>department_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Get the top 3 highest employee salaries by department

Top Three Salaries

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


<p>Given a table of students and their SAT test scores, write a query to return the two students with the closest test scores with the score difference.</p>

<p>If there are multiple students with the same minimum score difference, select the student name combination that is higher in the alphabet. </p>

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

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

<p><code>scores</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>student</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>score</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

<tr>
<td><code>other_student</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>score_diff</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


<p>Given two sorted lists, write a function to merge them into one sorted list.</p>

<p><em>Bonus: What’s the time complexity?</em></p>

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

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">list1</span> <span class="o">=</span> <span class="p">[</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">5</span><span class="p">]</span>
</span></span><span class="line"><span class="cl"><span class="n">list2</span> <span class="o">=</span> <span class="p">[</span><span class="mi">2</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">6</span><span class="p">]</span>
</span></span></code></pre>

<p><strong>Output:</strong></p>

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="k">def</span> <span class="nf">merge_list</span><span class="p">(</span><span class="n">list1</span><span class="p">,</span><span class="n">list2</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="p">[</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">]</span>
</span></span></code></pre>


<p>You have two sorted lists, one with m elements and one with n elements. What would be the time complexity of merging the two lists via merge sort?</p>


You have two sorted lists, one with m elements and one with n elements. What would be the time complexity of merging the two lists via merge sort? 

Merging Lists Complexity

<p>Given a <code>employees</code> and <code>departments</code> table, select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.</p>

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

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

<p><code>employees</code> table</p>

<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>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>departments</code> table</p>

<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>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>percentage_over_100k</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>department_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>number_of_employees</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


<p>Given a table called <code>employees</code>, get the largest salary of any employee by department</p>

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

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

<p><code>employees</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>department</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

<tr>
<td><code>largest_salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Write a query to get the largest salary of any employee by department

Largest Salary by Department

<p>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.</p>

<p>How would you assess the validity of the result?</p>


How would you assess the validity of the result?

Experiment Validity

A/B Testing

<p>The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.</p>

<ul>
<li><p>The attribution table logs a session visit for each row.</p></li>

<li><p>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</p></li>

<li><p>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</p></li>

<li><p>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</p></li>
</ul>

<p>First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.</p>

<p>Calculate the first touch attribution for each <code>user_id</code> that converted. </p>

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

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

<p><code>attribution</code> table</p>

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

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

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<p><code>user_sessions</code> table</p>

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Example output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>


<p>Given an integer <code>N</code>, write a function that returns a list of all of the prime numbers up to <code>N</code>.</p>

<p><em>Note: Return an empty list there are no prime numbers less than or equal to <code>N</code>.</em></p>

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

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">N</span> <span class="o">=</span> <span class="mi">3</span>
</span></span></code></pre>

<p><strong>Output:</strong></p>

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="k">def</span> <span class="nf">prime_numbers</span><span class="p">(</span><span class="n">N</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="p">[</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]</span>
</span></span></code></pre>


<p>Amy and Brad take turns in rolling a fair six-sided die. Whoever rolls a “6” first wins the game. Amy starts by rolling first.</p>

<p>What’s the probability that Amy wins?</p>


Amy and Brad take turns in rolling a fair six-sided die. Whoever rolls a “6” first wins the game. Amy starts by rolling first.

What’s the probability that Amy wins?

<p>Let’s say we’re comparing two machine learning algorithms. In which case would you use a bagging algorithm versus a boosting algorithm? </p>

<p>Give an example of the tradeoffs between the two.</p>


<p>In machine learning, when would you use a bagging algorithm over a boosting algorithm?</p>


In machine learning, when would you use a bagging algorithm over a boosting algorithm?

Bagging vs. Boosting

In which case would you use a bagging algorithm versus a boosting algorithm

Bagging vs Boosting

<p>Let’s say you work at a file-hosting website. You have information on user’s daily downloads in the <code>download_facts</code> table</p>

<p>Use the window function <code>RANK</code> to display the top three users by downloads each day. Order your data by <code>date</code>, and then by <code>daily_rank</code></p>

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

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

<p><code>download_facts</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>date</code></td>
<td>DATE</td>
</tr>

<tr>
<td><code>downloads</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

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

<tr>
<td><code>date</code></td>
<td>DATE</td>
</tr>

<tr>
<td><code>downloads</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Write a query to display the top three users by downloads each day

Top 3 Users

<p>You are about to get on a plane to Seattle. You want to know if you should bring an umbrella. You call 3 random friends of yours who live there and ask each independently if it’s raining. Each of your friends has a <sup>2</sup>⁄<sub>3</sub> chance of telling you the truth and a <sup>1</sup>⁄<sub>3</sub> chance of messing with you by lying. All 3 friends tell you that “Yes” it is raining.</p>

<p>What is the probability that it’s actually raining in Seattle?</p>


<p>What is the <strong>main</strong> difference between the Frequentist and Bayesian methods of probabilistic analysis?</p>


What is the **main** difference between the Frequentist and Bayesian methods of probabilistic analysis?

Frequentist Vs Bayesian Analysis

<p>Tell me about a data project that didn’t go the way you expected. What did you set out to do, what surprised you, and how did you handle it?</p>


Describing a data project and its challenges

Hurdles In Data Projects

Behavioral

<p>Let’s say you run a wine house. You have detailed information about the chemical composition of wines in a <code>wines</code> table.</p>

<p>One day, a customer comes asking specifically for a wine that has</p>

<ul>
<li>Greater or equal to than 13% alcohol content</li>
<li>Ash content less than 2.4</li>
<li>A color intensity less than 3</li>
</ul>

<p>Write a query to find the <code>id</code>s of suitable wines for this customer.</p>

<p><em>Note:</em> All percentages are reported with two numbers before the decimal point; for example, 13.55% is represented as <code>13.55</code> instead of <code>0.1355</code>.</p>

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

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

<p><code>wines</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>alcohol</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>malic_acid</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>ash</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>alcalinity_of_ash</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>magnesium</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>total_phenols</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>flavanoids</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>nonflavanoid_phenols</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>proanthocyanins</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>color_intensity</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>hue</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>od280_or_od315_of_diluted_wines</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>proline</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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


Let’s say you run a wine house. You have detailed information about the chemical composition of wines in a wines table.

SELECTive Wine Connoisseur

<p>You have an array of integers, <code>nums</code> of length <code>n</code> spanning <code>0</code> to <code>n</code> with one missing. Write a function <code>missing_number</code> that returns the missing number in the array.</p>

<p><em>Note: Complexity of $O(n)$ required.</em></p>

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

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">nums</span> <span class="o">=</span> <span class="p">[</span><span class="mi">0</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">]</span> 
</span></span><span class="line"><span class="cl"><span class="n">missing_number</span><span class="p">(</span><span class="n">nums</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="mi">3</span>
</span></span></code></pre>


<p>Say you are tasked with designing a data mart or data warehouse for a new online retailer.</p>

<p>How would you design the system?</p>

<p><em>Note: Sketch a star schema to explain your design.</em></p>


<p>How would you explain what a p-value is to someone who is not technical?</p>


<p>What does a p-value in a statistical test represent?</p>

What does a p-value in a statistical test represent?

P-value to a Layman I

<p>In a statistical test, how does a low p-value (less than 0.05) influence our decision about the null hypothesis?</p>

In a statistical test, how does a low p-value (less than 0.05) influence our decision about the null hypothesis?

P-value to a Layman II

Explain what a p-value is to someone who is not technical

P-value to a Layman

Statistics

<p>Imagine a deck of 500 cards numbered from 1 to 500. If all the cards are shuffled randomly and you are asked to pick three cards, one at a time, what’s the probability of each subsequent card being larger than the previous drawn card?</p>


<p>Imagine a deck of 2000 cards numbered from 1 to 2000. If all the cards are shuffled randomly and you are asked to pick three cards, one at a time, what’s the probability of each subsequent card being larger than the previously drawn card?</p>


Imagine a deck of 2000 cards numbered from 1 to 2000. If all the cards are shuffled randomly and you are asked to pick three cards, one at a time, what's the probability of each subsequent card being larger than the previously drawn card?

2000 cards

<p>Let’s say you work at Allstate. Allstate is running <code>N</code>  online ads right now. The table <code>ads</code> contains all those ads, ranked by popularity via the <code>id</code> column (e.g., the entry with <code>id = 1</code> is the most popular, etc.).</p>

<p>Create a subquery or common table expression named <code>top_ads</code> containing the top 3 ads (by popularity) and return the number of rows that would result from the following operations</p>

<ol>
<li><code>ads INNER JOIN top_ads</code></li>
<li><code>ads LEFT JOIN top_ads</code></li>
<li><code>ads RIGHT JOIN top_ads</code></li>
<li><code>ads CROSS JOIN top_ads</code></li>
</ol>

<p><em>Note: Please make the <code>join_type</code> column in your output have the values <code>inner_join</code>, <code>left_join</code>, etc. for each of their respective join types</em></p>

<p><em>Note: Please return only one query with each number in a different row</em></p>

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

<p><strong>Input:</strong></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>join_type</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>number_of_rows</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Create top_ads with the top 3 ads and return the row counts for inner, left, right, and cross joins with ads

Size of Joins

<p>Over budget on a project is defined when the salaries, prorated to the day, exceed the budget of the project.</p>

<p>For example, if Alice and Bob both combined income make 200K and work on a project of a budget of 50K that takes half a year, then the project is over budget given 0.5 * 200K = 100K &gt; 50K.</p>

<p>Write a query to forecast the budget for all projects and return a label of <code>&#34;overbudget&#34;</code> if it is over budget and <code>&#34;within budget&#34;</code> otherwise.</p>

<p><em>Note: Assume that employees only work on one project at a time.</em></p>

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

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

<p><code>employees</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>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>projects</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>title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>state_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>end_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>budget</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>departments</strong> 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><code>employee_projects</code> table</p>

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

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

<tr>
<td><code>employee_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

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


Write a query to forecast each project's budget and label it overbudget or within budget

Over-Budget Projects

<p>Let’s say you’re working in HR at a major tech company, and they ask you to find employees with a high probability of leaving the company. They tell you these employees perform well but have the lowest pay.</p>

<p>Given two tables, <code>employees</code>  and <code>projects</code>, find the five lowest-paid employees who have completed at least three projects.</p>

<p>Note: We consider projects to be completed when they have an end date, which is the same as saying their <code>End_dt</code> is not <code>NULL</code>.</p>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>employee_id</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the five employees with the hightest probability of leaving the company

Top 5 Turnover Risk

<p>Let’s say you have a categorical variable with thousands of distinct values, how would you encode it?</p>


<p>Which method can be used to extract communities from large networks, that does not require a pre-determined number of clusters like K-means?</p>

Which method can be used to extract communities from large networks, that does not require a pre-determined number of clusters like K-means?

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

<p>Given a table of <code>transactions</code> and <code>products</code>, write a function to get the <code>month_over_month</code> change in revenue for the year 2019. Make sure to round <code>month_over_month</code> to 2 decimal places.</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>products</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>

<tr>
<td><code>price</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>month</code></td>
<td>INTEGER</td>
</tr>

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


Write a function to get the month_over_month change in revenue for 2019 rounded to 2 decimal places

Month Over Month

<p>Write a Python function called <strong><code>max_profit</code></strong> that takes a list of integers, where the i-th integer represents the price of a given stock on day i, and returns the maximum profit you can achieve by buying and selling the stock.</p>

<p>You may complete, at most, two complete buy/sell transactions to maximize profits on a stock.</p>

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">prices</span> <span class="o">=</span> <span class="p">[</span><span class="mi">3</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span class="p">]</span>
</span></span></code></pre>

<p><strong>Output:</strong></p>

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="k">def</span> <span class="nf">max_profit</span><span class="p">(</span><span class="n">prices</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="mi">6</span>
</span></span></code></pre>

<p>Explanation:</p>

<pre><code>Buy on day 4 (price = 0) and sell on day 6 (price = 3): profit = 3 - 0 = 3.
Then buy again on day 7 (price = 1) and sell on day 8 (price = 4): profit = 4 - 1 = 3.
Total profit: 3 + 3 = 6.
</code></pre>


Find the maximum profit from at most two stock buy/sell transactions

Maximum Profit

<p>Let’s say we have two tables, <code>transactions</code> and <code>products</code>. Hypothetically the <code>transactions</code> table consists of over a billion rows of purchases bought by users.</p>

<p>We are trying to find paired products that are often purchased together by the same user, such as wine and bottle openers, chips and beer, etc..</p>

<p>Write a query to find the top five paired products and their names.</p>

<p><em>Notes:</em>
   <em>For the purposes of satisfying the test case, p2 should be the item that comes first in the alphabet.</em>
   <em>The <code>qty</code> column represents paired products count</em></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>products</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>

<tr>
<td><code>price</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>p1</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>p2</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>qty</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Paired Products

<p>There are two tables. One table is called <code>swipes</code> that holds a row for every Tinder swipe and contains a boolean column that determines if the swipe was a right or left swipe called <code>is_right_swipe</code>. The second is a table named <code>variants</code> that determines which user has which variant of an AB test.</p>

<p>Write a SQL query to output the average number of right swipes for two different variants of a feed ranking algorithm by comparing users that have swiped 10, 50, and 100 swipes in a <code>feed_change</code> experiment.</p>

<p><em>Note: Users have to have swiped at least 10 times to be included in the subset of users to analyze the mean number of right swipes.</em></p>

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

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

<p><code>variants</code> table</p>

<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>experiment</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>variant</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>swipes</code> table</p>

<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>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>swiped_user_id</code></td>
<td>INTEGER</td>
</tr>

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

<tr>
<td><code>is_right_swipe</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

<tr>
<td><code>mean_right_swipes</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>swipe_threshold</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_users</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Write a SQL query to find the average number of right swipes for different ranking algorithms.

Swipe Precision

<p>We’re given two tables. One is named <code>projects</code> and the other maps employees to the projects they’re working on. </p>

<p>We want to select the five most expensive projects by budget to employee count ratio. But let’s say that we’ve found a bug where there exist duplicate rows in the <code>employee_projects</code> table.</p>

<p>Write a query to account for the error and select the top five most expensive projects by budget to employee count ratio.</p>

<h3>Schema</h3>

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

<p><code>projects</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>title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>state_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>end_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>budget</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>employee_projects</code> table</p>

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

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

<tr>
<td><code>employee_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

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

<h3>Example</h3>

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

<p><strong><code>projects</code> table</strong></p>

<table>
<thead>
<tr>
<th>id</th>
<th>title</th>
<th>start_date</th>
<th>end_date</th>
<th>budget</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>party</td>
<td>2006-04-17 00:00:00</td>
<td>2006-05-19 00:00:00</td>
<td>25875</td>
</tr>

<tr>
<td>2</td>
<td>diversity</td>
<td>2017-08-09 00:00:00</td>
<td>2017-09-18 00:00:00</td>
<td>77867</td>
</tr>

<tr>
<td>3</td>
<td>integration</td>
<td>2005-06-29 00:00:00</td>
<td>2005-07-19 00:00:00</td>
<td>75987</td>
</tr>

<tr>
<td>4</td>
<td>testing</td>
<td>2009-01-12 00:00:00</td>
<td>2009-05-03 00:00:00</td>
<td>35946</td>
</tr>

<tr>
<td>5</td>
<td>launch</td>
<td>2005-05-02 00:00:00</td>
<td>2005-10-16 00:00:00</td>
<td>66292</td>
</tr>

<tr>
<td>6</td>
<td>meet</td>
<td>2001-09-09 00:00:00</td>
<td>2002-04-04 00:00:00</td>
<td>71243</td>
</tr>

<tr>
<td>7</td>
<td>payroll</td>
<td>2019-09-25 00:00:00</td>
<td>2020-05-05 00:00:00</td>
<td>97071</td>
</tr>

<tr>
<td>8</td>
<td>admin</td>
<td>2000-07-08 00:00:00</td>
<td>2000-09-10 00:00:00</td>
<td>24000</td>
</tr>

<tr>
<td>9</td>
<td>petronas</td>
<td>2016-07-01 00:00:00</td>
<td>2016-11-28 00:00:00</td>
<td>37088</td>
</tr>

<tr>
<td>10</td>
<td>bel</td>
<td>2005-08-03 00:00:00</td>
<td>2006-04-29 00:00:00</td>
<td>61937</td>
</tr>
</tbody>
</table>
<p><strong><code>employee_projects</code> table</strong></p>

<table>
<thead>
<tr>
<th>project_id</th>
<th>employee_id</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>7</td>
</tr>

<tr>
<td>1</td>
<td>9</td>
</tr>

<tr>
<td>2</td>
<td>6</td>
</tr>

<tr>
<td>3</td>
<td>1</td>
</tr>

<tr>
<td>3</td>
<td>2</td>
</tr>

<tr>
<td>4</td>
<td>5</td>
</tr>

<tr>
<td>5</td>
<td>3</td>
</tr>

<tr>
<td>5</td>
<td>4</td>
</tr>

<tr>
<td>6</td>
<td>8</td>
</tr>

<tr>
<td>8</td>
<td>10</td>
</tr>

<tr>
<td>9</td>
<td>11</td>
</tr>

<tr>
<td>10</td>
<td>12</td>
</tr>

<tr>
<td>5</td>
<td>5</td>
</tr>

<tr>
<td>9</td>
<td>11</td>
</tr>

<tr>
<td>6</td>
<td>8</td>
</tr>

<tr>
<td>4</td>
<td>5</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>title</th>
<th>budget_per_employee</th>
</tr>
</thead>

<tbody>
<tr>
<td>diversity</td>
<td>77867</td>
</tr>

<tr>
<td>meet</td>
<td>71243</td>
</tr>

<tr>
<td>bel</td>
<td>61937</td>
</tr>

<tr>
<td>integration</td>
<td>37993.5</td>
</tr>

<tr>
<td>petronas</td>
<td>37088</td>
</tr>
</tbody>
</table>


Project Budget Error

Challenge

<h3>Job Description</h3><div>Job Description<div><p>Job Title: Data Scientist<b> Location: Minneapolis, MN<b> <b> Job Summary: <b> System One is seeking a Data Scientist with 5+ years of hands-on experience to design, build, and deploy production-grade machine learning models. In this role, you will bridge the gap between traditional data science and software engineering by writing clean, modular Python code to build robust AI capabilities embedded directly into our enterprise products and systems.<b> <b> Responsibilities</b></b></b></b></b></b></p><ul><li>Design, train, and validate traditional predictive and analytical machine learning models (regression, classification, decision trees, time-series, and neural networks). </li><li>Write scalable, production-grade Python code to wrap models into microservices and expose them via RESTful APIs for real-time inference. </li><li>Build and maintain automated data preprocessing, feature engineering, and model evaluation pipelines using CI/CD and MLOps best practices. </li><li>Track model performance, data drift, and latency in production, ensuring reliability and accuracy over time. </li><li>Collaborate directly with executive leadership, product directors, and enterprise architects to define the AI/ML product roadmap. </li></ul> Requirements <ul><li>5-7+ years of progressive professional experience designing, shipping, and maintaining complex ML/AI solutions in enterprise production environments. </li><li>Experience building and deploying machine learning models in a production environment. </li><li>Strong practical experience with core ML algorithms (scikit-learn, XGBoost, LightGBM, statsmodels, PyTorch, or TensorFlow). </li><li>Demonstrated capability in writing clean, PEP 8-compliant, modular, and object-oriented Python code (beyond Jupyter notebooks). </li><li>Experience using automated testing frameworks (pytest, unittest) and writing unit/integration tests. </li><li>Hands-on experience developing RESTful APIs using frameworks like FastAPI or Flask. </li><li>Familiarity with containerization technologies (Docker) and version control workflows (Git, GitHub Actions, or GitLab CI/CD). </li><li>Advanced SQL proficiency and experience querying structured and unstructured datasets. </li><li>Bachelor’s or Master’s degree in Computer Science, Data Science, Statistics, Applied Mathematics, or a related quantitative field. </li></ul> Preferred Qualifications: <ul><li>Generative AI & Enterprise LLMs: Hands-on experience developing, fine-tuning (LoRA/QLoRA), or deploying proprietary Large Language Models (LLMs), agentic frameworks, custom embeddings, or enterprise RAG systems. </li><li>Experience with GPU acceleration frameworks (CUDA, TensorRT, vLLM, Ollama). </li><li>Demonstrated leadership in mentoring teams and defining enterprise data and AI governance policies. </li></ul><p>System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.</p><p>System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.</p><p>#M-1<b> #LI-SG1</b></p><b> <b>Ref: #431-IT Tampa<p><b></b></p></b></b></div></div>

<h3>Job Description</h3><div>Job Description<div><strong>Data Analyst/Dashboard Developer <b> Secret clearance required <b> must be able to obtain TS/SCI<b> Must be Security+ certified <b> Langley Air Force Base, VA – onsite<b> Direct Hire</b></b></b></b></b></strong> <b> <b> The Data Analyst / Dashboard Developer builds, maintains, and continuously improves the?live Performance Dashboard?that serves as the authoritative source for all contract performance data. Integrate data feeds from training systems, token management platforms, help desk operations, and workflow development pipelines into a unified dashboard accessible to the Contracting Officer's Representative (COR) and ACC leadership without requiring manual reports from the Program Manager. This is not a periodic reporting role. Build a?real-time performance intelligence system?that enables proactive decision-making, identifies emerging risks before they become performance failures, and demonstrates mission value through documented metrics. Works directly determines whether ACC leadership trusts the data they see—or whether they question every number. <b> <b> <strong>Required Qualifications:</strong> <b> • 3+ years?of DoD or federal government data analytics and dashboard development experience <b> • Proven track record building executive-level dashboards with automated data integration from multiple source systems <b> • Experience supporting performance-based contracts with KPI-driven QASP surveillance <b> • Familiarity with DoD data governance, security classification, and PII handling requirements <b> • CompTIA Security+?(DoD 8140.03 baseline) – Required <b> <b> <strong>Technical Proficiency (Required):</strong> <b> • Power BI?/ Power Automate proficiency –?Required?(must have hands-on experience building dashboards with automated data refresh, calculated fields, and drill-down capabilities) <b> • Advanced proficiency with?Microsoft Excel?(Power Query, Power Pivot, DAX formulas, pivot tables, advanced charting) <b> • SQL?query writing for data extraction and transformation <b> • Experience <span class="long-word">with?DAF365?and?SharePoint?environments</span> –?Strongly Preferred <b> • Familiarity with?Power Automate?for workflow automation and data pipeline orchestration <b> <b> <strong>Analytical Competencies:</strong> <b> • Strong statistical analysis and data visualization skills <b> • Ability to translate complex data into executive-level narratives and actionable insights <b> • Understanding of performance measurement frameworks (KPIs, OKRs, Balanced Scorecard) <b> • Experience with trend analysis, variance analysis, and predictive modeling <b> • Attention to detail in data validation and quality assurance <b> <b> <strong>Preferred Qualifications:</strong> <b> • Microsoft Certified: Data Analyst Associate (Power BI certification) <b> • Tableau Desktop Specialist or Certified Associate certification <b> • Experience with Python or R for advanced statistical analysis <b> • Background supporting Air Force or ACC organizations <b> • Familiarity with Earned Value Management (EVM) and schedule performance metrics <b> • Understanding of AI/ML platforms, RPA tools, or data analytics applications <b> • Previous work supporting DoD AI/data initiatives <b> • Experience with FedRAMP-authorized cloud platforms (Azure Government, AWS GovCloud) <b> <b> <strong>Essential Job Functions:</strong> <b> Live Performance Dashboard Development & Maintenance: <b> • Build and deploy the?live Performance <span class="long-word">Dashboard?within?60</span> days of contract award?on?Power BI?hosted on FedRAMP-authorized <span class="long-word">or?DAF365?platforms</span> <b> • Integrate data feeds from multiple source systems including: <b> • Token and License Management System (TLMS)?– token allocation, utilization, compliance status by wing and directorate <b> • Learning Management System (LMS)?– training completions, assessment scores, proficiency tracking <b> • Help Desk Ticketing System?– response times, resolution rates, recurring issue categories <b> • Integrated Master Schedule (IMS)?– task completion, schedule performance, milestone tracking <b> • Workflow Development Pipeline?– prototype status, transition timelines, ROI documentation <b> • Ensure dashboard displays all six PWS-required KPI categories: <b> • Training completions prior to access grant <b> • Token and license utilization by wing and directorate <b> • AI and RPA workflow development and transition status <b> • Help desk response and resolution rates <b> • Travel execution against approved wing visit schedules <b> • Quarterly performance trends and year-over-year comparisons <b> <b> <strong>Data Integration & Quality Assurance: </strong> <b> • Establish automated data pipelines from source systems to the dashboard with?daily refresh cycles?(or more frequent where technically feasible) <b> • Validate data accuracy through cross-referencing with source system reports and manual audits <b> • Identify and resolve data quality issues including missing records, duplicate entries, and classification mismatches <b> • Coordinate with the?Token/Resource <span class="long-word">Administrator,?Help</span> Desk Analysts, and?Program Analyst?to ensure source data integrity <b> • Document all data transformation logic, calculation methodologies, and business rules in technical specifications <b> • Maintain a data dictionary defining every metric, dimension, and KPI displayed on the dashboard <b> <b> <strong>Quarterly Performance Brief Data Packages: </strong> <b> • Generate <span class="long-word">comprehensive?Quarterly</span> Performance Brief data packages?for PM and COR review?5+ business days?before scheduled briefs <b> • Produce executive summary slides showing KPI trends, QASP standard compliance, and performance variance analysis <b> • Develop drill-down appendices with wing-level breakouts, directorate comparisons, and time-series trend charts <b> • Coordinate with the?Stakeholder Engagement & KM Specialist?to package metrics into governance-ready narratives <b> • Prepare data visualizations optimized for executive audiences (clear, concise, actionable) <b> • Document all data sources, assumptions, and calculation methods for COR transparency <b> <strong> <b> Service Desk Trend Analysis & Training Feedback Loop: </b></strong> <b> • Conduct?monthly service desk trend <span class="long-word">analysis?identifying:</span> <b> • Top 10 recurring issue categories requiring knowledge base articles or training updates <b> • Response and resolution time performance against QAP standards <b> • Ticket volume trends by wing, directorate, and platform <b> • Knowledge gaps indicating curriculum deficiencies <b> • Platform issues requiring vendor escalation or technical advisory engagement <b> • Deliver service desk analysis reports to the?Deputy PM?within?5 business days?of each month close to feed the?training feedback loop <b> • Track time from knowledge gap identification to updated training deployment as a mandatory KPI <b> • Measure knowledge base utilization impact on ticket volume reduction over time <b> <b> <strong>Utilization Analytics & Resource Optimization: </strong> <b> • Analyze token and license utilization patterns to identify: <b> • Underutilized allocations suitable for reallocation <b> • High-demand wings requiring additional resource allocation <b> • Cost-sharing opportunities across participating wings <b> • Compliance gaps where users received tokens without completing training <b> • Generate?monthly utilization reports?for the Token/Resource Administrator showing allocation efficiency and compliance status <b> • Produce cost-per-user and cost-per-wing analytics supporting ACC budget planning <b> • Forecast future resource requirements based on training completion trends and wing expansion plans <b> <b> <strong>Ad Hoc Analysis & Decision Support: </strong> <b> • Respond to ad hoc data requests from the PM, COR, and functional leads within?2 business days <b> • Conduct root cause analysis when KPIs fall below QASP thresholds, identifying contributing factors and corrective action recommendations <b> • Support?RAID log?population with data-driven risk assessments and impact quantification <b> • Perform comparative analyses across wings to identify best practices and adoption barriers <b> • Develop predictive models forecasting training completion rates, token demand, and workflow development throughput <b> <b> <strong>Schedule and Availability: </strong> <b> Core Hours: <b> 0800-1700 EST, Monday-Friday), with occasional extended hours to meet mission deadlines or support operational events <b> <b> Flexibility:? <b> Occasional early morning or evening meetings to accommodate wing schedules across time zones <b> <b> Surge Periods:? <b> Increased hours during major milestones, events, or exercises (with advance notice) <b> <b> Security Environment: <b> • Work with classified information up to Top Secret/SCI level <b> • Compliance with OPSEC, CUI handling, and classification protocols <b> • Subject to security inspections, audits, and continuous evaluation <b> • Adherence to base access, badge, and facility security requirements <b> <b> <strong>Performance Expectations: <b> Measured against deliverable quality and timeliness: </b></strong> <b> • Dashboard operational within 60 days?of contract award with all six PWS KPI categories integrated <b> • Daily data refresh cycles?maintained with 99%+ uptime (excluding planned maintenance) <b> • Quarterly performance brief data packages?delivered 5+ business days before scheduled briefs with zero data accuracy issues requiring correction <b> • Monthly service desk trend analysis?delivered within 5 business days of month close <b> • Ad hoc analysis requests?completed within 2 business days of PM/COR request <b> • Data quality audits?conducted quarterly with findings documented and corrective actions implemented within 10 days <b> <b> Ref: #851-Rockville-S1 <b> #M1 <b> #LI-VH1<p><b></b></p></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></div></div>

<h3>Job Description</h3><div>Job Description<div><p><strong>Senior IT Data Engineer<b> Washington, DC – onsite<b> US citizenship required per government contact <b> Must be able to obtain Public Trust clearance<b> Type: Multi-Year Contract supporting Federal Reserve Board<b> Open to W2 and C2C<b> Must apply by 12pm on July 2nd </b></b></b></b></b></b></strong><b> <b> The Data Architecture, Technology, and Analytics (DATA) section is tasked with transforming how the Federal Reserve Board’s Division of Research & Statistics (R&S) ingests, organize, uses, and visualizes data.<b> The Data Architecture, Technology, and Analytics (DATA) section is looking for an experienced detailed oriented Data Architect/Engineer who will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for economic policy and research teams. The ideal candidate is an experienced hands-on data modeler with working knowledge of database design and administration, data pipeline building, and data wrangling who enjoys improving existing data systems and/or building them from the ground up. The Data Architect/Engineer will support our economists and technical experts and will ensure optimal data delivery architecture is designed and developed. They must have a service mindset, be self-directed, and be comfortable supporting the data needs of multiple teams and systems. The right candidate will be excited by the prospect of optimizing or even re-designing the R&S division’s data architecture to support our next generation of data initiatives.<b> <b> <strong>Technical Skills:</strong><b> • Bachelor’s degree in computer science, Information Technology, Engineering or a related technical field and at least 7 years of related experience; advanced degree preferred.<b> • Advanced working knowledge of SQL and experience working with relational database platforms including PostgreSQL, Microsoft SQL Server, and MySQL.<b> • Advanced working knowledge of Python, R, and other scripting languages used for data engineering and analytics.<b> • Experience working with large-scale data systems, including distributed computing, scalable data processing, data storage architecture, and optimization of high-volume data workloads.<b> • Experience designing, developing, and automating ETL/ELT workflows and data integration pipelines.<b> • Experience building, optimizing, and maintaining scalable databases, data pipelines and data processing frameworks.<b> • Experience with workflow orchestration and pipeline automation tools such as Apache Airflow, Prefect, Dagster, or AWS Step Functions.<b> • Experience migrating workflows and data pipelines between on-premises and cloud environments.<b> • Experience processing, analyzing, and integrating structured and unstructured data sources.<b> • Experience developing in Linux environments and using source control platforms such as GitLab and/or GitHub.<b> • Experience performing root cause analysis on internal and external data and business processes to answer business questions and identify opportunities for improvement.<b> • Ability to design and communicate enterprise information architecture at conceptual, logical, and physical levels.<b> • In-depth experience designing and implementing database, data lake, and enterprise data platform solutions.<b> • Strong hands-on software engineering and implementation experience, including development, testing, and deployment of data applications and services.<b> • Excellent oral and written communication skills with a strong customer service orientation.<b> • Exceptional analytical, problem-solving, and troubleshooting skills.<b> • Understanding of time series data and related analytical and forecasting techniques.<b> • Experience working in a research environment and/or with economic or financial data.<b> • Experience with NoSQL and graph database technologies.<b> • Experience developing, training, deploying, and maintaining machine learning models.<b> • Working experience with cloud technologies such as AWS, Microsoft Azure, and Snowflake.<b> • Experience implementing data warehouses utilizing Change Data Capture (CDC) methodologies.<b> • Experience implementing and maintaining CI/CD pipelines and DataOps platforms.<b> • Working knowledge of additional programming and scripting languages such as Java, Scala, JavaScript, or Perl.<b> <b> </b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></b></p><p>System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.</p><p>System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.</p><p>#M1<b> #LI-VH1<b> Ref: #851-Rockville-S1</b></b></p><p><b></b></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p>Job Title: Business Analyst (Cloud Resource Management)<b> Location: Washington, DC<b> Type: Contract<b> Compensation: $52.96 per hour<b> Work Model: Onsite – onsite<b> Hours: 40.0<b> Security Clearance: PUBLIC TRUST – cannot begin assignment until granted. Prefer candidates with CURRENT PUBLIC TRUST, DOJ preferred</b></b></b></b></b></b></p><p>Responsibilities</p><ul><li>Support and analyze cloud resource usage, costs, and performance data to optimize cloud infrastructure investments.</li><li>Develop and maintain reports and dashboards using BI tools such as Power BI, Tableau, or Looker to monitor cloud resource efficiency and costs.</li><li>Collaborate with cloud operations teams to gather data from platforms like AWS, Azure, and Google Cloud.</li><li>Design automated processes for timely and accurate cloud data collection and reporting.</li><li>Assist in cloud infrastructure planning, deployment, and scaling efforts based on data analysis.</li><li>Document processes related to cloud resource monitoring, reporting, and optimization strategies.</li><li>Stay current with cloud technology trends and best practices to provide strategic recommendations for cost management.</li></ul> Requirements <ul><li>Bachelor’s degree in Business Intelligence, Data Analytics, Cloud Computing, Computer Science, or a related field.</li><li>2-4 years of experience with cloud resource management, cost optimization, or business intelligence in a cloud environment.</li><li>Experience with cloud platforms such as AWS, Azure, or Google Cloud.</li><li>Proficiency in BI tools like Power BI, Tableau, or Looker.</li><li>Strong SQL or cloud-native data query skills (e.g., AWS Athena, Google BigQuery).</li><li>Knowledge of cloud cost management tools such as AWS Cost Explorer or Azure Cost Management.</li><li>Ability to analyze large data sets and provide actionable insights.</li><li>Excellent communication skills for stakeholder engagement and presenting technical findings.</li><li>Preferably current Public Trust clearance; screening includes personal disclosure and soft credit check.</li></ul><p>System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.</p><p>System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.</p><p>#M-<b> #LI-<b> Ref: #851-Rockville-S1</b></b></p><p><b></b></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p>Job Title: Operations Data Analyst<b> Location: Indianapolis, IN (Hybrid)<b> Type: 17 month contract<b> Compensation: $59.69-70.22/hour, depending on qualifications<b> Work Model: Hybrid – 3 days onsite<b> Hours: 40.0</b></b></b></b></b></p><p>Overview<b> Supports pharmacy dispensing and fulfillment operations by developing operational metrics, maintaining reporting, analyzing performance data, and ensuring HIPAA-compliant handling of patient and operational data.</b></p><p>Responsibilities</p><ul><li>Develop, validate, and maintain operational metrics using pharmacy dispensing and platform data. </li><li>Create and maintain operational dashboards and performance reports for covered entity stakeholders. </li><li>Analyze operational data using SQL and Excel to identify trends, support issue resolution, and document KPIs. </li><li>Ensure data quality, availability, and compliance with HIPAA and data governance requirements. </li><li>Support cross-functional operational reporting, automation, and dispensing data initiatives. </li></ul><p>Requirements</p><ul><li>Bachelor’s degree in Business, Marketing, Healthcare Administration, Data Science, or a related discipline. </li><li>Proficiency in SQL, Excel, and at least one statistical programming language (Python or R). </li><li>Familiarity with healthcare, pharmacy, or claims/dispensing operational data. </li><li>1–3 years of experience in a HIPAA-covered entity with experience handling protected health information (PHI). </li><li>Working knowledge of HIPAA, data governance, and manufacturer versus covered-entity data separation; experience with operational analytics and dashboard reporting preferred. </li></ul><p>System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.</p><p>System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.</p><p>#M-<b> #LI-<b> Ref: #558-Scientific</b></b></p><p><b></b></p></div></div>

<h3>Job Description</h3><div>Job Description<div><p><strong>Job Title: HR Technology Data & Reporting Analyst<b> Location: Hybrid Work Model Reporting to Vienna, VA<b> Pay Rate: $60/hr. range W2. Benefits available<b> Position Type: Multiyear Contract</b></b></b></strong><b> <b> <strong>Position Overview:</strong><b> System One IT is seeking a highly analytical and technically skilled HR Technology Data & Reporting Analyst to support our client’s HR Technology team. This role will focus on creating dashboards and reports provided real-time visibility into HR Technology operations, streamlining and automating reporting processes to reduce manual effort, and developing actionable insights that drive measurable improvements in service delivery.<b> This is an excellent opportunity for someone to make an immediate impact on HR Technology strategy and operations while working with a collaborative, high-performing team focused on innovation and continuous improvement.<b> <b> <strong>Key Responsibilities</strong><b> <b> <strong>Data Integration & Aggregation</strong></b></b></b></b></b></b></b></b></p><ul><li>Consolidate and integrate data across HR Technology platforms, including: <ul><li>Oracle Fusion HCM </li><li>ServiceNow (HRSD) </li><li>Azure DevOps (ADO) </li><li>Adobe Experience Manager (AEM) </li></ul></li><li>Design and deliver reporting solutions that highlight: <ul><li>Operational performance (intake trends, incidents, SLAs) </li><li>Platform health and system usage metrics </li><li>Executive-level summaries for leadership reporting </li><li>Develop data visualizations that are clear, compelling, and actionable. </li></ul></li><li>Deliver insights tailored to both executive leadership and operational teams. </li></ul><b> <strong>ADO & ServiceNow Reporting Expertise</strong><b> <strong>Develop reporting across:</strong><ul><li>ADO (epics, features, user stories, throughput, velocity) </li><li>ServiceNow (cases, incidents, requests, trend analysis, resolution metrics) </li></ul><b> <strong>Analyze data to identify:</strong><ul><li>Trends and patterns </li><li>Operational gaps </li><li>Opportunities for process improvement </li><li>AI-Driven Insights & Automation </li></ul><b> <strong>Leverage AI tools and techniques to:</strong><ul><li>Automate data aggregation and reporting processes </li><li>Surface predictive insights and trends </li><li>Improve data quality and reporting efficiency. </li><li>Recommend innovative approaches to enhance reporting capabilities and scalability </li></ul><b> <strong>Stakeholder Engagement</strong><ul><li>Partner closely with HR Technology and cross-functional teams to: </li><li>Gather and clarify reporting requirements. </li><li>Translate business questions into analytical frameworks and outputs. </li><li>Present insights and recommendations in a clear, business-friendly manner </li></ul><b> <strong>QUALIFICATIONS</strong> <b> <b> <b> <strong>Required</strong><ul><li>5+ years of experience in data analytics, reporting, or business intelligence </li><li>Strong experience with HR Technology platforms (Oracle Fusion HCM, ServiceNow, ADO preferred) </li><li>Advanced data visualization skills (e.g., Power BI, Tableau, or similar tools) </li><li>Experience integrating and aggregating data across multiple systems </li><li>Strong analytical and problem-solving skills with attention to detail </li><li>Ability to communicate complex data insights to both technical and non-technical stakeholders </li></ul><strong>Preferred</strong><ul><li>Experience working in HR Technology or enterprise platforms </li><li>Familiarity with AI/ML tools for data analysis or automation </li><li>Experience with executive-level reporting and dashboard creation </li><li>Knowledge of Agile metrics and delivery reporting </li></ul><p><b> System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan. <b> <b> System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.<b> <b> <b> #M- MM1<b> #LI- MM1<b> Ref: #851-Rockville-S1</b></b></b></b></b></b></b></b></p> Ref: #851-Rockville-S1<p><b></b></p></b></b></b></b></b></b></b></b></b></div></div>

<h3>Job Description</h3><div>Job Description<div><p><strong>Job Title</strong>: Data Analyst<b> <strong>Location</strong>: San Francisco, CA<b> <b> <strong>Type</strong>: Contract-to-Hire<b> <strong>Compensation:</strong> $25-$28/hour<b> <strong>Contractor Work Model</strong>: Onsite<b> <strong>Hours</strong>: Monday through Friday (8AM to 5PM)<b> </b></b></b></b></b></b></b></p><p><strong>DATA ANALYST</strong></p><p><b> <strong>SUMMARY:</strong><b> <b> Responsible for analyzing data and other information for the effective quality control and compliance management of the Housing Choice Voucher Program. Provide support to the HCV management team. This position may also include other duties, responsibilities, and project participation as assigned.<b> <b> <strong>RESPONSIBILITIES:</strong><b> </b></b></b></b></b></b></p><ul><li>Assists upper management & Lead Data Analyst with data analysis and program evaluation projects </li><li>Monitor accuracy of HAP Payment Processing </li><li>Assist with creating and/or deleting manual adjustments upon request </li><li>Collect data and create reports regarding program performance and quality control reviews </li><li>Assist with Quarterly Reconciliation process which includes gathering, dispersing, analyzing, and reviewing quarterly reconciliation reports </li><li>Review and monitor reports and/or documents and assign appropriate actions or corrective actions including but not limited to SEMAP, Enterprise Income Verification (EIV), PIH Information Center (PIC), 50058 error reports, HUD regulations, and the HCV administrative plan </li><li>Assist with monitoring Tracker to ensure record consistency </li><li>Set up monitor and maintain tools to support ongoing operations </li><li>Assist team with issues concerning caseload complications </li><li>Evaluate, investigate and work closely with management and supervisory staff to identify solutions to a variety of data related problems and issues </li><li>Coordinate with management to produce reports as required to ensure integrity of program data and provide ongoing monitoring of program operations </li><li>Monitor and manage PIC/EIV reports (Deceased; Multiply Subsidy et al) and ensure all <span class="long-word">corrections/adjustments</span> are made </li><li>Assist management with check run </li><li>Prepare reports for all levels of the organization and client this includes but are not limited to weekly New Admission reports, monthly delinquent Re-exam reports, and other reports as assigned </li><li>Monitor SEMAP Compliance on an ongoing basis and perform related Quality Control testing, file reviews, and data collection as necessary </li><li>All additional duties as assigned by supervisor </li></ul><b> <strong>QUALIFICATIONS:</strong> <b><ul><li>Bachelor’s degree PLUS one (1) year of similar relevant experience OR Minimum of 2–4 years’ experience working in a similar capacity </li><li>Proficient with current technology, computer hardware and software, easily grasps new software </li><li>Proficient in using database systems and analytical tools/instruments such as Microsoft Excel, Microsoft Access and SharePoint </li><li>Must possess an analytical mind able to process information logically </li><li>Able to work under critical time deadlines, re-evaluate priorities and interact well with all levels of personnel </li><li>Ability to effectively write memos and maintain documentation </li><li>Ability to operate necessary office equipment, computers and peripherals </li><li>Proficient in all areas of Microsoft Office Suite (Word, Excel, PowerPoint, Access, Outlook, etc.) and ability to create and manipulate and analyze data </li><li>Responsible for maintaining all required records and for the preparation of all required reports </li><li>Must have ability to safeguard confidential and sensitive information </li><li>Exercise sound and ethical judgment when acting on behalf of the organization </li></ul><p></p><p>System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.<b> <b> System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.<b> <b> #M1<b> </b></b></b></b></b></p><p><b> <b> Ref: #562-Joule Staffing - Edison</b></b></p><p><b></b></p></b></b></div></div>

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

System One Interview Questions

System One Interview Guides

System One Interview Questions

Challenge

System One Opening Jobs

Discussion & Interview Experiences

Discussion & Interview Experiences