Media Analyst MyBuys

Description
This position is attached to the MyBuys Media team, which is responsible for our dynamic advertising solution. The POAG Associate - Media Analyst will assist in the preparation of a variety of Media specific analytics and reporting needs. Daily tasks will include the production and management of critical reports used for managing the business, including revenue projection models and campaign performance analyses. You will also be integral to the creation of internal ad hoc and standardized campaign insights reports. An understanding of very large datasets, statistical concepts, and an intuitive sense of data and data patterns will be highly valued. The candidate will have demonstrated success in executing analytical projects and have well developed db querying and spreadsheet skills.

Key Areas of Responsibility:

Media Business analytics
Help develop db queries, work with data tables and design readable reports that provide insights into the business and actionable recommendations
Execute daily/monthly/quarterly reports on partner performance and trends
Present data in a way that shows trends and aggregate performance metrics
Help maintain and run daily revenue and performance projection models
Assist in development and analysis of various performance testing strategies
Campaign Analytics
Assist in the monitoring of key metrics and reports used by various internal organizations.
Provide basic interpretation and insights around findings.
Assist the Media Account Managers in the trouble shooting of data issues and reports.
Monthly Financial Close
Assist in the preparation of billable cost and revenue data.
Maintain multi source datasets.
Update key revenue forecast models and monthly business metrics reports

Qualifications/ Requirements:

Bachelors degree in a quantitative field
Has been involved in projects that involve collecting, organizing, analyzing, and visually representing insights using large sets of data.
Exceptional quantitative skills and desktop analysis skills
An understanding of the importance of visual representation of complex data with skills in data presentation and report design (Excel/VBA, BI etc.) a plus
Familiarity with SQL databases and how to run complex queries against the data (MySQL, Oracle, SQLServer, etc)
Familiarity with desktop or enterprise database environments a plus
Familiarity in online Media, marketing, and personalization a plus
Understanding of web analytic systems (Google Analytics, WebTrends, Omniture SiteCatalyst) a plus
Strong verbal, written communication and presentation skills.

Location:	Ann Arbor, MI United States