location / New York, New York
date posted / 01/20/2017
job description / Analyst, MRM//McCann

Core Duties/Responsibilities


                                                 Job Title: Analyst

Position: Analyst

Focus: Digital Analytics and Business Intelligence



  • Learn the existing client data architecture for social, add new sustainable datasets to the ecosystem using APIs and SQL based on social business specifications
  • Leverage SQL, database knowledge and meticulous attention to detail to QA data
  • Relentlessly pursue data quality and standardization with a focus on exceeding all client and partner expectations, building relationships with the business
  • Understand data visualization and build visuals to tell stories with social data
  • Translate requirements for campaigns and programs into API and database technical requirements
  • Prepare and present client-facing deliverables on a regular basis
  • Collaborate with larger reporting team to provide quantitative and qualitative campaign reporting to provide ongoing optimizations and overall effect on paid and organic social initiatives
  • Support day to day database administration
  • Have the ability to pivot and change priorities very quickly, reacting and adapting to digital platform changes and ensuring data flows properly for social requirements


Required Skills/Knowledge/Experience


  • B.A. in Statistics, Mathematics, Computer Science, Economics or a quantitative degree in another social science
  • 1-2 years of experience with Performance Analytics
  • Knowledge and experience with one or more of the following:
    • Databases Management
    • Data modeling
    • Database architecture
    • ETL Processing
  • Experience with one or more of the following:
    • SQL
    • SAS
    • SPSS
    • Applied Statistics
    • API Connections and Querying
    • Business Intelligence Platforms: Tableau, DOMO, Birst, Microsoft Power BI, etc
    • Social Analytics (Facebook Insights, Facebook Ads, Twitter Analytics, Twitter Ads), Web Analytics(SiteCatalyst, Google Analytics, Omniture, WebTrends) and digital media analytics (Doubleclick, Atlas)
  • Strong attention to detail, analytical skills and data integrity with solid foundation in statistical techniques
  • Sense of urgency and large desire to satisfy partners and clients



MRM//McCann is committed to being the most relevant, effective, indispensable marketing agency in the digital world. We are a leading Customer Experience Agency that puts people first. We employ the most innovative talent in the industry to meet each client’s unique challenges with positive, measureable results. Our strategic, creative and technological expertise-including deep experience with segmentation, targeting, and analytical tools and methodologies- deliver the most effective marketing programs and platforms in the world.


We love our diverse workplace! MRM//McCann is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national or ethnic origin, disability, marital status, veteran status or any other occupationally irrelevant criteria.