Prepare for and practice interview questions from Glocomms.

Glocomms Interview Questions

Glocomms Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Glocomms Salaries by Position

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!

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*

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>

Glocomms Interview Questions

Glocomms Interview Guides

Glocomms Interview Questions

Glocomms Salaries by Position

Glocomms Opening Jobs