Sr Business Intelligence Analyst

We Are Rosie, LLC; Palmetto (GA); Remote; USD 83,000 - 124,000; Part time

Job summary

We Are Rosie, LLC is seeking a Senior Business Intelligence Analyst for a 4‑month contract. The role is remote, with availability for PST hours and a start as part-time, expanding to 40 hours per week in January 2027.

You will identify KPI projections, collaborate across teams to ensure robust measurement, and build interactive dashboards using Improvado, Snowflake, and Tableau. This position is a W2 contract.

Qualifications

• MS in a quantitative field preferred (e.g., math, economics, statistics).
• 3–5 years' experience with marketing and web analytics data.
• Proficiency in SQL, Python, R, Excel, and Google Sheets.
• Expertise with Tableau and Snowflake; strong data modeling.
• Hands-on with Improvado, GA, Meta, Google Ads/SA360, Campaign Manager 360.
• Strong data cleansing, merging, pivoting of messy datasets.
• Excellent written and verbal communication; able to present to clients.

Responsibilities

• Identify campaign KPIs and develop projections to forecast performance.
• Partner with digital media, ad operations, and communications teams to ensure robust tracking and measurement methodologies before launch.
• Integrate data from disparate platforms to answer key business questions.
• Develop and maintain interactive dashboards for internal stakeholders and clients.
• Provide initial optimization recommendations leveraging media platform familiarity.
• Serve as the go-to expert for the data stack (Improvado, Snowflake, Tableau) and troubleshoot performance.

Skills

SQL

Python

R

Excel

Google Sheets

Education

MS in a quantitative field

Tools

Improvado

Snowflake

Tableau

Google Analytics

Meta for Business

Google Ads/SA360

Campaign Manager 360

Job description

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 (Please include your ideal rate in your application)

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.
• 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.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply