Apply as Developer Hire Developer
Upstaff PDF OnePage PDF

Oleksandr T. BI Analyst

Data Analyst (DA), Business Intelligence (BI) (5.0 yr.)

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

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

Education

Donetsk national university, Historical faculty, International relationship