Sr Business Intelligence Analyst

We Are Rosie • Palmetto, GA

7d • 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, but the analyst must be available to work PST hours. The contract runs from November 20, 2026, through March 31, 2027. Hours are part-time initially and transition to 40 hours per week in January 2027. The hourly rate is to be determined; applicants are asked to provide their ideal rate.

The analyst will join a cross-agency team and use marketing and web analytics to support campaign measurement, performance forecasting, optimization, and business growth. The role combines data hygiene and integration, interactive dashboard development, measurement planning, and technical stewardship of the agency’s data stack, including Improvado, Snowflake, and Tableau.

We Are Rosie provides strategic consulting and talent solutions for the marketing industry and partners with more than 200 major brands and agencies. Founded in 2018, the company describes its approach as inclusive and human-centric and 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 work PST hours; this is a non-negotiable requirement.
• Curious and 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.

Nice To Haves

• A master’s degree in Math, Economics, Statistics, Engineering, Psychology, or a related quantitative field is preferred.

Responsibilities

• Identify campaign KPIs and develop projections to forecast performance.
• Partner with digital media, ad operations, and communications teams to establish tracking and measurement methodologies before campaign launches.
• Integrate data from disparate platforms to assess performance and identify 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 expert for the data stack, including Improvado, Snowflake, and Tableau; troubleshoot and manage systems to ensure performance.
• Cleanse, merge, transpose, and pivot complex datasets.

What This Job Offers

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