Learn more

Yuriy Trofymenko

Analytics Engineer with background in Marketing, Operations and Finance
Berlin, Berlin
|

linkedin.com/in/yuriy-trofymenko
|

github.com/YuriyTrofymenko
|

yuriytrofymenko@gmail.com
|

+491751242834
Experienced analytics engineer and marketer with more than 7 years of experience. I have large experience in both the startup environment, large corporate setting and different business topics
Y
T

Work Experience

Trade Republic

Analytics Engineer
|

Mar 2024 - Current
  • Refactoring and owning complex lineages with 100+ models and numeruous contributors
  • Delivering stable and accurate reporting that is being cross-checked perpetually by dozens of stakeholders
  • Leading analysts and operations specialists on refactoring and setting up their reporting
  • Creating complex metrics around processes and internal tools
  • Directing and participating in ingestion of internal tools’ data through Kafka and DMS with infrastructure and data engineering team
  • Conducting complex cross-team investigation on various topics(e.g. securities or taxation)

Humanoo

Analytics Engineer
|

Jan 2024 - Feb 2024
  • Restructuring data pipeliens for more scalable reporting
  • Reingesting events data

FINN GmbH

Analytics Engineer
|

Jul 2022 - Current
  • Created dashboards for securitization and investor reporting in Looker
  • Created models in DBT to be used in Looker
  • Suggested and participated in data warehouse restructuring that led to a huge increase in reusability and reliability of the data

Snap Inc.(Fit Analtyics Acquisition)

Data Analyst
|

May 2021 - Current

Snap Inc. acquired Fit Analytics

  • Building explores and dashboards in Looker
  • Providing ad hoc reports on large data sets with BigQuery
  • Data modelling, data warehouse restructuring
  • Working on internal data processing tasks

Fit Analytics GmbH

Data Analyst - Marketing Insights
|

Aug 2020 - Apr 2021
  • Preparing service reports for big fashion retail brands
  • Providing data for marketing materials
  • Automating billing process with GAS
  • Working with HubSpot API to create objects
  • Managing team sprints and quarterly planning

Taxfix GmbH

Junior Marketing Data Analyst
|

Apr 2020 - May 2020
  • Creating dashboards with Python, Metabase and Looker
  • Research on the optimal data stack and alternatives to the current one
  • Assisting on data related topics for brand team

Taxfix GmbH

Marketing Analytics Working Student
|

Dec 2019 - Mar 2020

Taxfix is providing digital experience around submitting tax refund declarations

  • Managed an urgent project of creating a website for social initiaves
  • Provided various marketing reports and analyses
  • Reviewed Google Marketing Platform Setup

Fineway GmbH

Marketing and Data Science Working Student
|

Dec 2018 - Oct 2019

Fineway is AI-driven travel company, that provides highly personalized instant trip planning

  • Created an interactive data quality control tool that helped show accommodations with missing or incorrect data on a map. Used text mining to identify discrepancies in descriptions
  • Created a tool to visualize highly complex funnel of a trip finder assistant
  • Helped set up an analysis hub system in order to have a holistic view on all of the analysis conducted in the company
  • Contributed to the recommendation engine

Finiata GmbH

Marketing Working Student & Intern
|

Feb 2018 - Oct 2018

Finiata is an AI-driven working capital provider for SME’s.

  • Responsible for website administration, tracking setup and website KPIs optimization
  • Implemented complex website migration with multiple freelancers
  • Responsible for marketing reporting, both internal and external use

Education

New European College, Munich, Germany

Bachelor of Arts International Business Management
|

Oct 2016 - Nov 2019

Major courses:

  • Accounting and Corporate Finance
  • Business Communication and Marketing
  • Statistics, Micro and Macro Economics
  • German and European Law, Business Ethics

Polytehnic University of Bucharest, Romania

BSc Computer Science
|

Oct 2014 - Jul 2016

Major courses: Object-oriented Programming, Computer Architecture, Mechanics, IT essentials, Calculus, Data structures, Physics, Philosophy

Projects

Mary's Tricks

Marketing Consultant
|

Apr 2018 - Current

Mary's Tricks is a digital-oriented beauty salon, that focuses on creating unique valuable content and easy booking experience

  1. Grew client base from 200 to 2000 recurring clients
  2. Worked with different freelancers(design, web development, content creation)
  3. Set up Google and Facebook marketing
  4. Set up website trackers and custom reports
  5. Conducted analysis and identified clusters of clients which helped identify common attributes among the most profitable clients

Skills

  • Google Cloud Platform(BigQuery, GCS)
  • DBT
  • Looker/LookML
  • Python and Analytical Packages
  • GitHub, GitLab
  • Bash Shell
  • Google Apps Script
  • HubSpot API
  • JavaScript
  • Major Marketing Platforms Advertising
  • No Code website builders
  • Figma

Languages

Russian
Native
German
B2
Ukrainian
Native
Romanian
B2
English
C1, IELTS certified