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

Weedmaps Business Intelligence Interview Guide

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


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

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

Overview

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

Weedmaps 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>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</p>

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

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

<p><code>transactions</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>user_id</code></td>
<td>INTEGER</td>
</tr>

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

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>products</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>price</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>users</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>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

Weedmaps Business Intelligence Interview Questions

<strong>Software Engineer III, Ruby</strong> (Hybrid - 2 to 3 days per week onsite in Austin, TX) <br><br><strong>Overview</strong> <br><br>As a Software Engineer III working with the Weedmaps Developer Tools and Services team, you will create internal software to be used by other team members to ship code quickly, launch test environments and interface with our cloud infrastructure and CI/CD pipelines. You will work closely with the Infrastructure and Application Development teams to help shape the tooling pipelines at Weedmaps. As a major player in this emerging industry, we have an opportunity to help define the market landscape and we invite you to help in that effort. <br><br><strong>The impact you'll make:</strong> <br><ul> <li>Produces high quality code inline with the guidance of the architects and senior software engineers </li><li>Works with Senior Software engineers to learn and grow technical abilities. </li> <li>Task estimation </li><li>Work with the Infrastructure teams to build out self-service operations in our automation framework. </li><li>Participates in code reviews, but cannot be the sole approver of Pull Requests from other developers at the same level </li><li>Pair program with other engineers. </li><li>Onboard and train junior engineers. </li></ul><strong>What you've accomplished:</strong> <ul> <li>5 years of professional programming experience. </li><li>Experience contributing to services using Ruby and Rails </li><li>BA or BS preferred </li><li>Knowledge of tools, frameworks and testing. </li><li>Ability to write and test complex applications. </li><li>Work in a team atmosphere and assist junior engineers. </li><li>Experience writing secure, RESTful APIs with performant database queries </li><li>Effective communication skills, a positive attitude, and ability to give and receive constructive feedback in an agile environment </li><li>Fluency using Git in a team environment </li><li>Ad Tech experience is a nice to have skill set for this team </li> </ul>The base pay range for this position is $130,000.00 to $150,000.00 per year <br><br><strong>2024 Benefits for Full Time, Regular Employees:</strong> <ul> <li>Physical Health benefits: Medical, Dental & Vision: </li><ul> <li>Employee - employer paid premium 100% </li><li>Company contribution to a HSA when electing the High Deductible Health Plan </li><li>For plans that offer coverage to your dependents, you pay a small contribution </li></ul> <li>Mental Health benefits: </li><ul> <li>Free access to CALM app for employees and dependents </li><li>Employee Training </li><li>Mental Health seminars and Q&A sessions </li></ul> <li>Basic Life & AD&D - employer paid 1x salary up to $250,000 </li><li>401(k) Retirement Plan (with employer match contribution) </li><li>Generous PTO, Paid Sick Leave, and Company Holidays </li><li>Supplemental, voluntary benefits </li><ul> <li>Student Loan Repayment/529 Education Savings - including a company contribution </li><li>FSA (Medical, Dependent, Transit and Parking) </li><li>Voluntary Life and AD&D Insurance </li><li>Critical Illness Insurance </li><li>Accident Insurance </li><li>Short- and Long-term Disability Insurance </li><li>Pet Insurance </li><li>Family planning/fertility </li><li>Identity theft protection </li><li>Legal access to a network of attorneys </li></ul> <li>Paid parental leave </li></ul><strong>Why Work at Weedmaps?</strong> <ul> <li>You get to work at the leading technology company in the cannabis industry </li><li>You get to play a meaningful role in helping to advance cannabis causes, including helping improve the lives of patients who rely on the benefits of cannabis </li><li>You get an opportunity to shape the future of the cannabis industry </li><li>You get to work on challenging issues in a collaborative environment that encourages you to do your best </li> <li>You get to work in a casual and fun environment; no fancy clothes required, but you are free to dress to the nines! </li><li>Generous PTO and company holidays </li><li>Numerous opportunities and tools to learn and grow your professional skills </li><li>Endless opportunities to network and connect with other Weedmappers through speaker series, Employee Resource Groups, happy hours, team celebrations, game nights, and much more! </li></ul>Weedmaps is an equal opportunity employer and makes employment decisions on the basis of merit. The Company prohibits unlawful discrimination against employees or applicants based on race (including traits historically associated with race, such as hair texture and protective hairstyles), religion and religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, military status, veteran status, uniformed service member status, sexual orientation, transgender identity, citizenship status, pregnancy, or any other consideration made unlawful by federal, state, or local laws. The Company also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics, or is associated with a person who has or is perceived as having any of those characteristics. Our company uses E-Verify to confirm the employment eligibility of all newly hired employees. To learn more about E-Verify, including your rights and responsibilities, please visit www.dhs.gov/E-Verify. <br><br>Applicants are entitled to reasonable accommodations under the terms of the Americans with Disabilities Act and applicable state/local laws, unless the accommodation presents undue hardship. Please email us at peopleoperations at weedmaps.com if you would like to confidentially discuss a potential accommodation during the interview process. <br><br><strong>About Weedmaps:</strong> <br><br>WM Technology, Inc.'s (Nasdaq: MAPS) mission is to power a transparent and inclusive global cannabis economy. Now in its second decade, WM Technology has been a driving force behind much of the legislative change we've seen in the past 10 years. <br><br>Founded in 2008, WM Technology, is a leading technology and software infrastructure provider to the cannabis industry, comprising a B2C platform, Weedmaps, and B2B software, WM Business. The cloud-based SaaS solutions from WM Business provide an end-to-end operating system for cannabis retailers. WM Business' tools support compliance with the complex, disparate, and constantly evolving regulations applicable to the cannabis industry. Through its website and mobile apps, WM Technology provides consumers with the latest information about cannabis retailers, brands, and products, facilitating product discovery and driving engagement with our retail and brand customers. <br><br>WM Technology holds a strong belief in the power of cannabis and the importance of enabling safe, legal access to consumers worldwide. Since inception, WM Technology has worked tirelessly, not only to become the most comprehensive platform for consumers, but to build the software solutions that power businesses compliantly in the space, to advocate for legalization, social equity, and licensing in many jurisdictions, and to facilitate further learning through partnering with subject matter experts on providing detailed, accurate information about the plant. <br><br>Headquartered in Irvine, California, WM Technology supports remote work for all eligible employees. Visit us at www.weedmaps.com. <br><br>Notice to prospective Weedmaps job applicants: <br><br>Our team has been made aware of incidents involving LinkedIn, Telegram, and Facebook accounts impersonating Weedmaps recruiters. These individuals are attempting to use our company name to solicit payment from prospective candidates interested in applying for jobs at our company. Our team is actively working to combat these attempts, but in the meantime, please be mindful of the following: <ul> <li>Our recruiters will always communicate with candidates through an @weedmaps.com email address. </li></ul> <ul><li>CORRECT: jlebowski@weedmaps.com </li></ul> <ul><li>INCORRECT: jlebowski@gmail.com </li></ul> <ul><li>Our recruiters will NEVER ask for or attempt to solicit payment from applicants in order to apply, interview, or work for Weedmaps. </li></ul> <ul><li>If you are interested in a role at Weedmaps, please apply through our established channels. </li></ul> <ul><li>Weedmaps Careers Page or LinkedIn </li></ul> <br>If you are unsure if a communication is legitimate, please contact our recruitment team at talentops@weedmaps.com and they will happily confirm for you. Thank you for your vigilance and we appreciate your interest in working with us!

Weedmaps Business Intelligence Interview Guide

Overview

Weedmaps Business Intelligence Salary

Weedmaps Business Intelligence Interview Process

Weedmaps Business Intelligence Interview Questions

Weedmaps Business Intelligence Jobs