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