Open to opportunities

Jan Chayopathum

@janchayopathum

Message

Marketing science data analyst turning programmatic campaign data into actionable revenue growth.

Canada

Message

What I'm looking for

I seek a collaborative role where I can build scalable data architectures, automate reporting, drive measurable marketing outcomes, mentor teams, and influence product and sales strategy.

I am a marketing science data analyst with 5+ years of experience in programmatic media, reporting, and data architecture, skilled at turning complex campaign data into clear insights that guide strategy and growth. I build and maintain SQL, Python, and R pipelines, automate dashboards in Tableau, ThoughtSpot and Looker Studio, and design scalable reporting solutions that drove client revenue and retention improvements.

I collaborate closely with Sales, Client Success, Product and Engineering to translate technical results into actionable stories, standardize processes, mentor junior analysts, and proactively solve analytics needs. My work has reduced reporting errors and manual effort, improved ROI on multi-million-dollar accounts, and produced self-serve reporting templates adopted by 200+ users.

Experience

Work history, roles, and key accomplishments

Current

Analyst II, Data Architecture

Current

StackAdapt

Jan 2025 - Present (9 months)

Built and maintained SQL, Python, and R pipelines and dashboards that improved customer retention by 10%+ and enabled upsell-driven revenue growth of 20%+. Designed scalable reporting and AI-assisted analysis tools to accelerate insights for Sales and client teams.

SQL Python R Snowflake Dashboard Automation

Programmatic Media Analyst

StackAdapt

Apr 2024 - Dec 2024 (8 months)

Consulted on campaign effectiveness and automated cross-channel reporting, driving insights that improved ROI by 15%+ on multi-million-dollar accounts and converted analyses into renewal and upsell opportunities.

CTR CPR ROAS ThoughtSpot Tableau Looker Studio

Reporting Developer

StackAdapt

Jun 2021 - Mar 2024 (2 years 9 months)

Automated reporting packs and QA scripts in SQL, Python, and Tableau, reducing manual effort by 30% and reporting errors by 50%, and delivered self-serve KPI templates adopted by 200+ users.

SQL Python Tableau QA Automation KPIs Funnel Analysis

Software Developer

Clockk.com

Jan 2021 - Apr 2021 (3 months)

Built front-end features in Ember, JavaScript, and TypeScript and migrated services to Elixir-backed APIs, improving performance and user experience while maintaining the web app codebase.

Ember.Js JavaScript TypeScript Elixir API Migration

Education

Degrees, certifications, and relevant coursework

Dalhousie University

Master of Applied Computer Science, Applied Computer Science

2019 - 2021

Activities and societies: Related courses: Applied Topics in Business; Data Management, Warehousing & Analytics; Software Development Concepts; Web Development; Cloud Computing; Mobile Computing.

Completed a Master of Applied Computer Science (Entrepreneurship Stream) with coursework in data management, analytics, software development, and cloud computing.