Analytics Engineer Team Leader

4 weeks ago

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.

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

  • 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

    1 month ago

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

  • Structural Team Leader

    1 month ago

    Cairo, Egypt Mimar egypt Full time

    We are seeking a highly motivated and experienced Structural Design Team leader to join our team. The successful candidate will lead a team of engineers and designers to deliver high-quality and cost-effective designs for a variety of structural projects. As the Structural Design Team leader, you will be responsible for overseeing the design process from...

  • Team Leader- Ths

    4 weeks ago

    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 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, Egypt IGT Solutions egypt Full time

    Team coordination in a contact center focused on delivering high quality support dedicated to leading international airlines, travel and/or tourism playersLead team(s) of up to 25 Contact Center representatives including SupervisorsEnsuring that the project assigned to you is functioning as per client expectations, meeting SLAsCoaching a group of agents and...

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

  • Senior Lead Quality Assurance Engineer

    4 weeks ago

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

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

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

  • Engineering Manager

    1 month ago

    Cairo, Egypt Unifonic Full time

    Proudly voted a Great Place to Work®, we are a dynamic startup in the SaaS space that is revolutionizing the way businesses communicate. Our team is made up of 500 energetic and passionate Unifones who are dedicated to delivering the best possible experience to 5000+ customer-centric companies. We pride ourselves on our fun and collaborative work...

  • Engineering Manager

    4 weeks ago

    Cairo, Egypt Unifonic Full time

    Proudly voted a Great Place to Work®, we are a dynamic startup in the SaaS space that is revolutionizing the way businesses communicate. Our team is made up of 500 energetic and passionate Unifones who are dedicated to delivering the best possible experience to 5000+ customer-centric companies. We pride ourselves on our fun and collaborative work...

  • Senior Analytics Engineer

    4 weeks ago

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

  • Delivery Team Leader Last Mile Team Leader

    1 month ago

    Cairo, Egypt Capiter Full time

    Job Description Accountable for orders Fulfillment.Responsible for Assigning the delivery agents on the orders run sheet.Responsible for Handling the delivery agents through the delivery process.Monitoring the delivery agents performance.Checking on ground the performance in the delivery areas.Responsible for daily reporting to his supervisorJob...

  • Delivery Team Leader Last Mile Team Leader

    4 weeks ago

    Cairo, Egypt Capiter Full time

    Job Description Accountable for orders Fulfillment.Responsible for Assigning the delivery agents on the orders run sheet.Responsible for Handling the delivery agents through the delivery process.Monitoring the delivery agents performance.Checking on ground the performance in the delivery areas.Responsible for daily reporting to his supervisorJob...

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