Note: The job is a remote job and is open to candidates in USA. Butler, Shine, Stern & Partners (BSSP) is hiring a freelance Business Intelligence Analyst to cover a leave of absence. The role plans campaign measurement, manages marketing data and reporting systems, and turns performance analysis into dashboards and recommendations for clients and agency teams.
Responsibilities
- Identify campaign KPIs and build projections of results based on campaign parameters
- Partner with Media, Ad Operations and Communications before launch so the right tracking, tagging and measurement methodologies are in place
- Load, organize and manage raw data in Snowflake from online and offline advertising, website tracking, and consumer demographic and behavioral sources
- Maintain data tables and reporting structures as campaigns change, so reporting stays accurate and current
- Drive data hygiene and the continued development of our data management and reporting systems
- Be the go-to person the Marketing Science team leans on to manage and troubleshoot BSSP’s data stack (Snowflake, Tableau)
- Integrate data across platforms to show how a client’s business is performing: What’s working? What’s not? What do we recommend they do about it?
- Build and update interactive dashboards and visualizations for internal teams and clients
- Evaluate media performance and bring initial optimization recommendations to Media and Communications teams
- Support survey analysis, segmentation, web analytics and secondary research as needed
- Represent Marketing Science and BSSP on cross-agency teams
Skills
- 3–5 years of experience working with marketing and web analytics data, or proven competency with similar datasets
- Proficiency with SQL, Tableau, Python, Excel and Google Sheets
- Proficiency administering and querying databases (e.g., Snowflake)
- Strength in cleaning, transforming, merging and analyzing large, complex datasets
- Experience with Google Analytics, Meta Business Suite, Google Ads/SA360 and Campaign Manager 360
- Strong logical thinking and the ability to implement technical solutions
- A curious, creative mindset, a continuous desire to learn, and a critical eye for detail
- Strong written and verbal communication skills, and the confidence to present to clients
- MS in Math, Economics, Statistics, Engineering, Psychology or another quantitative field preferred
Benefits
- This role can be remote as long as it's based in the US and doesn't require a VISA.
Company Overview