Position: Junior Data Analyst
Category: Data Analyst
Experience: 0 years | English: upper

1. I’m good at time management and in 98% of cases, I meet my deadlines.
2. At my previous job, I communicated with website readers, advertisers, partner website editors, and co-workers as a team lead. But I’m good with executing loads of work as an ordinary participant of the team as well.
3. Worked with website promotion, basic SEO, and Google Analytics. I brought one of my highly specialized startup websites to the top of Google search.
4. I have experience in developing startups (both good and bad, so I know what to expect).
My strongest side is data visualization. I have a designer eye, am diligent, and attentive to details. I’ve worked with Looker Studio, visualization in Google Sheets, and Tableau.
I have experience in creating Tableau dashboards. I’ve used various charts and graphics, including funnels, cohort graphics, heat maps, histograms, box plots, etc. I know how to work with filters, calculated fields, parameters, actions, change date types, and perform complex formatting in Tableau. The dashboards I’ve created are based on marketing metrics, particularly revenue, ARPPU, MRR, conversion rate, and others.
At the moment, I'm continuing to improve my Tableau visualization skills and learning how to create more complicated but user-friendly dashboards. I’m good at designing dashboards and have strong analytical skills needed to prioritize data issues and choose the right metrics. I have knowledge of SQL for data prep. And I can create high-quality analytical, operational, strategic, and financial dashboards.

Except for data visualization, I’ve performed projects in Google Sheets, PostgreSQL, and BigQuery. I code in SQL and have performed several projects. Among the functions and operators I’m familiar with are common table expressions (CTE), joining and unioning different data sources, window functions, DATE, COALESCE, CAST, and CASE functions, aggregation functions, etc.
Among the marketing metrics I have experience counting are CTR, CPC, CPM, ROMI, and working with UTM tags.
For example, I wrote code for SQL queries where I joined and unioned 2 tables in a CTE to extract the needed data, used aggregation functions to structure the data, counted marketing metrics (particularly, ROMI), and then extracted only the data that matched certain conditions.
In another project, I used 3 parallel CTEs (each extracted certain data or transformed it into the needed format), used COALESCE and CASE functions, changed the date format, used window functions with the LAG expression, and counted marketing metrics (CTR, CPM, ROMI) and the percent difference of each metric month by month.
In one of my BigQuery projects, I counted conversions from session_start to purchase regarding certain dates and traffic channels. This query included examples of CTE, a CAST function, a JOIN function, and counting of unique user_sessions per each step, a certain date, and a cartain traffic channel.
All these SQL projects can be found on my GitHub profile.
Ideally, I would love to work on freelance projects or in the field of outsourcing / outstaffing. My oral English level is Upper Intermediate and my written English is closer to Advanced. I have great experience of working with the American, Canadian, British market (and practically anywhere around the world) in content writing regarding the traditional culture, so the international business culture is also appealing to me. The least favored job offers for me are those that require full-time work in the office.