Analytics Engineer Team Leader

Are you looking for an opportunity to work in a company where progress and humility are valued as highly as technical excellence? At M-KOPA we use the latest technologies and architectures to build fantastic customer experiences with a socially and environmentally conscious mission that echoes throughout the organization.We are looking for a Senior Analytics Engineer with that managerial experience to join our Analytics department. This is a Senior Team Leading role reporting directly to the Head of Analytics.Team FocusedLeading a small 3 or 4 person team role focused on Dimensional Data modelling, Data Engineering, Business and Product Optimization, Cloud Platform Utilization and Data Management.Tools could include, SQL, Python, Power BI, Looker, Tableau, dbt, and airflow, all Cloud based.Your team will collaborate primarily with cross-functional product teams with some additional internal business units to gather requirements, understand business needs, and deliver data-driven recommendations.Often simplifying very complex and unstructured data into answers, testing hypotheses and delivering insights. This is a low ego creative environment where careers can thrive.BackgroundIf you have a background working in FinTech B2C environments where big data is leveraged for products and projects and you are comfortable building and managing large data sets then this might be the right place for you.Alternatively a background in consumer based high volume environments like, Travel, eCommerce, Delivery or Mobility could be useful.Work - Life BalanceThis is a remote role in a team that spans from the UK, through Europe to Africa. Work in a similar distributed environment would be ideal.At M-KOPA, we empower our people to own their careers through diverse development programs, coaching partnerships, and on-the-job training. We support individual journeys with family-friendly policies, prioritize well-being, and embrace flexibility.We are proud to have been recognised twice by the Financial Times as one Africa's fastest growing company (2022 and 2023) and by TIME100 Most influential companies in the world 2023 , we've served over 3 million customers, unlocking $1 billion in cumulative credit for the unbanked across Africa.Join us in shaping the future of M-KOPA as we grow together. Explore more at m-kopa.com.If the above is of interest to you, please apply.Optional Application TaskQuestion 1Imagine the following query being issued against a distributed analytics engine, such as Google Big Query or Redshift.SELECT sale_date, SUM(TotalAmount) / COUNT(DISTINCT salesperson_id) AS SalesPerPerson FROM sales GROUP BY sale_date[sales] table has one row for each product item sale transaction.What part of the query would cause the most data movement between the compute nodes?How would you optimize the query or data model to answer the same question with less data movement between compute nodes without loss of precision?Question 2Given the following Entity Relationship diagram describing a generic Shop selling products, please write a SQL query that answers the following question:“Which two Shops have the highest and the lowest productivity respectively in the last 28 days?”Shop productivity is measured by monetary value of sales divided by total salesperson work-hours in the same time period.Please submit the answers with your application.