Prepare for and practice interview questions from Marathon Ts.

Marathon Ts Interview Questions

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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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?

Marathon Ts Salaries by Position

Marathon TS is seeking a Data Analyst to support a federal client in Huntsville, AL. This position requires employees to be located in the Huntsville, AL area in order to report to work on-site at Redstone Arsenal. Responsibilities<ul> <li> Provide highly complex data mining, statistical analysis, trend analysis, and causal analysis.</li> <li> Perform as a technical lead responsible for monitoring and providing monthly contract reports and deliverables.</li> <li> Responsible for integrating multiple disciplines in an operations research team and translating applicable methods into language and application understandable by operational managers throughout the organization. Review and provide quality control methods on products.</li> <li> Prepare and update training materials to ensure newly assigned personnel gain an understanding of key analytic tools, procedures, and methodologies used.</li> <li> Take structured and unstructured data and distill the information into a cohesive analytical product for a contracting functional business area audience.</li> <li> Support pattern analysis methods to formulate recommendations to operational managers based upon exploiting patterns in the past, current, and anticipated operational environment.</li> </ul> Education and Experience<ul> <li> 4+ years in a technical field</li> <li> BA/BS in a relevant field is required.</li> </ul> Required Skills<ul> <li> Have experience advising senior DoD decision makers on methodologies, results, and conclusions from applied operations research.</li> <li> Have experience with the primary tools used for research services include, but are not limited to, Logistics Management Program, Vantage, Virtual Contracting Enterprise, General Fund Enterprise Business System (GFEBS), SAP Business Objects/Web Intelligence Reports, Microsoft SharePoint, Army-specific contract writing systems (Procurement Desktop Defense (PD2) and Procurement Automated Data and Document System (PADDS)), and various Government and Commercial business process automation systems.</li> <li> Personnel should have strong data manipulation and problem-solving skills.</li> <li> Must have strong technical skills in areas such as statistics, programming languages like R or Python, SQL (Structured Query Language), data visualization, and data cleaning and preparation.</li> <li> Have good communication skills and problem-solving ability.</li> </ul> Security Clearance<ul> <li> Active Secret clearance is required.</li> </ul> #CJJOBS Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").

Senior Data Analyst Job Summary Marathon TS is seeking a Senior Data Analyst to join a contract with a federal government client in support of an important mission. In this role, you will have the opportunity to work with a great team while supporting the team. Responsibilities<ul> <li>This role necessitates the employee to be based in the San Antonio area for on-site work at Fort Sam Houston. </li> <li>Conduct highly complex data mining, statistical analysis, trend analysis, and causal analysis.</li> <li>Act as a technical lead, responsible for monitoring and delivering monthly contract reports and deliverables.</li> <li>Integrate multiple disciplines within an operations research team, translating methodologies into a language understandable by operational managers.</li> <li>Review and ensure quality control of products.</li> <li>Develop and update training materials to educate newly assigned personnel on key analytic tools, procedures, and methodologies.</li> <li>Transform structured and unstructured data into cohesive analytical products for a contracting functional business area audience.</li> <li>Utilize pattern analysis methods to formulate recommendations for operational managers by identifying patterns in past, current, and anticipated operational environments.</li></ul>Education and Experience<ul> <li>A minimum of 8 years of experience in a technical field required.</li> <li>A Bachelor's degree in computer science, engineering, applied mathematics, statistics, or a related field is preferred.</li></ul>Required Skills<ul> <li>Experience advising senior DoD decision makers on methodologies, results, and conclusions from applied operations research.</li> <li>Proficiency in various research tools, including but not limited to Logistics Management Program, Vantage, Virtual Contracting Enterprise, General Fund Enterprise Business System (GFEBS), SAP Business Objects/Web Intelligence Reports, Microsoft SharePoint, Army-specific contract writing systems (Procurement Desktop Defense (PD2) and Procurement Automated Data and Document System (PADDS)), and various Government and Commercial business process automation systems.</li> <li>Strong data manipulation and problem-solving skills.</li></ul>Desired Skills<ul> <li>Proficiency in statistics, programming languages like R or Python, SQL (Structured Query Language), data visualization, and data cleaning and preparation.</li> <li>Effective communication skills and strong problem-solving ability.</li></ul>Security Clearance Eligibility to obtain a federal Security Clearance. #CJJOBS Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status").

Marathon Ts Interview Questions

Marathon Ts Interview Guides

Marathon Ts Interview Questions

Marathon Ts Salaries by Position

Marathon Ts Opening Jobs