Sr Business Intelligence Analyst

Remote Jobs; Palmetto (GA); Remote; USD 55,000 - 83,000; Part time

Job summary

We Are Rosie is seeking a Senior Business Intelligence Analyst to join a cross‑agency team. This remote role is PST hours, a 4‑month contract with a path to 40 hrs/week in January 2027.

The role focuses on strategic insight, data storytelling, and interactive dashboards using Improvado, Snowflake and Tableau to drive client campaigns.

Qualifications

• MS in quantitative field preferred.
• 3–5 years of experience with marketing and web analytics data.
• Proficient in SQL, Python, R, Excel and Google Sheets.
• Strong Tableau and Snowflake experience.
• Hands-on with Improvado, GA, Meta, Google Ads/SA360 and Campaign Manager 360.
• Able to cleanse, merge, transpose and pivot complex datasets.
• Curious, creative mindset with proactive, self‑motivated approach.
• Excellent written and oral communication skills.

Responsibilities

• Strategic Insight: Identify campaign KPIs and develop projections to forecast performance.
• Collaborative Measurement: Partner with digital teams to ensure robust tracking before launch.
• Data Storytelling: Integrate data from disparate platforms to answer key questions.
• Visualization: Build interactive dashboards for internal stakeholders and clients.
• Optimization: Provide initial optimization recommendations across media platforms.
• Technical Stewardship: Manage our data stack (Improvado, Snowflake, Tableau) and troubleshoot.

Skills

SQL

Python

R

Excel

Tableau

Snowflake

Improvado

Google Analytics

Google Ads

SA360

Campaign Manager 360

Data wrangling

Data visualization

Communication

Team collaboration

Education

MS in Math, Economics, Statistics, Engineering, Psychology, or related quantitative field

Tools

Snowflake

Tableau

Improvado

Job description

Company Description

A full service creative agency based in Sausalito

Job Description

Senior Business Intelligence Analyst (Contract)

Company: Full-Service Creative Agency

Location: Remote (Must be available for PST hours)

About the Role

We are looking for a Senior Business Intelligence Analyst to join our cross-agency team. If you are passionate about data hygiene, love building interactive dashboards that actually make an impact, and want to help drive business growth through rigorous analysis, we want to talk to you.

Key Role Information

• Role: Senior Business Intelligence Analyst
• Duration: 4 months (11/20/26 - 3/31/27)
• Location: Remote (Must be available for PST hours)
• Hours/wk: Part-time to start; transitioning to 40 hours/week in January 2027
• Hourly Rate: TBD

What You Will Do

• Strategic Insight: Identify campaign KPIs and develop projections to forecast performance.
• Collaborative Measurement: Partner with digital media, ad operations, and communications teams to ensure robust tracking and measurement methodologies are in place before launch.
• Data Storytelling: Integrate data from disparate platforms to answer the big questions: What's working? What's not? And what's the next move?
• Visualization: Develop and maintain interactive dashboards that provide clear, actionable performance evaluations for both internal stakeholders and clients.
• Optimization: Leverage your familiarity with various media platforms to provide initial optimization recommendations.
• Technical Stewardship: Serve as the go-to expert for our data stack (Improvado, Snowflake, Tableau), troubleshooting and managing our systems to ensure peak performance.

Qualifications

What You Will Need

• Education: MS in Math, Economics, Statistics, Engineering, Psychology, or a related quantitative field is preferred.
• Experience: 3-5 years of experience working with marketing and web analytics data.
• Technical Proficiency:
  • Expertise in SQL, Python, R, Excel, and Google Sheets.
  • Strong experience with Tableau and database administration/querying (Snowflake).
  • Hands-on experience with Improvado, Google Analytics, Meta for Business, Google Ads/SA360, and Campaign Manager 360.
• Data Mastery: Proven ability to cleanse, merge, transpose, and pivot complex, messy datasets.
• Soft Skills: A curious, creative mindset with strong logical thinking and a proactive, self-motivated approach.
• Communication: Excellent written and oral communication skills, with the ability to represent our department and agency professionally.

Additional Details

• This is a W2 contract position.
• Note: You must be willing to work PST hours; this is a non-negotiable requirement for this role.

Additional Information

We Are Rosie provides strategic consulting and talent solutions for the marketing industry. We partner with more than 200 of the world's biggest brands and agencies to help them solve unique marketing challenges with the best people, swiftly and at scale. Founded by former advertising executive Stephanie Nadi Olson in 2018, We Are Rosie is on a mission to redefine how marketing works, with an inclusive, human-centric approach that's better for business and better for marketers. Our company has been recognized as an industry trailblazer and earned many accolades, including being named to the 2023 Global Top 100 Inspiring Workplaces, the Inc. 5000 2022, and Adweek's Fastest Growing Agencies in 2021.

We Are Rosie is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, marital status, or any other status protected under federal, state, or local law.