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

About this role

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

Originally posted on Himalayas