Contract
Hybrid, Pittsburgh

We are looking for a Media Reporting Analyst to join our team. The ideal candidate will have experience using reporting dashboard tools and Microsoft Excel to pull media campaign data and analyze campaign performance data based on KPIs/business and marketing objectives. As a Media Reporting Analyst I (Junior), you will work closely with our sales and marketing teams to evaluate performance data across multiple KPIs, using data to tell the why behind campaign performance vs the what. You will be responsible for creating campaign reporting, assisting with executive summaries, and creating campaign reporting in PowerPoint.

Key Responsibilities:
Analyze media campaign performance data using reporting dashboard tools and Microsoft Excel
Evaluate performance data across multiple KPIs, using data to tell the why behind campaign performance vs the what
Create campaign reporting and assist with executive summaries and creating campaign reporting in PowerPoint
Support the sales team with ad hoc reporting asks by pulling data from internal dashboards and creating campaign reporting materials (i.e. deck, chart, graph) based on sales team/vendor needs
Help develop performance benchmarks based on marketing campaign data
Assist with presenting campaign wrap reports to internal and external key stakeholders
Assist with evolving campaign reporting templates based on reporting needs
Manage a high volume of campaign report creation independently, and own all campaign reporting status documents/trackers

Key Skills:
Strong analytical skills
Strong presentation capabilities
Strategic thinking skills
Strong communication skills
Strong time management skills
Strong organization skills
Fast learner – can execute tasks independently with minimal supervision
Detail-oriented

Technical Skills:
Proficient in Microsoft Office (i.e. Excel, PowerPoint)
Data modeling skills – able to analyze raw data to draw insights + learnings (i.e. pivot tables, etc.)
Exposure to data analytics software (i.e SQL, BigQuery, Google Analytics, Google Data Studio, Adobe Analytics, DV360, Google campaign & ads manager)

Background:
1-3 years of marketing OR data/analytics experience
Experience working with large amounts of data and creating reports (excel/ppt)
Experience presenting learnings/results from data
Experience evaluating data based on benchmarks/KPIs

If you are a self-motivated individual with a passion for data analysis and storytelling, please apply for the Media Reporting Analyst I (Junior) position.

edictplatform.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, edictplatform.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, edictplatform.com is the ideal place to find your next job.