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

Legalzoom Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Legalzoom? The Legalzoom 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 Legalzoom Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Legalzoom.</li>
<li>Practice real Legalzoom 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 Legalzoom Business Intelligence interview.</p>


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

- Know what skills are necessary for Legalzoom Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Legalzoom.
- Practice real Legalzoom 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 Legalzoom 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.

Legalzoom Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

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

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

<p><code>bank_transactions</code> table</p>

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

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

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

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

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

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

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<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>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Legalzoom Business Intelligence Interview Questions

Description

About LegalZoom
LegalZoom is on a mission to help people navigate the legal system with confidence and clarity. As a leader in online legal services for over 20 years, we combine technology, attorney-led solutions, and expertise to protect the aspirations, lives, and legacies of millions of customers. If you're ready to contribute to a collaborative, diverse, and distributed group of creative thinkers and problem-solvers, we can't wait to meet you.

Where we work
In an effort to foster a better work-life balance, LegalZoom is committed to a remote-first work environment. Our Austin, Beaverton, Frisco, LA Metro, and SF Bay Area offices allow our Zoomers to collaborate with teammates and offer special onsite events, lunches, and more.

While this position is remote, we encourage and at times, require in-person collaboration at our offices.

Overview

The Engineering team at LegalZoom builds user interfaces, features, applications, and tools for our customers. We're in an exciting period of growth and seeking talented developers who share our vision for helping fuel the success of small businesses. This is a role for a creative individual who wants to help shape the future direction of our LegalZoom offerings and who has strong engineering chops, opinions on what "good" product and design flows look like, is comfortable with ambiguity, and enjoys collaborating within a team environment.

You'll help by progressing the LegalZoom experience and you'll also inspire and elevate the team by producing work that is always raising the bar and taking a customer-obsessed approach to solving problems.

You will
Help define and steer a fast-growing new business at LegalZoom.
Work closely with product managers, designers, and other engineers to design, build and maintain customer-facing products and interfaces.
Design and improve our platform and components to help engineering teams across LegalZoom build amazing applications.
Debug production issues and improve engineering standards, tooling, and processes.
Join a dream team of amazing engineers to drive innovation within the organization and to champion product excellence.
This role will be a good fit if:    You have 8+ years of experience in a hands-on software engineering role.
You want to deeply understand your customers so that you can create experiences for them that they love.
You write code that is elegant, efficient and well-tested.
You are always curious and eager to learn new things and to improve your skills.
You have experience working in back-end systems using languages like Kotlin, Java, and Spring Boot
Familiarity with REST or GraphQL.
Strong database experience, including with experience with SQL
You can work independently and deliver high-quality code, but you also know when to ask for help when you need it.
You communicate and collaborate well with other teams and stakeholders.
You enjoy mentoring others and want to help create an environment where early-career engineers can grow and thrive.
You are able to travel occasionally for team offsites and conferences.
Desirable
You have experience in developing single-page applications using JavaScript/TypeScript.
Experience with event-driven architecture / Kafka

LegalZoom is a remote-first company and the national range for this role is ($159,900 - $236,900). Actual compensation offered will depend on several factors including but not limited to: geographic location, work experience, education, skill level, and/or other business and organizational needs. In addition, an annual bonus, incentive bonus and/or restricted stock units may be provided as part of the compensation package. You will also receive a full range of medical, financial, and other benefits as seen below.

•Medical, Dental, Vision Insurance

•401k, With Matching Contributions

•Paid Time Off

•Health Savings Account (HSA)

•Flexible Spending Account (FSA)

•Short-Term/Long-Term Disability Insurance

•Plus other wellness benefits to include:

•Fertility

•Mental Health

•One Medical

•Fringe lifestyle benefits up to $250

Join us in making a difference as we build our future and help ensure access to professional legal advice to all! LegalZoom is an equal opportunity employer, dedicated to diversity, equality, and inclusion, and provides equal employment opportunities to all employees and applicants for employment. LegalZoom 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. Additionally, LegalZoom is enrolled in the E-Verify program. For additional information on E-Verify, please visit Participation and Right to Work pages.

Description

About LegalZoom

LegalZoom is on a mission to help people navigate the legal system with confidence and clarity. As a leader in online legal services for over 20 years, we combine technology, attorney-led solutions, and expertise to protect the aspirations, lives, and legacies of millions of customers. If you're ready to contribute to a collaborative, diverse, and distributed group of creative thinkers and problem-solvers, we can't wait to meet you.

Where we work
We believe work should work for you. LegalZoom supports a remote-friendly environment that gives employees flexibility and balance. Our Austin, Beaverton, Frisco, Los Angeles Metro, and San Francisco Bay Area offices allow our employees to collaborate with teammates and offer special onsite events, lunches, and more.

This position will be based in the Los Angeles area, but is 100% remote and is not required to come into the office.

Overview

Are you a Product Manager who is customer-obsessed, and passionate about scaling a business? Are you excited to roll up your sleeves to execute, test and learn fast with the team? Have you built experiences that surprised and delighted your customers? Then this could be the opportunity for you!

Today's small and medium-sized businesses (SMBs) face a myriad of decisions as they look to officially form their business. They come to LegalZoom ready and excited to officially register their business. We build holistic experiences to educate, guide, and protect them as they look to start and grow their business. In this role, you will partner with engineering, product design, product marketing, data science and other cross-functional teams to remove the confusion for our customers and build their confidence. You will focus on SMB product experiences, likely running a myriad of tests to learn the best ways to solve customer problems with LegalZoom solutions. You'll sweat the details, work side by side with the team, and lead with a high say/do ratio. This is an opportunity to make a big impact on the lives of our small business customers and truly unleash entrepreneurship.

You will
Take a hands-on approach to leadership of your projects. You'll own planning and end-to-end execution of features/programs, working with cross functional partners. You'll define the roadmap and inspire the team to execute.
Focus on improving customer satisfaction, and by doing so, you'll also enable a long-term relationship with LegalZoom beyond the point of formation.
Be intimately connected with, and a champion for, our customers.
Possess a learn fast, fail fast mindset - identify, then focus on the key opportunities. You'll understand risk, and recognize when to ship fast and iterate from there.
Leverage data and insights to drive quality customer experiences and business outcomes.
Understand your funnel and be able to diagnose problems and lead brainstorming sessions for solutions.
You have    Proven track record of building and delivering successful ecommerce/tech products, ideally 2-4 years of product management experience.
A data-driven mindset, with the ability to interpret the data in-context and model changes. You make the recommendation and you act on it, with proven experience utilizing metrics & insights as tools for informed decision-making.
Ability to leverage strong problem-solving and analytical skills to transform challenging user experience, business, and technology problems into actionable paths.
Outstanding storytelling and communication skills, with the ability to adapt your style as you work with others up, down, and alongside you in the organization
Background in consumer-focused products, or products focused on SMB end-users.

LegalZoom is a remote-first company and the national range for this role is ($104,300-$121,700). Actual compensation offered will depend on several factors including but not limited to: geographic location, work experience, education, skill level, and/or other business and organizational needs. In addition, an annual bonus, incentive bonus and/or restricted stock units may be provided as part of the compensation package. You will also receive a full range of medical, financial, and other benefits as seen below.

• Medical, Dental, Vision Insurance

• 401k, With Matching Contributions

• Paid Time Off

• Health Savings Account (HSA)

• Flexible Spending Account (FSA)

• Short-Term/Long-Term Disability Insurance

• Plus other wellness benefits to include:

• Fertility

• Mental Health

• One Medical

• Fringe lifestyle benefits up to $250

Join us in making a difference as we build our future and help ensure access to professional legal advice to all! LegalZoom is an equal opportunity employer, dedicated to diversity, equality, and inclusion, and provides equal employment opportunities to all employees and applicants for employment. LegalZoom 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. Additionally, LegalZoom is enrolled in the E-Verify program. For additional information on E-Verify, please visit Participation and Right to Work pages.

<strong>Description</strong> <br><br>About LegalZoom <br><br>LegalZoom is on a mission to help people navigate the legal system with confidence and clarity. As a leader in online legal services for over 20 years, we combine technology, attorney-led solutions, and expertise to protect the aspirations, lives, and legacies of millions of customers. If you're ready to contribute to a collaborative, diverse, and distributed group of creative thinkers and problem-solvers, we can't wait to meet you. <br><br>Where we work <br>We believe work should work for you. LegalZoom supports a remote-friendly environment that gives employees flexibility and balance. Our Austin, Beaverton, Frisco, Los Angeles Metro, and San Francisco Bay Area offices allow our employees to collaborate with teammates and offer special onsite events, lunches, and more. <br><br><b><strong>This position will be based in the Los Angeles area, but is 100% remote and is not required to come into the office.</strong></b> <br><br>Overview <br>Are you a Product Manager who is customer-obsessed, and passionate about scaling a high-growth business? Can you think strategically and set a vision, while also rolling up your sleeves to execute with the team? Have you built experiences that surprised and delighted your customers? Then this could be the opportunity for you! <br><br>We are looking for a dynamic and strategic Principal PM to lead the evolution of MyLZ, our logged in product experience. This is a high visibility role that will require strong partnership with engineering, product design, business development, product marketing, and other cross-functional teams. You'll sweat the details, work side by side with the team, and lead with a high say/do ratio. This is an opportunity to make a big impact on the lives of our Small Business customers, drive huge business value and define the future of core engagement experiences with LegalZoom and our customers. <br><br>You will <br><ul> <li>Define and consistently refine the roadmap to optimize for business results </li><li>Execute with excellence on initiatives focused on enabling a scalable, easy to use, and valuable experience for our partners and customers </li><li>Balance longer term transformational initiatives with nearer-term value delivery </li><li>Own planning and end-to-end execution of features/programs working with business, product design, and engineering teams </li><li>Drive customer empathy and advocacy. You'll gain the relevant customer insights from a variety of sources knowing that your customers are both internal (product and business leaders) and external (Small and Medium sized businesses and consumers seeking legal and compliance help. </li><li>Dive deep and solve customer and product problems while also synthesizing and providing executive level updates and recommendations </li><li>Be a trusted partner for your fellow product team members and all cross-functional groups </li><li>Perform data analysis. You'll be tracking and constantly looking to optimize key metrics </li><li>Be available for occasional travel as needed </li></ul>You have <ul> <li>8+ years of experience as a product manager, collaborating closely with Engineering, Design, Data Science and other cross-functional partners </li><li>A deep user empathy for both internal and external customers </li><li>End-to-end problem solving skills. From product discovery in situations with high ambiguity up to the point of post-launch monitoring </li><li>Excellent "data skills". You are curious and ask the right questions, quickly gather relevant data points and are able to independently analyze and form data-backed perspectives </li><li>Proven track record of building and delivering successful B2C/B2B products that scale, and customer experiences which delight </li><li>Outstanding storytelling and communication skills, with the ability to adapt your style as you work with others up, down, and alongside you in the organization </li><li>Subscription service or SaaS experience preferred </li></ul> <br><br>LegalZoom is a remote-first company and the national range for this role is ($159,900-$213,200). Actual compensation offered will depend on several factors including but not limited to: geographic location, work experience, education, skill level, and/or other business and organizational needs. In addition, an annual bonus, incentive bonus and/or restricted stock units may be provided as part of the compensation package. You will also receive a full range of medical, financial, and other benefits as seen below. <br><br>• Medical, Dental, Vision Insurance <br><br>• 401k, With Matching Contributions <br><br>• Paid Time Off <br><br>• Health Savings Account (HSA) <br><br>• Flexible Spending Account (FSA) <br><br>• Short-Term/Long-Term Disability Insurance <br><br>• Plus other wellness benefits to include: <br><br>• Fertility <br><br>• Mental Health <br><br>• One Medical <br><br>• Fringe lifestyle benefits up to $250 <br><br>Join us in making a difference as we build our future and help ensure access to professional legal advice to all! LegalZoom is an equal opportunity employer, dedicated to diversity, equality, and inclusion, and provides equal employment opportunities to all employees and applicants for employment. LegalZoom 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. Additionally, LegalZoom is enrolled in the E-Verify program. For additional information on E-Verify, please visit Participation and Right to Work pages.

Legalzoom Business Intelligence Interview Guide

Overview

Legalzoom Business Intelligence Interview Process

Legalzoom Business Intelligence Interview Questions

Legalzoom Business Intelligence Jobs