Position: Junior Data Analyst / Data Analyst
Category: Data Analyst
English level: intermediate
Years of experience: 0.5

2016-2023:
A TOP-5 level company in the market of specialized construction services.
10-fold increase in the scale of the company.
More than 350 successfully implemented, profitable projects.

2014-2016:
Repeatedly - the best group according to work results
I have analytical experience from previous fields.
Working in the position of Team leader, I was daily involved in the analysis of key performance indicators (KPI) of the team's work, based on the analysis, I worked on improving these indicators.
While working as a manager of construction projects, he was constantly engaged in the analysis of projects profitability, calculation of the cost of projects implementation for clients, conversion analysis, and analysis of other main indicators of the company's performance.

Regarding Data Analytics skills:

Google Sheets
Working with tables and formulas in Google Sheets. Data cleaning and preparation. Work with product metrics. Calculation of engagement indicators. Use of linear regression for forecasting values. Construction of graphs. Construction of summary tables. Working with text functions and dates. Creating tables for cohort analysis.

SQL
Practical experience of working with PostgreSQL (using DBeaver).
Connecting to databases. Data cleaning and preparation. Writing basic queries. Application of grouping and aggregation functions. Combining data from different tables using join and union operations. Application of common table expressions (CTE). Using operators to work with strings. Using conditional and missing value operators. Application of functions for working with dates and window functions. Experience writing queries in BigQuery.

Visualization tools
Using Google Looker Studio to build a dashboard. Construction of reports and complex diagrams in Tableau. Creating and using calculation fields for calculating metrics, writing LOD expressions, using Table Calculations, using parameters and actions. Skills for creating beautiful visualizations.

Other tools
Using slack for communication, Trello for planning and working with tasks.
I want to join an interesting team and project that will give me the opportunity to fully reveal my analytical talents.