Brands Ad Analyst
- Role
- Data Science
- Experience
- Mid
- Company size
- Startup
Open to US only. Set where you work from to check your eligibility.
No BS summary
Digital advertising analytics candidate with 3-5+ years in media analytics, ad operations, or a related data-driven role. Must be strong in SQL, large datasets, Snowflake, dashboarding, and client-facing performance storytelling.
Core skills
Optional skills
About Dutchie
Founded in 2017, Dutchie is a comprehensive technology platform powering dispensary operations, while providing consumers with safe and easy access to cannabis. Dutchie aims to further support the positive societal change the cannabis industry brings to the world through wellness benefits, social justice, and empowering local communities through tax revenue. Powering thousands of dispensaries across 40+ markets throughout the United States and Canada, Dutchie is the leading technology company in the cannabis space and was named in Fast Company’s 10 Most Innovative Companies in North America and listed two years in a row on LinkedIn’s Top 50 Startups.
Dutchie has raised over $600M in funding to date, backed by D1 Capital Partners, Tiger Global, Dragoneer, DFJ Growth, Thrive Capital, Howard Schultz, Snoop Dogg’s Casa Verde Capital, Gron Ventures, members of the founding team at DoorDash, Kevin Durant’s Thirty Five Ventures, and other notable angel investors.
About This Job
The Brands Ad Analyst is a critical partner to the Dutchie Ads sales team, sitting at the intersection of data analytics, client services, and digital advertising strategy. This role is responsible for equipping the sales team with the data and narratives they need to win new business and retain existing clients. You will build compelling, data-driven stories that demonstrate the impact of advertising on Dutchie’s platform, deliver strategic recommendations for campaign optimization, and serve as a trusted analytical voice in client-facing conversations.
The ideal candidate is equally comfortable writing SQL queries in Snowflake, building dashboards in visualization tools, and presenting performance insights to brand partners. You thrive in a fast-paced, cross-functional environment and bring a consultative mindset to every interaction.
What You'll Do…
New Business Support
- Develop data-driven prospect briefs identifying high-potential brand targets based on market share, category penetration, and competitive positioning
- Build budget recommendations and media plans grounded in historical performance benchmarks and retailer-level data
- Create compelling pitch materials, including performance projections and ROI scenarios, to support the sales team in new business presentations
Existing Business – Monthly & Quarterly Reporting
- Own the end-to-end production of monthly performance narratives for brand clients, translating raw ad data into clear, strategic stories for client review meetings
- Conduct quarterly deep-dive analyses evaluating campaign health, incrementality, share of voice, and consumer behavior trends
- Frame insights around business outcomes—connecting ad spend to ROAS, new buyer acquisition, market dollar share, and conversion rate improvements
Dashboard & Visualization
- Design and maintain client-facing dashboards and internal reporting tools using visualization platforms such as Hex or Looker
- Develop reusable templates and automated workflows to streamline monthly and quarterly reporting cycles
- Ensure data accuracy and consistency across all deliverables through rigorous QA processes
Strategic Partnership
- Serve as the analytical voice in client meetings, confidently presenting findings and fielding data questions from brand stakeholders
- Provide strategic recommendations for new campaign launches, budget reallocations, and placement optimizations based on performance data
- Quantify the cost of inaction—translate ad spend pauses or reductions into measurable performance impact to reinforce the value of sustained investment
Cross-Functional Collaboration & Product Testing
- Work closely with Sales, Ad Operations, and Product teams to align on priorities, surface data needs, and communicate insights across the organization
- Participate in product testing for new ad placements, targeting features, and platform capabilities, providing structured feedback grounded in performance data
- Support ad hoc analytical requests from the sales team with quick, accurate turnarounds
What You Bring...
Required
- 3-5+ years of experience in digital advertising analytics, media analytics, ad operations, or a related data-driven role
- Proficiency in SQL with hands-on experience querying large datasets (Snowflake strongly preferred)
- Strong data storytelling ability—you can turn a table of numbers into a narrative that drives action
- Comfort in client-facing settings: you can present findings clearly and handle questions with confidence
- Experience working cross-functionally with sales, operations, and product teams
- Strong organizational skills with the ability to manage multiple deliverables across clients and deadlines
Technical Skills:
- Use snowflake or Hex to maintain, update and create ad reporting for client reviews
- Be familiar with the following schemas:
- Ad platform Data
- POS Data
- Telemetry Data
- Product Data
- Retailer Data
- Understand how all of the following relate to each other in order to build:
- Market Share Reports
- Market Impact Reports
- QBRs
- Ad Metric Reporting
- Ad Incrementality Reporting
- Retailer Level Reporting
- Be familiar enough with the data to quickly and accurately pull insights (ad projections, store lists, state rollups etc.) for sales and product teams
- Understand ads, snowflake and the data to write queries to test impact of campaign optimizations
- Work with Product team to rewrite incrementality report with A-B testing using ad server and user level data
It’s a Bonus if You…
- Experience with data visualization tools such as Hex, Looker, or similar BI platforms
- Background in media, digital advertising (retail media, programmatic, display, or sponsored product ads)
- Familiarity with ad performance metrics including ROAS, CTR, incrementality, share of voice, and conversion rate
- Experience with presentation tools (PowerPoint, Google Slides) for building polished client-ready decks
- Exposure to cannabis, CPG, or retail media industries is a plus
You’ll Get…
We are targeting a starting salary of $107,000 - $178,000 based on the intended level for this role.
In addition to cash compensation, our total rewards package includes:
- Full medical benefits including dental and vision plans to ensure you always have the best care.
- Equity packages in the form of stock options to all employees.
- Technology (hardware, software, reading materials, etc..) allowance
- Flexible vacation and sick days
At Dutchie, we’re committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. Dutchie believes that diversity and inclusion among our teammates is critical to our success, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool.
What you'll do
- Develop data-driven prospect briefs identifying high-potential brand targets based on market share, category penetration, and competitive positioning.
- Build budget recommendations and media plans grounded in historical performance benchmarks and retailer-level data.
- Create compelling pitch materials, including performance projections and ROI scenarios, to support the sales team in new business presentations.
- Own the end-to-end production of monthly performance narratives for brand clients, translating raw ad data into clear, strategic stories for client review meetings.
- Conduct quarterly deep-dive analyses evaluating campaign health, incrementality, share of voice, and consumer behavior trends.
- Frame insights around business outcomes by connecting ad spend to ROAS, new buyer acquisition, market dollar share, and conversion rate improvements.
- Design and maintain client-facing dashboards and internal reporting tools using visualization platforms such as Hex or Looker.
- Develop reusable templates and automated workflows to streamline monthly and quarterly reporting cycles.
- Ensure data accuracy and consistency across all deliverables through rigorous QA processes.
- Serve as the analytical voice in client meetings, confidently presenting findings and fielding data questions from brand stakeholders.
- Provide strategic recommendations for new campaign launches, budget reallocations, and placement optimizations based on performance data.
- Quantify the cost of inaction by translating ad spend pauses or reductions into measurable performance impact to reinforce the value of sustained investment.
- Work closely with Sales, Ad Operations, and Product teams to align on priorities, surface data needs, and communicate insights across the organization.
- Participate in product testing for new ad placements, targeting features, and platform capabilities, providing structured feedback grounded in performance data.
- Support ad hoc analytical requests from the sales team with quick, accurate turnarounds.
- Use Snowflake or Hex to maintain, update and create ad reporting for client reviews.
- Pull insights such as ad projections, store lists, and state rollups for sales and product teams.
- Write queries to test impact of campaign optimizations.
- Work with Product team to rewrite incrementality report with A-B testing using ad server and user-level data.
What they require
- 3-5+ years of experience in digital advertising analytics, media analytics, ad operations, or a related data-driven role.
- Proficiency in SQL with hands-on experience querying large datasets.
- Strong data storytelling ability; can turn a table of numbers into a narrative that drives action.
- Comfort in client-facing settings; can present findings clearly and handle questions with confidence.
- Experience working cross-functionally with sales, operations, and product teams.
- Strong organizational skills with the ability to manage multiple deliverables across clients and deadlines.
- Familiarity with Ad Platform Data schemas.
- Familiarity with POS Data schemas.
- Familiarity with Telemetry Data schemas.
- Familiarity with Product Data schemas.
- Familiarity with Retailer Data schemas.
- Ability to understand data relationships to build Market Share Reports.
- Ability to understand data relationships to build Market Impact Reports.
- Ability to understand data relationships to build QBRs.
- Ability to understand data relationships to build Ad Metric Reporting.
- Ability to understand data relationships to build Ad Incrementality Reporting.
- Ability to understand data relationships to build Retailer Level Reporting.
- Familiarity with ads data and the data needed to write queries testing the impact of campaign optimizations.
- Preferred: Background in media, digital advertising such as retail media, programmatic, display, or sponsored product ads.
- Preferred: Familiarity with ad performance metrics including ROAS, CTR, incrementality, share of voice, and conversion rate.
- Preferred: Exposure to cannabis, CPG, or retail media industries.
Benefits
- Full medical benefits including dental and vision plans.
- Equity packages in the form of stock options to all employees.
- Technology allowance for hardware, software, reading materials, and related items.
- Flexible vacation and sick days.
Dutchie is a comprehensive technology platform powering dispensary operations and providing consumers with access to cannabis, serving thousands of dispensaries across 40+ markets in the United States and Canada.