Analytics Engineer Team Leader

2 weeks ago

Cairo, Cairo, Egypt M-KOPA Full time

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


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

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

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.

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 2
Given 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.

M-KOPA is an equal opportunity and affirmative action employer committed to assembling a diverse, broadly trained staff. Women, minorities, and people with disabilities are strongly encouraged to apply.


M-KOPA explicitly prohibits the use of Forced or Child Labour and respects the rights of its employees to agree to terms and conditions of employment voluntarily, without coercion, and freely terminate their employment on appropriate notice.

M-KOPA shall ensure that its Employees are of legal working age and shall comply with local laws for youth employment or student work, such as internships or apprenticeships.

M-KOPA does not collect/charge any money as a pre-employment or post-employment requirement.

This means that we never ask for 'recruitment fees', 'processing fees', 'interview fees', or any other kind of money in exchange for offer letters or interviews at any time during the hiring process.

  • Team leader

    2 weeks ago

    Cairo, Cairo, Egypt Valeo Egypt Full time

    Responsibilities:We are leader on our businesses, and recognized as one of the largest global innovative companies.Management & CompetencyManage his team of engineers (yearly reviews, meetings, missions, objectives, timesheets)Define the necessary qualifications and training plan for his team with the support of his management Allocate his team staff in the...

  • Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Careem Full time

    Responsibilities: some of the general duties and responsibilities that make up the job description of most of them are shown in the example below: - Be in charge of running and managing the call center daily - Set targets for all other call center agents to meet up with - Schedule and organize shift patterns for other team members to ensure that customers...

  • Team Leader- Ths

    2 weeks ago

    Cairo, Cairo, Egypt Valeo Full time

    Valeo is a tech global company, designing breakthrough solutions to reinvent the mobility. We are an automotive supplier partner to automakers and new mobility actors worldwide. Our vision? Invent a greener and more secured mobility, thanks to solutions focusing on intuitive driving and reducing CO2 emissions. We are leader on our businesses, and recognized...

  • Software Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Valeo Full time

    Valeo is a tech global company, designing breakthrough solutions to reinvent the mobility. We are an automotive supplier partner to automakers and new mobility actors worldwide. Our vision? Invent a greener and more secured mobility, thanks to solutions focusing on intuitive driving and reducing CO2 emissions. We are leader on our businesses, and recognized...

  • Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Flyin Full time

    Create an inspiring team environment with an open communication culture.Set clear team goals.Delegate tasks and set deadlines.Oversee day-to-day operation.Monitor team performance and report on metrics.Motivate team members.Discover training needs and provide coaching.Listen to team members' feedback and resolve any issues or conflicts.Recognize high...

  • Senior Lead Quality Assurance Engineer

    2 weeks ago

    Cairo, Cairo, Egypt Clarivate Analytics Full time

    Develop and implement comprehensive QA strategies, methodologies, and processes tailored to the unique requirements of data products and services.Create and maintain test automation that is reusable, maintainable, and scalable.Conduct data profiling, validation, and cleansing activities to identify and address data quality issues, anomalies, and...

  • Sales Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Dubizzle MENA Full time

    Dubizzle Egypt is the leading marketplaces for selling and buying online in the region. Our aim is to upgrade people's lives by facilitating deals and identifying attractive opportunities for both individuals and businesses. Our goal is to strengthen local economies, empower small businesses, and help everyone in making smarter choices for themselves, the...

  • Content Localization Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Nagwa Full time

    Nagwa is searching for a localization team leader who will participate in localizing and shaping Nagwa's products across the globe. They will be responsible for managing and implementing localization for the content of Nagwa's products. The role requires the ability to work in an environment that is fast-paced and highly dynamic. What is needed to excel in...

  • Assistant Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Trinity College London Full time

    Contract: Permanent, full-timeLocation: Croydon/PortsmouthClosing date: 14 July 2023Our exams, assessments and publications are designed to help learners fulfil their own individual talents and abilities. Today we deliver over 850,000 assessments each year worldwide. Our international network is expanding quickly, and we now provide qualifications in more...

  • Sales Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Pins Full time

    1- Make a daily meeting with sales team members to discuss with them their yesterday visits, what they achieve and what is their today's plan. 2- Responsible about receiving visits feedback from sales team on daily basis and analyses them all to assure the credibility of their visits. 3- Collect data from sales team and send them all to telesales on a daily...

  • Real Estate Sales Team Leader

    4 weeks ago

    Cairo, Cairo, Egypt ARB Real Estate Solutions Full time

    " Role DescriptionThis is a full-time on-site role for a Sales Team Leader at ARB Real Estate Solutions in Qesm El Maadi. The Sales Team Leader will be responsible for training, mentoring, and managing a team of sales representatives, ensuring that sales targets are achieved, and developing and implementing sales strategies to improve revenue and market...

  • Real Estate Sales Team Leader

    1 month ago

    Cairo, Cairo, Egypt ARB Real Estate Solutions Full time

    " Role DescriptionThis is a full-time on-site role for a Sales Team Leader at ARB Real Estate Solutions in Qesm El Maadi. The Sales Team Leader will be responsible for training, mentoring, and managing a team of sales representatives, ensuring that sales targets are achieved, and developing and implementing sales strategies to improve revenue and market...

  • Category Leader

    4 days ago

    Cairo, Cairo, Egypt Amazon Full time

    Amazon strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. By giving customers more of what they want - low prices, vast selection, and convenience Amazon continues to grow and evolve as world class e commerce.The Category Lead will be responsible for every aspect of retailing...

  • Social Media Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Nok Human Capital Full time

    NOK is hiring a "Social Media Team leader" for a creative marketing agency located in Zahraa Elmaadi Job Responsibilities: 1) Monitor multiple client accounts across Facebook, Instagram, Twitter, TikTok, LinkedIn and YouTube public and direct messages for customer comments, feedback, queries, and complaints. 2) Engage with and respond to users within agreed...

  • Social Media Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Nok Human Capital Full time

    NOK is hiring a Social Media Team leader for a creative marketing agency located in Zahraa ElmaadiJob Responsibilities:1) Monitor multiple client accounts across Facebook Instagram Twitter TikTok LinkedIn and YouTube public and direct messages for customer comments feedback queries and complaints.2) Engage with and respond to users within agreed client SLA...

  • Business Intelligence Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Mondiamedia Full time

    An active member of a strong technical team, working closely with them to ensure proper delivery of system features Participate in designing of solutions using Mondia Media products Participate in development of new products and maintaining the existing solutions Help other team members with technical problems and decisions. Active involvement in the...

  • Team Leader

    2 weeks ago

    Cairo, Cairo, Egypt Majid Al Futtaim Full time

    Skill set (job specific technical skills and behavioural competencies needed) Characterized with: passion, energy, drive, trustworthiness, delivery, process orientation and people focus. Substantial ability to self motivate and start with great sense of leading multicultural teams.English language advanced verbal and written skills, Arabic desirable.Good...

  • Head of Data and Analytics

    2 weeks ago

    Cairo, Cairo, Egypt Khazna Full time

    About KhaznaKhazna was founded in 2019 with a mission to improve the financial well-being of the underbanked, who have little access to formal financial services by providing access to convenient, effective, and secure smartphone-based financial services. Khazna has received the Central Bank of Egypt's first prepaid card license and aims to become the go-to...

  • Head of Data and Analytics

    4 weeks ago

    Cairo, Cairo, Egypt Khazna Full time

    About KhaznaKhazna was founded in 2019 with a mission to improve the financial well-being of the underbanked, who have little access to formal financial services by providing access to convenient, effective, and secure smartphone-based financial services. Khazna has received the Central Bank of Egypt's first prepaid card license and aims to become the go-to...

  • Category Leader

    2 weeks ago

    Cairo, Cairo, Egypt Souq for E-Commerce LLC Full time

    10+ years' experience of leading a team. Strong experience in sales and vendor management. Strong business judgment with a track record of successful negotiations and overall relationship management. Proven analytical thinking, project management skills, and exceptional organizational skills are essential. Ability to think strategically and tactically, with...