Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Benefits
- Remote (must be available for PST hours)
Company Overview