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

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