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

Summary

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 RoleWe 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 analysisDevelop and maintain recurring and ad hoc campaign performance reports and dashboards using SQL, Tableau, Excel, and Google SheetsIdentify campaign KPIs and develop projections and forecasts of expected performance based on campaign parameters and historical benchmarksCollaborate with digital media, ad operations, and communications teams to ensure that appropriate tracking, tagging, and measurement methodologies are in place prior to campaign launchesIntegrate and analyze data from platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360 to create unified performance viewsPerform deep-dive analyses to understand drivers of campaign performance and provide clear, data-backed recommendations for optimizationDesign and implement QA processes to validate data accuracy, troubleshoot tracking issues, and resolve discrepancies across data sourcesBuild and optimize SQL queries and data transformations to support scalable reporting and self-service analyticsLeverage Python (where appropriate) for advanced analysis, data cleansing, and automation of repeatable analytics tasksTranslate complex analytical findings into clear narratives, visualizations, and presentations tailored to both technical and non-technical stakeholdersDocument data definitions, reporting methodologies, and analytic processes to ensure continuity during and after the leave coverage periodQualifications 3-5+ years of experience in business intelligence, marketing analytics, or a closely related field, preferably in a digital marketing or media environmentAdvanced proficiency in SQL for data extraction, transformation, and analysis across large, complex datasetsHands-on experience working with Snowflake, including loading raw data files and managing tables, schemas, and basic performance tuningProven ability to build and maintain dashboards and reports in Tableau or similar BI toolsStrong skills in Excel and Google Sheets, including complex formulas, pivot tables, and data visualization for reportingWorking knowledge of Python for data manipulation, analysis, and/or automation is strongly preferredExperience analyzing data from digital marketing and analytics platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360Demonstrated experience defining campaign KPIs and building performance projections, forecasts, or benchmarksFamiliarity 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 stakeholdersStrong attention to detail, with a commitment to data quality, validation, and documentationExcellent communication and collaboration skills, with experience partnering across marketing, media, and technical teamsAbility 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#J-18808-Ljbffr

Job Description

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 RoleWe 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 analysisDevelop and maintain recurring and ad hoc campaign performance reports and dashboards using SQL, Tableau, Excel, and Google SheetsIdentify campaign KPIs and develop projections and forecasts of expected performance based on campaign parameters and historical benchmarksCollaborate with digital media, ad operations, and communications teams to ensure that appropriate tracking, tagging, and measurement methodologies are in place prior to campaign launchesIntegrate and analyze data from platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360 to create unified performance viewsPerform deep-dive analyses to understand drivers of campaign performance and provide clear, data-backed recommendations for optimizationDesign and implement QA processes to validate data accuracy, troubleshoot tracking issues, and resolve discrepancies across data sourcesBuild and optimize SQL queries and data transformations to support scalable reporting and self-service analyticsLeverage Python (where appropriate) for advanced analysis, data cleansing, and automation of repeatable analytics tasksTranslate complex analytical findings into clear narratives, visualizations, and presentations tailored to both technical and non-technical stakeholdersDocument data definitions, reporting methodologies, and analytic processes to ensure continuity during and after the leave coverage periodQualifications 3-5+ years of experience in business intelligence, marketing analytics, or a closely related field, preferably in a digital marketing or media environmentAdvanced proficiency in SQL for data extraction, transformation, and analysis across large, complex datasetsHands-on experience working with Snowflake, including loading raw data files and managing tables, schemas, and basic performance tuningProven ability to build and maintain dashboards and reports in Tableau or similar BI toolsStrong skills in Excel and Google Sheets, including complex formulas, pivot tables, and data visualization for reportingWorking knowledge of Python for data manipulation, analysis, and/or automation is strongly preferredExperience analyzing data from digital marketing and analytics platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360Demonstrated experience defining campaign KPIs and building performance projections, forecasts, or benchmarksFamiliarity 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 stakeholdersStrong attention to detail, with a commitment to data quality, validation, and documentationExcellent communication and collaboration skills, with experience partnering across marketing, media, and technical teamsAbility 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#J-18808-Ljbffr