Rupert Arup

Data Team Lead at LendInvest
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
London, England, United Kingdom, UK
Languages
  • English Native or bilingual proficiency
  • French Native or bilingual proficiency
  • Spanish Limited working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United Kingdom
    • Financial Services
    • 100 - 200 Employee
    • Data Team Lead
      • Sep 2021 - Present

      Leading a team of engineers and BI developers in building a modern data platform at a growing fin-tech. Tools: Kafka, AWS Lambda, Terraform, Dagster, DBT, MySql, Python micro services, API gateway, AWS cloud management, GitHub actions, Liquibase, Docker. Responsibilities: Team roadmap, data architecture, data modelling and engineering

    • Senior BI Manager
      • Sep 2020 - Sep 2021

      Scrum master and data product lead

    • Business Intelligence Developer Manager
      • Apr 2019 - Sep 2020

      Developing the data architecture and managing the Business Intelligence to enable scalability and data autonomy at a fast growing fintech business. Our team is responsible for building all data pipelines from internal and external data sources into our AWS cluster where we clean and aggregate data for company-wide self serve reporting within our Data Warehouse. Using Git, Jenkins, CI, docker and k8s we have developed open source infrastructure with engineering best… Show more Developing the data architecture and managing the Business Intelligence to enable scalability and data autonomy at a fast growing fintech business. Our team is responsible for building all data pipelines from internal and external data sources into our AWS cluster where we clean and aggregate data for company-wide self serve reporting within our Data Warehouse. Using Git, Jenkins, CI, docker and k8s we have developed open source infrastructure with engineering best practices. Achievements: - Design, Implementation and delivery of searchable business data dictionary - Implementation of version controlled CICD on our data warehouse and source databases. - leading a team of BI analysts to deliver on business requirements Skills: Data warehousing & architecture, ETL, python, MySQL, MSSQL, tableau, gsheet scripting, API connectors, flask web apps, excel, GCP, docker, airflow, CICD, liquibase

    • Business Intelligence Developer
      • Jun 2017 - Apr 2019

      BI data analytics with a focus on automation of reporting and data delivery to the wider business. Skills acquired: - Python - Tableau. - MySQL, MSSQL. - Data warehouse development. - Git version control - Python libraries: Flask, pandas, numpy. - Google API and sheet scripting for task automation. - Google web analytics dashboards. - Segment event tracking.

    • Performance Marketing Analyst
      • Jun 2016 - Aug 2017

      Marketing performance: Working closely with the marketing team to assess all activity, provide actionable feedback to team leads and the ongoing management of digital marketing channels (ppc, sponsored content, re-marketing). Building tools to improve marketing spend tracking, cost per acquisition, budget control and ROI by channel to support marketing decisions based on real investor and borrower acquisition data. Skills: Data visualisations to aid with marketing, Google ads… Show more Marketing performance: Working closely with the marketing team to assess all activity, provide actionable feedback to team leads and the ongoing management of digital marketing channels (ppc, sponsored content, re-marketing). Building tools to improve marketing spend tracking, cost per acquisition, budget control and ROI by channel to support marketing decisions based on real investor and borrower acquisition data. Skills: Data visualisations to aid with marketing, Google ads management and scripting, Google analytics, re-marketing, Facebook ads, Google tag manager, Google sheets, campaign analysis Business intelligence: Analysis of our investor base to identify trends and produce KPIs to help management shape strategic product decisions. Skills: postgresSQL, MySQL, data manipulation, cohort analysis, advanced excel/Google sheets

    • Software Development
    • 700 & Above Employee
    • Client Solutions Manager - Ad Tech
      • Oct 2014 - Jun 2016

      Facebook's ad tech provides publishers off O&O Facebook a platform from which they can monetize their inventory on mobile apps, mobile web and desktop. On the advertiser side, the audience network, allows for people based marketing, leveraging facebook's targeting capabilities to deliver video advertising across AN's premium publisher network. Partner Account Manager Duties: - Integrating and supporting DSPs partners. - Providing technical support to clients - Support partner… Show more Facebook's ad tech provides publishers off O&O Facebook a platform from which they can monetize their inventory on mobile apps, mobile web and desktop. On the advertiser side, the audience network, allows for people based marketing, leveraging facebook's targeting capabilities to deliver video advertising across AN's premium publisher network. Partner Account Manager Duties: - Integrating and supporting DSPs partners. - Providing technical support to clients - Support partner campaign delivery - Manage FB targeted IO delivery for advertisers and agencies. Data Analytics, dashboards and visualisation: - Daily use of SQL to query data warehouses. - Creation of data pipelines to power custom dashboards. - Develop and maintain team target dashboards. Skills: Maintaining/Building strong partner relationships, writing SQL on Presto/Hive/mySQL, Tableau Visualization, FB internal data tools, oRTB, charles logging, VAST/VPAID XML debugging Show less Facebook's ad tech provides publishers off O&O Facebook a platform from which they can monetize their inventory on mobile apps, mobile web and desktop. On the advertiser side, the audience network, allows for people based marketing, leveraging facebook's targeting capabilities to deliver video advertising across AN's premium publisher network. Partner Account Manager Duties: - Integrating and supporting DSPs partners. - Providing technical support to clients - Support partner… Show more Facebook's ad tech provides publishers off O&O Facebook a platform from which they can monetize their inventory on mobile apps, mobile web and desktop. On the advertiser side, the audience network, allows for people based marketing, leveraging facebook's targeting capabilities to deliver video advertising across AN's premium publisher network. Partner Account Manager Duties: - Integrating and supporting DSPs partners. - Providing technical support to clients - Support partner campaign delivery - Manage FB targeted IO delivery for advertisers and agencies. Data Analytics, dashboards and visualisation: - Daily use of SQL to query data warehouses. - Creation of data pipelines to power custom dashboards. - Develop and maintain team target dashboards. Skills: Maintaining/Building strong partner relationships, writing SQL on Presto/Hive/mySQL, Tableau Visualization, FB internal data tools, oRTB, charles logging, VAST/VPAID XML debugging Show less

    • United Kingdom
    • Higher Education
    • 700 & Above Employee
    • Vice President
      • Apr 2013 - Jun 2014

      Ensuring the smooth operations of Exeter Snowsports, the largest student society at Exeter University. Responsibilities: - Administering club email, memberships and sponsorships. - Organize two trips to the alps - Sourcing and processing club orders Ensuring the smooth operations of Exeter Snowsports, the largest student society at Exeter University. Responsibilities: - Administering club email, memberships and sponsorships. - Organize two trips to the alps - Sourcing and processing club orders

    • Spain
    • Design Services
    • 1 - 100 Employee
    • Web Coordinator & Assistant Brand Strategist Intern
      • Apr 2013 - Aug 2013

      Intern at Flavio Kleijn Brand Agency in Barcelona Responsibilities: - Create online presence and launch new portfolio website. - Assist in strategic phase of brand creation for new clients; - Benchmarking presentations, Brand Key design for client use. Skills Gained: - Wordpress platform. - Understanding of core Branding Strategies used in practise. - Benchmarking analysis - Photoshop - Working in a predominantly Spanish speaking office improved langauge skills Intern at Flavio Kleijn Brand Agency in Barcelona Responsibilities: - Create online presence and launch new portfolio website. - Assist in strategic phase of brand creation for new clients; - Benchmarking presentations, Brand Key design for client use. Skills Gained: - Wordpress platform. - Understanding of core Branding Strategies used in practise. - Benchmarking analysis - Photoshop - Working in a predominantly Spanish speaking office improved langauge skills

Education

  • University of Exeter
    BSc Economics with European Study and Proficiency in Spanish, Economics
    2010 - 2014
  • Universitat Pompeu Fabra
    Business Economics, International Business
    2012 - 2013
  • The European School of Culham
    80%
    2001 - 2009

Community

You need to have a working account to view this content. Click here to join now