Position: Data\BI Engineer
Category: Data Engineer
English level: intermediate
Years of experience: 3

Skills:
    • Strong SQL skills. 
    • Strong knowledge of databases: MySQL, Oracle SQL, MongoDB
    • Knowledge of Python (Pandas, NumPy, Selenium, Scrapy, lxml, SQLAlchemy, BS4, OOP).
    • Understanding of work HTTP protocol, request, headers, Xpath
    • Working with Version Control Systems (Git).
    • Base knowledge about ETL (Python, Airflow) and DWH concepts.
    • Basic knowledge of Docker.
    • Basic knowledge of Linux.
    • Basic knowledge of HTML, JS.
    • Experienced with Agile methodology
Data Engineer
03.2022 – Present
Developed and maintained stored procedures, triggers, and functions in SQL server to optimize data extract, transform and load (ETL) processes; Collection of data from various sources via API (on- premises systems) using Azure Functions (Python with concurrency);
Created data transfer pipelines between Data Warehouse and on-premises systems using Azure Data Factory.
Middle BI Developer
03.2021 – Present
Automated manual reporting processes using Python; Developed and implemented advanced analytics solutions using data mining and data cleaning; Optimized SQL queries to improve report performance, resulting in 30% faster report rendering;
Created data models and automated data refresh processes to improve data accuracy and timeliness; Trained end-users on report navigation and dashboard customization to promote data-driven decision making;
Work with stakeholders across different business processes;
Analysis and modeling data is coming in from the different sources into BI tool;
Troubleshoot and resolve incidents, solve technical issues related to data.
SKILLS & COMPETENCIES
Cloud Computing (Azure) Relational and Non-Relational Database Management
Big Data Technologies (Spark, PySpark)
Data Warehousing Solutions
Data Modeling and Analysis
ETL (Extract, Transform, Load) Python (Numpy, Pandas, Matplotlib, SqlAlchemy, requests, cuncurency) MySQL, SQL Server, MongoDB
Data Visualization
Monitoring and Performance Tuning KPI Reporting
Business Metrics Analysis
Data Mining (Playwright, Selenium, Scrapy, lxml, BS4)