Felix Vemmer Genannt Meier

• Planned, designed and created Priceloop's pricing and ELT pipeline with Prefect for orchestration and DBT for data transformation giving pricing recommendations for thousands of products in an efficient way

• Translated business and pricing logic into composable well documented Python functions to be used in pricing pipeline

• Implemented end to end flexible database schema design in PostgreSQL for Priceloop's pricing and ELT pipeline that adapts to rapidly changing requirements • Designed and started implementing a holistic data testing framework with DBT to help catch data quality issues before they impact customers' pricing decisions

• Designed and started an online database and table documentation with DBT to allow anyone to easily understand current data architecture, data types and columns

• Interviewed, onboarded, and mentored two new junior data engineers in the data engineering team

• Researched, tested, and recommended a data visualisation and dashboarding solution solution for the reporting layer in the Priceloop App

• Built a reporting layer and dashboards for clients with Looker to evaluate pricing decisions before setting prices live

• Analyse various customer operation datasets for strategic decision-making with SQL and pandas

• Define, analyse and publish Customer Operations KPIs via self-service dashboards in Metabase

• Automate processes and standard reporting with Google Apps Script and Python resulting in one full day of work being saved every week

• Analysed how banks can more effectively segment SME's to better tailor products and services to their needs and expectations by conducting qualitative research creating different customer personas and journey's