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

Butler, Shine, Stern & Partners; United States; À distance; USD 55 000 - 110 000; Plein temps

Résumé du poste

BSSP is seeking a Freelance BI Analyst to cover a leave on the Marketing Science team. Remote role based in the US (PST). Dates roughly 12/7–4/30. Please include an hourly rate with submission.

Responsibilities include loading and validating data in Snowflake, building dashboards in Tableau, and delivering data-driven recommendations for campaign optimization. Strong SQL and Python skills preferred.

Qualifications

• 3-5+ years in BI/marketing analytics or related field.
• Advanced SQL proficiency for extraction, transformation, and analysis.
• Experience with Snowflake data loading and schema management.
• Proven ability to build dashboards in Tableau or similar BI tools.
• Strong Excel and Google Sheets skills with complex formulas/pivots.

Responsabilités

• Load, validate, and manage raw data in Snowflake with schema alignment.
• Develop recurring and ad hoc campaign reports and dashboards using SQL, Tableau, Excel, and Google Sheets.
• Identify KPIs and forecast performance based on historical benchmarks.
• Collaborate with marketing, media, and operations to ensure proper tracking before campaigns.
• Integrate data from GA, Meta, Google Ads/SA360, Campaign Manager 360 for unified views.
• Perform deep-dive analyses and provide data-backed optimization recommendations.
• Design QA processes to validate data accuracy and resolve discrepancies.
• Build and optimize SQL queries and data transformations for scalable reporting.
• Leverage Python for advanced analysis and automation of repetitive tasks.
• Translate findings into clear narratives and visuals for technical and non-technical stakeholders.
• Document data definitions and reporting methodologies for continuity.

Connaissances

SQL

Campaign analytics

Data visualization

Data storytelling

Excel

Google Sheets

Python

Dashboards

Presentation

Outils

Snowflake

Tableau

Excel

Google Sheets

Python

Description du poste

company

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.

role

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