The Laksan technologies Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Laksan technologies Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Laksan technologies? The Laksan technologies Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Laksan technologies Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Laksan technologies.</li>
<li>Practice real Laksan technologies Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Laksan technologies Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Laksan technologies? The Laksan technologies Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Laksan technologies Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Laksan technologies.
- Practice real Laksan technologies Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Laksan technologies Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Laksan technologies Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

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

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

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

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

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

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

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

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

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


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

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

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

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


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

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

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

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

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Laksan technologies Business Intelligence Interview Questions

This Data Scientist position with the Professional Services Procurement Office will be an important member of the VDOT PSPO team. In this role, the Data Scientist
collects and analyzes statistics and information from multiple sources to spot trends and to gain maximum insight that can give the company a competitive advantage and communicates informed conclusions and recommendations across an organization's leadership structure. Strategizes a
nd identifies unique opportunities to locate and collect new data, explores and mines data from many angles, and determines what it means. Communicates data findings to both business and IT leaders to influence how an organization approaches and meets business challenges of an evolving customer base and changing marketplace, using strong business acumen. Finds and recommends new uses for existing data sources; designs, modifies, and builds new data processes; and builds large, complex data sets.
In addition to standard knowledge, skills and abilities for a Data Scientist, the successful candidate for this role will have experience and knowledge of procurement, preferably professional services procurement and the data related to this business need as well as procurement related reporting systems and technology.
Skills Specific to this Position :
Provide expertise to agency on data-driven decision making and strategy.
Provide expertise in specific areas, such as machine learning, predictive analytics using data and systems related to public procurement.
Leading research projects, for advanced date mining, developing algorithms, or building data pipelines related to public procurement.
Tools and Technologies :
Programming languages : SQL, Python, PySpark, Shell Scripting, PowerShell
Other frameworks :  git, GitHub, SSH Secure Shell, Putty, XML, JSON, SQL Workbench
Statistical tools :  Snowflake, Redshift, Oracle, MySQL, Microsoft SQL Server, PostgreSQL
Create a job alert for this search  Data Scientist • Richmond, VA, United States

#J-18808-Ljbffr

<h3>Job Description</h3><div>Job Description<div><p><strong>About Lark</strong></p><p>At Lark Health, we’re leading the way into a new era of cardiometabolic care, leveraging advanced AI techniques–including deterministic and generative models–to provide scalable, affordable, and compassionate care. We help our healthcare partners manage over 30 million lives and prevent conditions like obesity, hypertension, type II diabetes, and behavioral health. Our platform delivers real-time personalized counseling and health monitoring for each patient. By providing compelling and actionable insights, we empower every user to live happier, healthier lives. Come join our team!</p><p><strong>The Role<br /></strong>As the Lead Marketing Analyst at Lark, you’ll collect, analyse, model and visualize our marketing data to generate reports and insights. Reporting directly to the Director of Marketing Analytics, you’ll design internal dashboards, enhance our marketing activities, and help the company grow. You’ll collaborate across the organization—Consumer marketing, Product, Finance, and more—to translate business requirements into powerful, scalable data solutions.</p><p><strong>What You’ll Do</strong></p><ul><li><p>Drive substantial gains in growth, conversion rates, customer engagement, and ROI by delivering sharp insights and recommendations</p></li><li><p>Partner with channel managers to measure the effectiveness of customer acquisition and engagement campaigns</p></li><li><p>Develop analysis, reports, and recommendations to deliver continuous improvement in performance and identify new opportunities</p></li><li><p>Serve as a key member of our testing and experiments activities, build a testing roadmap that spans our customer touchpoints, steer rigorous implementation, and analyze results</p></li><li><p>Propose, socialize, and implement data and systems improvements that enable improved cross-channel coordination, targeting, ROI measurement, segmentation, and personalization</p></li><li><p>Become a subject matter expert in our online enrollment flows, attribution, engagement, marketing automation, analytics platforms, and associated data</p></li><li><p>Develop innovative reporting and dashboards that make it easy to understand campaign performance at a glance, and be the owner of those metrics as they vary along key customer segments</p></li><li><p>Understand data requirements of various campaigns and systems, prepare, format, and verify data files, and ensure compliance with rigorous security and compliance standards</p></li><li><p>Partner with Data Engineering & Data Science. Optimize and align data models in Snowflake, and explore ways to implement AI/ML features in future reporting initiatives</p></li></ul><p><strong>What You’ll Need</strong></p><ul><li><p>Expertise in SQL, Snowflake, Tableau, and dbt</p></li><li><p>Advanced, hands-on experience with major online marketing tools, such as automation marketing platforms (preferred - Braze), organic and paid media platforms, and testing tools</p></li><li><p>Strong Analytical Skills: Ability to translate open-ended business questions into defined problem statements and structured analyses</p></li><li><p>Effective collaboration: Skilled at simplifying technical details for diverse audiences and translating insights into strategic actions, forming strong partnerships with multiple cross-functional teams</p></li><li><p>Project Management: Demonstrated ability to juggle multiple priorities, set realistic timelines, and meet deadlines in a fast-paced environment</p></li><li><p>Data Architecture Know-How: Comfortable designing and maintaining presentation-layer data structures that feed internal and external reporting needs</p></li><li><p>Experience mentoring analysts, fostering a supportive, growth-oriented environment</p></li><li><p>5+ years of progressive experience in analytics or business intelligence, including at least 2 years in a mentorship role</p></li><li><p>Bachelor’s degree in STEM or a related field, or relevant professional experience</p></li></ul><p><strong>Working at Lark </strong></p><p>Lark operates as a remote organization, requiring all employees to reside within the United States.  The specific salary offered to a candidate will depend on various factors, including their location, job level, and verified job-related knowledge, skills, and experience. In addition to a comprehensive benefits package, candidates may be eligible for additional compensation, such as participation in a bonus program and stock awards, where applicable.</p><p><em>Lark is an Equal Opportunity and Affirmative Action Employer. We believe that diverse teams foster innovation and add to our mission-driven culture. We strongly encourage people from underrepresented groups to apply.</em></p><p></p><p><em>#LI-JB1</em></p><p><em>#LI-Remote</em></p><p>Compensation Range: $104.7K - $157.2K</p></div></div>

Join to apply for the  Staff Software Engineer - Mobile  role at  Lark Health
Join to apply for the  Staff Software Engineer - Mobile  role at  Lark Health
Get AI-powered advice on this job and more exclusive features.
About Lark

At Lark Health, we’re leading the way into a new era of cardiometabolic care, leveraging advanced AI techniques–including deterministic and generative models–to provide scalable, affordable, and compassionate care. We help our healthcare partners manage over 30 million lives and prevent conditions like obesity, hypertension, type II diabetes, and behavioral health. Our platform delivers real-time personalized counseling and health monitoring for each patient. By providing compelling and actionable insights, we empower every user to live happier, healthier lives. Come join our team!
About Lark

At Lark Health, we’re leading the way into a new era of cardiometabolic care, leveraging advanced AI techniques–including deterministic and generative models–to provide scalable, affordable, and compassionate care. We help our healthcare partners manage over 30 million lives and prevent conditions like obesity, hypertension, type II diabetes, and behavioral health. Our platform delivers real-time personalized counseling and health monitoring for each patient. By providing compelling and actionable insights, we empower every user to live happier, healthier lives. Come join our team!

The Role

We’re seeking a Staff Software Engineer with deep expertise in React Native and mobile application development, coupled with strong leadership and mentoring skills. In this role, you’ll lead technical direction for our mobile initiatives, mentor engineers, and partner cross-functionally to scale and modernize Lark’s app. This is a high-impact role ideal for someone who is passionate about quality, collaboration, and shaping the future of mobile health.

What You’ll Do

Technical Leadership & Strategy

Set the technical vision for our React Native codebase, championing architectural improvements and scalability.
Lead design sessions, code reviews, and architectural discussions to elevate engineering standards across the team.
Own and modernize key components of the mobile platform with performance, accessibility, and security in mind.
Drive quality with near 100% test coverage, CI/CD best practices, and a relentless focus on reliability.

Team Collaboration & Mentorship

Act as a role model and mentor to other engineers, providing technical guidance and career development support.
Collaborate closely with Product, Design, and other engineering teams to scope, build, and ship impactful features.
Help refine engineering processes, improve team velocity, and reduce tech debt
Write and maintain documentation that enables efficient onboarding and consistent best practices.

Hands-On Engineering

Build, refactor, and scale our core mobile application using React Native and TypeScript.
Contribute to backend systems and APIs (NodeJS or Go) as needed to support mobile functionality.
Champion performance monitoring, observability, and error tracking using tools like Datadog
Ensure security and privacy standards are upheld, including zero trust principles and secure authentication.

What You’ll Need

Expertise in React Native and TypeScript, with a proven track record of building scalable mobile apps.
Experience modernizing and extending legacy code while preserving existing functionality and minimizing risk.
Experience with at least one native mobile platform (iOS or Android).
Strong understanding of automated testing frameworks and E2E testing practices.
Familiarity with backend technologies including NodeJS or Go.
Demonstrated success mentoring engineers and leading technical initiatives across teams.
Strong collaboration and communication skills, with the ability to work effectively across disciplines.
MS in Computer Science or equivalent work experience.

Working at Lark

Lark operates as a remote organization, requiring all employees to reside within the United States. The specific salary offered to a candidate will depend on various factors, including their location, job level, and verified job-related knowledge, skills, and experience. In addition to a comprehensive benefits package, candidates may be eligible for additional compensation, such as participation in a bonus program and stock awards, where applicable.

Lark is an Equal Opportunity and Affirmative Action Employer. We believe that diverse teams foster innovation and add to our mission-driven culture. We strongly encourage people from underrepresented groups to apply.

Compensation Range: $162.5K - $231.4K

Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Engineering and Information Technology
Industries Hospitals and Health Care
Referrals increase your chances of interviewing at Lark Health by 2x
Sign in to set job alerts for “Staff Software Engineer” roles.  Remote Senior Software Engineer (LLM) - 34953  Staff Frontend Software Engineer, Web UI  Mountain View, CA $180,000.00-$210,000.00 1 month ago
Sr. Software Engineer, Full-Stack Opening, Chile  [Future Opportunities] Senior Software Engineer, C++  San Francisco Bay Area $120,000.00-$155,000.00 1 month ago
Redwood City, CA $150,000.00-$250,000.00 1 month ago
Senior/Staff+ Software Engineer - Ledger Team  San Mateo, CA $100,000.00-$180,000.00 11 months ago
San Francisco Bay Area $180,000.00-$210,000.00 1 month ago
Sr. Software Engineer, Full-Stack Opening, USA  Pleasanton, CA $150,000.00-$300,000.00 4 days ago
Redwood City, CA $200,000.00-$275,000.00 2 days ago
San Jose, CA $90,000.00-$185,000.00 1 day ago
Staff Software Engineer, Backend (Remote)  Staff Software Development Engineer in Test (SDET)  Palo Alto, CA $160,000.00-$190,000.00 6 hours ago
Principal Software Engineer - Data Platform  Sr. Software Engineer - Frontend (Remote)  Staff Software Engineer, Backend (Virtual Cards Platform)  San Jose, CA $100,000.00-$260,000.00 1 week ago
Staff Software Engineer, Backend (Virtual Cards Platform)  We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Laksan technologies Business Intelligence Interview Guide

Overview

Laksan technologies Business Intelligence Interview Process

Laksan technologies Business Intelligence Interview Questions

Laksan technologies Business Intelligence Jobs