Position:   Data Analyst
Team:  Ipsos MMA
Locations:  New York NY / Norwalk CT / Chicago IL

MMA is a leader in the fast-growing predictive analytics and “big marketing data” space.  We are looking for skilled professionals seeking to work in a dynamic, fast-paced environment with a focus on predictive analytics, client and project management and strategic consulting.  MMA has been a leader in driving innovative analytic solutions for 30 years.  In the past six years MMA has grown over 400% and over 50%.  Candidates need to be able to work and thrive in an evolving, fast moving, growth-oriented business.

About YOu / about the role

You have communication, SQL and ETL development skills.  You will report into the data science Project Manager. This is a client-facing role that will involve:

  • Working closely with our clients and third-party data providers to establish and maintain an understanding of data
    • Maintain data inventories and project schedules by ensuring on time delivery of raw data sources
    • Understand relationships between different sets of data
    • Understand relationships from raw sets of data to processed sets of data
    • Document relationships between distinct raw datasets and that raw data to processed datasets
  • Collaboration with our project teams to ensure data requirements and destinations are well understood and documented
    • Stage and profile raw datasets, identify data anomalies
    • Assist in documenting operations or procedures for data retrieval and processing
    • Understand the desired end state of the processed data and needs/improvements of the raw data to reach desired state
    • Build data review presentations for both internal and external partners
  • Developing ETL scripts using Microsoft technologies including SQL Server and SSIS
    • Courageous development/exploration of automation by recognizing patterns in raw data, or common behaviors in client submittal of raw data
    • Improve internal process for acquiring and staging raw data

You are a data scientist who is strong at both “doing” and collaborating with other members of the team.  You have a passion for working with data and all of the intricacies and issues that come with it.

Key Prerequisite Skills

Qualified candidates should have the following skills:

  • Advanced proficiency with SQL (ANSI or T-SQL) skills
  • Strong internal and external (client facing) communication skills
  • Ability and willingness to write detailed, high quality documentation of complex processes
  • Exploratory data analysis using tools such as Microsoft Excel
  • Ability to identify anomalies in the data, troubleshoot and reconcile
  • Strong organizational skills with the ability to prioritize and execute tasks across multiple projects in a high-pressure environment

desired skills

Candidates with these additional skills are preferred:

  • Experience working with SAS, R or other statistical software packages
  • Experience with emerging distributed data processing systems – Hadoop or similar
  • Experience with Microsoft Access
  • Strong PowerPoint skills

Growth Opportunities

MMA is an established analytic leader and is growing rapidly.   Opportunities for advancement of skilled, committed professionals include:

  • Analytics and Project Management
  • Product Development and Innovation
  • Global Client Management
  • Strategic Consulting
  • Marketing & Business Development

ABOUT IPSOS MMA

MMA is a leading global analytics company that provides Fortune 500 organizations with forward looking, predictive solutions that drives continuous, repeatable and incremental value.  The company was founded in 1989, pioneering the commercialization of marketing mix modelling, and through their innovative analytic methodologies and approaches, management of “big marketing data”, predictive software and high-value consulting, MMA has helped companies generate billions of dollars in incremental returns.  MMA has offices in NYC, Norwalk, CT and Chicago and is a part of leading global custom market research company Ipsos, who has major offices in over 80 locations worldwide.

For more information, visit:   https://mma.com/

If your background and experience is a match, please send your resume to:  Liz.Fleuette@Ipsos.com.