About this role.
Dutchie is hiring a Brands Ad Analyst to support its advertising sales organization through analytics, reporting, and client-facing strategy. The role uses SQL, preferably in Snowflake, and BI tools such as Hex or Looker to analyze ad, POS, telemetry, product, and retailer data. Key deliverables include prospect briefs, media plans, monthly performance narratives, QBR analyses, dashboards, and incrementality reporting. The analyst will translate campaign metrics such as ROAS, conversion rate, market share, and share of voice into actionable recommendations for brand clients and internal sales, product, and ad-operations teams.
Role DNA
A quick view of the complexity, pace, ownership and collaboration implied by the job description.
Job Complexity
4/5Pace & Pressure
4/5Autonomy Level
4/5Communication Load
5/5Salary analysis
Estimated compensation compared with the broader US market for similar roles.
Core skills
Skills and capabilities most closely associated with this opportunity.
Sample interview questions
I would first validate the underlying campaign, retailer, and conversion data, then compare results with prior periods, benchmarks, and campaign goals. I would connect delivery and efficiency metrics such as spend, impressions, CTR, conversion rate, ROAS, and new-buyer acquisition to business outcomes. The final narrative would highlight what happened, why it happened, recommended optimizations, and expected implications for the next period.
I would define an appropriate treatment and control methodology, ideally using user-level or retailer-level exposure data and a comparable unexposed audience. I would measure outcome differences while accounting for baseline purchasing behavior, seasonality, market changes, and selection bias. I would report both the estimated incremental lift and limitations of the methodology so stakeholders can make informed budget decisions.
I would document metric definitions and source tables, build validation checks for completeness and freshness, and reconcile headline totals with trusted source reports. I would test filters, date logic, joins, and edge cases before release. I would also establish an owner, refresh schedule, and QA process so recurring reports remain consistent over time.
I would combine market, retailer, product, and advertising data to segment brands by category penetration, market share, geographic availability, historical advertising activity, and growth trends. I would then rank prospects using a transparent scoring framework that considers addressable retailer reach and evidence of likely advertising impact. The output would include concise prospect briefs with supporting metrics and recommended outreach narratives.
I would answer directly when the data and methodology support a confident conclusion, explaining the metric in business terms. If the question requires validation, I would clearly state what I can confirm, avoid speculation, and commit to a specific follow-up with the required analysis. Maintaining credibility is more important than offering an immediate but uncertain answer.
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.
Upload your resume now
- To unlock remote work opportunities and be discovered by global employers.
This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.
