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 identify customers who placed more than three transactions each in both 2019 and 2020.</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>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>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Weedmaps Business Intelligence Interview Questions

<strong>Senior Software Engineer, Ruby</strong> (Remote)<br>We have offices in Irvine, CA; Austin, TX; Denver, CO <br><br><strong>Overview:</strong><br><br>Weedmaps is looking for a highly motivated and experienced Senior Software Engineer to join our team. As a Senior Software Engineer, you will be responsible for the design and development of mission-critical components of a distributed platform. You will design, code, troubleshoot, and support scalable services in a high volume and low latency environment.<br><br><strong>The impact you'll make:</strong><br><ul><li>Take ownership of significant features and drive them from development to production</li><li>Collaborate with stakeholders to build new and iterate on existing features</li><li>Cultivate sense of customer empathy to continue building an exceptional product</li><li>Help optimize legacy code for improved performance</li><li>Regularly participate in code reviews and other team functions</li><li>Passionate about improving processes and developer productivity</li><li>Pair with other engineers regularly</li></ul><br><strong>What you've accomplished:</strong><br><ul><li>Bachelor's degree or equivalent practical experience.</li><li>Minimum of 7 years of professional software development experience.</li><li>Minimum 5 years of development experience at startup / mid-sized companies</li><li>Minimum 5 years experience with Ruby</li><li>Expertise in building responsive user-interfaces</li><li>Effective communication skills, a positive attitude, and ability to give and receive constructive feedback</li><li>Possess a high level of attention to detail and aesthetic sensibilities</li><li>Expert knowledge of modern browser technologies, cross-browser compatibility issues, and client-side performance considerations</li><li>Take pride in raising the bar for engineering excellence across the organization</li><li>Deep understanding of the GitFlow branching strategy</li><li>Familiarity with server-side frameworks such as Next.js or Ruby on Rails</li><li>Computer science or other engineering background</li></ul><br>The base pay range for this position is $160,000.00 to $180,000.00 per year<br><br><strong>2024 Benefits for Full Time, Regular Employees:</strong><br><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><br><strong>Why Work at Weedmaps?</strong><br><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><br>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:<br><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!

<strong>Senior Software Engineer, Android</strong> (Hybrid - 2 to 3 days onsite per week in Irvine, CA)<br><br><strong>Overview</strong><br><br>The Senior Software Engineer working with the Weedmaps Android team will be expected to write software at a high velocity, support other engineers through code reviews and pair programming, and help maintain the build and release pipeline for the platform. They will be tasked with improving the applications architecture and overall quality. They will need to work closely with product owners and designers to break down initiatives and bring them to production. Additionally, the Senior Software Engineer will be expected to drive technical initiatives from start to finish, defining work for other engineers in the process.<br><br><strong>The impact you'll make:</strong><br><ul><li>Maintain and strengthen our Android Platform capabilities</li><li>Contribute to and mature our platform architecture.</li><li>Collaborate and contribute in agile ceremonies</li><li>Learn from and collaborate with peers and seniors as an avid pair programmer</li><li>Define and write actionable user stories.</li><li>Decompose initiatives with product management.</li><li>Communicate progress towards releases with stakeholders</li><li>Keep well organized and articulated documentation</li><li>Remain current on industry changes, and keep us at the forefront of technological trends</li></ul><br><strong>What you've accomplished:</strong><br><ul><li>Minimum of 4 years with Kotlin</li><li>Minimum of 7 years of professional software development experience.</li><li>Experience with Android Test Automation Frameworks</li><li>Bachelor's degree or equivalent practical experience.</li><li>Minimum 5 years of development experience at startup / mid-sized companies</li><li>Effective communication skills, a positive attitude, and ability to give and receive constructive feedback</li><li>Possess a high level of attention to detail and aesthetic sensibilities</li><li>Take pride in raising the bar for engineering excellence across the organization</li></ul><br><strong>Bonus Points</strong><br><ul><li>Experience with Maintaining CI Pipelines (Bitrise)</li><li>Experience with React Native</li></ul><br>The base pay range for this position is $151,000.00 to $170,000.00 per year<br><br><strong>2024 Benefits for Full Time, Regular Employees:</strong><br><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><br><strong>Why Work at Weedmaps?</strong><br><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><br>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:<br><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