Sr Business Intelligence Analyst

We Are Rosie is recruiting a Senior Business Intelligence Analyst on contract for a full-service creative agency. The role supports campaign measurement and business growth by forecasting performance, integrating marketing data, building dashboards, and providing optimization recommendations.

Responsibilities:

• 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

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/querying (Snowflake)
• Hands-on experience with Improvado, Google Analytics, Meta for Business, Google Ads/SA360, and Campaign Manager 360
• Proven ability to cleanse, merge, transpose, and pivot complex, messy datasets
• A curious, creative mindset with strong logical thinking and a proactive, self-motivated approach
• Excellent written and oral communication skills, with the ability to represent our department and agency professionally
• MS in Math, Economics, Statistics, Engineering, Psychology, or a related quantitative field