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

Glocomms Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Glocomms? The Glocomms Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Glocomms Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Glocomms.</li>
<li>Practice real Glocomms Business Intelligence interview questions.</li>
</ul>
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 Glocomms Business Intelligence interview.


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

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

Overview

Glocomms Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Glocomms Business Intelligence Interview Process

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.

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

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

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

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

Example:

Input:

<code>transactions</code> table

<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>
<code>products</code> table

<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>
<code>users</code> table

<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>
Output:

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

<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>
 
Output:

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

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

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

Customer Orders

Glocomms Business Intelligence Interview Questions

BESS Senior Product Manager Company Overview: Our client is a leader in the energy storage sector, dedicated to advancing domestic manufacturing and cutting-edge technology. They are expanding its energy storage battery production facilities and strategically focusing on supplying battery cells to major automotive manufacturers. Role Overview: We are seeking a Senior Product Manager for our Energy Management System (EMS), which plays a crucial role in managing large-scale energy storage solutions. This position involves close collaboration with our software team to develop and optimize software solutions that integrate seamlessly with battery systems, ensuring efficient energy management and operational reliability. You will gather customer feedback, drive product enhancements, and oversee successful project deployments in a fast-paced environment. Key Responsibilities: <ul> <li>Develop and improve software solutions for energy storage systems. </li><li>Collaborate with internal teams (software, service, engineering) to ensure seamless integration and operation. </li><li>Drive customer engagement and gather feedback to refine product offerings. </li><li>Monitor industry trends and competitive landscape to inform product strategy. </li><li>Up to 20% travel required. </li></ul> Qualifications: <ul> <li>Bachelor's degree or equivalent practical experience. </li><li>10+ years of B2B enterprise product management experience in energy storage, renewable energy, and industrial automation, adept at handling long sales cycles, complex hardware/software integrations, and large projects with limited volume. </li><li>Familiarity with safety-critical infrastructure controls and software development. </li></ul> *This role is remote but candidates must be in EST or CST time zone*

**Lead Data Engineer**Location: Dallas, TX (On-Site)Base Comp: 140-165KRole cannot Provide Sponsorship Are you a passionate Lead Data Engineer seeking an exciting new challenge? We're looking for someone with strong coding abilities and substantial experience to join our dynamic team based in the heart of Dallas. This is not just another job; it's a chance to make significant contributions using top-notch technology within the Azure data factory environment. *Role Highlights:*- Permanent, full-time position- Location: On-site at our modern office space in Dallas- Focus on Azure Data Factory technologies The successful candidate will have over 5 years of hands-on experience and demonstrated leadership skills. You'll be responsible for projects that require deep technical knowledge, managing processes efficiently while pushing technological boundaries. *Skills Required:*1. **Strong Coding Expertise:** - Mastery level required due to the complex nature of tasks. 2. **Azure Knowledge & Experience:** - Proficiency in utilizing Azure services, particularly around data management tools like Azure Data Factory. 3. **Leadership Abilities**: - Proven track record leading teams or projects ensuring smooth execution from conception through delivery. 4. **Data Engineering Acumen**: - Strong experience with ETL pipeline work in addition to understanding migration within ADZ and Copy Data & Data Flow. If you are determined, enjoy solving challenging problems, possess excellent communication skills, and thrive when immersed deeply in technicalities, this role could provide the perfect next step in your career journey! Email me at trinity.bell@glocomms.com with your most updated CV or to share any referrals for this position!

Role: Software EngineerLocation: NYC (onsite, 5 days in office)Tech Stack: Python, JavaScript/TypeScript, React, SQL, AWSCompensation: $120,000-150,000 Base + Annual bonus + Equity Currently working with an exciting Series A startup in the healthtech space! They are building an AI-based platform using greenfield methods to improve patient outcomes and reduce risk. This is a unique opportunity to maintain strong ownership of your work and contribute to the forefront of medical technology in the country's biggest medical hotspot! Responsibilities:<ul><li>Writing clean, high-quality, high-performance, maintainable code</li><li>Develop and support software including applications, database integration, interfaces, and new functionality enhancements</li><li>Coordinate cross-functionally to insure project meets business objectives and compliance standards</li><li>Support test and deployment of new products and features</li><li>Participate in code reviews</li></ul> Qualifications:<ul><li>Bachelor's degree in Computer Science</li><li>2+ years of relevant work experience</li><li>Strong backend development experience in Python, SQL, and AWS</li><li>Expertise in Object Oriented Design and Database Design</li><li>Well-versed in computer science fundamentals such as data structures, algorithms, and OOP concepts</li><li>Experience with Agile or Scrum software development methodologies</li></ul> Nice to Have:<ul><li>Previous early-stage startup experience</li><li>Exposure to the healthtech space</li><li>Experience building microservices architecture</li></ul>

BESS Senior Product Manager Company Overview:Our client is a leader in the energy storage sector, dedicated to advancing domestic manufacturing and cutting-edge technology. They are expanding its energy storage battery production facilities and strategically focusing on supplying battery cells to major automotive manufacturers. Role Overview:We are seeking a Senior Product Manager for our Energy Management System (EMS), which plays a crucial role in managing large-scale energy storage solutions. This position involves close collaboration with our software team to develop and optimize software solutions that integrate seamlessly with battery systems, ensuring efficient energy management and operational reliability. You will gather customer feedback, drive product enhancements, and oversee successful project deployments in a fast-paced environment. Key Responsibilities:<ul><li>Develop and improve software solutions for energy storage systems.</li><li>Collaborate with internal teams (software, service, engineering) to ensure seamless integration and operation.</li><li>Drive customer engagement and gather feedback to refine product offerings.</li><li>Monitor industry trends and competitive landscape to inform product strategy.</li><li>Up to 20% travel required.</li></ul> Qualifications:<ul><li>Bachelor's degree or equivalent practical experience.</li><li>10+ years of B2B enterprise product management experience in energy storage, renewable energy, and industrial automation, adept at handling long sales cycles, complex hardware/software integrations, and large projects with limited volume.</li><li>Familiarity with safety-critical infrastructure controls and software development.</li></ul> *This role is remote but candidates must be in EST or CST time zone*

About the Role:We are seeking a skilled Data Analyst with a strong background in life sciences to join our team. The ideal candidate will have experience working with multiple scientific databases and a deep understanding of metadata harmonization. This role offers the opportunity to grow into a more senior position within our organization. Key Responsibilities:<ul><li>Database Management: Work with various scientific databases, including PubMed and open-source databases.</li><li>Metadata Harmonization: Harmonize metadata from different sources to ensure consistency and accuracy.</li><li>Cross-Functional Collaboration: Collaborate with other database teams to integrate and harmonize data.</li><li>Data Understanding and Visualization: Interpret complex data sets and visualize data using tools like Power BI.</li><li>Data Cleaning: Perform data cleaning and harmonization to maintain data integrity.</li></ul> Qualifications:<ul><li>Educational Background: Degree in Life Sciences, Data Science, or a related field.</li><li>Experience: Proven experience in the pharma/life sciences industry.</li><li>Technical Skills: Proficiency in data visualization tools such as Power BI.</li><li>Medical Content Understanding: Ability to understand and interpret medical content.</li><li>Growth Potential: Eagerness to grow into a more senior role within the organization.</li></ul>

Glocomms Business Intelligence Interview Guide

Overview

Glocomms Business Intelligence Salary

Glocomms Business Intelligence Interview Process

Glocomms Business Intelligence Interview Questions

Glocomms Business Intelligence Jobs