Analytics Engineer Team Leader

hace 3 semanas


Madrid provincia, España M-KOPA A tiempo completo

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


  • Data Engineer

    hace 3 semanas


    Madrid, España Serem A tiempo completo

    Data engineer - Team leader en Madrid. En serem estamos comprometidos con diversos proyectos y queremos contar con los mejores profesionales del sector. Actualmente nos encontramos en la búsqueda de un/a Data engineer - Team Leader para trabajar para importante cliente en modo híbrido con un 50 de teletrabajo. **Requisitos**: Formación superior en IT Al...


  • Madrid, España Semrush A tiempo completo

    Data Governance Engineer (Analytics Infrastructure Team) Analytics location_on Remote: SpainHi there!We are Semrush, a global IT company developing our own product – a platform for digital marketers. New stars are born here, so don't miss your chance.This is our Data Governance Engineer role for those who want to turn ideas into reality and participate in...

  • Data Governance Engineer

    hace 3 semanas


    Madrid, España Semrush A tiempo completo

    Data Governance Engineer (Analytics Infrastructure Team) Analytics location_on Remote: SpainHi there!We are Semrush, a global IT company developing our own product – a platform for digital marketers. New stars are born here, so don't miss your chance.This is our Data Governance Engineer role for those who want to turn ideas into reality and participate in...


  • Madrid, Madrid, España Stratesys Group A tiempo completo

    Tras más de 25 años ejecutando más de 1500 proyectos y desarrollando soluciones tecnológicas de negocio, Stratesys se ha convertido en una multinacional líder en servicios digitales y una de las mayores especialistas en tecnología SAP.Dentro de nuestro plan de crecimiento para la oficina de Madrid buscamos incorporar dos perfiles de Project Team Leader...

  • Team Leader Cobol

    hace 1 semana


    Tres Cantos, Madrid provincia, España The White Team A tiempo completo

    **Descripción del puesto** Desde el equipo de The Whiteam Consulting, estamos seleccionando un/a Team Leader para gestionar un equipo de 5 personas para un cliente del sector bancario, en modalidad presencial 2 días en Madrid y 3 días en remoto. Será imprescindible experiência en el puesto de más de 5 años en ; - Oz/OS, Microfocus - AS400, Linux,...


  • Madrid, España Semrush A tiempo completo

    Data Governance Engineer (Analytics Infrastructure Team)Analyticslocation_onRemote: SpainHi there!We are Semrush, a global IT company developing our own product – a platform for digital marketers. New stars are born here, so don't miss your chance.This is ourData Governance Engineerrole for those who want to turn ideas into reality and participate in...

  • Data Governance Engineer

    hace 3 semanas


    Madrid, España Semrush A tiempo completo

    Data Governance Engineer (Analytics Infrastructure Team)Analyticslocation_onRemote: SpainHi there!We are Semrush, a global IT company developing our own product – a platform for digital marketers. New stars are born here, so don't miss your chance.This is ourData Governance Engineerrole for those who want to turn ideas into reality and participate in...

  • Team Leader

    hace 1 semana


    Madrid, Madrid, España Employment Pro Limited A tiempo completo

    Buscar vagas de emprego e oportunidades de carreiraEncontramos23vagas para Vagas de emprego team-leadertiffosi-vora .Receba alerta de vagas em seu email. Registre-se agoraFunção: Team Leader CRMEmpresa: DellentTipo: Full-timeContrato: Contrato sem termoLocalidade: Lisboa, PortoFunção: ServiceDesk Team LeaderEmpresa: Noesis PortugalTipo:...


  • Madrid, España Employment Pro Limited A tiempo completo

    Buscar vagas de emprego e oportunidades de carreiraEncontramos 99 vagas para Vagas de emprego english-speaking-team-leader-for-b2b-sales-team. Receba alerta de vagas em seu email. Registre-se agora! Função: Architect Team LeaderEmpresa: Crossjoin SolutionsTipo: Full-timeContrato: Contrato sem termoLocalidade: Lisboa, SetúbalFunção: Team Leader...


  • Madrid, España Employment Pro Limited A tiempo completo

    Buscar vagas de emprego e oportunidades de carreiraEncontramos 99 vagas para Vagas de emprego english-speaking-team-leader-for-b2b-sales-team .Receba alerta de vagas em seu email. Registre-se agora!Função: Architect Team LeaderEmpresa: Crossjoin SolutionsTipo: Full-timeContrato: Contrato sem termoLocalidade: Lisboa, SetúbalFunção: Team Leader...

  • Team Leader

    hace 1 semana


    Madrid, Madrid, España Employment Pro Limited A tiempo completo

    Buscar vagas de emprego e oportunidades de carreiraEncontramos 23 vagas para Vagas de emprego team-leadertiffosi-vora. Receba alerta de vagas em seu email. Registre-se agora Função: Team Leader CRMEmpresa: DellentTipo: Full-timeContrato: Contrato sem termoLocalidade: Lisboa, PortoFunção: ServiceDesk Team LeaderEmpresa: Noesis PortugalTipo:...


  • Madrid, Madrid, España Employment Pro Limited A tiempo completo

    Buscar vagas de emprego e oportunidades de carreiraEncontramos 99 vagas para Vagas de emprego english-speaking-team-leader-for-b2b-sales-team . Receba alerta de vagas em seu email. Registre-se agora Função: Architect Team LeaderEmpresa: Crossjoin SolutionsTipo: Full-timeContrato: Contrato sem termoLocalidade: Lisboa, SetúbalFunção: Team Leader...


  • Madrid, España Semrush A tiempo completo

    Insights Analytics Team Lead (Analytics & Insights Team)Analyticslocation_onRemote: SpainHi there!We are Semrush, a global IT company developing our own product—a platform for digital marketers. New stars are born here, so don't miss your chance.This is ourInsights Analytics Team Leadrole for the Marketing division for those who want to turn ideas into...


  • Madrid, España Semrush A tiempo completo

    Insights Analytics Team Lead (Analytics & Insights Team)Analyticslocation_onRemote: SpainHi there!We are Semrush, a global IT company developing our own product—a platform for digital marketers. New stars are born here, so don't miss your chance.This is ourInsights Analytics Team Leadrole for the Marketing division for those who want to turn ideas into...


  • Madrid, España Semrush A tiempo completo

    Insights Analytics Team Lead (Analytics & Insights Team) Analytics location_on Remote: SpainHi there!We are Semrush, a global IT company developing our own product—a platform for digital marketers. New stars are born here, so don't miss your chance.This is our Insights Analytics Team Lead role for the Marketing division for those who want to turn ideas...


  • Madrid, España Semrush A tiempo completo

    Insights Analytics Team Lead (Analytics & Insights Team) Analytics location_on Remote: SpainHi there!We are Semrush, a global IT company developing our own product—a platform for digital marketers. New stars are born here, so don't miss your chance.This is our Insights Analytics Team Lead role for the Marketing division for those who want to turn ideas...


  • Madrid, Madrid, España Employment Pro Limited A tiempo completo

    Buscar vagas de emprego e oportunidades de carreiraEncontramos 99 vagas para Vagas de emprego english-speaking-team-leader-for-b2b-sales-team .Receba alerta de vagas em seu email. Registre-se agoraFunção: Architect Team LeaderEmpresa: Crossjoin SolutionsTipo: Full-timeContrato: Contrato sem termoLocalidade: Lisboa, SetúbalFunção: Team Leader CRMEmpresa:...

  • Team Leader

    hace 7 días


    Illes Balears provincia, España Page Personnel España A tiempo completo

    Coordinación del equipo - Supervisión de llamadas y trabajo diario del equipo - Gestión y reparto de cartera de clientes - Planificación de estrategias para el cumplimiento de objetivos - Control de la agenda y reuniones distribuidas a los diferentes directores - Reporte de visitas - Control de comisiones equipo - Control de registro horario...


  • Madrid, España Securitas Direct España S.A.U A tiempo completo

    ¿Tienes experiencia en Gestión de Proyectos?¿has trabajado con gran cantidad de datos?En Securitas Direct buscamos incorporar un/a Team Leader en el departamento de Performance Improvement dentro del área de People de Operaciones.Tu misión como Team Leader será la gestión de Speech Analytics, participará en nuevos proyectos y realizará un trabajo...


  • Madrid, España Securitas Direct España S.A.U A tiempo completo

    ¿Tienes experiencia en Gestión de Proyectos?¿has trabajado con gran cantidad de datos?En Securitas Direct buscamos incorporar un/a Team Leader en el departamento de Performance Improvement dentro del área de People de Operaciones.Tu misión como Team Leader será la gestión de Speech Analytics, participará en nuevos proyectos y realizará un trabajo...