Senior Business Intelligence Analyst (Leave Coverage) 12/1- 4/30 in Sausalito, California at Butler Shine Stern & Partners

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