Senior Business Intelligence Analyst (Leave Coverage) 12/1- 4/30
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