Prepare for and practice interview questions from Made tech.

Made tech Interview Questions

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

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

Made tech Salaries by Position

Salary: £85,000 to £100,000 depending on experienceLocation: Hybrid working in either Swansea, Bristol, Manchester, London. Are you a skilled Data Engineer who can deliver Data Platforms?Are you familiar of working on agile delivery-led projects? Data Engineers at Made Tech help build data platforms to enable predictive government services that make a positive impact on the people in the UK. So, if you are looking to be part of this mission, we would love to hear from you. Support in applyingIf you need this job description in another format, or other support in applying, please email talent@madetech.com. We believe we can use tech to make public services better. We also believe this can happen best when our own team represents the society that actually uses the services we work on. We’re collectively continuing to grow a culture that is happy, healthy, safe and inspiring for people of all backgrounds and experiences, so we encourage people from underrepresented groups to apply for roles with us. When you apply, we’ll put you in touch with a talent partner who can help with any needs or adjustments we may need to make to help with your application. This includes alternative formats for documents, the time allotted for interviews and any other needs. We also welcome any feedback on how we can improve the experience for future candidates. As a Lead Data Engineer or architect at Made Tech, you'll play a pivotal role in helping public sector organisations become truly data-lead, by equipping them with robust data platforms. You'll also join a data team on its mission to get data knowledge and skills out of silos and embedded into delivery teams. You'll also help implement efficient data pipelines & storage. Your role at Made Tech<ul><li>Define, shape and perfect data strategies in central and local government.</li><li>Help public sector teams understand the value of their data, and make the most of it.</li><li>Establish yourself as a trusted advisor in data driven approaches using public cloud services like AWS, Azure and GCP.</li><li>As employee growth is a huge focus here, we would expect you to contribute to our recruitment efforts and take on line management responsibilities.</li></ul> What skills and experience are we looking for?We are looking for candidates with a range of skills and experience, please apply even if you don’t meet all the criteria as if unsuccessful we can provide you with feedback.<ul><li>Proficiency in Git (inc. Github Actions) and able to explain the benefits of different branch strategies.</li><li>Strong experience in IaC and able to guide how one could deploy infrastructure into different environments.</li><li>Knowledge of handling and transforming various data types (JSON, CSV, etc) with Apache Spark, Databricks or Hadoop.</li><li>Good understanding of possible architectures involved in modern data system design (Data Warehouse, Data Lakes, Data Meshes)</li><li>Ability to create data pipelines on a cloud environment and integrate error handling within these pipelines.</li><li>You understand how to create reusable libraries to encourage uniformity or approach across multiple data pipelines.</li><li>Able to document and present end-to-end diagrams to explain a data processing system on a cloud environment.</li><li>Some knowledge of how you would present diagrams (C4, UML, etc.)</li><li>Enthusiasm for learning and self-development.</li><li>You have experience of working on agile delivery-lead projects and can apply agile practices such as Scrum, XP, Kanban.</li><li>Can own the cloud infrastructure underpinning data systems through a DevOps approach.</li><li>Design and implement efficient data transformation processes at scale, both in batch and streaming use cases.</li><li>You are a skilled Data Engineer who has delivered data platforms.</li><li>Knowledge of SOLID, DRY and TDD principles and how to practically implement these into a project.</li><li>You can demonstrate a commercial mindset when on projects to grow accounts organically with senior stakeholders.</li><li>You have the experience to improve resilience into a project by checking for software vulnerabilities and implement appropriate testing strategies (unit integration, data quality, etc)</li><li>You are skilled at offering guidance on how one would implement a robust DevOps approach in a data project.</li><li>You can comfortably talk about tools needed such as DataOps in areas such as orchestration, data integration and data analytics.</li></ul> Desirable experienceExperience in the following things isn’t essential, but it’s highly desirable!<ul><li>Working at a technology consultancy</li><li>Working with Docker and virtual environments as part of the development and CI/CD process.</li><li>Working with senior stakeholders to gather requirements and keep them engaged with</li><li>Experience in working with a team of engineers using a variety of techniques such as pair programming or mob programming.</li><li>Working with data scientists to productionise advanced data deliverables, such as machine learning models</li><li>Working knowledge of statistics</li><li>Working with multidisciplinary digital and technology teams</li><li>Working within the public sector</li><li>Working with data scientists to productionise advanced data deliverables, such as machine learning models</li></ul> Life at Made TechWe’re committed to building a happy, inclusive and diverse workforce. You can get a sense of what it’s like working here from <a>our blog, where we talk about mental health, communities of practice and neurodiversity</a> (as well as our client work and best practice).Like many organisations, we use Slack to chat to each other. The Slack groups that have formed give an idea of the diversity within Made Tech. If you’d like to speak to someone from one of these groups about their experience as an employee, let your recruitment agent or Made Tech Talent Partner know.The groups are:<ul><li>antiracist-activists</li><li>disability</li><li>lgbtqiaplus-allies-and-activists</li><li>neurodiversity</li><li>parents-carers</li><li>women-in-tech</li></ul>BenefitsWe are always listening to our growing teams and evolving the benefits available to our people. As we scale, as do our benefits and we are scaling quickly. We've recently introduced a flexible benefit platform which includes a Smart Tech scheme, Cycle to work scheme, and an individual benefits allowance which you can invest in a Health care cash plan or Pension plan. We’re also big on connection and have an optional social and wellbeing calendar of events for all employees to join should they choose to.Here are some of our most popular benefits listed below:✈️ <a>30 days Holiday</a> - we offer 30 days of paid annual leave????️ <a>Flexible Working Hours</a> - we are flexible with what hours you work???? <a>Flexible Parental Leave</a> - we offer flexible parental leave options????‍???? <a>Remote Working</a> - we offer part time remote working for all our staff???? <a>Paid counselling</a> - we offer paid counselling as well as financial and legal advice. An increasing number of our customers are specifying a minimum of SC (security check) clearance in order to work on their projects. As a result, we're looking for all successful candidates for this role to have eligibility.Eligibility for SC requires 5 years' UK residency and 5 year' employment history (or back to full-time education). Please note that if at any point during the interview process it is apparent that you may not be eligible for SC, we won't be able to progress your application and we will contact you to let you know why.

Salary range is £49,500 - £85,000 depending on experienceLocation: Hybrid working in either Bristol, Manchester, London or Swansea. Support in applyingIf you need this job description in another format, or other support in applying, please email talent@madetech.com. We believe we can use tech to make public services better. We also believe this can happen best when our own team represents the society that actually uses the services we work on. We’re collectively continuing to grow a culture that is happy, healthy, safe and inspiring for people of all backgrounds and experiences, so we encourage people from underrepresented groups to apply for roles with us. When you apply, we’ll put you in touch with a talent partner who can help with any needs or adjustments we may need to make to help with your application. This includes alternative formats for documents, the time allotted for interviews and any other needs. We also welcome any feedback on how we can improve the experience for future candidates. Your role at Made TechAt Made Tech we want to positively impact the future of the country by using technology to improve society, for everyone. We want to empower the public sector to deliver and continuously improve digital services that are user-centric, data-driven and freed from legacy technology. A key component of this is developing modern data systems and platforms that drive informed decision-making for our clients. You will also work closely with clients to help shape their data strategy. Our Senior Data Engineers enable public sector organisations to embrace a data-driven approach by providing data platforms and services that are high-quality, cost-efficient, and tailored to clients’ needs. They develop, operate, and maintain these services. They make sure they provide maximum value to data consumers, including analysts, scientists, and business stakeholders. As a Senior Data Engineer, you may play one or more roles according to our clients' needs. The role is very hands-on and you'll support as a senior contributor role for a project, focusing on both delivering engineering work as well as upskilling members of the client team. At other points, you might play more of a technical architect role and work with the larger MadeTech team to identify growth opportunities within the account. You’ll need to have a drive to deliver outcomes for users. You’ll make sure that the wider context of a delivery is considered and maintain alignment between the operational and analytical aspects of the engineering solution. What skills and experience are we looking for?We are looking for candidates with a range of skills and experience, please apply even if you don’t meet all the criteria as if unsuccessful we can provide you with feedback.<ul><li>Enthusiasm for learning and self-development</li><li>Proficiency in Git (inc. Github Actions) and able to explain the benefits of different branch strategies</li><li>Gathering and meeting the requirements of both clients and users on a data project</li><li>Strong experience in IaC and able to guide how one could deploy infrastructure into different environments</li><li>Owning the cloud infrastructure underpinning data systems through a DevOps approach</li><li>Knowledge of handling and transforming various data types (JSON, CSV, etc) with Apache Spark, Databricks or Hadoop</li><li>Good understanding of the possible architectures involved in modern data system design (e.g. Data Warehouse, Data Lakes and Data Meshes) and the different use cases for them</li><li>Ability to create data pipelines on a cloud environment and integrate error handling within these pipelines. With an understanding how to create reusable libraries to encourage uniformity of approach across multiple data pipelines.</li><li>Able to document and present an end-to-end diagram to explain a data processing system on a cloud environment, with some knowledge of how you would present diagrams (C4, UML etc.)</li><li>To provide guidance how one would implement a robust DevOps approach in a data project. Also would be able to talk about tools needed for DataOps in areas such as orchestration, data integration and data analytics.</li><li>Experience in improving resilience into a project by checking for software vulnerabilities and implement appropriate testing strategies (unit, integration, data quality etc.)</li><li>Knowledge of SOLID, DRY and TDD principles and how to practically implement these into a project.</li><li>Agile practices such as Scrum, XP, and/or Kanban</li><li>Designing and implementing efficient data transformation processes at scale, both in batch and streaming use cases</li><li>Owning the cloud infrastructure underpinning data systems through a DevOps approach</li><li>Agile practices such as Scrum, XP, and/or Kanban</li><li>People skills such as mentoring, supportive team player and performing line management duties</li><li>To be able to demonstrate a commercial mindset when on projects to grow accounts organically with senior stakeholders</li></ul> Desirable experienceExperience in the following things isn’t essential, but it’s highly desirable!<ul><li>Working at a technology consultancy</li><li>Working with Docker and virtual environments as part of the development and CI/CD process.</li><li>Working with senior stakeholders to gather requirements and keep them engaged with</li><li>Experience in working with a team of engineers using a variety of techniques such as pair programming or mob programming.</li><li>Working with data scientists to productionise advanced data deliverables, such as machine learning models</li><li>Working knowledge of statistics</li><li>Working with multidisciplinary digital and technology teams</li><li>Working within the public sector</li></ul> Life at Made TechWe’re committed to building a happy, inclusive and diverse workforce. You can get a sense of what it’s like working here from <a>our blog, where we talk about mental health, communities of practice and neurodiversity</a> (as well as our client work and best practice).Like many organisations, we use Slack to chat to each other. The Slack groups that have formed give an idea of the diversity within Made Tech. If you’d like to speak to someone from one of these groups about their experience as an employee, let your recruitment agent or Made Tech Talent Partner know.The groups are:<ul><li>antiracist-activists</li><li>disability</li><li>lgbtqiaplus-allies-and-activists</li><li>neurodiversity</li><li>parents-carers</li><li>women-in-tech</li></ul> BenefitsWe are always listening to our growing teams and evolving the benefits available to our people. As we scale, as do our benefits and we are scaling quickly. We've recently introduced a flexible benefit platform which includes a Smart Tech scheme, Cycle to work scheme, and an individual benefits allowance which you can invest in a Health care cash plan or Pension plan. We’re also big on connection and have an optional social and wellbeing calendar of events for all employees to join should they choose to.Here are some of our most popular benefits listed below:✈️ <a>30 days Holiday</a> - we offer 30 days of paid annual leave????️ <a>Flexible Working Hours</a> - we are flexible with what hours you work???? <a>Flexible Parental Leave</a> - we offer flexible parental leave options????‍???? <a>Remote Working</a> - we offer part time remote working for all our staff???? <a>Paid counselling</a> - we offer paid counselling as well as financial and legal advice. An increasing number of our customers are specifying a minimum of SC (security check) clearance in order to work on their projects. As a result, we're looking for all successful candidates for this role to have eligibility. Eligibility for SC requires 5 years' UK residency and 5 year' employment history (or back to full-time education). Please note that if at any point during the interview process it is apparent that you may not be eligible for SC, we won't be able to progress your application and we will contact you to let you know why.

Made tech Interview Questions

Made tech Interview Guides

Made tech Interview Questions

Made tech Salaries by Position

Made tech Opening Jobs