(Senior) Product Data Analyst

Smartly; Helsinki; On-site; EUR 55,000 - 85,000; Full time

Benefits offered by this job

Autonomy to grow your craft

Competitive local compensation

Wellbeing support

Job summary

Smartly is seeking a Product Data Analyst to help product teams understand how customers use the platform, how to invest effectively, and how launches create value. You will work in a Data Analytics squad, collaborating with Product, Design, Engineering, and Data Engineering to build trusted data products and answer product questions.

This role blends analytics engineering with product analytics, writing code, building models, and delivering dashboards as a by-product of durable data solutions.

Qualifications

• Advanced SQL with cloud data warehouses (BigQuery) and complex transforms.
• dbt or similar workflow with modular design and testing.
• Python for data tooling, automation, and tooling beyond dashboards.
• Strong product-analytics judgment across funnels, cohorts, retention, and impact.

Responsibilities

• Build production-quality dbt models in BigQuery and product marts.
• Define grain, keys, joins, types, history, and performance before implementation.
• Write clean, tested code with version control and reviews.
• Turn recurring questions into durable, self-service data products.
• Partner with PMs and engineers on instrumentation, data contracts, and validation.
• Ensure data quality, lineage, and reliability before users use it.

Skills

Advanced SQL

BigQuery

dbt

Python

Product analytics judgment

Stakeholder communication

Engineering mindset

Experimentation & analytical thinking

Tools

Tableau

Job description

Turn product data into better decisions, experiences, and measurable customer impact.

Smartly is an AI-powered advertising platform uniting creative and media workflows. We are looking for a Product Data Analyst who helps product teams understand how customers use the platform, choose investments, and measure whether launches create value.

About the role

Reporting to the Manager, Data Platform, you will be a hands-on contributor in the Data Analytics squad, partnering closely with Product, Design, Engineering, and Data Engineering across the company.

This role combines analytics engineering with product analytics. You will write code, build production-grade models and trusted data products, then use them to answer product questions and shape decisions for teams across Smartly. Dashboards are a delivery surface, not the goal.

Smartly moves fast. You will turn ambiguity into a plan, deliver in valuable increments, make sound technical choices, surface blockers early, and drive work through adoption. This is not a coordination or reporting-production role.

What you will own

• Build production-quality dbt models in BigQuery, from source-aligned layers to reusable product marts and metric foundations.
• Design tables deliberately, defining grain, keys, joins, data types, null handling, history, and performance before implementation.
• Write clean, maintainable code using version control, pull requests, automated tests, documentation, and peer review.
• Turn recurring questions and one-off reports into durable models, shared definitions, and self-service data products.
• Partner with Product Managers and Engineers on instrumentation, event schemas, data contracts, validation, and quality monitoring.
• Own domain data quality by tracing discrepancies, lineage, and join coverage; fix root causes before users find them and expose reliability.
• Analyse journeys, funnels, cohorts, retention, adoption, experiments, and commercial outcomes to recommend next steps.
• Build decision-ready dashboards when appropriate, keeping trusted modelling and metric logic beneath the visualisation.
• Drive work end to end: clarify outcomes, scope pragmatically, ship iteratively, communicate directly, and ensure adoption.
• Use AI tools to increase speed while protecting confidential data, reviewing generated code, and verifying conclusions.

What success looks like

• Within three months, you understand the product and architecture, contribute reviewed code regularly, and ship a trusted model or improvement.
• Within six months, you own a product area’s analytics foundations: tested, documented models actively used in decisions and trusted by product teams.
• You replace recurring manual analysis and reporting with reusable models, reliable metrics, and effective self-service.
• Your pace shows in completed outcomes: you move without perfect information while maintaining quality and alignment.

What we are looking for

• Advanced SQL and strong experience with BigQuery or another cloud warehouse, including complex transformations, window functions, nested data, type conversion, and performance trade-offs.
• Strong modelling judgement across warehouse and analytics use cases: grain, cardinality, dimensional models, deduplication, historical data, and the metric risks of poor joins or types.
• Hands‑on dbt or similar experience, including modular design, testing, documentation, lineage, version control, and production deployment workflows.
• Ability to code beyond dashboards—for example, using Python to inspect data, automate workflows, use APIs, or build analytical tools.
• An engineering mindset focused on correctness, maintainability, observability, reproducibility, and solutions others can safely extend.
• Practical product‑analytics judgement across funnels, cohorts, retention, adoption, segmentation, and product‑impact measurement.
• Strong delivery instinct: you navigate ambiguity and shifting priorities, decide with available evidence, and unblock progress.
• Clear stakeholder communication: translate business needs into technical designs, explain trade-offs, challenge assumptions, and recommend action.
• Curiosity about digital advertising and motivation to learn enough product and customer context to model data correctly.

Nice to have

• Experience with orchestration, semantic layers, data contracts, lineage, observability, or near‑real‑time data.
• Experience with experimentation, causal inference, or advanced statistics.
• Experience in B2B SaaS, adtech, or complex workflow products.
• Experience with Tableau, Redash, or similar BI tools.

How we work

Join an international, fast-moving team where Product, Engineering, Design, and Analytics work together with clear personal accountability. We value ownership, simplicity, learning, direct feedback, and sustainable delivery. This Helsinki-based role follows Smartly’s hybrid practices, with regular in‑person collaboration.

What we offer

• Product work with visible customer and business impact.
• Autonomy, supportive peers, and room to grow your craft.
• A global, inclusive team built on trust and open feedback.
• Competitive local compensation, benefits, and wellbeing support.

About Smartly

Smartly is the AI-powered advertising technology company transforming ad experiences for brands and their consumers. Our comprehensive advertising platform seamlessly integrates the capabilities of media, creative, and intelligence to power more than 800 billion impressions and generate more than 300 billion creatives annually, delivering tangible business outcomes for brands and advertisers.

Smartly is the only company in the industry recognized as a Leader in The Forrester Wave: Creative Advertising Technologies with PwC validating the results it delivers for brands. We manage creative and media for 700+ brands worldwide and $6B in ad spend across the largest media platforms, including Facebook, Google, Instagram, Pinterest, Snap, and TikTok. Our end‑to‑end technology, unmatched access to media platforms and exceptional customer service help Fortune 500 brands to reach and engage consumers and learn what performs best.Smartly is a multinational and diverse team of 750+ Smartlies from 60+ nationalities, working in 13 countries. Together, we want to create and maintain an inclusive environment where everyone feels respected and heard. Our Diversity, Equity & Inclusion approach is at the heart of it.

We use Greenhouse’s AI-powered Talent Matching tool to compare your application against our job requirements. To learn more or to opt‑out of this process entirely follow the Learn More link!