Position: Data Engineer
Category: Data Engineer
English level: upper
Years of experience: 3


BI Engineer / Data Engineer
Jul 2022 - Present

Responsibilities:
- Aggregating data from the different data sources
- Ensuring correctness of data in the data warehouse
- Creating dashboards in Logi Analytics
- Developing an additional application 
- Writing documentation

Achievements:
- Developed tools for easier and faster reporting deployment
- Reduced inconsistencies in the database
- Build a reporting tool that provides brief information about data matching
- Wrote production-ready CI/CD scripts


Data analyst / Data Engineer
Oct 2020 - Jul 2022

Responsibilities:
- Aggregating data from the different data sources
- Developing reliable data source based on BigQuery
- Creating dashboards in Tableau
- Ad hoc reporting
- Developing an analytical framework for using within a team
- Writing documentation

Achievements:
- Wrote framework for connecting to multiple sources
- Initiated and ensured the transition from cron to another automation system that allows you to build pipelines, parallel processes, dependencies, etc
- Initiated the transition to BigQuery as the only data warehouse with testing of tables and data integrity. Now we use only it when building reports
- Redesigned many dashboards, both visually and conceptually, and held clarifying meetings with customers.
- Initiated and implemented the transition from periodical reports in Excel to dashboards in Tableau
- Unified the naming of metrics, and documented them in the knowledge base

Junior data analyst
Dec 2019 – Sep 2021

Achievements:
- Modified existing SQL queries to optimize efficiency and decreased execution time by up to 50%
- Created database structure for the client
- Wrote different macros on VBA for weekly reports


------
Skills
Databases
- Familiar with: MySQL, PostgreSQL, ClickHouse, MongoDB, MS SQL, BigQuery
- Experience in optimization and performance tuning

Programming
- Applied experience in Python
- Experience in designing, and developing data pipelines
- Experience operating with distributed systems
- Experience with data modeling, data warehousing
- Knowledge of REST/GraphQL APIs
- Experience with Git(GitHub, GitLab), CI/CD, Docker, dbt
- Orchestration tools: Airflow, Argo Workflow

Analytics
- Developed analytics for different business needs
- Automate periodical reporting
- BI: Tableau, DataStudio