Prepare for and practice interview questions from Novalink Solutions Llc.

Novalink Solutions Llc Interview Questions

Novalink Solutions Llc Interview Guides

Machine Learning

Encoding Categorical Features

Say you are given a dataset of perfectly linearly separable data. What would happen when you run logistic regression?

Perfectly Separable

Missing Housing Data

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

Get Top N Frequent Words

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

Prime to N

Move Zeros Back

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

Closest SAT Scores

Get the top 3 highest employee salaries by department

Top Three Salaries

Probability

First to Six

500 Cards

Raining in Seattle

Found Item

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

Median Probability

Statistics

P-value to a Layman

What are the assumptions of linear regression?

Assumptions of Linear Regression

Using R Squared

What statistical test could you use to determine which of two parcel types is better to use, given how often they are damaged?

Different Parcel Effectiveness

Unbiased Estimator

<p>When an interviewer asks a question along the lines of:</p>

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

<p>How would you respond?</p>


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

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

Your Strengths and Weaknesses I

<p>Which of the following is an acceptable strategy when discussing weaknesses in an interview?</p>

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

Your Strengths and Weaknesses II

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

Your Strengths and Weaknesses

Brainteasers

<p>When an interviewer asks you a question along the lines of:</p>

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

<p>How should you respond?</p>


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

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

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

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

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

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

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

Why Do You Want to Work With Us

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


Describing a data project and its challenges

Hurdles In Data Projects

Analytics

<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

<p>What are the assumptions of linear regression?</p>


Which assumption of the residuals of the standard linear regression model can not be overcome by increasing the sample size?

Regression assumptions

<p>Let’s say that you’re training a classification model.</p>

<p>How would you combat overfitting when building tree-based models?</p>


Let's say that you're training a classification model.   How would you combat overfitting when building tree-based models?

Overfit Avoidance

<p>How would you handle the data preparation for building a machine learning model using imbalanced data?</p>


Addressing imbalanced data in machine learning through carefully prepared techniques.

Data Preparation for Imbalanced Data

<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

Bagging vs Boosting

<p>Talk about a time when you had trouble communicating with stakeholders. How were you able to overcome it?</p>


Strategically resolving misaligned expectations with stakeholders for a successful project outcome

Stakeholder Communication

<p>Given a string, write a function to determine if it is palindrome or not.</p>

<p><em>Note: A palindrome is a word/string that is read the same way forward as it is backward, e.g. <code>&#39;reviver&#39;</code>, <code>&#39;madam&#39;</code>, <code>&#39;deified&#39;</code> and <code>&#39;civic&#39;</code> are all palindromes, while <code>&#39;tree&#39;</code>, <code>&#39;music&#39;</code> and <code>&#39;person&#39;</code> are not palindromes.</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">word1</span> <span class="o">=</span> <span class="s2">&#34;tree&#34;</span>
</span></span><span class="line"><span class="cl"><span class="n">word2</span> <span class="o">=</span> <span class="s2">&#34;radar&#34;</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">is_palindrome</span><span class="p">(</span><span class="n">word1</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="kc">False</span>
</span></span><span class="line"><span class="cl"><span class="k">def</span> <span class="nf">is_palindrome</span><span class="p">(</span><span class="n">word2</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="kc">True</span>
</span></span></code></pre>


Given a string, write a function to determine if it is palindrome or not.

String Palindromes

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

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


Bias vs. Variance Tradeoff

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


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


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

XGBoost vs Random Forest: Choice

Xgboost vs Random Forest

<p>How does random forest generate the forest? Additionally, why would we use it over other algorithms such as logistic regression?</p>


<p>What happens when you average the output on multiple decision trees?</p>


What happens when you average the output on multiple decision trees?

Average Trees

Random Forest Explanation

<p>What is the difference between Logistic and Linear Regression?</p>

<p>When would use one instead of the other in practice?</p>


What is the difference between Logistic and Linear Regression?

Linear vs Logistic Regression

<p>Let’s say that you work at a B2B SAAS company that’s interested in testing the pricing of different levels of subscriptions.</p>

<p>Your project manager comes to you and asks you to run a two-week-long A/B test to test an increase in pricing.</p>

<p>How would you approach designing this test?  How would you determine whether the increase in pricing is a good business decision?</p>


Testing Price Increase

A/B Testing

<p>Tell me about a project in which you had to clean and organize a large dataset.</p>


Describing a real-world data cleaning and organization project

Data Cleaning Experiences

Data Pipelines

<p>What are the key differences between classification models and regression models?</p>


<p>What is the MOST important difference between regression and classification models?</p>


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

Classification vs Regression

Classification and Regression

<p>Given an array and a target integer, write a function <code>sum_pair_indices</code> that returns the indices of two integers in the array that add up to the target integer. If not found, just return an empty list.</p>

<p><em>Note: Can you do it on \(O(n)\) time?</em></p>

<p><em>Note: Even though there could be many solutions, only one needs to be returned.</em></p>

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

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">array</span> <span class="o">=</span> <span class="p">[</span><span class="mi">1</span> <span class="mi">2</span> <span class="mi">3</span> <span class="mi">4</span><span class="p">]</span> 
</span></span><span class="line"><span class="cl"><span class="n">target</span> <span class="o">=</span> <span class="mi">5</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">sum_pair_indices</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">target</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="p">[</span><span class="mi">0</span> <span class="mi">3</span><span class="p">]</span> <span class="ow">or</span> <span class="p">[</span><span class="mi">1</span> <span class="mi">2</span><span class="p">]</span>
</span></span></code></pre>

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

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">array</span> <span class="o">=</span> <span class="p">[</span><span class="mi">3</span><span class="p">]</span>
</span></span><span class="line"><span class="cl"><span class="n">target</span> <span class="o">=</span> <span class="mi">6</span> 
</span></span></code></pre>

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">Do</span> <span class="n">NOT</span> <span class="k">return</span> <span class="p">[</span><span class="mi">0</span> <span class="mi">0</span><span class="p">]</span> <span class="k">as</span> <span class="n">you</span> <span class="n">can</span><span class="s1">&#39;t use an index twice.</span>
</span></span></code></pre>


Given an array and a target integer, write a function that returns the indices of two integers in the array that add up to the target integer.

Target Indices

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


Experiment Validity

<p>Let’s say that you work at a bank that wants to build a model to detect fraud on the platform.</p>

<p>The bank wants to implement a text messaging service in addition that will text customers when the model detects a fraudulent transaction in order for the customer to approve or deny the transaction with a text response.</p>

<p>How would we build this model?</p>


<p>Let’s say that you work at a bank that wants to build a model to detect fraud on the platform.</p>

<p>The bank wants to implement a text messaging service that will text customers when the model detects a fraudulent transaction in order for the customer to approve or deny the transaction with a text response.</p>

<p>Which statement is true?</p>


Let's say that you work at a bank that wants to build a model to detect fraud on the platform.

The bank wants to implement a text messaging service that will text customers when the model detects a fraudulent transaction in order for the customer to approve or deny the transaction with a text response.

Which statement is true?

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


Size of Joins

<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>How would you convey insights and the methods you use to a non-technical audience?</p>


Making data-driven insights actionable for those without technical expertise

Simple Explanations

<p>What’s the relationship between PCA and K-means clustering?</p>


<p>What does the variable “k” in k-means clustering refer to?</p>


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

Input of K-means

PCA and K-Means

<p>Let’s say you are working on Google Docs. A product manager comes to you and asks how the product is doing. </p>

<p>What are the top five metrics that you would start tracking to understand the health of Google Docs?</p>


Docs Metrics

Product Sense & Metrics

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

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

<p><strong>Example 1:</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">5</span>
</span></span></code></pre>

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">fibonacci</span><span class="p">(</span><span class="n">n</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="mi">5</span>
</span></span></code></pre>

<p><strong>Example 2:</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">10</span>
</span></span></code></pre>

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

<pre tabindex="0" class="chroma"><code><span class="line"><span class="cl"><span class="n">fibonacci</span><span class="p">(</span><span class="n">n</span><span class="p">)</span> <span class="o">-&gt;</span> <span class="mi">55</span>
</span></span></code></pre>

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


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

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

<p>How would you go about diagnosing and improving the performance of this query?</p>


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

Slow SQL Query

Query Optimization

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


<p>How would you explain the bias variance tradeoff in machine learning to a high school student?</p>


Replaced by QUESTION 791 - Should be deleted

Bias Variance Tradeoff

Challenge

Novalink Solutions Llc Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div>looking for an experienced and ambitious Business Analyst (BA) to join the team. As a BA, she or he will under general direction, as part of a team, provides program technical assistance to data systems professionals and technicians engaged in establishing and enhancing Ohio’s Comprehensive Child Welfare Information Systems (CCWIS) (i.e., Ohio Statewide Automated Child Welfare Information System [Ohio SACWIS]; Business Intelligence Channel [BIC]; Results Oriented Management [ROM]; TEAM Ohio) and other child serving program applications (i.e., adoption and placement data; child abuse and neglect tracking; intake and assessment; resource management; program eligibility and financial tracking).<br /></div><div><br /></div><div><b>The BA will be responsible for: </b><br /></div><div>• Remaining current in program policy changes<br /></div><div>• Providing program technical assistance to DCY development personnel and contractors in determining scope and requirements derived from federal system requirements document (i.e., interpreting federal and state statutes to ensure compliance in child welfare information system design)<br /></div><div>• Creating, updating and reviewing design documents; plans, develops, and recommends performance criteria and test case scenarios (i.e., creating realistic child welfare scripts)<br /></div><div>• Conducting system tests to ensure expected outcomes and to test user scenarios<br /></div><div>• Assisting with data conversion from current child welfare information systems<br /></div><div>• Assisting in implementation of new systems<br /></div><div>• Developing marketing material for partner agencies<br /></div><div>• Developing webinars, procedure manuals, and user support documentation<br /></div><div>• Monitoring adherence of system development to federal and state requirements<br /></div><div>• Providing help desk customer service to system users (i.e., county Public Children Service Agencies (PCSAs), Title IV-E Juvenile Courts, private non-custodial agencies (PNAs), and private child placing agencies (PCPAs))<br /></div><div>• Creating and deliver trainings to system users in conjunction with other DCY bureaus to ensure program compliance through use of state's child welfare information systems<br /></div><div>• Monitoring counties knowledge and use of state's child welfare information systems by identifying user and/or software problems through help desk activities with PCSAs, PNAs, and PCPAs staff<br /></div><div>• Responding to PCSAs, PNAs, and PCPAs inquiries regarding child welfare information systems user related issues<br /></div><div>• Providing technical assistance<br /></div><div>• Determining security profiles for agency staff<br /></div><div>• Analyzing data<br /></div><div>• Creating reports and assists with federal reporting requirements<br /></div><div>• Identifying source of problems and prepares corrective action steps<br /></div><div>• Participating in and/or supplies technical solutions to meet federal requirements (i.e., establishing schedule of activities with timetables for completion)<br /></div><div>• Monitoring PCSAs, PNAs, and PCPAs to ensure readiness and compliance<br /></div><div>• Preparing responses to inquiries from government officials, constituent groups, and general public<br /></div><div>• Representing child welfare information systems and prepare and deliver speeches and presentations at meetings and conferences<br /></div><div>• Participating in the development and/or revision of program policies<br /></div><div>• Performing other related duties as assigned (e.g., attending and participating in staff meetings; traveling to attend meetings, conferences, and trainings; compiling periodic activity and project status reports or ad hoc narrative and statistical reports; participating on special assignments; operating personal computer to produce correspondence, reports, and other documents; maintaining logs, records, and files).<br /></div><div><br /></div><div><br /></div><div><b>Experience</b><br /></div><div><br /></div><div>• Knowledge of human services program delivery pertinent to assigned process automation project<br /></div><div>• Federal and/or state laws, rules, regulations and best practice scenarios for human services program delivery pertinent to assigned process automation project<br /></div><div>• Public speaking<br /></div><div>• Technical writing<br /></div><div>• Interviewing and facilitation<br /></div><div>• Automated business rules and rules engines<br /></div><div>• Skill in operation of personal computer and software programs (e.g., Microsoft Word, Excel, Access)<br /></div><div>• Ability to define unusual problems, collect data, establish facts and draw complex technical conclusions<br /></div><div>• Read and comprehend legislative or policy-related materials<br /></div><div>• Create and/or edit <span class="long-word">technical/instructional</span> materials to be presented in print or oral form to variety of human services personnel<br /></div><div>• Handle routine and sensitive contacts with governmental, business officials, and general public<br /></div><div>• Work independently or as part of team<br /></div><div><br /></div><div><br /></div><div><b>Mandatory Requirements</b><br /></div><div>• 2-year college degree or equivalent technical study <br /></div><div>• 24 months of workflow automation<br /></div><div>• 24 months of Salesforce experience<br /></div><div>• 24 months of applying laws, policies & procedures<br /></div><div>• Competency in Microsoft applications including Visio, Word, Excel, PowerPoint and Outlook <br /></div><div><br /></div><div><b>Preferred</b><br /></div><div>• Salesforce experience is preferred<br /></div><div>• Ohio SACWIS experience is preferred<br /></div><div>• Experience leading digital workflow automation projects preferred<br /></div><div><br /></div><div><br /></div><div><br /></div><br />Requirements<div><div><div><div><div><div><div><div><div><div><div><div><div><div>Skill<br /></div><div>Required / Desired<br /></div><div>Amount<br /></div><div>of Experience<br /></div></div></div></div><div><div><div>• 2-year college degree or equivalent technical study<br />Required<br />2<br />Years<br /></div><div>• 24 months of workflow automation<br />Required<br />2<br />Years<br /></div><div>• 24 months of Salesforce experience<br />Required<br />2<br />Years<br /></div><div>• 24 months of applying laws, policies & procedures<br />Required<br />2<br />Years<br /></div><div>• Competency in Microsoft applications including Visio, Word, Excel, PowerPoint and Outlook<br />Highly desired<br><br></div><div>• Salesforce experience is preferred<br />Highly desired<br><br></div><div>• Ohio SACWIS experience is preferred<br />Highly desired<br><br></div><div>• Experience leading digital workflow automation projects preferred<br />Highly desired<br><br></div></div></div></div></div></div></div></div></div></div></div></div></div><div><div><br /></div></div><div><br /></div><br /></div></div>

<h3>Job Description</h3><div>Job Description<div><div>During this assignment, the financial business analyst will report to the State functional manager to<br /></div><div>provide status updates on assigned tasks. The resource should be able to work independently with<br /></div><div>minimum guidance to enhance the current application’s user interface to be interactive and self-guided<br /></div><div>primarily in financial areas of SC Child Support Application.<br /></div><div>Primary Responsibilities<br /></div><div>• Work closely with the State Functional Manager and Business Analysts to identify areas for<br /></div><div>improvement within PACSS and deliver practical, actionable recommendations.<br /></div><div>• Analyze existing workflows to uncover inefficiencies and pain points.<br /></div><div>• Design optimized workflows for complex processes in alignment with South Carolina business<br /></div><div>requirements.<br /></div><div>• Propose enhanced functionality for complex financial activities within PACSS.<br /></div><div>• Design self-guiding workflows, including guided navigation, tooltips, and contextual assistance,<br /></div><div>for critical areas such as order entry and financial adjustments.<br /></div><div>• Design user-friendly features such as step-by-step wizards, contextual help, and automated<br /></div><div>guidance to improve usability and reduce training needs.<br /></div><div>• Conduct stakeholder interviews as needed to gain a comprehensive understanding of South<br /></div><div>Carolina business processes.<br /></div><div>• Collaborate with other Business Analysts to develop comprehensive test scenarios, test cases,<br /></div><div>and provide general assistance during testing activities.<br /></div><div>• Participate in regular functional meetings focused on user-reported issues, enhancements, and<br /></div><div>bug triage to review progress, discuss solutions, and align on priorities.<br /></div><div>REQUIRED SKILLS (RANK IN ORDER OF<br /></div><div>IMPORTANCE):<br /></div><div>1. Experience working as a Financial<br /></div><div>Business Analyst in more than one<br /></div><div>Child Support Systems<br /></div><div>2. Experience working with financial<br /></div><div>operations (such as receipts,<br /></div><div>distribution, disbursements,<br /></div><div>recoupment, and/or reconciliation) in<br /></div><div>more than one Child Support System<br /></div><div>3. Experience in system designing and<br /></div><div>developing processes for complex<br /></div><div>workflows<br /></div><div>PREFERRED SKILLS (RANK IN ORDER OF<br /></div><div>IMPORTANCE):<br /></div><div>1. Experience with Microsoft Team<br /></div><div>Foundation Server (TFS) and<br /></div><div>Microsoft Test Manager<br /></div><div>2. Experience with SQL query skills to<br /></div><div>extract, validate and interpret data for<br /></div><div>decision making<br /></div><div>3. Experience with Sharepoint<br /></div><div>REQUIRED EDUCATION:<br /></div><div>BS Degree or equivalent work experience.<br /></div><div>ADDITIONAL SKILLS:<br /></div><div>Proficiency in MS Office suite<br /></div><div>Ability to communicate (orally and written)<br /></div><div>effectively with technical, non-technical staff,<br /></div><div><span class="long-word">customers/stakeholders</span> (State and Federal)<br /></div><div>and executives<br /></div><br /><span class="long-word">RequirementsRequired</span> Skills<br /><div><div><div>Skill Type<br /></div><div>Skill Name<br /></div></div><div><div><span class="long-word">CertificationEducationLicenseOtherSkill</span></div><div>Experience working as a Financial Business Analyst in more than one Child Support Systems<br /></div></div><div><div><span class="long-word">CertificationEducationLicenseOtherSkill</span></div><div>Experience working with financial operations (such as receipts, distribution, disbursements, recoupment, and/or reconciliation) in more than one Child Support System<br /></div></div><div><div><span class="long-word">CertificationEducationLicenseOtherSkill</span></div><div>Experience in system designing and developing processes for complex workflows<br /></div></div></div>Preferred Skills<br /><div><div><div>Skill Type<br /></div><div>Skill Name<br /></div></div><div><div><span class="long-word">CertificationEducationLicenseOtherSkill</span></div><div>Experience with Microsoft Team Foundation Server (TFS) and Microsoft Test Manager<br /></div></div><div><div><span class="long-word">CertificationEducationLicenseOtherSkill</span></div><div>Experience with SQL query skills to extract, validate and interpret data for decision making<br /></div></div><div><div><span class="long-word">CertificationEducationLicenseOtherSkill</span></div><div>Experience with Sharepoint<br /></div></div></div><div><br /></div><br /></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

Novalink Solutions Llc Interview Questions

Novalink Solutions Llc Interview Guides