Data Analyst / Senior Data Analyst

New York, United States Full-time

Who We Are:

We are Mekanism.  

We are a New York City based agency with offices in Seattle, Chicago, and San Francisco. We solve real business problems using a strategic blend of storytelling, high design and/or clever, bust-a-gut humor.  It’s basically just advertising.  We do it for brands your Mom’s heard of – HBO, Red Nose Day, MillerCoors, Starbucks Doubleshot, Alaska Airlines, Charles Schwab, Amazon, Ben & Jerry’s, The White House (seriously), Muscle Milk, and a few others.

Our innovative approach to get asses in seats and move product from shelves has earned Agency of the Year Awards the past two years, numerous Effies, two Harvard case studies and all sorts of industry hardware. And most recently…drum roll please…we were voted Best Place to Work by AdAge in 2016 & 2017!

We take great pride in making unconventional campaigns for brands in conventional categories.  Our patented blend of storytelling for emerging media takes a small army of Mekanistas to pull off.  What is a Mekanista you ask? Being a Mekanista requires a rare combination of being a strange, wonderful and talented person who enjoys coffee, ping-pong and impromptu rooftop jam and workout sessions.  We are smart, strange, wonderful folks that brave our contentious and often violent brainstorming sessions to make advertising magic.

Key Areas of Responsibility

Campaign Reporting: Work with a range of analytical tools to provide sophisticated and comprehensive reporting to clients on a weekly/monthly basis. This involves understanding the campaign’s key KPIs, sourcing the right data, calculating metrics and providing insights/recommendations.

Build and Maintain Reporting Tools: Be an integral part of designing, building and maintaining Mekanism’s reporting platform, including the data pipeline. Continuously ideate ways to make reporting more automated, more robust and more valuable for our clients.

Predictive modeling / Machine Learning: Work with client’s data and third-party data to build time-series and regression models, used to measure and attribute incremental sales (or other conversions) driven by a campaign.

Measurement Partner Liaising: Help decide which measurement partners we should work with to deliver the right analysis for our clients, and lead communication with these partners throughout the campaign.

Media collaboration: Work closely with the media team to ensure tracking/tagging is in place to enable adequate real-time reporting. Also support the media team in compiling strategy decks when pitching for new clients or new projects.

Managing Tasks & Timelines: Support the team by taking ownership of task lists, project timelines and key client deliverables. Become an expert in the delivery of all elements of a successful media / measurement program.

Qualifications:

  • 1-3 years experience as a data analyst. Experience in a media company or integrated agency is preferable but not necessary.
  • You have a strong desire to build analytical products and provide valuable insights to clients
  • You have a passion for creativity, innovation and to understand the media landscape
  • Ideally have experience working on a range of clients, especially CPG clients
  • Comfortable working at a fast pace and be able to work directly with brand strategy, creative & media teams. We blend teams across disciplines.
  • Comfortable communicating with clients via email/phone, presenting campaign results, and fielding client requests
  • Proficiency in R, SQL and Excel
  • Ideally have experience using Google Analytics, Google Doubleclick and Social platforms such as Facebook and Twitter
  • Experience in the suite of Google Docs / Sheets / Slides is a plus
  • You are a social animal. You like to collaborate with people and work with new technologies to help grow business.

Apply for this opening at http://mekanism.recruiterbox.com/jobs/fk01mov?apply=true