.**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 Analytics Engineer with that managerial experience to join our Analytics department. _**Team Focused**:Working in 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.You 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.**Background**:If 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 Balance**:This 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 recognized 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.If the above is of interest to you, please apply.**Optional Application Task****Question 1**Imagine 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 #J-18808-Ljbffr