Senior Business Intelligence Analyst (Leave Coverage) 12/1- 4/30

Butler Shine Stern & Partners; Sausalito (CA); Remote; USD 96,000 - 131,000; Full time

Job summary

Butler Shine Stern & Partners is seeking a Senior Business Intelligence Analyst to cover a leave. This remote role supports the Marketing Science team and reports to the Analytics Director. The engagement runs roughly December through April and follows Pacific Time hours for US-based work.

You will load and validate data in Snowflake, develop dashboards in Tableau, and perform analyses to drive data-informed decisions. Strong SQL, Python, and digital analytics experience are essential.

Qualifications

• 3–5+ years in BI, marketing analytics, or a closely related field.
• Advanced proficiency in SQL for large datasets.
• Hands-on Snowflake experience: loading data, schemas, tuning.
• Proven ability to build dashboards in Tableau or similar BI tools.
• Strong Excel/Google Sheets skills with complex formulas and charts.
• Experience with digital analytics platforms (GA, Meta, SA360, Campaign Manager 360).
• Ability to define KPIs and build performance projections or benchmarks.
• Strong storytelling to translate data into actionable insights.
• Excellent collaboration with marketing, media, and technical teams.

Responsibilities

• Load, validate, and manage raw data in Snowflake with correct schema alignment.
• Develop recurring and ad hoc reports and dashboards using SQL/Tableau/Sheets.
• Identify KPIs and project performance using historical benchmarks.
• Collaborate with digital teams to ensure proper tracking and measurement.
• Integrate data from GA, Meta, SA360, and Campaign Manager 360 for unified views.
• Conduct deep-dive analyses and provide data-backed optimization recommendations.
• Design QA processes to validate data accuracy and resolve discrepancies.
• Build efficient SQL queries and data transformations for scalable analytics.
• Use Python for advanced analysis and automation where appropriate.
• Translate findings into clear narratives and visuals for stakeholders.
• Document data definitions and methodologies to ensure continuity.

Skills

SQL

Snowflake

Tableau

Excel

Google Sheets

Python

Google Analytics

Meta for Business

SA360

Campaign Manager 360

KPI definition

Data storytelling

Tools

Snowflake

Tableau

Excel

Google Analytics

Python

Job description

Senior Business Intelligence Analyst (Leave Coverage) 12/1- 4/30

About this position

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