The Data Management Analyst is responsible for reporting and presenting of strategic insights from KPI?s that guide creative brand direction and influence paid media investments. This role will closely collaborate with assigned agency client account teams and build direct relationships with clients related to analytic deliverables.
The ideal candidate must be passionate about data, measuring what matters, and ?connecting the dots? on which KPI?s should be acted upon and when. This key role works within the agency team environment and is responsible for reviewing the integrity of the data and automating the report process. Candidates must have knowledge in techniques for visual storytelling through data and the ability to process insights into actionable recommendations for both brand direction and ongoing paid media investments; including but not limited to traditional, digital and paid search campaigns. While not required, experience utilizing data visualization software such as Salesforce Wave, Tableau, GoodData or DOMO is beneficial, as well as a general understanding of relational databases and any derivatives of SQL. This position will report to the Supervisor, Data Management and Analytics.
Integrating internal and external data sources into data visualization software
Updating and publishing of executive level reports/dashboards
Creating reports in various formats for use by various stakeholders
Establishing media ROI calculations by client and media campaigns
Partnering with search & programmatic teams for use of data, reports and integration into client campaign level insights
Providing proactive recommendations based on interpretation of data and analysis of KPI?s
Benchmarking digital media strategies from digital activity as well as offline business metrics
Provide analysis of website traffic for key clients including monthly updates, yearly summaries and ad hoc requests, including designing dashboard and PowerPoint reports.
Understand client?s business requirements and design reporting and analysis approaches tailored to their needs
Provide modeling, datamining and statistical analysis, as required on accounts.
Deliver models and other advanced statistical solutions to client business case and marketing issues.
Contribute to increasing the level of innovation in data, analytics and CRM at the agency
Bachelor’s degree in Business with a focus on Computer Information Systems (CIS), Marketing or Economics
Preferred 2+ years of experience in a similar field; ecommerce a plus
Google Analytics Certified
Strong analytical skills, must be proficient in analyzing and interpreting internet-related data from standard software packages, SAS and client databases
Solid understanding of the fundamentals of digital advertising and social media
Advanced Excel acumen
Experience using SQL or any of its derivatives
Experience with web analytics packages such as Google Analytics, WebTrends, Omniture, Coremetrics, Hitbox, Visual Sciences etc.
Agency background with interactive and/or direct marketing experienced preferred+
Collaborative and works well with others
Competitive pay based on experience
Generous PTO/VAC plus 12 holidays (closed between Christmas Eve and New Year’s Day)
Casual and fun culture