Prepare for and practice interview questions from Red Arch Solutions.

Red Arch Solutions Interview Questions

Red Arch Solutions Interview Guides

Machine Learning

Why would one algorithm generate different success rates with the same dataset?

Same Algorithm Different Success

How would you build a model to detect if a post on a marketplace is talking about selling a gun?

Detecting Firearm Sales

Classification and Regression

Xgboost vs Random Forest

PCA and K-Means

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

First Touch Attribution

Project Budget Error

Employee Project Budgets

Count the number of users that like each user

Liker's Likers

Data Structures & Algorithms

String Mapping

This question requires the implementation of the Fibonacci sequence using three different methods: recursively, iteratively, and using memoization.

Implementing the Fibonacci Sequence in Three Different Methods

Brainteasers

How would you answer when an Interviewer asks why you applied to their company?

Why Do You Want to Work With Us

What do you tell an interviewer when they ask you what your strengths and weaknesses are?

Your Strengths and Weaknesses

Analytics

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

Swipe Precision

Describing a data project and its challenges

Hurdles In Data Projects

When an interviewer asks a question along the lines of:

<ul>
<li>What would your current manager say about you? What constructive criticisms might he give?</li>
<li>What are your three biggest strengths and weaknesses you have identified in yourself?</li>
</ul>

How would you respond?

When asked about your strengths in an interview, what is an effective way to respond?

When asked about your strengths in an interview, what is an effective way to respond?

Your Strengths and Weaknesses I

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Your Strengths and Weaknesses II

When an interviewer asks you a question along the lines of:

<ul>
<li>Why did you apply to our company?</li>
<li>What are you looking for in your next job?</li>
<li>What makes you a good fit for our company?</li>
</ul>

How should you respond?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

Why Do You Want to Work With Us I

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

Why Do You Want to Work With Us II

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

Why Do You Want to Work With Us III

Describe a data project you worked on. What were some of the challenges you faced?

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

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

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

P-value to a Layman I

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

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

P-value to a Layman

Statistics

Imagine you are asked to build a machine learning model to decide new loan approvals for a
financial firm. You ask the data department in the company for a subset of data to get started
working on the problem. The data includes different features about applicants such as age,
occupation, zip code, height, number of children, favorite color, etc. You decide to build
multiple machine learning models to test out different ideas before settling on the best one.

How would you explain the bias-variance tradeoff with regards to
building and choosing a model to use?

Bias vs. Variance Tradeoff

Explain the difference between the XGBoost and random forest algorithms and give an example where you would use one over the other.

Why might a data scientist choose to use XGBoost instead of Random Forest for a particular machine learning task?

Why might a data scientist choose to use XGBoost instead of Random Forest for a particular machine learning task?

XGBoost vs Random Forest: Choice

What are the key differences between classification models and regression models?

What is the MOST important difference between regression and classification models?

What is the MOST important difference between regression and classification models?

Classification vs Regression

What’s the relationship between PCA and K-means clustering?

What does the variable “k” in k-means clustering refer to?

What does the variable "k" in k-means clustering refer to?

Input of K-means

The Fibonacci sequence is a series of numbers in which each number is the sum of the two preceding ones, usually starting with 0 and 1. It is often used in algorithm examples, and is defined by the following formula: F(n) = F(n-1) + F(n-2), with F(0) = 0 and F(1) = 1.

Your task is to implement the Fibonacci algorithm in three different methods:
1. Recursively
2. Iteratively
3. Using Memoization

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>n = 5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>fibonacci(n) -&gt; 5
</code></pre>

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>n = 10
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>fibonacci(n) -&gt; 55
</code></pre>

The Fibonacci sequence starts as follows: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55…

Let’s say you’re a data engineer at Fidelity Investments, and you’re running a SQL query on a cloud-based data warehouse. All cluster resources and network health metrics look normal, but the query is still taking over 10 minutes to complete.

How would you go about diagnosing and improving the performance of this query?

How would you diagnose and speed up a slow SQL query when system metrics look healthy?

Slow SQL Query

Query Optimization

What does the backpropagation algorithm do in the context of neural networks? What is the informal intuition behind the algorithm? What are some drawbacks of the algorithm compared to other optimization methods?

Bonus: Formally derive the backpropagation algorithm and prove that it does what it claims to do.

Backpropagation Explanation

Let’s say that you work on the revenue forecasting team at a company like Facebook.

An executive comes to you asking about how much revenue Facebook will make in the coming year.

How would you forecast revenue for the next year?

Forecasting New Year Revenue

Forecasting & Time Series

As a data scientist at a real estate analytics startup, you’re tasked with building a predictive model for home prices in a large metropolitan area. During your exploratory data analysis, you notice that the <code>home_prices</code> column in your dataset is heavily right-skewed (i.e., there are many lower-priced homes and a few extremely high-priced ones).

How might this skewness impact your modeling approach, and what steps would you consider to address it before training your model?

Bonus: If, instead, you discover that the target variable (<code>home_prices</code>) is heavily left-skewed (i.e., there are many high-priced homes and a few low-priced outliers), what would you do differently, if anything?

You're building a model to predict home prices and you see that the prices in your training data are right-skewed. How would you handle this situation?

Skewed Pricing

Why would the same machine learning algorithm generate different success rates using the same dataset?

Note: When they ask us an ambiguous question, we need to gather context and restate it in a way that’s clear for us to answer.

Given two strings, <code>string1</code> and <code>string2</code>, write a function <code>str_map</code> to determine if there exists a one-to-one correspondence (bijection) between the characters of <code>string1</code> and <code>string2</code>.

For the two strings, our correspondence must be between characters in the same position/index.

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>string1 = &#39;qwe&#39;
string2 = &#39;asd&#39;

string_map(string1, string2) == True

# q = a, w = s, and e = d
</code></pre>

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>string1 = &#39;donut&#39;
string2 = &#39;fatty&#39;

string_map(string1, string2) == False
# cannot map two distinct characters to two equal characters
</code></pre>

Example 3:

Input:

<pre tabindex="0" class="chroma"><code>string1 = &#39;enemy&#39;
string2 = &#39;enemy&#39;

string_map(string1, string2) == True
# there exists a one-to-one correspondence between equivalent strings
</code></pre>

Example 4:

Input:

<pre tabindex="0" class="chroma"><code>string1 = &#39;enemy&#39;
string2 = &#39;ymene&#39;

string_map(string1, string2) == False
# since our correspondence must be between characters of the same index, this case returns &#39;False&#39; as we must map e = y AND e = e
</code></pre>

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

Write a query to get the top five most expensive projects by budget to employee count ratio.

Note: Exclude projects with 0 employees. Assume each employee works on only one project.

<code>projects</code> table

<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>
<code>employee_projects</code> table

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

<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>INTEGER</td>
</tr>
</tbody>
</table>

Let’s say you are designing a marketplace for your website.

Selling firearms is prohibited by your website’s Terms of Service Agreement (not to mention the laws of your country). To this end, you want to create a system that can automatically detect if a listing on the marketplace is selling a gun.

How would you go about doing this?

While designing a system to detect firearms listings on a marketplace website, what metrics could be used to minimize both false positives and false negatives?

While designing a system to detect firearms listings on a marketplace website, what metrics could be used to minimize both false positives and false negatives?

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.

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.

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.

Example:

Input:

<code>variants</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>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>
<code>swipes</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>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>
Output:

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

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

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

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

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

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

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

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

Example:

Input:

<code>attribution</code> table

<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>
<code>user_sessions</code> table

<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>
Example output:

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

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

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.

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

<h3>Schema</h3>

Input:

<code>projects</code> table

<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>
<code>employee_projects</code> table

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

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

Input:

<code>projects</code> table

<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>
<code>employee_projects</code> table

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

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

A dating website’s schema is represented by a table of people that like other people. The table has three columns. One column is the <code>user_id</code>, another column is the <code>liker_id</code> which is the <code>user_id</code> of the user doing the liking, and the last column is the <code>date time</code> that the like occurred.

Write a query to count the number of liker’s likers (the users that like the likers) if the liker has one.

Example:

Input:

<code>likes</code> table

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

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

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

<tr>
<td><code>liker_id</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

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

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

Challenge

<h3>Job Description</h3><div>Job Description<div>ACTIVE TS/SCI Clearance with Poly REQUIRED Overview:  Red Arch Solutions is hiring a Software Engineer 0 to join our program in Fort Meade, Maryland. Requirements:<ul><li>Must have TS/SCI clearance w/ active polygraph.</li><li>Bachelor’s degree in Computer Science or related discipline from an accredited college or university is required Four (04) years of SWE experience on projects with similar software processes may be substituted for a bachelor’s degree.</li><li>Relevant experience must be in engineering systems over their lifecycle (for example, conception, design & development, testing, production, distribution/deployment, operation, maintenance & support, decommissioning).</li></ul> Responsibilities include, but are not limited to:<ul><li>Analyze user requirements to derive software design and performance requirements</li><li>Debug existing software and correct defects</li><li>Provide recommendations for improving documentation and software development process standards</li><li>Design and code new software or modify existing software to add new features</li><li>Integrate existing software into new or modified systems or operating environments</li><li>Develop simple data queries for existing or proposed databases or data repositories</li></ul>Salary range for this position: $110,000 - 119,000  #CJ The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.Red Arch Solutions Benefits Snapshot:<ul><li>100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.</li><li>HaloScripts Concierge prescription medication service</li><li>Generous PTO.</li><li>10 % 401K 6% match vested day one and up to 4% profit sharing contribution.</li><li>Annualized bonus compensation.</li><li>Spot bonuses for hard work.</li><li>Tuition reimbursement.</li><li>529 College Saving Plan.</li><li>College Loan Pay Back Program.</li><li>11 Paid Federal Holidays</li><li>Generous Referral Bonuses.</li></ul>Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.Have more questions about Red Arch? Email us at Careers@RedArchSolutions.comPowered by JazzHRKjl8Zumn08</div></div>

<h3>Job Description</h3><div>Job Description<div>ACTIVE TS/SCI Clearance with Poly REQUIRED Overview:  Red Arch Solutions is hiring a Software Engineer to join our program in Fort Meade, Maryland. Requirements:<ul><li>Must have TS/SCI clearance w/ active polygraph.</li><li>Bachelor’s degree in Computer Science or related discipline from an accredited college or university is required. Four (4) years of additional SWE experience on projects with similar software processes may be substituted for a bachelor’s degree.</li><li>Relevant experience must be in engineering systems over their lifecycle (for example, conception, design & development, testing, production, distribution/deployment, operation, maintenance & support, decommissioning).</li><li>Level 02 - Fourteen (14) years of experience as a SWE in programs and contracts of similar scope, type, and complexity is required.</li><li>Software Engineering experience developing using the following or comparable software technologies: Java SE, Python, Git, Shell/bash, Nexus, Maven, JavaScript/HTML5/CSS3, JUnit, and IDEs. Software Engineering</li><li>Software architecture development, requirements analysis, code generation, process execution and evaluation, selection and evaluation Software Engineering</li><li>Experience with containers and container orchestration (e.g., Docker/Kubernetes/OpenShift and GitLab CI) is highly desired, including experience with the following: - microservices and microservice orchestration; - experience with CI/CD pipelines; - integration of automated testing tools like SonarQube; - implementing automated deployments/failure rollbacks; - deployment to Kubernetes Agile</li><li>Experience supporting programs using an agile development methodology, delivering a new capability in every Sprint Software Engineering</li><li>Experience with Spring Framework, Spring Tool Suite, Grit, Jenkins, Hibernate, MySQL, Web Services, and Google Web Toolkit or Vaadin, also a plus</li></ul> Responsibilities include, but are not limited to:<ul><li>Analyze user requirements to derive software design and performance requirements</li><li>Debug existing software and correct defects</li><li>Provide recommendations for improving documentation and software development process standards</li><li>Design and code new software or modify existing software to add new features</li><li>Integrate existing software into new or modified systems or operating environments</li><li>Develop simple data queries for existing or proposed databases or data repositories</li><li>Write or review software and system documentation</li><li>Serve as team lead at the level appropriate to the software development process being used on any particular project</li><li>Design or implement complex database or data repository interfaces/queries</li><li>Develop or implement algorithms to meet or exceed system performance and functional standards</li><li>Assist with developing and executing test procedures for software components</li><li>Develop software solutions by analyzing system performance standards, confer with users or system engineers; analyze systems flow, data usage and work processes; and investigate problem areas</li><li>Modify existing software to correct errors, to adapt to new hardware, or to improve its performance</li><li>Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design</li><li>Design or implement complex algorithms requiring adherence to strict timing, system resource, or interface constraints; Perform quality control on team products</li><li>Implement recommendations for improving documentation and software development process standards</li><li>Oversee one or more software development teams and ensure the work is completed in accordance with the constraints of the software development process being used on any particular project</li><li>Confer with system engineers and hardware engineers to derive software requirements and to obtain information on project limitations and capabilities, performance requirements and interfaces</li><li>Coordinate software system installation and monitor equipment functioning to ensure operational specifications are met</li></ul>Salary range for this position: $180,000 - 195,000  #CJ The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.Red Arch Solutions Benefits Snapshot:<ul><li>100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.</li><li>HaloScripts Concierge prescription medication service</li><li>Generous PTO.</li><li>10 % 401K 6% match vested day one and up to 4% profit sharing contribution.</li><li>Annualized bonus compensation.</li><li>Spot bonuses for hard work.</li><li>Tuition reimbursement.</li><li>529 College Saving Plan.</li><li>College Loan Pay Back Program.</li><li>11 Paid Federal Holidays</li><li>Generous Referral Bonuses.</li></ul>Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.Have more questions about Red Arch? Email us at Careers@RedArchSolutions.comPowered by JazzHRy9ojgC9hdY</div></div>

<h3>Job Description</h3><div>Job Description<div>Active TS/SCI with Polygraph (required)Red Arch Solutions is seeking a Data Scientist who will use AI algorithms, statical analysis and other data science techniques to analyze, and interpret datasets to support decision making for the acquisition and integration of new and existing datasets for a suite of customer tools and mission priorities. The Data Scientist will work closely with a small contractor team and engage with industry and senior customer leadership to help define a comprehensive data strategy for the enterprise in line with customer mission priorities. Key Responsibilities:<ul><li>Utilize cloud-based data analysis tools, visual analytic tools, and open-source textual processing technologies to analyze and interpret datasets</li></ul><ul><li>Extract, transform, load, analyze, and interpret data to provide recommendations to customer leadership </li></ul><ul><li>Provide reports on associated patterns, anomalies, and data quality issues with data samples</li><li>Develop expertise with customer applications, analytic capabilities, existing data, and mission objectives to help drive recommendations for new datasets and the comprehensive data strategy </li><li>Conduct ongoing research on emerging data science methodologies and technologies, implementing new approaches to interpret and utilize data</li><li>Analyze unstructured and semi-structured data using advanced techniques such as latent semantic indexing (LSI), entity identification and tagging, and complex event processing (CEP)</li><li>Utilize advanced tools and computational skills to interpret, connect, predict, and make discoveries in complex data</li><li>Apply machine learning, algorithm analysis, and data clustering techniques to evaluate datasets</li><li>Communicate and present ideas to key stakeholders. Writing, documenting, and presenting technical material to senior level officials</li><li>Leverage project management tools such as, Gitlab, Jira, Confluence, SharePoint.</li></ul>Required Skills and Qualifications<ul><li>Demonstrated strong experience with data engineering, data management, data visualization, machine learning principles, data fusion, and data science tools (Tableau, Python, R, pandas, Jupyter Notebooks etc.)</li><li>Demonstrated experience working independently without direct supervision, able carry out strategic objectives.  Experience working with senior government officials and tailoring communication for the audience.</li><li>Demonstrated 12+ years of relevant experience (relevant bachelor’s degree can be substituted in lieu of 4 years of experience; master’s degree can be substituted in lieu of 6 years)</li><li>TS/SCI clearance with CI Polygraph #CJ</li></ul>The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.Red Arch Solutions Benefits Snapshot:<ul><li>100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.</li><li>HaloScripts Concierge prescription medication service</li><li>Generous PTO.</li><li>10 % 401K 6% match vested day one and up to 4% profit sharing contribution.</li><li>Annualized bonus compensation.</li><li>Spot bonuses for hard work.</li><li>Tuition reimbursement.</li><li>529 College Saving Plan.</li><li>College Loan Pay Back Program.</li><li>11 Paid Federal Holidays</li><li>Generous Referral Bonuses.</li></ul>Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.Have more questions about Red Arch? Email us at Careers@RedArchSolutions.comPowered by JazzHRHNm5cEGIwX</div></div>

<h3>Job Description</h3><div>Job Description<div>***Active TS/SCI with CI Polygraph Required***Red Arch Solutions is a proven and effective small business integrator and consultant, recognized as a leading provider of IT development to the Federal Government, and primarily focused within the Intelligence Community. Red Arch Solutions is looking for a software engineer to support our client. The scope of this contract relates to maturing and maintaining an IT managed service model, evolving an intelligence organization and its data to a hyperconverged cloud environment, improving the organizational collaboration technology, delivering a more agile operational architecture to the warfighter using commercial technology. As Software Engineer , you’ll bring creative architect solutions to end customers, with the goal to make an impact across the federal government.If you think you can see yourself delivering our mission and pursuing our goals with us, then check out the job description below!What you’ll do:<ul><li>You'll work with AI team members to operationalize data pipelines and ML tasks</li><li>You'll provide day-to-day support of deploying Python-native ML pipelines</li><li>You'll support architectural leadership, technical support, and advisement services to ensure identity management system technologies are integrated and meeting the appropriate security requirements</li><li>You’ll support leadership who engage with senior level executives at a public facing Federal agency and provide subject matter expertise in security architecture and other key domain</li></ul>What you’ll need to succeed:<ul><li>A minimum of 7 years of experience in the Information Technology field, focusing on development projects using DevSecOps and AWS cloud environments</li><li>A bachelor’s degree in Computer Science, Information Technology Management or Engineering, or other comparable degree; or equivalent experience in leu of degree</li><li>Active TS/SCI CI Poly clearance</li><li>At least 6 years of specific experience with full stack engineering (defined as proficient in database development/integration as well as server and client application development/integration), including at least 6 years of experience deploying production enterprise applications in AWS</li><li>Strong, repeat experience designing, developing, and deploying applications leveraging AWS cloud services in IL6+ classified environments</li><li>Proven experience in large-scale, high-performance enterprise big data application deployment and solution architecture on complex heterogeneous environments in AWS</li><li>Strong experience with automation and engineering tasks, implementation, data, infrastructure/operations, and security engineer tasks in cloud environments</li><li>The ability to perform, but not limited to, automation and engineering tasks, testing, implementation, data, AI/ML, infrastructure/operations, and security engineer tasks in cloud environments</li><li>You have 3+ years of experience with multiple of the following: Go, Python, Java, JavaScript, React, AngularJS, TypeScript, NextJS #CJ</li></ul>The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.Red Arch Solutions Benefits Snapshot:<ul><li>100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.</li><li>HaloScripts Concierge prescription medication service</li><li>Generous PTO.</li><li>10 % 401K 6% match vested day one and up to 4% profit sharing contribution.</li><li>Annualized bonus compensation.</li><li>Spot bonuses for hard work.</li><li>Tuition reimbursement.</li><li>529 College Saving Plan.</li><li>College Loan Pay Back Program.</li><li>11 Paid Federal Holidays</li><li>Generous Referral Bonuses.</li></ul>Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.Have more questions about Red Arch? Email us at Careers@RedArchSolutions.comPowered by JazzHRbv0NA6dFJ5</div></div>

<h3>Job Description</h3><div>Job Description<div>ACTIVE TS/SCI Clearance with Poly REQUIRED Overview:  Red Arch Solutions is hiring a Sr Software Engineer to join our program in Fort Meade, Maryland. Requirements:<ul><li>Must have TS/SCI clearance w/ active polygraph.</li><li>Bachelor’s degree in Computer Science or related discipline from an accredited college or university is required. Four (4) years of additional SWE experience on projects with similar software processes may be substituted for a bachelor’s degree.</li><li>Relevant experience must be in engineering systems over their lifecycle (for example, conception, design & development, testing, production, distribution/deployment, operation, maintenance & support, decommissioning).</li><li>Twenty (20) years of experience as a SWE in programs and contracts of similar scope, type, and complexity is required.</li><li>Software Engineering experience developing using the following or comparable software technologies: Java SE, Python, Git, Shell/bash, Nexus, Maven, JavaScript/HTML5/CSS3, JUnit, and IDEs. Software Engineering</li><li>Software architecture development, requirements analysis, code generation, process execution and evaluation, selection and evaluation Software Engineering</li><li>Experience with containers and container orchestration (e.g., Docker/Kubernetes/OpenShift and GitLab CI) is highly desired, including experience with the following: - microservices and microservice orchestration; - experience with CI/CD pipelines; - integration of automated testing tools like SonarQube; - implementing automated deployments/failure rollbacks; - deployment to Kubernetes Agile</li><li>Experience supporting programs using an agile development methodology, delivering a new capability in every Sprint Software Engineering</li><li>Experience with Spring Framework, Spring Tool Suite, Grit, Jenkins, Hibernate, MySQL, Web Services, and Google Web Toolkit or Vaadin, also a plus</li></ul>Responsibilities include, but are not limited to:<ul><li>Analyze user requirements to derive software design and performance requirements</li><li>Debug existing software and correct defects</li><li>Provide recommendations for improving documentation and software development process standards</li><li>Design and code new software or modify existing software to add new features</li><li>Integrate existing software into new or modified systems or operating environments</li><li>Develop simple data queries for existing or proposed databases or data repositories</li><li>Write or review software and system documentation</li><li>Serve as team lead at the level appropriate to the software development process being used on any particular project</li><li>Design or implement complex database or data repository interfaces/queries</li><li>Develop or implement algorithms to meet or exceed system performance and functional standards</li><li>Assist with developing and executing test procedures for software components</li><li>Develop software solutions by analyzing system performance standards, confer with users or system engineers; analyze systems flow, data usage and work processes; and investigate problem areas</li><li>Modify existing software to correct errors, to adapt to new hardware, or to improve its performance</li><li>Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design</li><li>Design or implement complex algorithms requiring adherence to strict timing, system resource, or interface constraints; Perform quality control on team products</li><li>Implement recommendations for improving documentation and software development process standards</li><li>Oversee one or more software development teams and ensure the work is completed in accordance with the constraints of the software development process being used on any particular project</li><li>Confer with system engineers and hardware engineers to derive software requirements and to obtain information on project limitations and capabilities, performance requirements and interfaces</li><li>Coordinate software system installation and monitor equipment functioning to ensure operational specifications are met</li></ul>Salary range for this position: $210,000 - 232,000  #CJ The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.Red Arch Solutions Benefits Snapshot:<ul><li>100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.</li><li>HaloScripts Concierge prescription medication service</li><li>Generous PTO.</li><li>10 % 401K 6% match vested day one and up to 4% profit sharing contribution.</li><li>Annualized bonus compensation.</li><li>Spot bonuses for hard work.</li><li>Tuition reimbursement.</li><li>529 College Saving Plan.</li><li>College Loan Pay Back Program.</li><li>11 Paid Federal Holidays</li><li>Generous Referral Bonuses.</li></ul>Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.Have more questions about Red Arch? Email us at Careers@RedArchSolutions.comPowered by JazzHRvgG65lETKp</div></div>

<h5>Software Engineer </h5>Active TS/SCI Clearance with Poly Required Overview: Red Arch Solutions is hiring a Software Engineer to join our program in Fort Meade, Maryland. Requirements: Must have TS/SCI clearance w/ active polygraph. Bachelor's degree in Computer Science or related discipline from an accredited college or university is required. Four (4) years of additional SWE experience on projects with similar software processes may be substituted for a bachelor's degree. Relevant experience must be in engineering systems over their lifecycle (for example, conception, design & development, testing, production, distribution/deployment, operation, maintenance & support, decommissioning). Level 02 - Fourteen (14) years of experience as a SWE in programs and contracts of similar scope, type, and complexity is required. Software Engineering experience developing using the following or comparable software technologies: Java SE, Python, Git, Shell/bash, Nexus, Maven, JavaScript/HTML5/CSS3, JUnit, and IDEs. Software architecture development, requirements analysis, code generation, process execution and evaluation, selection and evaluation Software Engineering Experience with containers and container orchestration (e.g., Docker/Kubernetes/OpenShift and GitLab CI) is highly desired, including experience with the following: - microservices and microservice orchestration; - experience with CI/CD pipelines; - integration of automated testing tools like SonarQube; - implementing automated deployments/failure rollbacks; - deployment to Kubernetes Agile Experience supporting programs using an agile development methodology, delivering a new capability in every Sprint Software Engineering Experience with Spring Framework, Spring Tool Suite, Grit, Jenkins, Hibernate, MySQL, Web Services, and Google Web Toolkit or Vaadin, also a plus Responsibilities include, but are not limited to: <ul> <li>Analyze user requirements to derive software design and performance requirements </li><li>Debug existing software and correct defects </li><li>Provide recommendations for improving documentation and software development process standards </li><li>Design and code new software or modify existing software to add new features </li><li>Integrate existing software into new or modified systems or operating environments </li><li>Develop simple data queries for existing or proposed databases or data repositories </li><li>Write or review software and system documentation </li><li>Serve as team lead at the level appropriate to the software development process being used on any particular project </li><li>Design or implement complex database or data repository interfaces/queries </li><li>Develop or implement algorithms to meet or exceed system performance and functional standards </li><li>Assist with developing and executing test procedures for software components </li><li>Develop software solutions by analyzing system performance standards, confer with users or system engineers; analyze systems flow, data usage and work processes; and investigate problem areas </li><li>Modify existing software to correct errors, to adapt to new hardware, or to improve its performance </li><li>Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design </li><li>Design or implement complex algorithms requiring adherence to strict timing, system resource, or interface constraints; Perform quality control on team products </li><li>Implement recommendations for improving documentation and software development process standards </li><li>Oversee one or more software development teams and ensure the work is completed in accordance with the constraints of the software development process being used on any particular project </li><li>Confer with system engineers and hardware engineers to derive software requirements and to obtain information on project limitations and capabilities, performance requirements and interfaces </li><li>Coordinate software system installation and monitor equipment functioning to ensure operational specifications are met </li></ul> Salary range for this position: $180,000 - 195,000 #CJ The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data. Red Arch Solutions Benefits Snapshot: <ul> <li>100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits. </li><li>HaloScripts Concierge prescription medication service </li><li>Generous PTO. </li><li>10 % 401K 6% match vested day one and up to 4% profit sharing contribution. </li><li>Annualized bonus compensation. </li><li>Spot bonuses for hard work. </li><li>Tuition reimbursement. </li><li>529 College Saving Plan. </li><li>College Loan Pay Back Program. </li><li>11 Paid Federal Holidays </li><li>Generous Referral Bonuses. </li></ul> Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Have more questions about Red Arch? Email us at Careers@RedArchSolutions.com

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

Red Arch Solutions Interview Questions

Red Arch Solutions Interview Guides

Red Arch Solutions Interview Questions

Challenge

Red Arch Solutions Opening Jobs

Discussion & Interview Experiences

Discussion & Interview Experiences