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

Justworks Business Intelligence Interview Guide

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


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

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

Overview

Justworks Business Intelligence Salary

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

Justworks 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>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</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>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

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

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

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Justworks Business Intelligence Interview Questions

<strong><strong>Who We Are</strong></strong><br><br>At Justworks, you'll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We work hard and care about our most prized asset - our people.<br><br>We're helping businesses get off the ground by enabling them to focus on running their business. We solve HR issues. We're data-driven and never stop iterating. If you'd like to work in a supportive, entrepreneurial environment, are interested in building something meaningful and having fun while doing it, we'd love to hear from you.<br><br>We're united by shared goals and shared motivations at Justworks. These are best summed up in our company values, which are reflected in our product and in our team.<br><br>Our Values<br><br>If this sounds like you, you'll fit right in.<br><br><strong><strong>Who You Are</strong></strong><br><br>Are you passionate about design and development? Do you have experience building, deploying, and maintaining large-scale, distributed applications? Are you ready to take your skills to the next level and join a team of innovative self-starters in a supportive, entrepreneurial environment?<br><br>As part of the larger Employer Risk vertical, Fraud Prevention is a new team built from the ground up. The team will focus on building the backend services and frontend experiences and toolings to automate and scale the detection and prevention of fraudulent entities and activities in the Justworks platform. We work closely with cross functional partners across multiple business domains. <br><br>As a Senior Software Engineer in the team, you will be one of the founding engineers to build 0 to 1 software services and tools. You will be leveraging your experience working within a service-oriented architecture. You will be responsible for separating data and functionality as necessary, and will demonstrate an understanding and use of automated testing as a productivity multiplier. You are eager to learn and passionate about improvement. You want to understand how systems work, and you think about how to make them work even better. You will work closely with product managers, UX designers, and other engineers to scope, design, and build new features and functionality. You will be working primarily in Ruby on Rails and/or JavaScript/React, but prior knowledge is not a requirement.<br><strong><strong>Your Success Profile</strong></strong><br><strong><strong>What You Will Work On</strong></strong><br><ul><li>Collaborate with a cross functional team to build solutions to detect and prevent fraud</li><li>Take ownership of designing and implementing APIs, systems integrations, data models and backend services</li><li>Promote engineering excellence through technical leadership, knowledge-sharing and mentorship</li><li>Instate best-practices observability and monitoring as "first principles" of all our services</li><li>Keep extremely sensitive data compartmentalized and secure</li><li>Perform other related duties as assigned</li></ul><strong><strong>How You Will Do Your Work </strong></strong><br><br>As a Senior Software Engineer, how results are achieved is paramount for your success and ultimately result in our success as an organization. In this role, your foundational knowledge, skills, abilities and personal attributes are anchored in the following competencies:<br><ul><li><strong>Good judgment </strong>- the exercise of critical thinking, analyzing and assessing problems and implications, identifying patterns, making connections of underlying issues, understanding risks and developing mitigation strategies, and taking ownership of the outcome.</li></ul><ul><li><strong>Resourcefulness </strong>- taking a can-do approach, even in the face of obstacles and constraints by assessing what's in front of you and effectively and efficiently optimizing what you have, whether it's working on something new or thinking about how to do something better.</li></ul><ul><li><strong>Teamwork and communication </strong>- putting our collective best together through documentation, collaboration, relationship-building, listening, empathy, recruiting, and evangelism.</li></ul><ul><li><strong>Influence and leadership </strong>- fostering a community of knowledge-sharing, collaboration, mentorship, and forward-thinking.</li><li><strong>Skills and knowledge </strong>- the capacity to actively learn and apply specific domain knowledge, know-how, and best practices to continually enhance and improve.</li></ul><br>In addition, all Justworkers focus on aligning their behaviors to our core values known as COGIS. It stands for:<br><ul><li><strong>Camaraderie</strong> - Day to day you can be seen working together toward a higher purpose. You like to have fun. You're an active listener, treat people respectfully, and have a strong desire to know and help others.</li><li><strong>Openness</strong> - Your default is to be open. You're willing to share information, understand other perspectives, and consider new possibilities. You're curious, ask open questions, and are receptive to thoughts and feedback from others.</li><li><strong>Grit </strong>- You demonstrate grit by having the courage to commit and persevere. You're committed, earnest, and dive in to get the job done well with a positive attitude.</li><li><strong>Integrity</strong> - Simply put, do what you say and say what you'll do. You're honest and forthright, have a strong moral compass, and strive to match your words with your actions while leading by example. </li><li><strong>Simplicity</strong> - Be like Einstein: "Everything should be made as simple as possible, but no simpler."</li></ul><strong><strong>Qualifications </strong></strong><br><ul><li>Minimum of 5 years of professional hands-on experience</li><li>Strong object-oriented design and coding skills</li><li>Solid understanding of data structures and algorithms</li><li>Prior experience in fraud detection and prevention strongly preferred</li><li>Experience building new feature from scratch, using clean, organized, and scalable code</li><li>Experience supporting other engineers and acting as a "tech lead"</li><li>Experience working with complicated systems at scale</li><li>Experience working using Agile/Scrum methodology in a fast-paced environment</li><li>Experience in a high-growth environment working with deadlines and milestones</li></ul><strong><strong>Technologies Used</strong></strong><br><ul><li><strong>Languages: </strong>Ruby on Rails, Javascript, Kotlin, Go</li><li><strong>Messaging / APIs: </strong>Kafka, Open API, GraphQL, Apollo, Redis</li><li><strong>Infrastructure: </strong>Kubernetes, Docker, CircleCI, DataDog, Snowflake, AWS</li></ul><br>The base wage range for this position based in our New York City Office is targeted at $167,500.00 to $205,000.00 per year.<br><br>#LI-AD1 #LI-Hybrid #LI-JS1<br><br>Actual compensation is based on multiple factors that are unique to each candidate, including and not limited to skill set, level of relevant experience, and specific work location. Salary ranges for positions based in other locations may differ based on the cost of labor in that location. <br><br>For more information about Justworks' Total Reward Philosophy, including all of the perks and benefits we are proud to offer our team members, please visit Total Rewards @ Justworks. <br><strong><strong>Diversity At Justworks</strong></strong><br><br>Justworks is committed to maintaining a workplace where diversity of identity, culture, and life experience is the norm and is celebrated authentically and respected consistently. Diversity in our work, our people, and our product drives creativity and innovation, entrepreneurial leadership and integrity, competitiveness, and collaboration throughout our business and in the market. We depend on our differences to make our team stronger, our workplace more dynamic, and our product accessible to all of our customers.<br><br>We're proud to be an equal opportunity employer open to all qualified applicants regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital or familial status, disability, pregnancy, gender identity or expression, veteran status, genetic information, or any other legally protected status. Justworks is fully dedicated to providing necessary support to candidates with disabilities who may require reasonable accommodations. We also provide reasonable accommodations to employees based on their sincerely held religious beliefs, as well as for other covered reasons consistent with applicable federal, state, and local laws. If you're in need of a reasonable accommodation, please reach out to us at accommodations@justworks.com. Your comfort and success matter to us, and we're here to ensure an inclusive experience.<br><br>Our DEIB Report and Our DEI Commitment

Justworks Business Intelligence Interview Guide

Overview

Justworks Business Intelligence Salary

Justworks Business Intelligence Interview Process

Justworks Business Intelligence Interview Questions

Justworks Business Intelligence Jobs