Prepare for and practice interview questions from Glocomms.

Glocomms Interview Questions

Glocomms Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

Glocomms Salaries by Position

Freelance Data Analyst – Hybrid We are looking for a Freelance Data Analyst to join a leading Energy companyThe ideal candidate must have in depth knowledge of Data Analysis Role:<ul><li>Data Analyst</li><li>Start date: ASAP</li><li>6-month contract but extendable</li></ul> Skills needed:<ul><li>Good experience as a Data Analyst</li><li>Several years of experiences in conducting statistical analyses</li><li>Good knowledge in at least one programming language</li><li>Good Excel and Powerpoint knowledge (pivoting, VBA, scenarios)</li><li>Experience with data visualization tools (Tableau and Looker) to build data stories</li><li>Proficiency with SQL</li></ul> Please email me at ammar.nabi@glocomms.com or call me at +49 30 726211428

Freelance Data Engineer with Digital Marketing Insights - English Speaking We are currently searching for a Freelance Data Engineer / Consultant for a project with one of our clients based in Switzerland and France. The ideal candidate will have experience in Digital Marketing, as well as extensive knowledge in dashboard development, data management, data modelling and performance optimisation. The candidate will support with key activities within the Data Team in the Global Strategic Marketing division! About the role:<ul><li>Role: Digital Insights Consultant / Data Engineer</li><li>Location: Remote - with some collaboration onsite in Paris, France</li><li>English Speaking (French is a nice-to-have)</li><li>Start date: Start of September</li><li>Contract length: until the end of 2024 with potential extensions</li></ul> Role requirements:<ul><li>Design and implement Dashboards creating, based on business requirements, user-friendly and visually corporate dashboards with key metrics and insights presented in a clear and actionable format.</li><li>Data Integration connecting Power BI to various data sources (e.g., SQL, AWS, cloud services) to automate data updates and ensure accuracy.</li><li>Custom Visualizations developing custom visualizations to meet specific analytical needs, ensuring they are aligned with business goals.</li><li>Data Modeling building data models that support efficient and scalable data analysis, including measures, calculated columns, and DAX (Data Analysis Expressions) formulas.</li><li>Optimize Performance ensuring dashboards are optimized for performance, minimizing load times and ensuring smooth interactions.</li><li>Documentation developing comprehensive documentation covering dashboard usage, data sources, data model structures, and maintenance procedures.</li><li>Analysis of business objectives, data exploration and insight generation / reporting.</li></ul> Please get in touch to learn more about this role!

About the Company: The Senior Manager MSAT, Digital Systems and Processes serve as the site MSAT leader in the data and analytics space, supporting site initiatives and implementation of smart manufacturing principles in collaboration with the site digital and analytics teams and driving innovative solutions to complex technical problems. The Senior Manager will lead a team of data scientists and engineers to facilitate delivery of product and process data solutions in biologics manufacturing environment. This team will leverage data as a key asset to accelerate technology transfer and simplify validation processes, support continuous improvement for established commercial processes, and enhance technical understanding of biopharmaceutical manufacturing. About the Role: The Senior Manager will be expected to support technical development of the MSAT organization, promoting technical and leadership capability to develop a high performing MSAT team and improving the data literacy and capability of the MSAT organization. The Senior Manager is also expected to manage within a matrix team to ensure alignment of data analytics platforms and approaches, collaborating with team members from other UM Biopharm departments (i.e. production, quality, engineering) and with stakeholders in central MSAT, data, and analytics teams to drive implementation of novel data analytics tools and technologies into the commercial manufacturing space. Responsibilities: <ul><li>Serve as the technical enterprise leader for data science and analytics capabilities for the MSAT team at UM Biopharm to deliver acceleration and simplification of new product introduction and robust commercial manufacturing for GSK supply chain and patients.</li><li>Accountable for the development and deployment of the strategic data and analytics plan for the UM MSAT Team, in collaboration with other site and central digital and analytics teams.</li><li>Drive innovation through leading continuous improvement for technical processes or systems and championing introduction of novel technologies, including new modeling platforms and approaches (first-principle modeling, CFD, machine learning), digital systems and visualizations, and process analytical technologies (PAT).</li><li>Lead a team of scientists and engineers to work collaboratively and efficiently to deliver the technical objectives.</li><li>Support capability development of the MSAT team to learn/implement new analytical technologies and modeling systems.</li></ul> Qualifications: <ul><li>BS/BA degree in either biological or chemical science or engineering or related field (i.e., engineering, science, etc.) with a minimum of 5 years of experience in the Biopharmaceutical/pharmaceutical industry OR MS or PhD degree with a minimum of 3 years of experience in the biopharmaceutical/pharmaceutical industry.</li></ul> Required Skills: <ul><li>Regulatory Compliance </li><li>Auditing </li><li>Data Science </li><li>Analytics Modeling </li><li>Statistical Modeling</li></ul>

We are seeking engineers with strong problem-solving abilities and a deep understanding of algorithms to build and maintain high-performance, scalable, and reliable systems. You will collaborate closely with global engineering and product teams in a dynamic and impactful environment. Key Responsibilities:<ul><li>Develop forecasting models to optimize ad budget allocation for advertisers.</li><li>Innovate monetization products that boost engagement and revenue.</li><li>Contribute to the development of a large-scale Ads system.</li><li>Enhance Ads algorithms through Machine Learning techniques.</li><li>Work on NLP and CV technologies for content understanding and taxonomy.</li><li>Drive the success of a rapidly growing organization with speed and quality.</li></ul>Minimum Qualifications:<ul><li>Proficiency in programming, debugging, and optimization in languages such as Go, C/C++, or Python.</li><li>Strong critical thinking and problem-solving skills.</li><li>Expertise in one or more of the following areas: brand ads, content ads, auction, bidding, ranking, and ads forecasting.</li><li>Experience with Machine Learning in forecasting, Deep Learning, NLP, ranking systems, recommendation systems, backend, large-scale systems, data science, or full-stack development.</li></ul>Preferred Qualifications:<ul><li>Bachelor’s degree in Computer Science, Computer Engineering, or a related field, with 5+ years of relevant experience.</li><li>Professional experience in machine learning, data mining, data analysis, or distributed systems.</li><li>Strong product sense and experience in designing and implementing product features.</li></ul> Locations for Onsite work: Los Angeles, CAWill provide a relocation package

The Role: As a Lead Data Engineer, you will spearhead the creation of both the team and the data pipeline from the ground up. You will tackle cutting-edge challenges in the big data and AI sectors, requiring a strong passion for innovation. Collaboration with cross-functional teams will be essential to understand business requirements and translate them into technical solutions. Additionally, you will provide technical guidance, mentorship, and support to junior team members. Responsibilities: <ul> <li>Design and implement efficient, scalable, and reliable data pipelines and infrastructure for ingesting, processing, and transforming large datasets. </li><li>Develop the technical strategy and roadmap for data engineering projects, aligning them with business objectives. Continuously evaluate and integrate industry best practices and advanced technical approaches, updating the strategy as the industry evolves. </li><li>Build and lead a high-performing data engineering team, offering business, technical, and personal development coaching. </li><li>Drive data engineering projects by leveraging both internal and cross-functional resources, setting ambitious targets, and achieving them through innovative methods. </li><li>Promote a collaborative and inclusive team culture, working closely with data scientists and other teams. </li></ul> Requirements: Minimum Qualifications: <ul> <li>Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field. </li><li>5 years of experience in data engineering, with proven expertise in building scalable data pipelines and infrastructure. </li><li>Proficiency in programming languages such as Python, SQL, and Java. </li><li>Strong understanding of database systems, data warehousing, and distributed computing concepts. </li><li>Excellent leadership, communication, and interpersonal skills. </li><li>Demonstrated success in leading teams and delivering complex data engineering projects. </li><li>Ability to thrive in a fast-paced, dynamic environment and manage multiple priorities effectively. </li></ul> Preferred Qualifications: <ul> <li>3 years of experience with big data technologies such as Apache Spark, Hadoop, and Kafka. </li> </ul>

Do you want to be a driving force in a rapidly expanding environment, making a tangible difference in the process? We have an exciting opportunity for you!Our Client a global leading German bank is looking for a Junior Product Manager Key Responsibilities:<ul><li>Developing (technical) concepts and processes-based bank’s requirements</li><li>Analysing APIs and data requirements of 3rd party systems for integration into the overall architecture</li><li>Bringing new ideas for optimizing products, systems, and processes</li><li>Preparing user stories for the development team and software testing before commissioning</li><li>Implementing support of the conceptualized features in close cooperation with other divisions such as other IT development teams</li></ul> Required Skills and Qualifications:<ul><li>University degree in business or IT (e.g., technical business administration, business informatics, industrial engineering, )</li><li>Initial Professional experience in the field of (technical) product management would be a plus</li><li>Good with Data and processes</li><li>Empathetic and understands user needs, focused on user-centered design (UX/UI Design)</li><li>Analytically strong and a creative problem solver who enjoys working in agile teams</li><li>Experience in creating mock-ups and prototypes (e.g., Figma or UXPin) is a plus</li><li>Fluent in written and spoken German</li></ul> Please contact me on ammar.nabi@glocomms.com or please call me on +49 30 726211428 for further information.

The Role:As a Lead Data Engineer, you will spearhead the creation of both the team and the data pipeline from the ground up. You will tackle cutting-edge challenges in the big data and AI sectors, requiring a strong passion for innovation. Collaboration with cross-functional teams will be essential to understand business requirements and translate them into technical solutions. Additionally, you will provide technical guidance, mentorship, and support to junior team members.Responsibilities:<ul><li>Design and implement efficient, scalable, and reliable data pipelines and infrastructure for ingesting, processing, and transforming large datasets.</li><li>Develop the technical strategy and roadmap for data engineering projects, aligning them with business objectives. Continuously evaluate and integrate industry best practices and advanced technical approaches, updating the strategy as the industry evolves.</li><li>Build and lead a high-performing data engineering team, offering business, technical, and personal development coaching.</li><li>Drive data engineering projects by leveraging both internal and cross-functional resources, setting ambitious targets, and achieving them through innovative methods.</li><li>Promote a collaborative and inclusive team culture, working closely with data scientists and other teams.</li></ul>Requirements:Minimum Qualifications:<ul><li>Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.</li><li>5 years of experience in data engineering, with proven expertise in building scalable data pipelines and infrastructure.</li><li>Proficiency in programming languages such as Python, SQL, and Java.</li><li>Strong understanding of database systems, data warehousing, and distributed computing concepts.</li><li>Excellent leadership, communication, and interpersonal skills.</li><li>Demonstrated success in leading teams and delivering complex data engineering projects.</li><li>Ability to thrive in a fast-paced, dynamic environment and manage multiple priorities effectively.</li></ul>Preferred Qualifications:<ul><li>3 years of experience with big data technologies such as Apache Spark, Hadoop, and Kafka.</li></ul>

The Role: Staff Data Engineer We love our customers, and we love data that tells their story. And while we’re happy to say that we have a lot of both, we need help bringing it together, managing it, and making it useful -- to us and to our customers. This is where you come in: we’re building our business on this foundation of data, and you’ll make sure it’s a stable one. As a technical leader of our data engineering team, reporting to our Director of Business Intelligence, you’ll play a pivotal role in defining the foundation crucial for various types of analysis. Your work will encompass heavy cross-channel analysis of media interaction logs, optimizing paid media, distilling purchase data to better understand our customers, and evaluating warehouse and sourcing data to improve operational efficiency. You will help us think of innovative ways to improve our data systems to help the business make decisions and make it even more enjoyable and valuable to shop with us. We have thousands of items, data-driven fulfillment centers, a robust order management system, an exhaustive tagging footprint, a growing number of media outlets, and happy, engaged customers... If you’re already imagining all the cool stuff we’ll be able to build with that, then we should talk. What you'll do: <ul><li>Apply your engineering expertise to solve large-scale business problems. Drive design and architecture discussions and build alignment on complex technical decisions</li><li>Design, implement, validate, and deploy software solutions to enhance our reporting and analytics systems. This includes new features and architectural improvements for our data pipeline and analytics tools, such as Looker, dbt, Databricks, Fivetran, Airbyte, and AWS Redshift</li><li>Provide technical leadership in data architecture and help establish best practices for data modeling, storage, and retrieval</li><li>Collaborate with cross-functional teams to understand data needs and design solutions that meet business requirements</li><li>Drive the adoption of advanced analytics techniques and technologies to unlock insights from large datasets</li><li>Perform design and code reviews to ensure quality and scalability</li><li>Lead the design of data governance policies and procedures. Help establish and enforce data security and privacy protocols to safeguard sensitive information</li><li>Further agile and DevOps practices to ensure efficient and high-quality data engineering processes</li><li>Support on-call assignments and operational management</li><li>Collaborate with business analysts and product owners to assist with measuring experiments to vet hypotheses</li><li>Mentor, lead, and train other members of the data engineering team</li><li>Be the champion for data from a technical perspective across the entire organization</li></ul> What you'll bring:<ul><li>Apply your engineering expertise to solve large-scale business problems. Drive design and architecture discussions and build alignment on complex technical decisions</li><li>Design, implement, validate, and deploy software solutions to enhance our reporting and analytics systems. This includes new features and architectural improvements for our data pipeline and analytics tools, such as Looker, dbt, Databricks, Fivetran, Airbyte, and AWS Redshift</li><li>Provide technical leadership in data architecture and help establish best practices for data modeling, storage, and retrieval</li><li>Collaborate with cross-functional teams to understand data needs and design solutions that meet business requirements</li><li>Drive the adoption of advanced analytics techniques and technologies to unlock insights from large datasets</li><li>Perform design and code reviews to ensure quality and scalability</li><li>Lead the design of data governance policies and procedures. Help establish and enforce data security and privacy protocols to safeguard sensitive information</li><li>Further agile and DevOps practices to ensure efficient and high-quality data engineering processes</li><li>Support on-call assignments and operational management</li><li>Collaborate with business analysts and product owners to assist with measuring experiments to vet hypotheses</li><li>Mentor, lead, and train other members of the data engineering team</li><li>Be the champion for data from a technical perspective across the entire organization</li></ul>What you'll bring:<ul><li>Bachelor's degree required in Computer Science, Software Engineering, or related field</li><li>Master's degree preferred in a related field</li><li>6+ years of experience in data engineering working with big data systems that can process and transform data at scale</li><li>Deep knowledge of analytics technologies, modeling techniques, data streaming and other ingestion approaches, data warehousing concepts, cloud platforms (AWS preferred), and proven experience with data architecture including data pipelines, dimensional modeling, and dependency management</li><li>Experience developing with data SaaS and BI tooling (Fivetran, Looker, dbt, Databricks, Apache Airflow, etc.)</li><li>Experience automating data integration using APIs</li><li>Proficiency in programming languages such as SQL and Python in an analytics context</li><li>Experience handling operational aspects of large-scale systems focusing on observability, tech debt management, code refactoring, and robust software development and release processes</li><li>Experience articulating technically complex topics in an easy-to-understand way via written and verbal communication methods</li><li>Proven track record of mentorship, leadership, and ownership within teams and organizations</li><li>Curiosity and creativity, with sound judgment and a high degree of both integrity and empathy</li><li>Ability to create strategies and plans that define how information can be utilized to support an organization's overall business strategy, and how that information and data is organized, and governed inside an organization</li><li>Experience with agile methodologies, DevOps practices, and CI/CD pipelines</li><li>Communication and leadership experience, with experience initiating and driving projects</li><li>Effective written and verbal communication of data-driven solutions across all levels of the organization</li><li>Significant experience in consumer, retail or ecommerce organization</li></ul> What we offer:<ul><li>A high-growth and rewarding role in a foundationally strong and rapidly evolving business</li><li>Excellent benefits including a 401K Match</li><li>Paid Maternity, Adoption and Paternity leave </li><li>Base salaries may vary based on factors such as skills, experience and qualifications for the role. Base pay is only part of the total compensation package, which, depending on the position, may also include short & long term incentive compensation. In addition, employees are eligible for our standard benefits package including paid time off, medical, dental and 401K match.</li></ul>

Responsibilities: • Conducting research on on investment sectors and build insights through regression, ML models, etc.• Develop, Build and Maintain systematic, automated machine learning models to projectlocalized economic trends into actionable products.• Collaborate with internal stakeholders and portfolio companies to make sure models meetbusiness needs, are actively monitored, and are scalable• Ability to interpret complex economic problems and break down research projects intostructured machine learning research projects.• See through the end-to-end deployment of machine learning solutions, incorporating someback-end data engineering workflows via cloud-based solutions (prototype to productiondeployment)• Drive continuous improvement and best practices for the team’s data quality andultimately model performanceQualifications:• Strong academic background in a relevant field (Computer Science, Engineering)• 4+ Years of professional experience in an environment prioritizing accuracy and quality ofwork• Highly proficient of a scientific computing language (Matlab, Python, Perl, R, etc.) andexpert with common software/database development flows and tools (Linux, git,AWS/Azure, SQL (Snowflake), NoSQL (MongoDB), etc.)• Strong expertise in AI/ML platform engineering, modern data platforms and data structuresinterfacing within cloud-based environments• Experience within AI/ML pipelines, MLOps and production ML/Deep Learning models(exposure across training, evaluating and deploying solutions)• Demonstrated workflow and time management skills capable of advancing multipleprojects with varying timelines• Open to critical thinkers inside and outside of the financial industry, searching forpassionate individuals interested in disrupting a legacy sector• Ability to work decisively under time pressure from time to time

Data Engineer Manager Base Comp: 220-350KLocation: San Jose, CA OR Seattle, WA Summary:This company is a top e-commerce company based out of the West coast. They are actively building out and growing their data team and platform this year. This company is looking for someone with at least 3 years of people management experience, in addition to strong technical background. The Data Engineer Manager will be responsible for:<ul><li>Scaling a data engineering team from 0-1+</li><li>Road mapping and providing overall strategy for both business and technical support</li><li>Overall architecting data pipelines and infrastructure for ingestion of large amounts of data</li></ul> The Data Engineer Manager should have the following qualifications:<ul><li>7+ years of data engineering experience</li><li>3+ years of people management experience</li><li>Strong level of experience Python, SQL and Java</li><li>Preferred experience with Spark and Kafka</li></ul> Benefits:<ul><li>401K</li><li>Medical, Dental, and Health</li><li>Relocation package (if needed)</li></ul> If you are interested in the Data Engineer Manager role, then please don’t wait to apply.

Glocomms Interview Questions

Glocomms Interview Guides

Glocomms Interview Questions

Glocomms Salaries by Position

Glocomms Opening Jobs