Upgrade Projekt einstellen
Profilbild von Elisha RachovitskyDuarte Senior IT Consultant & BI Specialist, Data Scientist & Lead Analyst in Python, SQL, & R aus Berlin

Elisha Rachovitsky-Duarte

Berlin
verfügbar

Letztes Update: 06.09.2022

Senior IT Consultant & BI Specialist, Data Scientist & Lead Analyst in Python, SQL, & R

Abschluss: MSc Social Data Science, AB
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: Deutsch (verhandlungssicher) | Englisch (Muttersprache) | Italienisch (Grundkenntnisse) | Japanisch (Grundkenntnisse) | Spanisch (Muttersprache) | Hebräisch (Grundkenntnisse)

Schlagwörter

Dateianlagen

CV-Final-2022.pdf

Skills

With 9 years of experience as a Data Scientist and Business Intelligence Expert, I have successfully completed freelance and commercial projects with over 20 international organisations representing the internet, e-learning, e-commerce, marketing, banking, automotive, retail, electronics, financial, legal, and broadcasting industries. Not only specialising in European markets, particularly, DACH, I have also collaborated with colleagues and analysed market trends across the US, UK, Middle East, and Asia. At heart, I am a published academic, consultant, and programmer fluent in Python, R, and SQL plus working knowledge of Java, JavaScript, HTML, and CSS. Coming from both a quantitative and qualitative background, I hold an MSc in Data Science from the University of Oxford and an AB from the Ivy League university, Dartmouth College. Based between Berlin, Spain, and USA, I am open to remote or semi-remote work thriving in multilingual and cosmopolitan environments. I prefer working as a Freelancer under service or hourly contracts concerning Information Technology (IT), Data Science, Data Engineering, Market Research, and Business Intelligence. More specifically, these topics include solutions using Statistics, Hypothesis Testing, Predictive Analytics, Machine Learning (Supervised & Unsupervised for Regression|Classification & Clustering with Parametric and Non-Parametric Algorithms), Natural Language Processing (NLP), Data Architecture & ETL Pipeline Design, Data Collection & Enrichment, API Deployment, Web Tracking, Marketing Mixed Modelling, Survey Implementation, Causal Impact & Lift Estimators, Customer Segmentation, Competitive Intelligence, OKR & KPI Outlining, Financial Analysis, Budget Calculators, Process Automation, and Dashboard Building in Looker, PowerBI, & Tableau.

Projekthistorie

10/2021 - 12/2021
Senior Information Technology Consultant in Marketing Intelligence
Cheil Worldwide (Marketing, PR und Design, 5000-10.000 Mitarbeiter)
Working with the SAMSUNG electronics group of Seoul, South Korea via its marketing analytics subsidiary Cheil Worldwide, I completed a short-term marketing intelligence project involving the measurement of absolute cumulative revenue lift per product type on stores with different treatments. Using regression and Naïve-Bayes time-series analysis, I determined the best predictors of historical revenue then calculated overall ROI per store using the attributable lift. Finally, I enriched marketing intelligence capacity by collecting more than 50 ancillary datasets created from both Google Trends and publicly available German statistics. (Python, R, PowerPoint, Tableau, Excel)
05/2021 - 09/2021
Senior Information Technology Consultant in UX & Product
MediaMarktSaturn GmbH (Konsumgüter und Handel, 5000-10.000 Mitarbeiter)
Working with terabytes of Google Analytics mobile data from their native application in BigQuery, I developed ETL processing
scripts in SQL to mine the nested insights into a functional dataset with hundreds of engineered/coded features. Using Tableau, I then created automatically scheduled reports and dashboards for the UX and consumer application teams. Finally, I supported the famous electronics merchandiser with senior level hiring and mentorship. (Google Analytics, Firebase, BigQuery, SQL, Tableau)
04/2021 - 09/2021
Sports Data Warehouse, Lead Analyst in Software Engineering
Olympics Channel Services (Medien und Verlage, 500-1000 Mitarbeiter)
As the technical lead of the software engineering team for the 2020 Tokyo Olympics, I managed the largest, oldest, and most
intricately designed sports data warehouse that includes every sport, competition, player/horse, medal, etc. - all broken down to their granular components. The architecture strives to be a unified sports data model with a NoSQL logic able to integrate any new or missing sport into its schema. One of my key tasks was to create Data Tools in Python & Cassandra Query Language to monitor, troubleshoot, and optimise the process of turning real-time match results into Olympic digital canon.
04/2021 - 06/2021
Senior Business Intelligence Consultant
CoachHub (Internet und Informationstechnologie, 10-50 Mitarbeiter)
Acting as a Senior Business Intelligence consultant for the e-learning and coaching platform based in Berlin, I developed and
maintained existing SQL queries to improve and extend their LookerML model, whilst iterating with stakeholders in the Customer Success and Finance Departments on their strategic data KPI Reporting needs. I clearly documented the provenance of every visualisation, scheduled its automatic reporting, and collaborated with Graphic Designers to customise via LookerML CSS and HTML their strategic, customer-facing embedded-dashboard product in Looker. (SQL, DataGrip, CSS/HTML, Looker, Github)
03/2021 - 06/2021
Data Scientist and Business Intelligence Mentor
CareerFoundry
As a mentor for this e-learning and coding bootcamp platform, I remotely instructed several students 1:1 on topics concerning
Statistics, Excel, SQL, and Python for Data Analysis.
12/2020 - 02/2021
Senior Information Technology in Marketing Intelligence
Zalando SE (Konsumgüter und Handel, 1000-5000 Mitarbeiter)
Created a script to calculate the revenue and popularity or website traffic lift from brand marketing Christmas campaign launch in Ireland. Helped with business intelligence and data science projects by consulting directly with the Head of Marketing for UK and Ireland on strategy, KPI development, and analytics' visualization via Tableau.
09/2020 - 11/2020
Data Scientist
Trade Republic GmbH (Banken und Finanzdienstleistungen, 50-250 Mitarbeiter)
For the innovative Berlin bank, I provided data science support on customer-investor segmentation using unsupervised clustering methods of users' financial portfolios to analyze performance trends. I also created regression models describing relationship of app usage and investing habits to underlying business profit. (Statistics, ML, R, Python, Jupyter, SQL, Github)
03/2020 - 10/2020
Senior Analytics Consultant
Digital Motion GmbH (Internet und Informationstechnologie, 10-50 Mitarbeiter)
During the onset of COVID, I joined a German consultancy firm based in Nordrhein-Westphalen specialising in advanced analytics & micro-consulting services. There, I consulted on data strategy and created solutions for Data Architecture, recommendation engines, web tracking, and coding tutorials for several notable clients like Volkswagen & Redbull.
05/2019 - 09/2019
Lead Data Scientist in Marketing Intelligence
Taxfix GmbH (Banken und Finanzdienstleistungen, 50-250 Mitarbeiter)
Working directly with the CMO on marketing channel strategy with reports & ad hoc analyses to justify decision making, I
completed several projects: a correlational analysis to optimise marketing channel performance & budgeting; a causal impact analysis of offline brand marketing campaigns on traffic & revenue lift; campaign manager training for using experimental design & hypothesis testing to improve campaign performance; an organic revenue & traffic predictor; an algorithm to determine whether or not two paid marketing channels were cannibalising the other; customer segmentation with k-modes clustering to develop customer personae for targeting and product enrichment; and, finally, a predictor of ROI per channel achieved using time-series regression in R and Python.
09/2017 - 08/2018
Digital Business Analyst
XING AG (Internet und Informationstechnologie, 1000-5000 Mitarbeiter)
In the Black Unit of the German, career-oriented social network, XING AG, I worked directly with the Managing Directors of its employee-feedback publishing website: kununu.com in Vienna and its Berlin startup: engage - an anonymous feedback tool that helps companies measure employee satisfaction. At XING, I created monthly reports with 'deep dive' and ad hoc analyses for PR, marketing, SEO, and sales teams. I also managed several projects or JIRA tickets regarding data enrichment with APIs, the implementation of partial-string matching to improve data quality, the configuration of an algorithm to value online reviews as an asset in Python, and other correlation and time-series analyses in R. For the engage product, I developed from cradle-to-grave the BI infrastructure: KPI construction, ETL processing in SQL, and strategic dashboards/reports in Tableau.
05/2017 - 08/2017
Data Scientist
Pixsy GmbH (Internet und Informationstechnologie, 10-50 Mitarbeiter)
Working directly under the CEO and CTO for the Berlin legal-tech that 'finds and fights image theft online', I was responsible for BI and Data Science initiatives like creating Machine Learning pipelines, which included research, Python engineering, and crossfunctional teamwork with developers and account executives. Here, I learned how to feature engineer, troubleshoot ML class bias, use auto-ML methods, and prepare data for investors. On the Business Intelligence side, I built the entire analytics infrastructure from scratch for every department including ~850 visualisations for KPIs using SQL and the visualisation software, Domo.
10/2015 - 11/2016
Data Scientist
Oxford Internet Institute (Internet und Informationstechnologie, 10-50 Mitarbeiter)
As a member of the Computational Social Science Research Team at Oxford, I used Python, R, and SQL to collect databases for future research & analysed online social trace data & qualitative surveys on a variety of topics from e-learning behaviour to online pornography usage under the leadership of Dr Taha Yasseri.
.
06/2010 - 09/2010
Product Analyst & Researcher
Tiltfactor.org (Internet und Informationstechnologie, 10-50 Mitarbeiter)
At the Digital Humanities and games development lab at Dartmouth College, I focused on using psychological principles to create interactive technologies and systems that positively foster player attitude and behavioural change. Managed quantitative and qualitative data whilst implementing social experiments to better understand values at play in digital media under the supervision of the lab's founder, Professor Dr Mary Flanagan.

Reisebereitschaft

Verfügbar in den Ländern Deutschland
Located in Berlin, DE, Cincinnati, OH, and Spain
Profilbild von Elisha RachovitskyDuarte Senior IT Consultant & BI Specialist, Data Scientist & Lead Analyst in Python, SQL, & R aus Berlin Senior IT Consultant & BI Specialist, Data Scientist & Lead Analyst in Python, SQL, & R
Registrieren