Sr Business Intelligence Analyst

We Are Rosie is a strategic consulting and talent solutions company serving the marketing industry. The Senior Business Intelligence Analyst will identify campaign KPIs, integrate and analyze data from multiple platforms, build interactive dashboards, and provide optimization recommendations while managing the data stack.

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 is preferred