Lead Data Analyst

Softsich; Polska; Hybrid; PLN 100,000 - 140,000; Full time

Benefits offered by this job

Remote work option

Office options in Kyiv/Warsaw

Vacation days + medical insurance

Professional development support

Team events and strong culture

No ties with aggressor country

Job summary

Softsich is seeking a Lead Data Analyst to own the full acquisition analytics cycle—from validating data sources to building dashboards and forecasting ROI.

You will collaborate with the Retention team for end-to-end traffic quality assessment, define metrics, and automate data pipelines to support budget allocation decisions across campaigns and channels.

Qualifications

• 4 years of analytics experience with 1-2 years in marketing analytics.
• Experience in performance/affiliate marketing in a high-traffic vertical.
• Strong SQL skills: window functions, CTEs, cohort analysis, large datasets, and understanding query costs.
• Practical experience with BI tools (Tableau preferred; Power BI / Looker / Metabase also acceptable).
• Understanding of acquisition unit economics: CPA, CPL, RevShare, Hybrid, ROI/ROAS, LTV, and payback period.
• Understanding of attribution and tracking: UTM, postbacks, attribution windows, multitouch vs. last-click attribution.
• Python at an automation level: pandas, API data extraction, reconciliation scripts.
• Ability to independently trace data back to its source rather than relying on ready-made data marts.

Responsibilities

• Analyze the performance of acquired traffic and marketing campaigns.
• Analyze and optimize marketing funnels and identify bottlenecks.
• Collect, validate, and consolidate data from multiple sources for reporting; own and maintain metric definitions.
• Develop and maintain dashboards for different stakeholders.
• Automate data collection and analytical processes, moving manual reporting into automated pipelines.
• Generate and validate hypotheses to improve traffic ROI and operational efficiency.
• Identify anomalies and conversion issues on a daily basis.
• Turn raw data into actionable recommendations for budget allocation and decision-making.

Skills

SQL

Window Functions

CTEs

Cohort Analysis

Large Datasets

Query Costs

Tools

Tableau

Power BI

Looker

Metabase

Job description

We are looking for a Lead Data Analyst to join the team. The role covers the full acquisition analytics cycle — from validating and consolidating data from the DB, affiliate platforms, and advertising sources to building dashboards, forecasting ROI, and providing recommendations on budget allocation. The position also serves as a point of connection with the Retention team for end-to-end traffic quality assessment.

Requirements

• 4 years of overall analytics experience, including 1-2 years specifically in marketing analytics; experience in performance/affiliate marketing in a high-traffic vertical.
• Strong SQL skills: window functions, CTEs, cohort analysis, working with large datasets, and understanding query costs.
• Practical experience with BI tools (Tableau is preferred; Power BI / Looker / Metabase are also acceptable).
• Understanding of acquisition unit economics: CPA, CPL, RevShare, Hybrid, ROI/ROAS, LTV, and payback period.
• Understanding of attribution and tracking: UTM, postbacks, attribution windows, multitouch vs. last-click attribution.
• Python at an automation level: pandas, API data extraction, reconciliation scripts.
• Ability to independently trace data back to its source rather than relying on ready-made data marts.

Responsibilities

• Analyze the performance of acquired traffic and marketing campaigns.
• Analyze and optimize marketing funnels and identify bottlenecks.
• Collect, validate, and consolidate data from multiple sources for reporting; own and maintain metric definitions.
• Develop and maintain dashboards for different stakeholders.
• Automate data collection and analytical processes, moving manual reporting into automated pipelines.
• Generate and validate hypotheses to improve traffic ROI and operational efficiency.
• Identify anomalies and conversion issues on a daily basis.
• Turn raw data into actionable recommendations for budget allocation and decision-making.

Nice to Have

• Experience with affiliate platforms.
• Experience with Snowflake, dbt, and Airflow.
• Experience with LTV/ROI forecasting, cohort models, and survival analysis.
• Experience identifying fraudulent or low-quality traffic: bonus abuse, incentivized traffic, source spoofing.
• Experience conducting and correctly interpreting A/B tests.
• Experience working with retention data and CRM campaigns.
• Experience in a multi-brand environment across multiple geos and currencies.

What we offer:

• Flexible schedule and freedom to choose your work format: remote or from our offices in Kyiv or Warsaw.
• 24 paid vacation days, sick leave, and medical insurance (already available in Ukraine; other locations - in progress).
• A team where it’s easy to ask questions, learn, contribute, and be yourself.
• Coverage for professional events, training, and certifications.
• Team buildings, birthday gifts, and a community that truly cares.
• Zero business ties with the aggressor country - and we’re proud of that.