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 identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</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>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</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>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<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

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

Data Engineer Glocomms are partnered with a growing customer in the Finance sector to find an experienced Data Engineer with a strong background in AWS, specifically in serverless technologies. The ideal candidate will be responsible for building, testing, and deploying data services, while ensuring the integrity of data workflows and code management. Key Responsibilities:<ul><li>Design, build, test, and deploy data services within AWS, focusing on serverless architecture.</li><li>Orchestrate workflows using AWS Lambda and Step Functions to automate and manage end-to-end processes.</li><li>Manage code using GitHub, GitLab, and Terraform (Infrastructure as Code).</li><li>Implement data workflows and services using Jenkins for CI/CD pipelines.</li><li>Develop scalable data pipelines using PySpark and AWS Glue for data ingestion and transformation.</li><li>Implement and manage unit tests in Python to ensure the quality and reliability of data pipelines.</li><li>Support the team in the entire lifecycle of data transformation, including ETL processes.</li></ul> Key Requirements:<ul><li>Expertise in AWS, particularly in serverless services such as AWS Lambda, API Gateway, etc.</li><li>Strong experience in building, testing, and deploying services within AWS environments.</li><li>Proficiency in code management using GitHub, GitLab, Terraform (IAC), and Jenkins.</li><li>Solid understanding of data transformation processes and ETL tools.</li><li>Experience with data processing using Spark and PySpark.</li><li>Strong programming skills in Python, with experience in data-related libraries and frameworks.</li><li>Ability to work in a Scrum/Agile environment.</li></ul> We are looking for a Data Engineer to join for 12 months, for an extendable up to 3 years contract to work 2 days on site.

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*

Glocomms Business Intelligence Interview Guide

Overview

Glocomms Business Intelligence Salary

Glocomms Business Intelligence Interview Process

Glocomms Business Intelligence Interview Questions

Glocomms Business Intelligence Jobs