Prepare for and practice interview questions from Lancesoft, Inc..

Lancesoft, Inc. Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Lancesoft, Inc. Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

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?

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>

First Touch Attribution

Information Technology Business AnalystLocation Address: 44 King Street W (44 KING) 11th Floor Contract Duration: 5 monthsPossibility of extension – YesPossibility of conversion to FTE - YesMust-Have: 1) 8+ years of experience as a technical BA 2) 3+ years experience in a technical domain (e.g., software development, operations). 3) 3+ years hands on experience with building and maintaining DevOps environments and CI/CD pipelines. 4) 3+ years experience working in Agile environments 5) 3+ years of experience with Release Management/automation 6) Familiarity with process analysis techniques (e.g., Value Stream Mapping, Six Sigma). Nice-to-Have: • advanced ITSM experience, especially with ITIL frameworks. • Spanish language skills. • Experience with ServiceNow DPR and Release Management. • ITIL certification preferred Soft Skills: • Critical thinker with strong analytical and problem-solving abilities. • Proven leadership in both people and process initiatives. • Champions a high-performance, inclusive, and customer-focused culture • Excellent communication and stakeholder engagement skills. • Fluency in English. Education & Certifications: • Bachelor’s degree in Computer Science, Computer Engineering, or a related field.

Information Technology Business AnalystLocation Address: 44 King Street W 19th Floor (44K-19)Hybrid: 2 days in-office (will increase to 4 days in future) Contract Duration: 01/05/2026 to 12/31/2026Possibility of extension: Yes, based on performance and business needsConversion to FTE: May be, based on performance and business needsMust have skills: • 10+ years of experience working in a similar capacity as a BA/BSA • 7 + years of Recent project experience writing intermediate to advanced queries using SQL. • 7+ years of experience as Business Data analyst working with large sets of data including data mapping and Big Data technologies • 3+ years' finance/accounting background • 3 + years of experience with revenue reporting and P&L Nice to have: • Power BI is a strong asset. • Experience with automated testing. • Agile/Scrum methodology understanding / worked in an Agile environment • Previous recent experience working with Top 5 Banks/FI Soft Skills Required: • Proactive and a self-starter • Ability to work as part of a team, as well as work independently or with minimal direction. • Excellent written, presentation, and verbal communication skills. • Ability to handle different user groups Education: • Bachelor's degree in a technical field such as Computer Science, Computer Engineering or related field required. • Financial courses or certification completion is an asset. • Prior courses taken in Mathematics (statistical analysis and discreet mathematics)

Job Requirements• Bachelor’s in business, marketing, or finance or similar is required• 2+ years of relevant business experience in the field of pricing or finance• Experience working with a pricing software (PROS, Vendavo or similar) is a nice to have• Strong leadership, project management, analytical skills with the ability to influence people at different levels across the organization• Strong communication (verbal, written, presentation) skills• Very good business acumen, results-driven, self-motivating and hands-on approach• Creative problem-solving skills and great attention to detailsJob Responsibilities • Member of the regional pricing team to shape and implement the pricing strategy within the General Maintenance & Manufacturing Strategic Business Unit of Adhesive Technologies• Support all pricing related topics, ensure pricing governance, and manage pricing processes• Monitor pricing performance with reviews on pricing, cost, and identification of outliers in close collaboration with category & product management teams• Review and resolve pricing deductions, inquiries, and requests in a timely manner• Support coordination of Contract-Through-Distribution (CTD) rebate process; working with CTD processors, Distributors, and sales personnel to minimize errors and create proactive solutions to develop best-in-practice rebate management process• Handle all issues with the quotation process and coordinate resolution of issues related to the pricing tool, from user access to troubleshooting

Pay $65-75/hr Looking for richmond & Mclean, VA hybrid Application developer is responsible for designing, developing, testing, deployment and maintaining the services following the enterprise standards and guidelines with the thorough understanding of cloud environment and DevSecOps. Basic Qualifications- Bachelor Degree in Computer science or related field- At least 5 years of experience in software development including design, coding and testing- At least 2 years of experience in Java, Spring and SprintBoot frameworks- At least 3 years of experience in design and development of Restful APIs- At least 3 years of experience in using the DEVOPS tools for pipelines- At least 2 years of experience in Cloud environment using various compute, storage and network services Preferred Qualifications- Experience in Identity and Access Management related services using SAML, OIDC/OAUTH- Experience AWS Cloud environment for various services- Experience in Application/Data security with the understanding of OWASP top 10

Title: Elastic Engineer / Elasticsearch Specialist with Java (Spring boot, Kafka)Duration: 6+ months (Extension Possible) Location: DALLAS/ PITTSBURGH/ Strongsville- (Onsite, 5 days/week) Role Summary:Exp: 10 & Above Skills must have: Pega, Pega Decision Management Design and implement Next-Best-Action (NBA) strategies using Pega CDH Configure and optimize decision strategies, engagement policies, and predictive models. Develop and maintain Pega rules, flows, and data models aligned with business requirements. Integrate Pega CDH with external systems for data ingestion and outbound communication. Collaborate with business analysts, architects, and QA teams to ensure high-quality deliverables. Perform unit testing, debugging, and performance tuning of Pega applications. Stay updated with Pega platform upgrades and best practices. 7 years of experience in Pega development, with at least 4 years in Pega CDH. Strong knowledge of Pega Decisioning Framework, NBA Designer, and Customer Profile Designer. Experience with Pega 8.x or higher versions. Familiarity with data flows, adaptive models, and predictive analytics. Experience in SQL queries Understanding of integration protocols (SOAP, REST, MQ, etc.). Pega certifications such as CPDC (Certified Pega Decisioning Consultant) or CSACSSA preferred. Excellent problem-solving and communication skills. Nice-to-Have API development and debugging. Knowledge of Agile methodologies and DevOps practices. Exposure to cloud environments (AWS, Azure, GCP).

Senior Business AnalystLocation Address: Hybrid - 333 King Street East, Toronto – 3 days/week onsite, no exceptions (which days will depend on project squad, TBD)Contract Duration: ASAP to 04/30/2026 - approx. 4 monthsPossibility of extension & conversion to FTE Typical Day in Role:<ul><li>Analyze and develop technical requirements based on solution documentation</li><li>Ensure integrity of the business and technical requirements in the end-to-end customer journey</li><li>Drive joint application design solutioning sessions with our architecture, development, and security</li><li>architecture teams that inform high-level estimates for large and medium-sized incoming initiatives</li><li>Facilitate requirements gathering and design sessions with multiple stakeholders to extract</li><li>requirements, and turn them into use cases, user stories, sequence diagrams, etc. to meet development and stakeholder needs</li><li>Lead enterprise process engineering development across infrastructure, Security, DevOps and cryptography teams </li><li>Create, refine and maintain the product backlog and associated deliverables; release backlog with forecasted delivery timelines</li><li>Bridge the gap between business and IT, ensuring common understanding and IT/Business</li><li>alignment of both functional (for business needs) and non-functional requirements (such as</li><li>reporting, performance, interfaces, and constraints.)</li><li>Help improve and drive our engineering practices by providing valuable inputs and suggestions as to what works well and what can be done better</li></ul> Candidate Requirements/Must Have Skills: 1) 10+ years of progressive experience as a Business Systems Analyst in a challenging IT system solution environment 2) 5+ years of hands-on experience with REST API's and microservices 3) 5+ years’ experience working with API documents using either Swagger or OpenAPI 4) 4+ years’ experience creating BSA artifacts – user stories, sequence diagrams, flow, UML diagrams etc. 5) Recent experience from FI/banking Nice-To-Have Skills: 1) Experience as a Delivery Lead or Scrum master (scrum master preferred) 2) Experience with system analysis on enterprise level solutions 3) Experience with estimating high level work efforts 4) 5+ years of experience in an agile environment – agile/lean evangelist

Job Title: Business AnalystLocation: Waltham, MADuration: 6 months Core Skills and Expertise:Expert in Agile and Scrum methodologies, including requirements gathering and process mapping.Expert-level knowledge in capturing BRDs, FRDs, epics, user stories, acceptance criteria, and defining Definition of Done.Skilled in data manipulation using Excel, SQL, BI tools, dashboards, and data visualization.Ability to collaborate with cross-functional teams—including marketing, UX, IT, finance, and operations—to align digital initiatives with overall business objectives.Perform customer behavior research and market trend analysis to guide e-commerce strategy.Strong background in the Retail Domain, with extensive e-commerce experience.

<h5>Job Title </h5>Enter Job Description... Experience business analysis experience on software development projects including: the preparation of project related documentation. Strong interpersonal, collaborative, analytical, written/verbal/presentation communication skills in English (specifically technical writing); and well versed with MS Office suite of products and prototyping.

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

Lancesoft, Inc. Interview Questions

Lancesoft, Inc. Interview Guides

Lancesoft, Inc. Interview Questions

Lancesoft, Inc. Opening Jobs