Business Intelligence Analyst

Responsibilities:

● Analyze marketing and attribution data to quantify return on marketing investment and optimize budget allocation across channels and partners utilizing media mix model, cross platform analyses, and experimentation outputs

● Provide insights to marketing and media activation teams to inform strategic marketing decisions and implement budget recommendations and optimizations

● Create and maintain reporting and dashboards for internal marketing teams and external agency

● Partner closely with internal data science teams and external partners to enhance and optimize the media mix to increase relevance and actionability of the results

● Improve and strengthen marketing data pipelines with data engineering teams

● Support ad hoc analysis to provide deeper and more granular insights on media performance

● Additional other duties and responsibilities, as assigned

Qualifications:

● BA/BS. 2+ years experience in digital marketing and analytics, web analytics, online media industry.

● Proficient in SQL with a thorough understanding of data and systems' infrastructures; experience extracting data from databases using SQL

● Experience or coursework in media measurement including web, native app, video measurement technology and standards

● Proficient with analytical tools and languages supporting data analysis, reporting, and visualization - Excel, Microsoft Office, Google Collaborative Apps (Docs, Sheets, Slides), Tableau, R, Python

● Strong detail-orientation with a penchant for data accuracy and good grammar

You might also have:

● Strong mathematics, statistics background

● Strong solutions-oriented and critical thinking mindset

● Experience using Google Cloud Platform (BigQuery)

● Experience translating requirements into actionable instructions and documentation

● Experience in working independently to meet deliverables with some oversight

● Experience using project management tools like those from Atlassian (JIRA, Confluence)

Mandatory Skills : Design Thinking And Ideation Workshops, M365 Suites of Products, PowerBI, Tableau, UML diagrams