Serhii Y. looks like a good fit?

We can organize an interview with Aldin or any of our 25,000 available candidates within 48 hours. How would you like to proceed?

Schedule Interview Now

Serhii Y. SQL, Python and Data Analytics

My name is Serhii Y. and I have over 4 years of experience in the tech industry. I specialize in the following technologies: Google Tag Manager, Looker Studio, SQL, Microsoft Power BI Data Visualization, BigQuery, etc.. I hold a degree in Bachelor's degree. Some of the notable projects Iโ€™ve worked on include: Full-funnel End-to-End Marketing Analytics for Real Estate, Looker Studio dashboard with custom GTM/GA events for Medical Company, Shopify Theme Purchase Detalized Dashboarding, Monthly SEO dashboarding for big pharma, End-to-End Data Warehouse Solution with Analytics Integration, etc.. I am based in Gianyar, Indonesia. I've successfully completed 18 projects while developing at Softaims.

I value a collaborative environment where shared knowledge leads to superior outcomes. I actively mentor junior team members, conduct thorough quality reviews, and champion engineering best practices across the team. I believe that the quality of the final product is a direct reflection of the team's cohesion and skill.

My experience at Softaims has refined my ability to effectively communicate complex technical concepts to non-technical stakeholders, ensuring project alignment from the outset. I am a strong believer in transparent processes and iterative delivery.

My main objective is to foster a culture of quality and accountability. I am motivated to contribute my expertise to projects that require not just technical skill, but also strong organizational and leadership abilities to succeed.

Main technologies

  • SQL, Python and Data Analytics

    4 years

  • Google Tag Manager

    1 Year

  • Looker Studio

    2 Years

  • SQL

    2 Years

Additional skills

  • Google Tag Manager
  • Looker Studio
  • SQL
  • Microsoft Power BI Data Visualization
  • BigQuery
  • Web Analytics
  • Marketing Analytics
  • Advanced Analytics
  • Data Warehousing & ETL Software
  • Python
  • Google Analytics 4
  • n8n
  • AI Chatbot
  • AI Agent Development
  • Conversion Rate Optimization
  • Data Analysis

Direct hire

Potentially possible

Previous Company

Traveloka

Ready to get matched with vetted developers fast?

Let's get started today!

Hire Remote Developer

Experience Highlights

Full-funnel End-to-End Marketing Analytics for Real Estate

๐Ÿ“Š Built an end-to-end analytics system for a real estate company from scratch ๐Ÿ“Œ Set up GA4 custom events/parameters via GTM ๐Ÿ›  Integrated data via Python scripts + cron from GA4, Google Ads, Facebook Ads, Bitrix24 CRM, Yandex Direct APIs into BigQuery โœ… Bild ELT pipeline for fetching data from multiple sources (AD platforms, CRM, GA4) ๐Ÿงน Developed advanced data transformation SQL scripts for data marts ๐Ÿ“ˆ Created Looker Studio dashboards with KPIs (budget, ROAS, CPL, CPD) and advanced filters by ad platform, city, site, UTM ๐Ÿš€ Delivered actionable insights to optimize marketing ROAS

Looker Studio dashboard with custom GTM/GA events for Medical Company

๐Ÿ“Š Designed a high-impact Looker Studio dashboard for making strategic decisions ๐Ÿ›  Implemented advanced Google Analytics event tracking via GTM: PDF downloads, drop menu usage, quiz completions & other user interactions on key pages ๐Ÿ” Delivered deep analysis of traffic, landing pages, and user behavior ๐Ÿ“Œ Multi-dimensional segmentation with advanced filtering by device, source, category, and multiple custom-built segments ๐Ÿš€ Empowered data-driven decisions to boost engagement & conversions

Shopify Theme Purchase Detalized Dashboarding

As Analytics Engineer specializing in e-commerce, I built a Shopify Theme Store GA4 dashboard. Linked "add_to_cart"/install events to referrers for conversion insights. Aggregated real-time data into reports on themes, searches, keywords, filters (features, industry, price, location). ๐Ÿ“Š Linked add_to_cart & install events to referrer pages for conversion insights ๐Ÿ› ๏ธ Implemented custom dimensions, event mapping & URL categorization ๐Ÿ“Œ Built Looker Studio dashboard with an advanced filtering by theme, category, features, price & location ๐Ÿ” Solved parameter aggregation & attribution gaps

Monthly SEO dashboarding for big pharma

We have 2 types of granularity: - Monthly - Weekly 1. Python script fetches data monthly and writes it to bigquery. 2. Transformed data in bigquery is a data source for Looker Studio. 3. Looker Studio shows the most important metrics and dimensions for the client - Looker Studio works fast and efficiently because the data source is bigquery - For almost 1 year of reporting, the client paid 0$ for the infrastructure))

End-to-End Data Warehouse Solution with Analytics Integration

Objective: Develop a comprehensive data warehouse system using ClickHouse, integrated with R scripts for ETL processes, and visualized through Yandex DataLens to leverage insights from Yandex Metrica raw data. Key Features: Data Warehousing: Implemented a robust data warehousing solution using columnar OLAP DWH ClickHouse to store and manage large datasets efficiently. ETL Processes: Utilized R scripts to perform Extract, Transform, and Load (ETL) operations, ensuring data integrity and preparation for analysis. Scheduling: Configured cron jobs on a Linux Virtual Machine to automate the ETL process, allowing for regular data updates without manual intervention. API Integration: Employed R to retrieve raw data from Yandex Metrica Logs API, ensuring a steady stream of up-to-date data for reporting and analysis. Data Visualization: Designed and developed dynamic dashboards using the open-source BI tool Yandex DataLens, providing clear visual storytelling of the data trends and metrics. Querying and Analysis: Wrote complex SQL queries to extract insights from the data, supporting strategic business decisions. Outcome: This end-to-end solution transformed the data landscape for stakeholders, automating the extraction of Yandex Metrica data and streamlining its processing and storage in a ClickHouse as a data warehouse. With the implementation of Yandex DataLens for visualization, stakeholders now have unprecedented access to insights that were previously hidden. This newfound clarity enables them to make more informed and strategic decisions, leveraging data in ways that were not possible before.

Education

  • Sumy State University

    Bachelor's degree in Electronic engineering

    2009-01-01-2012-01-01

Languages

  • English
  • Russian
  • Ukrainian

Personal Accounts