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

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.

  • Senior Testing Engineer

    3 months ago

    Cairo, Egypt vodafone Senior Testing Engineer Full time

    Interacts with the project team to gain an understanding of the business environment, technical context, and conformance criteria.Understands and uses appropriate automated testing processes and tools.Stays current on established tools, techniques, and technologies.Supports knowledge management and collaboration through participation in testing discussions,...

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

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

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

  • Portfolio Analytics

    2 months ago

    Cairo, Egypt PayTech Nexus Ltd Full time

    Term: 12 monthsExperience Requirement: 10 yearsJob location: Cairo EgyptProject scope: Portfolio AnalyticsLanguage requirements: English and Arabic fluencyRole:The Analytics SBOS will provide data analytics support for portfolio segmentation and analytics activities. The dedicated resource will perform the following activities:The Analytics SBOS will provide...

  • Portfolio Analytics

    4 weeks ago

    Cairo, Egypt PayTech Nexus Ltd Full time

    Term: 12 monthsExperience Requirement: 10 yearsJob location: Cairo EgyptProject scope: Portfolio AnalyticsLanguage requirements: English and Arabic fluencyRole:The Analytics SBOS will provide data analytics support for portfolio segmentation and analytics activities. The dedicated resource will perform the following activities:The Analytics SBOS will provide...

  • Senior Planning Engineer

    2 weeks ago

    Cairo, Cairo, Egypt ABEC Full time

    Company DescriptionEstablished in 1989, ABEC was restructured in 2020 to deliver innovative buildings efficiently and provide full integrated construction service. The company had a wide history of construction projects in various industries in the past, which now decided to take a different route focusing on specific types of buildings. Assist senior...

  • Analytics Manager-fintech

    3 months ago

    Cairo, Egypt MaxAB egypt Full time

    Responsibilities:Develop effective business intelligence strategies and analytics solutions.Oversee analytics projects to extract, manage, and analyze customer data from multiple applications, ensuring that deadlines are met.Apply statistics and data modeling to gain actionable business insights and boost customer productivity and revenue.Enforce company...

  • Senior Data Engineer

    3 months ago

    Cairo, Egypt Talent Pal Full time

    We are seeking a highly skilled and experienced Senior Data Engineer to join our team on a parttime basis. As a Senior Data Engineer you will be responsible for designing and developing data pipelines optimizing data collection and flow across various data sources and ensuring a consistent data delivery architecture throughout ongoing projects. Your...

  • Senior Manager, Software Engineering

    3 months ago

    Cairo, Egypt Procore Full time

    Procore is looking for a **Senior Manager, Software Engineering** to join Procore’s Construction Intelligence Org to maintain, optimize, and enhance the data pipeline that supports all user analytics. You’ll be responsible for the data pipeline’s end-to-end functionality, from the streaming service receiving the events from sources to the tools landing...

  • Senior Manager, Software Engineering

    3 weeks ago

    Cairo, Egypt Procore Full time

    Procore is looking for a **Senior Manager, Software Engineering** to join Procore’s Construction Intelligence Org to maintain, optimize, and enhance the data pipeline that supports all user analytics. You’ll be responsible for the data pipeline’s end-to-end functionality, from the streaming service receiving the events from sources to the tools landing...

  • Senior Software Test Automation Engineer

    4 weeks ago

    Cairo, Egypt Arrow Electronics, Inc. Full time

    **Position**: Senior Software Test Automation Engineer We are seeking a Senior Software Test Automation Engineer focusing on quality and expertise in Java and Selenium. This role is critical in enhancing our software test automation standards and practices. We are excited about the opportunity to welcome you to our team. REQUIRED QUALIFICATIONS: -...

  • Senior Backend Engineer, Python

    2 weeks ago

    Cairo, Egypt Invitro Capital Full time

    **Job Overview**: Invitro Capital is seeking a highly skilled and experienced Senior Backend Engineer with expertise in Python to join our team in Egypt. As a Senior Backend Engineer, you will be responsible for designing, developing, and maintaining robust and scalable backend systems for our portfolio companies. You will work closely with cross-functional...

  • Senior Data Engineer

    3 months ago

    Cairo, Egypt SIGMA Full time

    We are seeking a highly skilled and experienced Senior Data Engineer to join our team on a parttime basis. As a Senior Data Engineer you will be responsible for designing and developing data pipelines optimizing data collection and flow across various data sources and ensuring a consistent data delivery architecture throughout ongoing projects. Your...

  • Senior Data Engineer

    4 weeks ago

    Cairo, Egypt SIGMA Full time

    We are seeking a highly skilled and experienced Senior Data Engineer to join our team on a parttime basis. As a Senior Data Engineer you will be responsible for designing and developing data pipelines optimizing data collection and flow across various data sources and ensuring a consistent data delivery architecture throughout ongoing projects. Your...

  • Senior Software Engineer

    4 weeks ago

    Cairo, Egypt Procore Full time

    What if you could use your technology skills to develop a product that impacts the way communities’ hospitals, homes, sports stadiums, and schools across the world are built? Construction impacts the lives of nearly everyone in the world, and yet it’s also one of the world’s least digitized industries, not to mention one of the most dangerous. That’s...

  • Senior Backend Engineer, Python

    2 weeks ago

    Cairo, Cairo, Egypt Invitro Capital Full time

    Job Overview:Invitro Capital is seeking a highly skilled and experienced Senior Backend Engineer with expertise in Python to join our team in Egypt. As a Senior Backend Engineer, you will be responsible for designing, developing, and maintaining robust and scalable backend systems for our portfolio companies. You will work closely with cross-functional teams...