Senior Media Analyst

  • Full-time

Company Description

Spark Foundry is a global media agency that exists to bring HEAT – Higher Engagement, Affinity, and Transactions – to brands. By combining flawless media fundamentals with aggressive innovation, Spark inspires consumers to pay more attention; to care more about our clients’ brands; and to buy more products and services from them.

Balancing the nimble spirit of a startup with the powerhouse soul of Publicis Media, Spark Foundry delivers the best of both worlds to a client roster that spans some of the world’s best and most beloved brands and companies. We combine boutique-caliber insights and service with the buying clout and first-look access of a global leader, bringing the heat to challenger brands that want to act like giants, and to giant brands that want to act like challengers.

With a Millennial-friendly, bottom-up culture that celebrates diversity and aims for all voices to be heard, Spark has become a magnet for the industry’s best talent, with one of the best retention rates in the industry. And by applying a whole-person approach to professional and personal development, Spark develops a workforce that is well prepared for today’s challenges, and also poised to create meaningful careers in the years to come. 

Because we know that heat arises the intersection of complementary forces, our professionals come from myriad disciplines and backgrounds: data, analytics, and insights; content and creative production; communications and strategy; finance and marketing; and sociology, psychology, and other liberal arts disciplines.

Job Description

The Senior Media Analyst is a key driver to provide visualizations, a strategic thinker and a talented data visualization with a heavy emphasis on dashboard reporting. The primary responsibility will be generating and owning dashboards for clients. This position will allow you to be a significant contributor as part of the team and provide insights and recommendations through data visualizations.
 
This position requires both strategic and tactical skill sets with an eye for numbers, intellectual curiosity, proficiency at problem solving, and a critical understanding of online media. The candidate must have a proven track record in data-rich analyses, and be a team player. A “roll up the sleeves” approach is mandatory and a “get it done” attitude is a must. Specific responsibilities include coordination between the research, analytics & media teams ensuring high quality analytical projects are effectively delivered.
 
Successful candidates will be multi-dimensional ‘rising-stars’ who are able to employ complex problem solving skills, and are able to communicate these succinctly to a broad client and media stakeholder audience.

Roles and Responsibilities:

• Understand how platform/data technologies work and offer the ability to explain technical concepts in ordinary terms (be technically savvy - understand the opportunities and limitations)
• Establish and manage data integrations utilizing a taxonomy nomenclature to make recommendations for data visualization to showcase media performance through the use of Datorama or Tableau
• Perform regular quality assurance/quality control checks on assigned client campaigns to ensure the data is processing accurately
• Utilize Excel, Datorama and Tableau to pull data into custom charts, tables, and to showcase the most critical series of actionable business metrics
• Design and build backend data streams and processes to automate reporting capability with data visualization tools
• Contribute to client status and reporting calls, including presentation of reporting as required
• Support the development of measurement strategies, learning agendas and roadmaps with input from senior team members and internal stakeholders
• Develop subject matter expertise in performance marketing, web analytics and Business Intelligence  platforms
• Clearly define project deliverables, timelines, and dependencies for junior team members, internal stakeholders and clients
• Complete other duties as assigned.

Qualifications

Required:

• Possess strong oral and written communication skills
• Partner with media teams to understand campaign objectives, strategy, and execution of digital and traditional media plans
• Analyze, synthesize and visually present data for campaign analysis meeting internal and external reporting deadlines
• 1 to 2 years related experience in digital analytics/dashboard design is a plus
• Experience working with international teams is a plus
• Proficiency with Datorama, Tableau, or other data visualization tools is required
• Advanced user Microsoft Office Suite and reporting tools
• Strong verbal/written communication and interpersonal skills is required
• Self-starter with ability to thrive in an fast paced environment and able to function independently while providing status updates to a team of analysts
• Cooperative, flexible, conscientious, dependable, resourceful, self-motivated, team-oriented, Problem solving skills, time management and critical thinking with a professional and positive attitude
• Bachelor’s degree or combination of education, and equivalent work experience is required
• Web analytics platforms (Google Analytics, Adobe Analytics, WebTrends, etc.)
• Demonstrated expertise in core MS Excel functions (vlookup, pivot tables, data visualization)
• Experience with online advertising/media, channel marketing, strategic marketing, off-line advertising/media and/or consulting
• Experience to design jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without modification.
• Ability to create ETL specifications, unit, and system integration test cases
• Clear understanding of SSIS and ETL best practices within a MS SQL Server environment
• SSIS error handling, error propagation and email notification

Other qualifications

• Strong analytical and problem solving skills
• Effective communication skills
• Ability to work independently and as part of a team
• Bachelor Degree in Economics, Statistics. Marketing or related discipline preferred

Additional Information

All your information will be kept confidential according to EEO guidelines.

Privacy Policy