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.
About The Role
We are looking for a Freelance BI Analyst to cover a leave. This role sits on the Marketing Science team and reports in to our Analytics Director. The dates are roughly 12/7-4/30. This is a remote role working PST and based in the US.
Rate
Rate is based on experience, skills and location. Please include hourly rate with submission.
What You'll Do
- Load, validate, and manage raw data files in Snowflake, ensuring data integrity and proper schema alignment for reporting and analysis
- Develop and maintain recurring and ad hoc campaign performance reports and dashboards using SQL, Tableau, Excel, and Google Sheets
- Identify campaign KPIs and develop projections and forecasts of expected performance based on campaign parameters and historical benchmarks
- Collaborate with digital media, ad operations, and communications teams to ensure that appropriate tracking, tagging, and measurement methodologies are in place prior to campaign launches
- Integrate and analyze data from platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360 to create unified performance views
- Perform deep-dive analyses to understand drivers of campaign performance and provide clear, data-backed recommendations for optimization
- Design and implement QA processes to validate data accuracy, troubleshoot tracking issues, and resolve discrepancies across data sources
- Build and optimize SQL queries and data transformations to support scalable reporting and self-service analytics
- Leverage Python (where appropriate) for advanced analysis, data cleansing, and automation of repeatable analytics tasks
- Translate complex analytical findings into clear narratives, visualizations, and presentations tailored to both technical and non-technical stakeholders
- Document data definitions, reporting methodologies, and analytic processes to ensure continuity during and after the leave coverage period
Qualifications
- 3–5+ years of experience in business intelligence, marketing analytics, or a closely related field, preferably in a digital marketing or media environment
- Advanced proficiency in SQL for data extraction, transformation, and analysis across large, complex datasets
- Hands-on experience working with Snowflake, including loading raw data files and managing tables, schemas, and basic performance tuning
- Proven ability to build and maintain dashboards and reports in Tableau or similar BI tools
- Strong skills in Excel and Google Sheets, including complex formulas, pivot tables, and data visualization for reporting
- Working knowledge of Python for data manipulation, analysis, and/or automation is strongly preferred
- Experience analyzing data from digital marketing and analytics platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360
- Demonstrated experience defining campaign KPIs and building performance projections, forecasts, or benchmarks
- Familiarity with digital marketing tracking, tagging, and measurement best practices (e.g., pixels, UTMs, conversion tracking)
- Ability to translate complex data into clear, concise insights and recommendations for business stakeholders
- Strong attention to detail, with a commitment to data quality, validation, and documentation
- Excellent communication and collaboration skills, with experience partnering across marketing, media, and technical teams
- Ability to work independently in a fast-paced environment and manage priorities within a defined coverage period (12/1–4/30)
- Fluency in English, both written and verbal
Skills Required
- 3-5+ years of experience in business intelligence, marketing analytics, or a closely related field
- Advanced proficiency in SQL for data extraction, transformation, and analysis across large, complex datasets
- Hands-on experience with Snowflake, including loading raw data files and managing tables, schemas, and basic performance tuning
- Experience building and maintaining dashboards and reports in Tableau or similar BI tools
- Strong skills in Excel and Google Sheets, including complex formulas, pivot tables, and data visualization
- Working knowledge of Python for data manipulation, analysis, or automation
- Experience analyzing data from Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360
- Experience defining campaign KPIs and building performance projections, forecasts, or benchmarks
- Familiarity with digital marketing tracking, tagging, and measurement best practices, including pixels, UTMs, and conversion tracking
- Ability to translate complex data into clear, concise insights and recommendations for business stakeholders
- Strong attention to detail and commitment to data quality, validation, and documentation
- Excellent communication and collaboration skills across marketing, media, and technical teams
- Ability to work independently in a fast-paced environment and manage priorities within a defined coverage period
- Fluency in written and verbal English
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.
