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

Geocomply Business Intelligence Interview Guide

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


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

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

Overview

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

Geocomply 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

Geocomply Business Intelligence Interview Questions

<b>About GeoComply</b><br><br>We're GeoComply! We are at the forefront of geolocation, cybersecurity, and anti-fraud innovation, developing and delivering cutting-edge technologies to help ensure regulatory compliance, combat bad online actors, alleviate user friction, and protect businesses from fraud.<br><br>Achieving significant business and revenue growth over the past three years and dubbed a tech "Unicorn," GeoComply has been trusted by leading global brands and regulators for over ten years. Our compliance-grade geolocation technology solutions are installed on over 400 million devices and analyze over 12 billion transactions a year.<br><br>At the heart of it all is the people, united by a deep commitment to problem-solving and revolutionizing how people and businesses use the internet to instill confidence in every online interaction. With teams across five countries, three continents, and a global customer base, we have no plans to slow down.<br><br>The Role <br><br>As a <b>Senior Product Manager, Chargebacks</b> at GeoComply, you will take responsibility for our payment/chargeback product from conception to launch in collaboration with multiple teams across the organization. You will oversee all product development activities including ideation, product roadmap, goals, UI/UX, engineering (partnership with Engineering Manager), success metrics, A/B testing strategy, and launch plan. As an integral part of the Product team you will have an immediate impact on the bottom line of GeoComply's new and existing businesses.<br><br><strong>Key Responsibilities</strong><br><ul><ul><li>Define and provide regular product roadmap updates, aligning vision with leadership and key stakeholders (engineering, design, DS, GTM, customer support)</li><li>Drive feature request discussion and ideation to determine business value and rigorous prioritization - continuously evaluating tradeoffs. </li><li>Create product specifications in collaboration with stakeholders, review engineering design documents, and lead the execution with cross-team support.</li><li>Define product success metrics, and monitor and optimize for future iterations.</li><li>Collaborate with engineers and data scientists to build a plan to grow and scale the product through high-velocity experimentation and heuristics/ML models.</li><li>Collaborate with data scientists to analyze data to identify fraud trends and drive improvements.</li><li>Maintain consistent relationships with enterprise customers to serve as point person for your product space, regularly taking feedback into account and anticipating their future needs.</li></ul></ul><br><br><strong>Who You Are</strong><br><ul><ul><li>5+ years of experience delivering successful products, in engineering or product management role: you're extremely proud of what you've accomplished</li><li>Previous experience in building products in the fintech, payments or chargeback space is preferred.</li><li>Stellar technical depth and product instincts: have engineering background/experience, able to make product/tech trade-offs</li><li>Customer obsession: you are passionate about delivering an exceptional user experience, have design thinking and customer-centric approach to building, experimenting, and iterating products</li><li>Data-driven: you use data to inform decision-making</li><li>Technical skills: ability to inform and evaluate engineering decisions</li><li>Stakeholder management: able to effectively manage stakeholders and integration partners</li><li>Bias for action: you don't hesitate to take initiative and address something hands-on</li><li>Great presentation and interpersonal skills</li><li>A never-ending desire to grow and learn</li></ul></ul><br><br><strong>Bonus Points</strong><br><ul><ul><li>You have iGaming Industry experience</li></ul></ul><br><br>$140,000 - $192,500 a year<br><br>Our compensation reflects the cost of labor across several Global markets. The salary for this position ranges from $140,000 per year up to $192,500 USD per year. Pay is based on several factors evaluated throughout the interview, including market location, job-related knowledge, skills, and experience. At GeoComply, our salary bands are crafted with purpose. They testify to the diverse range of skills and experiences that fuel our success.<br><br>In addition to our competitive salary package, we also offer the following personal and professional development benefits:<br><br>Performance-based bonus<br><br>Equity plans<br><br>Paid vacation and sick days<br><br>Extended health benefits<br><br>Generous Learning & Development Allowance<br><br>Sports and Physical Wellness budget (30% of L&D Allowance)<br><br>Charitable and DEI initiatives<br><br>Team-building events<br><br><b>Apply Now!</b><br><br>Interested in joining our team? Send us your resume and a cover letter. We can't wait to meet you!<br><br><b>Commitment to Diversity and Equity.</b><br><br>If you don't tick every box in this job description, please don't rule yourself out. Research suggests that women and other people in underrepresented groups tend to only apply if they meet every requirement. We focus on hiring people who value inclusion, collaboration, adaptability, courage, and integrity rather than ticking boxes, so if this resonates with you, please apply.<br><br><b>Search Firm Representatives Please Read Carefully</b><br><br>We do not accept unsolicited assistance from search firms for employment opportunities. All CVs or resumes submitted by search firms to any employee at our company without a valid written agreement in place for this position will be considered the sole property of our company. No fee will be paid if a candidate is hired by GeoComply due to an agency referral where no existing agreement exists with the GeoComply Talent Acquisition Team. Where agency agreements are in place, introductions must be through engagement by the GeoComply Talent Acquisition Team.<br><br><b>Why GeoComply?</b><br><br>Joining the GeoComply team means you'll be part of an award-winning company to work, learn and grow. We are fast-paced, high-impact, and have a can-do team culture.<br><br>To be successful in our organization, you need an eager attitude, professionalism, and the confidence to willingly work to prove yourself and your ideas, and earn the trust of the organization.<br><br>Here's why we think you'd love working with us.<br><br><b>We're working towards something big</b><br><br>We've built a reputation as the global market leader for geolocation compliance solutions for over 10 years. We're trusted by customers from all over the world, and the next few years will be particularly exciting as we continue to scale across new markets.<br><br><b>Our values aren't just a buzzword</b><br><br>Our values are the foundation for what we as a company care about most. They signify the commitment we make to each other around how we act and what we stand for. They are our north star as we work together to build a company we're all proud to be a part of. Learn more, here.<br><br><b>Diversity, equity, and inclusion are at the core of who we are</b><br><br>In collaboration with our team and external partners, we promote DEI in our recruitment and hiring practices; scholarships and financial aid; training and mentorship programs; employee benefits, and more.<br><br><b>Learning is at the heart of our employee experience</b><br><br>At GeoComply, we foster an environment that empowers every employee to gain the knowledge and abilities needed to perform at their very best and help our organization grow. From a professional development budget to local training opportunities, knowledge-sharing sessions and more, we are continually investing in employee career growth and development.<br><br><b>We believe in being a force for good</b><br><br>We profoundly care about our impact on the world and strive to make meaningful contributions to the communities we work and live in. Our Impact division focuses on philanthropic and social responsibility initiatives, including supporting our local communities, advancing equality, and harnessing our technology to protect vulnerable groups. Learn more, here.<br><br><b>We care about our team</b><br><br>Our GeoComply team is talented, driven and hard-working, and is known for its positive attitude and energy. At GeoComply, we take care of our employees with the total package. Team members are generously rewarded with competitive salaries, incentives, and a comprehensive benefits program.<br><br><b>We value in-person collaboration</b><br><br>GeoComply culture thrives on a dynamic mix of in-person energy and independent focus and we champion a hybrid work model that blends the energy of in-person collaboration with the flexibility to work from home. Our 3-day in-office policy fosters teamwork and innovation, while also recognizing the importance of individual work styles and needs.<br><br>- - - - - - - - - -<br><br>At GeoComply, we live our value of Act with Integrity. Our workplace is built on mutual respect and inclusion, and we welcome applicants of all backgrounds, experiences, beliefs, and identities. Creating an accessible interview experience for all candidates is important to us. If you have any requests (big or small) throughout our hiring process, please don't hesitate to let us know so we can do our best to prioritize your needs.<br><br>We care about your privacy and want you to be informed about your rights. Please read our Applicant Privacy Notice before applying for the position.

Geocomply Business Intelligence Interview Guide

Overview

Geocomply Business Intelligence Salary

Geocomply Business Intelligence Interview Process

Geocomply Business Intelligence Interview Questions

Geocomply Business Intelligence Jobs