Freelance Business Intelligence Analyst (LOA Coverage)

Posted 5 Days Ago
Sausalito, CA, USA
In-Office
Mid level
AdTech • Marketing Tech
The Role
Freelance Business Intelligence Analyst responsible for campaign measurement planning, KPI projections, data management, database administration, dashboard development, media performance analysis, and client-facing storytelling. The role manages Snowflake and Tableau data systems, ensures tracking accuracy and data hygiene, integrates advertising and behavioral data, and provides optimization recommendations. Requires strong SQL, Python, analytics, visualization, communication, and technical troubleshooting skills.
Summary Generated by Built In

BSSP is an independent creative agency where the best work comes from people who push each other past the obvious. We’re collaborators first, we bring a challenger mindset to everything we make, and we’re ambitious for our clients, the work and each other.

This is a Freelance/Temp role ranging from 12/7/26-4/30/27 covering a leave of absence. The ideal candidate will onboard/train for two weeks in December and return early to mid January.


This role can be remote as long as it's based in the US and doesn't require a VISA. This role will work pacific standard hours.


Rate of pay will be based on experience, skills and location.


WHAT YOU’LL DO

Plan the measurement

■     Identify campaign KPIs and build projections of results based on campaign parameters

■     Partner with Media, Ad Operations and Communications before launch so the right tracking, tagging and measurement methodologies are in place

Own the data

■     Load, organize and manage raw data in Snowflake from online and offline advertising, website tracking, and consumer demographic and behavioral sources

■     Maintain data tables and reporting structures as campaigns change, so reporting stays accurate and current

■     Drive data hygiene and the continued development of our data management and reporting systems

■     Be the go-to person the Marketing Science team leans on to manage and troubleshoot BSSP’s data stack (Snowflake, Tableau)

Tell the story

■     Integrate data across platforms to show how a client’s business is performing: What’s working? What’s not? What do we recommend they do about it?

■     Build and update interactive dashboards and visualizations for internal teams and clients

■     Evaluate media performance and bring initial optimization recommendations to Media and Communications teams

■     Support survey analysis, segmentation, web analytics and secondary research as needed

■     Represent Marketing Science and BSSP on cross-agency teams

WHAT EXCELLENCE LOOKS LIKE

■     Campaigns launch with tracking verified up front, not patched after the fact

■     Dashboards are trusted: accurate, current, and actually used by our teams and clients

■     Every analysis lands with a point of view presented as a compelling story, never just a data dump

■     When the data stack breaks, the team turns to you first, and you fix the root cause

■     Clients and agency teams depend on you to get it done with autonomy

WHAT YOU BRING

■     3–5 years of experience working with marketing and web analytics data, or proven competency with similar datasets

■     MS in Math, Economics, Statistics, Engineering, Psychology or another quantitative field preferred

■     Proficiency with SQL, Tableau, Python, Excel and Google Sheets

■     Proficiency administering and querying databases (e.g., Snowflake)

■     Strength in cleaning, transforming, merging and analyzing large, complex datasets

■     Experience with Google Analytics, Meta Business Suite, Google Ads/SA360 and Campaign Manager 360

■     Strong logical thinking and the ability to implement technical solutions

■     A curious, creative mindset, a continuous desire to learn, and a critical eye for detail

■     Strong written and verbal communication skills, and the confidence to present to clients

Skills Required

  • 3-5 years of experience working with marketing and web analytics data, or proven competency with similar datasets
  • Proficiency with SQL, Tableau, Python, Excel, and Google Sheets
  • Proficiency administering and querying databases such as Snowflake
  • Strength in cleaning, transforming, merging, and analyzing large, complex datasets
  • Experience with Google Analytics, Meta Business Suite, Google Ads or SA360, and Campaign Manager 360
  • Strong logical thinking and ability to implement technical solutions
  • Strong written and verbal communication skills and confidence presenting to clients
  • MS in Math, Economics, Statistics, Engineering, Psychology, or another quantitative field
  • Must be based in the United States and not require visa sponsorship
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Sausalito, CA
130 Employees
Year Founded: 1993

What We Do

Just beyond the bridge from San Francisco, you will find the small town of Sausalito. It’s a quirky town with a different perspective on the most interesting city in the world. There you’ll find our office, full of interesting people. Strategists. Data enthusiasts. Media minded geniuses. Creatives. Natural-born creators. Free-thinkers. Makers alike. All products of the surroundings here in Sausalito. We don’t just talk about being unique and different. We live and work differently here in Sausalito. That’s how we’ve created interesting work with interesting brands for the last 3 decades. Things are just more interesting here beyond the bridge.

Similar Jobs

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Senior Underwriter, Inland Marine

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Hybrid
7 Locations
40000 Employees
69K-215K Annually

Comcast Logo Comcast

Account Executive

Digital Media • Information Technology • News + Entertainment
Remote or Hybrid
California, USA
115000 Employees
72K-96K Annually

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Retail Contingent Sales Associate

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
Vacaville, CA, USA
16000 Employees
15-24 Hourly

Cloudflare Logo Cloudflare

Senior Software Engineer

Cloud • Information Technology • Security • Software • Cybersecurity
Hybrid
4 Locations
4400 Employees
185K-266K Annually

Similar Companies Hiring

MFour Data Research Thumbnail
Marketing Tech • Software
Irvine, CA
98 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account