Prepare for and practice interview questions from Harnham.

Harnham Interview Questions

data and analytics recruitment is our core business and we’re proud to say, our customers believe we’re good at it. in our most recent customer satisfaction survey, 95% of respondents said that they would recommend harnham. harnham has actively chosen to focus on data and analytics, we’ve immersed ourselves in this market and are now an integral part of this business community. our capability has grown to provide recruitment services and advice across the marketing analytics, credit risk, data science, data and technology and digital sectors.

data and analytics recruitment is our core business and we’re proud to say, our customers believe we’re good at it. in our most recent customer satisfaction survey, 95% of respondents said that they would recommend harnham. harnham has actively chosen to focus on data and analytics, we’ve immersed ourselves in this market and are now an integral part of this business community. our capability has grown to provide recruitment services and advice across the marketing analytics, credit risk, data science, data and technology and digital sectors.

Overview

Harnham Interview Guides

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

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?

Harnham Salaries by Position

Data Scientist / Analyst Paris CDI Cette start-up est en forte croissance et se distingue par son approche disruptive du secteur logistique. Avec un pôle data en plein développement, elle s’appuie sur les dernières avancées technologiques pour optimiser ses opérations et proposer des solutions à haute valeur ajoutée pour le pricing du fret. Missions : • Analyser et exploiter les données pour générer des insights à forte valeur ajoutée, afin d’améliorer la performance des opérations logistiques. • Effectuer des analyses statistiques et prédictives pour identifier des tendances et des opportunités d’optimisation. • Participer à des projets de data science et data analytics, en utilisant des méthodes avancées de machine learning et d’analyse statistique. • Créer et maintenir des tableaux de bord et des visualisations de données pour suivre les indicateurs clés de performance (KPI) à travers des outils de data visualisation. • Travailler sur la manipulation et l’exploitation de grandes bases de données, avec un focus sur SQL et Python. • Collaborer étroitement avec les équipes internes pour traduire les besoins métiers en analyses exploitables. • Garantir la qualité et la fiabilité des données analysées. Profil recherché : • Entre 1 et 4 ans d’expérience en data science, data analytics ou un poste similaire. • Diplôme en mathématiques, statistiques, probabilités ou un domaine connexe. • Forte aisance avec les chiffres, un esprit analytique et une rigueur scientifique. • Maitrise d’un outil de data visualisation (ex : Tableau, Power BI). • Expérience en SQL et/ou Python indispensable. • Anglais courant pour évoluer dans un environnement international. • Proactif, curieux, avec une capacité à résoudre des problèmes complexes et à travailler de manière autonome.

Data Scientist Paris CDI Acteur majeur dans la digitalisation du transport de fret, cette start-up transforme la gestion logistique avec une plateforme intelligente qui permet de réduire significativement les coûts tout en améliorant les performances. Forte de son succès, elle développe aujourd’hui son pôle data composé d’une vingtaine d’experts. L’équipe data, au cœur de l’innovation de l’entreprise, joue un rôle central dans l’analyse des données pour offrir des solutions à haute valeur ajoutée à ses clients. Missions : <ul><li>Analyser les données issues de la plateforme pour identifier des tendances et générer des insights exploitables afin d’optimiser les coûts de transport.</li><li>Développer des modèles prédictifs pour améliorer la performance des opérations logistiques et anticiper les fluctuations du marché.</li><li>Créer des visualisations de données percutantes via des outils tels que Tableau et Power BI pour fournir des indicateurs de performance (KPI) aux équipes internes et aux clients.</li><li>Collaborer avec les équipes produit et métier pour répondre aux besoins spécifiques des clients à travers des analyses poussées.</li><li>Interagir directement avec les clients, en apportant une expertise analytique pour les aider à mieux comprendre les résultats et optimiser leurs processus logistiques.</li><li>Utiliser SQL et Python pour la manipulation des données, automatisation des analyses, et développement de solutions sur-mesure.</li></ul> Profil recherché : <ul><li>Expérience de 1 à 4 ans en data science ou data analytics.</li><li>Compétences solides en SQL et Python, avec une capacité à manipuler et analyser des jeux de données complexes.</li><li>Maîtrise d’un outil de data visualisation (Tableau, Power BI).</li><li>Connaissances en modélisation statistique et analytique.</li><li>Anglais courant indispensable pour interagir avec des clients et équipes internationales.</li><li>Une expérience dans le conseil ou le client-facing serait un plus, car le poste implique une interaction fréquente avec les clients pour comprendre leurs besoins et leur fournir des solutions personnalisées.</li></ul>

Senior Software EngineerFashionNew York, New York (Hybrid)$160,000 - $180,000 + Equity The Company:A fashion company utilizing AI technology aims to minimize the environmental impact of the industry by optimizing supply chains, reducing waste, and enhancing sustainable practices. By leveraging advanced AI algorithms, the company improves resource efficiency, predicts fashion trends more accurately, and ensures responsible material sourcing, all while creating eco-friendly, innovative designs. This approach not only supports environmental sustainability but also fosters a more transparent and ethical fashion ecosystem. They are looking to bring on a Senior Fullstack Software Engineer to join their rapidly growing team. The ideal candidate is experienced in building out customer-facing platforms. The Role:As a Senior Software Engineer, you will be responsible for building out our customer-facing platform, ensuring it meets high standards for performance, reliability, and user experience. You will collaborate with cross-functional teams to design and implement scalable solutions, leveraging your expertise in developing intuitive interfaces and optimizing backend systems. Your role will also involve troubleshooting and resolving complex technical issues, as well as mentoring junior developers to enhance the overall development process. Your Skills and Experience:<ul><li>Design, build, and optimize web applications with a focus on performance, scalability, and user experience.</li><li>Demonstrate strong expertise in React, Node.js, TypeScript, and JavaScript to create dynamic and interactive interfaces and robust backend services.</li><li>Lead the design and implementation of scalable, high-quality software solutions, ensuring seamless integration between frontend and backend systems.</li><li>Work closely with product managers, UX/UI designers, and other engineers to translate business requirements into technical specifications and deliver solutions that meet customer needs.</li><li>Write clean, maintainable code and conduct code reviews to uphold high standards of software development.</li><li>Apply best practices in software engineering, including testing, debugging, and documentation.</li><li>Identify and address performance bottlenecks in both frontend and backend systems, ensuring a smooth and responsive user experience.</li><li>Provide guidance and support to junior developers, fostering a collaborative and innovative engineering culture.</li><li>Keep abreast of emerging technologies and industry trends to continuously improve and adapt the technology stack and development practices.</li><li>Experience in the fashion industry is a plus.</li></ul> The Benefits:<ul><li>A base salary between $160,000 - $180,000, plus equity</li><li>Comprehensive health, dental, vision, and 401k benefits</li></ul> How to Apply:<ul><li>Please register your interest by sending your resume to Neha Nidamarti via the Apply link on this page.</li></ul> Key Words:React, Typescript, Javascript, Node.js, Backend Engineer, Frontend Engineer, Fullstack Engineer, Software Engineer, Fashion, Technology, AI

SENIOR BUSINESS INTELLIGENCE MANAGER CHICAGO HYBRID - 2 DAYS IN THE OFFICE A WEEK UP TO $150,000 This role doesn't offer sponsorship THE COMPANY A leading force in the Marketing Media industry that is using data-driven strategies to shape the future of digital marketing, partnering with top brands to deliver media solutions across multiple industries THE ROLE AND RESPONSIBILITIES They are seeking an experienced Senior Manager specialised in Business Intelligence to bring their deep understanding of data analytics, media performance metrics, and stakeholder management skills to the leadership of the BI team In this role you will be: <ul> <li>Leading and managing a team of 6 analysts ensuring high-quality data analysis, reporting, and insight </li><li>Develop and maintain the BI roadmap, implementing BI strategies across the business </li><li>Collaborating with the Marketing, Media, and Product teams to identify KPIs and develop interactive dashboards </li><li>Overseeing the development of data models and predictive modeling to help inform on customer behavior </li><li>Present insights to senior leadership and clients </li></ul> YOUR SKILLS AND EXPERIENCE They are looking for an experienced candidate who has proven experience in management and providing advanced analytical solutions Please apply if you have experience: <ul> <li>A bachelor's degree in marketing, Data Science, Data Analytics, Statistics or a related field </li><li>Minimum 5 years' experience working within Business Intelligence with at least 2 in a leadership role </li><li>Proven experience in developing and implementing successful BI solutions and strategies </li><li>Strong proficiency in BI analytics tools and platforms (e.g. Power BI, Tableau, Looker, SQL, Python) </li><li>Excellent communication and presentation skills with the ability to translate complex data insight </li></ul> BENEFITS <ul> <li>A competitive salary of up to $150,000 </li><li>Performance bonuses based on individual and company performance </li><li>401k plan </li><li>Private dental and life insurance </li></ul> Please apply via the website

Data Analyst Paris CDI Notre cabinet de recrutement recherche pour une start-up en pleine expansion, spécialisée dans le fret et la logistique à Paris, un Data Analyst pour renforcer son équipe data. Cette entreprise innovante propose une solution digitale révolutionnaire pour optimiser les coûts de transport et améliorer l’efficacité des opérations logistiques. Présentation de l’entreprise : Cette start-up, acteur clé dans la digitalisation du transport de fret, se démarque grâce à une plateforme technologique innovante permettant de réduire les coûts et d’optimiser les flux logistiques. En pleine croissance, l’entreprise développe actuellement son pôle data, qui compte déjà une vingtaine d’experts, et recherche un Data Analyst pour accompagner son expansion et transformer la donnée en insights actionnables. Missions : <ul><li>Analyser les données opérationnelles et commerciales pour identifier des opportunités d’optimisation des coûts et améliorer les processus logistiques.</li><li>Créer des rapports et des tableaux de bord sur des outils de data visualisation tels que Tableau ou Power BI, permettant de suivre les performances et de faciliter la prise de décision.</li><li>Transformer des données brutes en insights exploitables pour les équipes internes et les clients, en expliquant les résultats de manière claire et actionnable.</li><li>Effectuer des analyses statistiques pour comprendre les tendances, prévoir les évolutions du marché et identifier des opportunités d’amélioration.</li><li>Collaborer avec les équipes produit et métiers, en traduisant les besoins opérationnels en analyses concrètes.</li><li>Interagir avec les clients, en leur fournissant des analyses et des visualisations adaptées à leurs besoins et en les accompagnant dans la compréhension des données.</li></ul> Profil recherché : <ul><li>Expérience de 1 à 4 ans en tant que Data Analyst ou dans un rôle similaire.</li><li>Maîtrise des outils de data visualisation (Tableau, Power BI) pour créer des rapports percutants et lisibles.</li><li>Compétences solides en SQL et une bonne connaissance de Python pour manipuler et analyser des données complexes.</li><li>Forte capacité analytique et aisance avec les chiffres, ainsi qu’une excellente compréhension des modèles statistiques.</li><li>Anglais courant indispensable pour évoluer dans un environnement international et interagir avec des clients.</li><li>Une expérience dans le conseil ou dans un rôle client-facing serait un plus, le poste nécessitant une interaction régulière avec les clients pour les accompagner dans l’analyse des données.</li></ul>

Staff Software EngineerFin TechBrooklyn, NY (Hybrid)$220,000-$250,000 + Equity About Us:We are working with an innovative startup that's pioneering decentralized policy enforcement and pushing the boundaries of Web3 technologies. Their platform empowers developers to create custom rules, such as flow-of-funds and rate limits, merging decentralized governance with the security and transparency of blockchain. Role Description:As a Staff Software Engineer, you'll be at the forefront of shaping the strategic direction and architecture of software that impacts leading crypto and Web3 projects. You'll play a pivotal role in designing, implementing, and optimizing the distributed systems that form the backbone of our protocol.<ul><li>Utilize your expertise in distributed systems to design and implement robust back-end services.</li><li>Develop and communicate technical designs and solutions within the Web3 ecosystem.</li><li>Engage in design and code reviews, daily stand-ups, and agile development processes.</li><li>Continuously learn from peers and stay updated on emerging technologies and methodologies in distributed node infrastructure and Web3.</li></ul> Requirements:<ul><li>BS/MS in a technical field such as Computer Science.</li><li>Proficiency in Golang Web3, Docker, Kubernetes.</li><li>At least 5 years of software development experience with high-scale distributed systems (building, owning, and operating).</li><li>Strong knowledge of software engineering best practices across the full development life cycle, including coding standards, code reviews, source control, build processes, and automated testing.</li><li>Experience in fast-paced startups and blockchain development.</li></ul> The Benefits:As a Staff Software Engineer, you'll receive a competitive salary of $220,000-$250,000 + Equity. This role also includes 401k, health, dental, and vision care. How to Apply:Register your interest by sending your resume to Jacob Bisson via the Apply link on this page. Key Words:Golang, Blockchain, Web3, Crypto, Distributed Systems, Docker, Kubernetes, Startup, Software Engineer

LEAD CREDIT RISK ANALYST LEEDSUP TO £60,000 As a Lead Credit Risk Analyst, you will play a pivotal role in managing and enhancing our bank's credit risk strategies. Leveraging your expertise in credit risk analysis, you will contribute to the development and implementation of robust credit risk models and policies, ensuring the bank's portfolio remains resilient and aligned with regulatory standards. THE ROLE<ul><li>Conduct a comprehensive analysis of the credit portfolio, identifying emerging risks, providing insights to senior management for informed decision-making and implementing credit risk strategies.</li><li>Collaborate with cross-functional teams to formulate and update credit risk policies, ensuring compliance with regulatory requirements and internal standards.</li><li>Utilize large datasets to extract meaningful patterns, trends, and insights, contributing to a proactive and data-driven credit risk management approach.</li><li>Stay abreast of industry regulations and ensure that credit risk strategies and models align with regulatory guidelines, making necessary adjustments as required.</li></ul> REQUIREMENTS<ul><li>Bachelor's degree in a quantitative field such as Finance, Economics, Mathematics, or Statistics. Advanced degree (MSc, PhD) is a plus.</li><li>Proven experience in credit risk analysis within a banking or financial services environment.</li><li>Strong proficiency in statistical modeling and programming languages (e.g., SAS, R, Python) for data analysis.</li><li>In-depth understanding of credit risk principles, regulatory requirements, and industry best practices.</li></ul> HOW TO APPLY Please send CV or apply below!

Product Pricing AnalystBirmingham – Hybrid Up to £35,000 THE COMPANY A leading company in the automotive industry is looking for a Product Pricing Analyst to join the team! THE ROLEThis role will sit in the pricing arm of the wider commercial team and will be responsible for the end-to-end delivery of pricing for a range of products. You will deliver insights to influence pricing decisions, working with a range of stakeholders across the business to come up with the best pricing strategies across different categories, ensuring the best price point is maintained. YOUR SKILLS AND EXPERIENCE<ul><li>Extensive experience in Excel</li><li>Strong commercial experience</li><li>Experienced in presenting insights and making recommendations</li></ul> BENEFITSUp to £35,000Hybrid working patternOpportunity to grow and develop your career HOW TO APPLYPlease register your interest by sending your CV to Lauren McAlister via the Apply link on this page.

ANALYTICS MANAGER£55,000-60,000 + BENEFITSLONDON THE COMPANYA role as an Analytics Manager at a leading service provider, supporting charities, providing analytics and insights solutions to drive performance. This company has a vast amount of data to work through and as a Analytics Manager, you will be working closely with talented individuals to deliver essential insight that will allow the company to continue growing. THE ROLEAs a Analytics Manager, you can expect to be leading a team whilst analysing and interpreting results of both testing and optimisation experiments in a statistical and scientifically sound manor.In specific, you can expect to be involved in the following:<ul><li>Identification of opportunities to increase revenue through channel optimisation across SEO, Push, Paid Media, CRM, and more</li><li>Analysis and interpretation of testing results and optimisation experiments (incl. a/b testing) </li><li>Analysis of marketing communications for the purpose of generating insights and testable hypotheses</li><li>Defining segmentations</li><li>Tracking and improvisation of marketing measurement across LTV, Acquisition, Churn and more</li><li>Visualisation of data using tools such as Looker or Tableau</li></ul> YOUR SKILLS AND EXPERIENCEThe successful Analytics Manager will have the following skills and experience:<ul><li>Full proficiency using SQL, coding from scratch (or similar)</li><li>Experience with large-scale A/B testing and familiar frameworks</li><li>Ideally experience with Adobe or Google Analytics</li><li>Experience with media measurement and LTV, Churn, Acquisition, ROI all desirable</li><li>Experience using Tableau or Similar</li></ul> THE BENEFITSThe successful Analytics Manager will receive a salary between £55,000 and £60,000 as well as a comprehensive benefits package. HOW TO APPLY:Please register your interest by sending your CV to Dylan Butcher via the Apply link on this page. Desired Skills and Experience THE ROLE As a Analytics Manager, you can expect to be leading a team whilst analysing and interpreting results of both testing and optimisation experiments in a statistical and scientifically sound manor. In specific, you can expect to be involved in the following: Identification of opportunities to increase revenue through channel optimisation across SEO, Push, Paid Media, CRM, and more Analysis and interpretation of testing results and optimisation experiments (incl. a/b testing) Analysis of marketing communications for the purpose of generating insights and testable hypotheses Defining segmentations Tracking and improvisation of marketing measurement across LTV, Acquisition, Churn and more Visualisation of data using tools such as Looker or Tableau YOUR SKILLS AND EXPERIENCE The successful Analytics Manager will have the following skills and experience: Full proficiency using SQL, coding from scratch (or similar) Experience with large-scale A/B testing and familiar frameworks Ideally experience with Adobe or Google Analytics Experience with media measurement and LTV, Churn, Acquisition, ROI all desirable Experience using Tableau or Similar THE BENEFITS The successful Analytics Manager will receive a salary between £55,000 and £60,000 as well as a comprehensive benefits package. HOW TO APPLY: Please register your interest by sending your CV to Dylan Butcher via the Apply link on this page.

DIGITAL PRODUCT MANAGERUP TO £55,000HYBRID – LONDON – 2 days a week in the office THE COMPANYThis digital marketing agency work with some huge clients globally, and they are now looking to expand their business solutions and product teams! THE ROLEAs a Digital Product Manager, you can expect to be involved in the following:<ul><li>Working very closely with clients, taking briefs, suggesting solutions, and coming up with the strategy roadmap</li><li>Collaborating with Data, research, and content teams internally on delivery of solutions</li><li>Taking a strategic approach to client work</li><li>Hep clients to achieve their goals from a digital perspective</li></ul>YOUR SKILLS AND EXPERIENCE<ul><li>Experience working agency side in a Product role is required</li><li>Understanding of Digital Marketing is ideal</li><li>Strong experience working closely with clients is needed</li><li>Internal stakeholder management experience will support your application</li></ul>BENEFITS<ul><li>Salary up to £55,000</li><li>Opportunity to work in a top digital agency</li><li>Hybrid working</li></ul>How to applyExpress your interest in this opportunity by sending your CV to Theo via the apply link on this page

Harnham Interview Questions

Overview

Harnham Interview Guides

Harnham Interview Questions

Harnham Salaries by Position

Harnham Opening Jobs