Position: Data Engineer
Category: Data Engineer
English level: fluent
Years of experience: 2


Data Analyst / Data Engineer - Thedigital (March 2021 - present)
Engineering:
- development of data collection and data processing strategy from the ground up
- deployment and maintenance of a Data Warehouse (Bigquery), managing DW budget
- deployment of Airflow + Python ETL scripts, building data pipelines
- prototyping of a Golang client-server telemetry network for scheduled internet speed measurement
Analytics:
- creation of automated financial reports (Tableau, Data Studio), time series analysis, regression analysis
- geo-spatial analysis: creation of an algorithm constructing isolated chains of shortest paths for thousands of points (Python, OpenStreetMa deployed as a local Docker instance, QGIS)
- point-in-polygon analysis of client coordinates (shapely, geojson)
-plotting of complex geospatial data

Data analyst - Uploadcare, Canada (1 year, remote)
- conducting product-, marketing-, finances-related analysis using Python (jupyter, pandas, pyspark, multiprocessing, numpy, plotly, seaborn, regexp), BigQuery, Chartio, PopSQL, Amplitude, Heap Analytics and Tableau (complex queries in Standard SQL):
- calculating and visualizing SaaS-related business metrics - MRR/ARR/churn ratio/customers' debt/conversion rates etc.
- parsing gigabytes of raw json logs for data warehouse backfilling, historical analysis based on raw data. Building basic data pipelines with Apache Airflow.
- cohort- and segment-based financial analysis, ad hoc drilldowns, detecting outliers and anomalies within the working datasets
- setting up front-end tracking events using Heap Analytics, Google Tag Manager, Segment (event routing)

Marketing-Manager (Israel, US market).
Responsibilities:
- Competitive analysis: (US, French market)
- Optimization of internal workflows: pitching of automation ideas, close cooperation with Dev department, design of use cases and user stories
- Design of A/B tests, analysis of metrics, reporting (Google Optimize, Google Analytics, SEMrush)
- Client relations, translation of product specifications, promotional and advertising materials

Pet projects:
- Web-app with as Interactive Visualization of covid-19 cases in Ukraine, fatality and recovery ratios, testing rate (requests, MySQL Server, Pandas, Plotly/Dash on Flask)
- Telegram bot for Kiev Municipal Blood Center (requests, threading, SQLAlchemy, MySQL Server, PythonTelegramBotApi (JSON))
- Jupyter scripts for historic data analysis of raw data, visualizations using Plotly
Searching for an enthusiastic team, eager to learn new stuff.