Data Analyst (Campaign Analyst)

StickEarn; Jakarta Pusat; Hybrid; IDR 496.935.000 - 745.404.000; Full time

Job summary

A leading advertising technology company is seeking a Data Analyst (Campaign Analyst) to transform raw data into actionable insights across campaign lifecycles. Responsibilities include building data models, monitoring performance, delivering ROI reporting, and collaborating with cross-functional teams. The ideal candidate has a Bachelor's degree and 2-3 years of relevant experience, expert SQL skills, and a strong analytical mindset. A hybrid working setup and competitive compensation are offered.

Benefits

Hybrid working setup

Private insurance

Training budget & laptop ownership program

Competitive compensation package

Flexible & anniversary leaves

Qualifications

• 2–3 years of experience in data analysis or marketing analytics.
• Expert-level SQL proficiency for large datasets.
• Experience with A/B testing and statistical methods.

Responsibilities

• Build data models and develop targeting recommendations.
• Monitor campaign performance in real-time and recommend optimizations.
• Deliver reporting that quantifies ROI and measures business impact.

Skills

Data visualization

SQL proficiency

Analytical mindset

A/B testing

Marketing metrics understanding

Education

Bachelor’s degree in Statistics, Mathematics, or related field

Tools

Tableau

Power BI

BigQuery

Snowflake

Job description

Overview

Data Analyst (Campaign Analyst) at StickEarn

StickEarn is an advertising technology company on a mission to transform Out-of-Home (OOH) advertising through technology, data, and creativity. We empower brands, agencies, and media owners to create impactful advertising experiences across Indonesia. We are looking for a Data Analyst (Campaign Analyst) who can transform raw data into actionable insights across the full campaign lifecycle — from forecasting success, to monitoring live performance, to delivering post-campaign learnings that link directly to ROI.

What You’ll Do

• Pre-Campaign: Build data models, develop targeting recommendations, and forecast performance to support media planning.
• During Campaign: Monitor campaign performance in real-time, diagnose issues, and recommend optimizations (e.g., route, placement, targeting) to maximize the campaign impact.
• Post-Campaign: Deliver clear, comprehensive reporting that quantifies ROI, measure business impact, and generate strategic learnings for future optimization.
• Data Storytelling: Translate analytical findings into compelling narratives for non-technical stakeholders, ensuring insights connect directly to business goals.
• Collaboration: Work with Sales, Strategy, Campaign, and Creative teams to ensure analysis drives smarter, more impactful campaigns.

What We’re Looking For

• Bachelor’s degree in Statistics, Mathematics, Computer Science, Economics, or Business/Marketing Analytics.
• 2–3 years of experience in data analysis, marketing analytics, or campaign measurement (preferably in Marketing, Ad-Tech, or Digital Agency).
• Expert-level SQL proficiency in querying, joining, and manipulating large datasets; familiarity with relational database design and data modeling.
• Strong understanding of core marketing metrics (Impressions, Reach, Frequency, CTR, CPL, CPA, ROI, O2O attribution).
• Hands-on experience with A/B testing and statistical methods to evaluate and optimize campaign performance.
• Proven skills in data visualization (Tableau, Power BI, Looker Studio, or similar).
• Strong analytical mindset with the ability to identify performance issues and translate numbers into actionable recommendations.
• Experience or exposure to Python/R, with familiarity in ETL/ELT processes, cloud data warehouses (e.g., BigQuery, Snowflake), and predictive or attribution modeling for campaign measurement and optimization.
• Professional working proficiency in English (written & spoken).

What We Offer

• Flexibility with our hybrid working setup
• Private insurance to keep you covered
• Training budget & laptop ownership program to boost your productivity & growth
• Competitive compensation package with performance bonus.
• Flexible & anniversary leaves to support work-life balance and celebrate milestones

Apply now and help StickEarn deliver smarter, impactful campaigns as our next Data Analyst (Campaign Analyst)!
Only shortlisted candidates will be contacted.