Sr Business Intelligence Analyst

We Are Rosie • Palmetto, GA

12h • Remote

About The Position

We Are Rosie is seeking a Senior Business Intelligence Analyst for a four-month W2 contract with a full-service creative agency. The role is remote, with required availability during Pacific Time hours. It starts part-time and transitions to 40 hours per week in January 2027. The stated contract duration is November 20, 2026, through March 31, 2027; the hourly rate is to be determined.

The analyst will join a cross-agency team and use marketing and web analytics data to support business growth. The work includes identifying campaign KPIs, forecasting performance, coordinating measurement and tracking with internal teams before campaigns launch, integrating data from multiple platforms, and communicating performance insights through interactive dashboards. The analyst will also recommend initial optimizations and oversee the agency’s data stack, including Improvado, Snowflake, and Tableau.

We Are Rosie provides strategic consulting and talent solutions for the marketing industry and describes its approach as inclusive and human-centric. It is an equal opportunity employer.

Requirements

• 3–5 years of experience working with marketing and web analytics data.
• Expertise in SQL, Python, R, Excel, and Google Sheets.
• Strong experience with Tableau and database administration and querying, including Snowflake.
• Hands-on experience with Improvado, Google Analytics, Meta for Business, Google Ads/SA360, and Campaign Manager 360.
• Ability to cleanse, merge, transpose, and pivot complex, messy datasets.
• Curious, creative mindset; strong logical thinking; and a proactive, self-motivated approach.
• Excellent written and oral communication skills and ability to represent the department and agency professionally.
• Must be willing and available to work Pacific Time hours.

Nice To Haves

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

Responsibilities

• Identify campaign KPIs and develop projections to forecast performance.
• Partner with digital media, ad operations, and communications teams to establish robust tracking and measurement methodologies before launch.
• Integrate data from disparate platforms to identify what is working, what is not, and recommended next steps.
• Develop and maintain interactive dashboards that provide actionable performance evaluations for internal stakeholders and clients.
• Use familiarity with media platforms to provide initial optimization recommendations.
• Serve as the data-stack expert for Improvado, Snowflake, and Tableau, troubleshooting and managing systems.

What This Job Offers

• Job Type: Part-time
• Career Level: Senior
• Education Level: No Education Listed