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

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?

Harnham Salaries by Position

Senior Product Manager, Data & AnalyticsVery successful Private Equity firmAtlanta, GA - onsite 5 days per week$180,000 to $220,000 base salary We have been exclusively retained to search for a super unique role with a leading private equity firm focused on investing in consumer and multi-unit businesses. With a portfolio which includes some very iconic brands, this company are a huge player in this space.... About the RoleAs a Senior Product Manager, you will play a pivotal role in shaping their data & analytics strategy. You will lead the development and implementation of data products and solutions that drive strategic decision-making and operational efficiency across their portfolios. Key Responsibilities:<ul><li>Product Strategy: Develop and execute a product vision and strategy for data and analytics products.</li><li>Product Management: Manage the entire product lifecycle, from ideation and requirements gathering to launch and ongoing support.</li><li>Stakeholder Management: Collaborate closely with business stakeholders, data scientists, and engineers to understand their needs and translate them into product requirements.</li><li>Technical Proficiency: Possess a strong understanding of data engineering, data science, and machine learning concepts.</li><li>Data Governance: Establish and enforce data governance standards and policies.</li><li>Team Leadership: Mentor and guide a team of product managers and analysts.</li></ul> Skills needed to be successful in the role<ul><li>Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field</li><li>8+ years of experience in product management, preferably all of that within data and analytics</li><li>Strong technical skills, including Python, SQL, and other relevant tools</li><li>Experience with data warehousing, data modeling, and data visualization</li><li>Excellent communication and presentation skills</li><li>Ability to manage multiple projects and prioritize effectively</li></ul> Candidates must be authorized to work in the US for consideration. This client unfortunately can't sponsor visas. **An advert never does a role justice so if you're not sure, feel free to apply and one of our consultants will give you a call to give you a more detailed overview!**

Data Engineer1 Year ContractHybrid (2 Days Onsite)$75-85/hr We are partnered with a leading beauty retailer, delivering innovative and personalized beauty experiences to their customers. We are looking for a highly skilled Data Engineer to join the team and help enhance our data platforms and analytics capabilities. You will work with cutting-edge technologies to process large volumes of data, integrate machine learning models, and build scalable data pipelines that will power our e-commerce platforms and improve customer experiences. Role Overview As a data engineer, you will play a key role in shaping and implementing our data strategy. You will be responsible for leading the development and deployment of data processing pipelines, driving machine learning model integration, and ensuring high-quality, scalable, and reliable data platforms. Key Responsibilities<ul><li>Drive the design, implementation, and optimization of data pipelines for heavy-volume data processing, including ETL workflows using Spark and Python.</li><li>Build and enhance large-scale data platforms, data lakes, and data warehouses using technologies like Databricks and Delta Lake.</li><li>Oversee the integration of machine learning models into production systems. Work through all phases of model development, including data preprocessing, feature engineering, and model deployment.</li><li>Ensure near-real-time, batch, and real-time data pipelines are efficient, accurate, and meet the required performance metrics.</li><li>Work hands-on with deep learning frameworks such as PyTorch, TensorFlow, and Keras to integrate ML models in a production environment.</li></ul> Required Skills and Experience<ul><li>8-10 years of experience in data engineering, data processing, data platforms, or equivalent.</li><li>Strong proficiency in Python and Spark (5+ years of hands-on experience) for building scalable ETL workflows and data pipelines.</li><li>Hands-on experience in ETL workflows using Spark and Python.</li><li>Designing and implementing large-scale data processing pipelines for batch and real-time data flows.</li><li>Building and deploying ML models in a production environment, with expertise in data preprocessing, feature engineering, and model engineering.</li><li>Experience with Databricks or similar data platforms for managing and processing large-scale data workflows.</li></ul>

Senior Data Product Manager Atlanta, GA (5 days onsite) $150,000 - $175,000 base + guaranteed bonusPlay a pivotal role in developing and managing cutting-edge data products that drive investment decisions and external insights for one of the leading private equity firms in the country. This position is ideal for a data-oriented product manager with strong technical skills and a passion for leveraging data to solve complex business problems.You will need experience applying the product management discipline to data products e.g. understanding customer goals, evaluating effectiveness of the product in enabling them to achieve those, creating a roadmap to mature the product etc.THE COMPANYA leading private equity firm known for its collaborative and inclusive culture, committed to building innovative solutions that drive business success.THE ROLEAs Senior Data Product Manager, you will lead the development of data-driven products that support investment decisions and provide strategic analytics to portfolio companies.<ul><li>Manage the lifecycle of data products-from gathering business requirements, setting product roadmap, to working with data scientists and engineers to deliver solutions, to overseeing product rollout and post-launch support</li><li>Develop internal data products that enhance productivity and provide actionable insights for the deal teams and leadership to achieve their goals</li><li>Collaborate with stakeholders to ensure alignment on product goals and timelines while balancing technical depth with business strategy.</li><li>Drive technical decision-making in close collaboration with the engineering team, ensuring data products are scalable, efficient, and deliver high-impact analytics.</li><li>Navigate datasets using SQL and support the integration of advanced analytics tools, with a focus on driving productivity through actionable insights.</li></ul>This is an individual contributor role with a potential for growth as the team expands, and it requires someone who thrives in a fast-paced, entrepreneurial environment.YOUR EXPERIENCE<ul><li>8-12 years of product management experience with a focus on data products and analytics solutions</li><li>Excellent analytical skills and ability to use data to solve problems</li><li>Strong technical foundation, particularly in SQL, with familiarity in Python being a plus</li><li>Proven ability to take business requirements and translate them into technical product specifications</li><li>Experience in managing the development and delivery of data-driven solutions that meet business needs</li><li>Ability to collaborate across diverse teams including data scientists, engineers, and executives to deliver high-impact data products</li><li>Experience managing product lifecycles from ideation to delivery in a fast-paced, deadline-driven environment</li><li>Scrappy, entrepreneurial mindset with the ability to quickly adapt and prioritize in a dynamic environment</li></ul>BENEFITS<ul><li>$150,000 - $175,000 base (flexible for top performers)</li><li>Guaranteed annual bonus</li><li>Daily breakfast and lunch, with dinner provided when working late</li><li>Access to office perks, including a golf simulator and speakeasy</li><li>Comprehensive benefits package including health insurance and 401(k) match</li></ul>

Hello, do you want to be a part of a team that strives everyday to perform at their very best? Are you interested in automotive industry, resorts and other fast growing markets. We are looking for someone who has solid business or data analyst experience and can provide insight on how we can become more profitable. Provide clear and concise insight as to why you make a business recommendation. Communication is everything in this role!Day to day responsibilities <ul><li>Make sense of large and complex data</li><li>Provide business insight and present to stakeholders </li><li>Performs data analysis on different data sources, consolidating multiple data sets and analysing the data accurately and efficiently.</li><li>Performs business process analysis to define how data and analytic solutions should be configured to meet those needs.</li><li>Collaborates with internal customers to ensure user requirements are complete and concise, confirming that changes and enhancements meet technical specifications and user requirements.</li></ul>Skills and Experience <ul><li>Comfort with SQL, Python, Power BI, Tableau and Excel </li><li>Proven track record as a business analyst, project manager or data scientist </li><li>Bachelors degree in applicable field </li><li>Present data and be clear, concise and convincing when giving insight or recommendations </li></ul>Benefits <ul><li>Hybrid work schedule with one day fully remote</li><li>Competitive salary, along with a bonus</li><li>Vehicle program </li><li>Work with a competitive and eager team</li></ul>

Staff Data ScientistUp to £120,000London (Hybrid/Remote) Company:This Software scale-up enables researchers across academia to collect high-quality human-powered data at scale enabling. They are utilising the latest advancements across Gen AI and LLMs to make it quicker and easier to secure data from a diverse global community. Responsibilities:<ul><li>Lead the conceptualization and planning of data science initiatives that align with and drive key business objectives.</li><li>Spearhead the development and implementation of sophisticated data models and algorithms, diving into hands-on coding for the most critical components</li><li>Guide the technical direction of the team through thoughtful code reviews and targeted mentorship, fostering a culture of excellence and continuous improvement.</li><li>Collaborate closely with product managers to identify opportunities where data science can drive product innovation and user value.</li><li>Partner with data engineers to enhance data pipelines, logging systems, and MLOps practices, creating a robust foundation for advanced analytics and modelling.</li></ul> Requirements:<ul><li>MSc or PhD Degree in Computer Science, Artificial Intelligence, Mathematics, Statistics or related fields.</li><li>Strong coding skills in Python and SQL</li><li>Strong communication skills, with the ability to work effectively in a fast-paced, collaborative environment.</li><li>Have a track record of successfully leading complex data science initiatives that deliver tangible business value.</li></ul> How to Apply:Please register your interest by sending your CV to Emily Burgess via the Apply link on this page. Keywords:Machine Learning, Data Science, Survey, Analytics, Search, Ranking, MLOps, Data Scientist, LLMs, Large Language Models

SENIOR DATA ENGINEER $120,000 - $160,000 + BENEFITS GREATER PHOENIX AREA (ONSITE 5 DAYS A WEEK) COMPANY OVERVIEW Join an innovative investment firm thats combining traditional financial research with cutting-edge machine learning to enhance decision-making. They're a dynamic team passionate about technology, data, and driving success through smart analytics. THE ROLE As a Data Engineer, youll be at the forefront of managing and optimizing the firms data architecture to support its machine learning pipelines and financial analysis. Youll take ownership of building and optimizing ETL pipelines, integrating new data sets, and ensuring high performance for both on-premise and cloud systems. In this high-impact, hands-on role, youll also partner on machine learning projects and ensure best practices in data governance and security. ROLE RESPONSIBILITIES <ul> <li>Database Management: Oversee database architecture, permissions, and security, ensuring systems are optimized and secure. </li><li>ETL Pipelines: Build and optimize ETL pipelines, integrating new data sets to support machine learning initiatives. </li><li>dbt & SQLmesh: Migrate existing processes to dbt and/or SQLmesh to modernize and streamline data transformations. </li><li>Change Data Capture (CDC): Implement and optimize CDC for high-priority tasks. </li><li>Data Governance: Ensure adherence to best practices in data governance and secure data access management. </li><li>Collaboration on ML Projects: Partner with other firms and internal teams on machine learning initiatives, adapting projects as needed. </li></ul> SKILLS & EXPERIENCE <ul> <li>3+ years of hands-on experience with Python and PostgreSQL. </li><li>Expertise in building and optimizing ETL pipelines. </li><li>Strong understanding of database architecture, performance tuning, and security best practices. </li><li>Proficiency with dbt, SQLmesh, or similar data transformation tools. </li><li>Experience with Change Data Capture (CDC) and/or NoSQL databases like Cassandra is a plus. </li><li>A background in finance or economics is a bonus but not required. </li></ul> BENEFITS <ul> <li>Competitive Salary: $130,000 - $160,000 base + comprehensive benefits package. </li><li>Professional Growth: Opportunities for advancement and participation in cutting-edge projects. </li><li>Collaborative Team: Join a passionate, innovation-driven environment. </li></ul> If you're ready to leverage your technical expertise in Python and PostgreSQL while contributing to machine learning advancements, wed love to hear from you!

MDM Product Manager - HR Data Santa Clara, CA Up to $230,000 + benefitsThis is an exciting opportunity to shape the HR data landscape within a pioneering healthcare technology company. You'll be joining a highly innovative team where your expertise in HR data governance and analytics will have a tangible impact on employee experience and data-driven HR strategies.As the Master Data Management Product Manager specializing in HR data, you'll be the bridge between HR, IT, and Analytics teams. You'll oversee the organization's Employee Master Data, ensuring data integrity, consistency, and regulatory compliance. With a keen focus on data governance, you will shape HR data models, maintain data accuracy across systems, and support advanced analytics projects that enhance the employee lifecycleKey Responsibilities:<ul><li>Data Ownership: Manage and maintain the integrity of the Employee Master Data, working closely with HR stakeholders and IT teams.</li><li>Data Governance: Develop and enforce data governance standards for employee data, ensuring compliance with privacy regulations across global regions.</li><li>Analytics & Reporting: Support the People Analytics function by designing a robust data model, powering HR analytics to enhance organizational insights.</li><li>Project Management: Lead HR data quality initiatives, partnering with cross-functional teams to ensure accurate data flows across multiple systems, including Workday, SAM, and more.</li><li>Stakeholder Collaboration: Work closely with IT, EA, and HR teams to align on HR strategic initiatives and manage the downstream integration of employee data.</li></ul>Experience & Skills:<ul><li>Core Expertise: 8+ years in MDM tools and technologies; strong background in data governance, HR analytics, and HRIS systems (preferably Workday).</li><li>Technical Skills: Experience with SQL, data modeling, data warehousing, and data cataloging; proficiency in analytics and visualization tools (Tableau, Power BI).</li><li>Soft Skills: Excellent communication and collaboration skills, with a proven ability to influence cross-functional stakeholders, including senior leadership.</li><li>Project Management: Skilled in leading cross-functional projects with a focus on data quality, security, and privacy.</li></ul>

SENIOR DATA ENGINEER $120,000 - $160,000 + BENEFITS GREATER PHOENIX AREA (ONSITE 5 DAYS A WEEK) COMPANY OVERVIEWJoin an innovative investment firm that’s combining traditional financial research with cutting-edge machine learning to enhance decision-making. They're a dynamic team passionate about technology, data, and driving success through smart analytics. THE ROLEAs a Data Engineer, you’ll be at the forefront of managing and optimizing the firm’s data architecture to support its machine learning pipelines and financial analysis. You’ll take ownership of building and optimizing ETL pipelines, integrating new data sets, and ensuring high performance for both on-premise and cloud systems. In this high-impact, hands-on role, you’ll also partner on machine learning projects and ensure best practices in data governance and security. ROLE RESPONSIBILITIES<ul><li>Database Management: Oversee database architecture, permissions, and security, ensuring systems are optimized and secure.</li><li>ETL Pipelines: Build and optimize ETL pipelines, integrating new data sets to support machine learning initiatives.</li><li>dbt & SQLmesh: Migrate existing processes to dbt and/or SQLmesh to modernize and streamline data transformations.</li><li>Change Data Capture (CDC): Implement and optimize CDC for high-priority tasks.</li><li>Data Governance: Ensure adherence to best practices in data governance and secure data access management.</li><li>Collaboration on ML Projects: Partner with other firms and internal teams on machine learning initiatives, adapting projects as needed.</li></ul> SKILLS & EXPERIENCE<ul><li>3+ years of hands-on experience with Python and PostgreSQL.</li><li>Expertise in building and optimizing ETL pipelines.</li><li>Strong understanding of database architecture, performance tuning, and security best practices.</li><li>Proficiency with dbt, SQLmesh, or similar data transformation tools.</li><li>Experience with Change Data Capture (CDC) and/or NoSQL databases like Cassandra is a plus.</li><li>A background in finance or economics is a bonus but not required.</li></ul> BENEFITS<ul><li>Competitive Salary: $130,000 - $160,000 base + comprehensive benefits package.</li><li>Professional Growth: Opportunities for advancement and participation in cutting-edge projects.</li><li>Collaborative Team: Join a passionate, innovation-driven environment.</li></ul> If you're ready to leverage your technical expertise in Python and PostgreSQL while contributing to machine learning advancements, we’d love to hear from you!

Paid Search Analyst Media/Advertising$80,000 to $95,000Remote EST Harnham is partnered with a boutique media company looking to hire a search engine marketing analyst to join its ever-growing digital analytics function. If you thrive in a fast-paced environment, this could be the role for you! THE ROLE:As the search engine marketing analyst, you will be responsible for<ul><li>Helping lead internal and external projects with a primary focus on building out reports on a 0-1 capacity.</li><li>Building a full-funnel SEM strategies utilizing Google Ads, Bing Ads, Search Ads 360, and YouTube.</li><li>Presenting insights derived from prior analytics work with a focus on digital media, SEM.</li><li>Engaging in face-to-face capacity with clients to achieve SEM goals.</li></ul> SKILLS & EXPERIENCE<ul><li>Bachelor's Degree required with a preference for computer science, business administration, or economics.</li><li>Prior experience working with an agency in the media or advertising domain.</li><li>Strong technical proficiency leveraging Google Ads, Bing Ads, Search Ads 360, and YouTube</li><li>Strong foundation in engaging and managing client accounts, with a primary focus on SEM</li><li>Proficient oral and communication abilities to present key findings through presentations to both internal and external stakeholders in a senior capacity.</li></ul> BENEFITS: Search Engine Marketing Analyst As a Search Engine Marketing Analyst you can expect to earn a salary of up to $95,000 with gold standard benefits. HOW TO APPLYPlease register your interest by sending your Resume to Sam Willman via the apply link on this page

Machine Learning EngineerAdTech Hybrid (Ann Arbor, Michigan) $175,000 - $205,000 USD/yr + bonus Harnham is partnering with an ad technology firm that provides services to help advertisers to optimize their ad campaigns. Their tools are used to help maximize engagement and conversion of ads.This firm is looking for a Machine Learning Engineer to join their Data Science team. This role is critical for developing and implementing advanced machine learning models that operate at scale in a high-performance, data-driven environment.If you thrive in complex, data-driven settings and are eager to contribute to the development of innovative machine learning solutions that solve real-world business challenge. This role could be for you. THE ROLEThe Machine Learning Engineer will work closely with cross-functional teams of data scientists, engineers, and business stakeholders to deliver ML solutions that address complex, high-impact challenges. This position requires expertise in deploying models, using AWS, GCP, or Azure. This role requires experience with for high-throughput and low-latency settings. RESPONSIBILITIES<ul><li>Collaborate on designing and implementing machine learning models to tackle complex business needs in areas like recommendation systems, predictive analytics, and natural language processing.</li><li>Deploy models into cloud environments (AWS, GCP, Azure) and manage the pipeline using Docker and Kubernetes. </li><li>Ensure models are production-ready, scalable, and reliable, working alongside engineering teams to maintain performance standards.</li><li>Monitor model efficacy in live environments, troubleshooting and optimizing as needed.</li><li>Contribute to ongoing research efforts and stay abreast of advancements in machine learning to continuously improve capabilities.</li></ul> YOUR SKILLS AND EXPERIENCE<ul><li>5-7 years of experience in machine learning engineering, with proficiency in languages such as Python, SQL, or Java.</li><li>Proven expertise in end-to-end model development, including inception, deployment, and automated retraining of advanced models (e.g., Contextual Bandits, Deep Neural Networks).</li><li>Advanced degree (Master’s or Ph.D.) in Statistics, Computer Science, or a related field is preferred.</li><li>Experience with cloud platforms (AWS, GCP, or Azure), containerization (Docker, Kubernetes), and machine learning tools (Databricks, MLFlow, etc.).</li><li>Strong analytical and problem-solving skills, with the ability to communicate complex concepts to non-technical stakeholders.</li></ul> HOW TO APPLYFor those with a strong background in machine learning who are looking to make a significant impact within a fast-paced, collaborative environment, we encourage you to reach out for more details.Please register your interest by sending your resume to Virginia via the Apply link on this page. KEYWORDSMachine Learning | Model Deployment | Recommendation | NLP | Contextual Bandit | Deep Neural Networks | Python | SQL | AWS | GCP | Azure | Docker | Kubernetes | MLflow | Kubeflow | TensorFlow | Pytorch

Harnham Interview Questions

Overview

Harnham Interview Guides

Harnham Interview Questions

Harnham Salaries by Position

Harnham Opening Jobs