Oleksandr T., BI Analyst
C1 (Advanced) English
Senior (5-10 years)
Odesa,
Ukraine
UTC+02:00
Summary
- Experienced BI Analyst with a diverse background in data analysis, data engineering, and data visualization
- Proficient in utilizing various BI tools such as PowerBI, Tableau, Metabase, and Periscope for creating reports and visualizations.
- Skilled in exploratory data analysis using Python/pandas or SQL, as well as data manipulation in Excel
- Experienced in database engineering and ETL processes using airflow/prefect/databricks as an orchestration tool and dbt for transformations.
- Knowledge of data governance and implementing data standards.
- DB: Postgres, BigQuery/Snowflake.
- Advanced English
Main Skills
Programming Languages
Python Libraries and Tools
Python Frameworks
Data Analysis and Visualization Technologies
Databases & Management Systems / ORM
Azure Cloud Services
Google Cloud Platform
Virtualization, Containers and Orchestration
Version Control
Other Technical Skills
Experience
Business Intelligence Analyst in Data Operation Insights, KMD PARTNERS LLC (USA fintech company)
October 2021-present
Responsibilities:
-
Data Analysis (underwriting process)
-
Alerts & Monitoring
-
DB engineering (dbt + airflow + Snowflake)
-
Data governance
-
Data visualization (periscope)
Senior Business Intelligence Analyst, InsightWhale (CRO & Analytical Agency)
November 2019 - September 2021
Responsibilities:
-
BI reports (PowerBI, Tableau, Metabase, GDS)
-
Exploratory data analysis (python+pandas, excel)
-
DB engineering (for ETL, BI structure) - Postgres, BigQuery
-
Process standardization, including training, templates, and everyday workflow
-
Building custom ELT system (based on Laravel admin panel/python (pipeliners) / rabbitmq / bigquery)
Freelance, consulting, self-study
2018 - 2019
Responsibilities:
-
Developed a BI system for a recruitment agency, recommendations for optimizing business processes for personnel search and management (Betapress)
-
Developed an online store (for-auto.com) and implemented ad hoc analytics (based on PostgreSQL + PowerBI) for tracking the effectiveness of each product/channel.
-
Built an analytics-based marketing strategy for several small companies
Head of Marketing (Lead of the team) / Analyst, Private network of online stores.
2015-2018
Responsibilities:
-
Optimized the marketing department and implemented a mechanism for remote employees
-
Reception and dismissal of employees developed a motivation system
-
Created ad hoc analytics (based on MSSQL + Analysis Services) for End-to-End Analytics + implemented call tracking
-
Python ETL
-
Implemented a KPI system to monitor the effectiveness of marketing activities (total number of sites more than 100)
-
Technical tasks for the development department (custom CMS, analytics, ab tests)
-
Coordinated the whole online marketing activity
Internet marketing expert, traffic manager, and Private network of online stores. PPC, SEO, marketplaces
2013-2015
Responsibilities:
-
Launching new stores on the market
-
Reporting
-
Full online marketing support
Other Experience
Small and medium client projects in the web studio. Self-education.
2013 – 2014
Consulting on PPC and web analytics, trainer in ppc school
2013 – 2014
Head of the online store (tekhnika.ua), PJSC "AO Technika"
2012 – 2014
Responsibilities:
-
Organized and launched an online store.
-
Debugged business processes and logistics.
-
Implemented a price adjustment system
-
Built a working marketing model for customer acquisition
Marketing Specialist, CJSC Technika (distributor of IT equipment)
2011 - 2012
Responsibilities:
-
Creation, planning, and implementation of promotions
-
Branches performance evaluation (including product placement)
-
PR. Work with negative