Butler, Shine, Stern & Partners
Senior Business Intelligence Analyst (Leave Coverage) 12/1- 4/30
Freelance/contract BI analyst covering a leave (roughly 12/7–4/30) on the Marketing Science team at ad agency Butler, Shine, Stern & Partners. Day to day: loading and validating data in Snowflake, building campaign performance reports and dashboards in SQL, Tableau, Excel and Sheets, and analyzing ad-platform data (GA, Meta, Google Ads/SA360, CM360). Remote within the US, working PST; hourly rate
- Compensation
- Not disclosed
- Location
- Sausalito, CA
- Work setup
- Remote
- Seniority
- Senior
- Employment
- Contract
- Experience
- 5+ years
- Category
- Data analytics
- Posted
Skills
Must have
- 3–5+ years of experience in business intelligence, marketing analytics, or closely related field, preferably in digital marketing or media
- Advanced proficiency in SQL for data extraction, transformation, and analysis across large datasets
- Hands-on experience 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
- Experience analyzing data from platforms such as Google Analytics, Facebook/Meta for Business, Google Ads/SA360, and Campaign Manager 360
- Experience defining campaign KPIs and building performance projections, forecasts, or benchmarks
- Familiarity with digital marketing tracking, tagging, and measurement best practices (pixels, UTMs, conversion tracking)
- Ability to translate complex data into clear insights and recommendations for business stakeholders
- Strong attention to detail with commitment to data quality, validation, and documentation
- Excellent communication and collaboration skills across marketing, media, and technical teams
- Ability to work independently in a fast-paced environment and manage priorities within the coverage period (12/1–4/30)
- Fluency in English, both written and verbal
Nice to have
- Working knowledge of Python for data manipulation, analysis, and/or automation
Full description
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