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.

DATA ANALYST

Locations:            New York, NY

MMA is searching for a Data Consultant with communication, SQL and ETL development skills for a position in our New York, NY office.   This position will report into the Senior Director of Data Management.  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
  • Understand relationships between different sets of data
  • Understand relationships from raw sets of data to processed sets of data
• Collaboration with our project teams to ensure data requirements and destinations are well understood and documented
  • 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
• Developing ETL scripts using Microsoft technologies including SQL Server and SSIS
  • Includes both structured ETL development and exploratory development of automation through recognizing patterns in raw data, and common attributes of semi structured client submitted data

The ideal candidate will be strong at both “doing” and collaborating with other members of the team

We’re looking for candidates who have a passion for working with data and all of the intricacies and issues that come with it. If that sounds like you, we’d like to hear from you!

SKILL REQUIREMENTS

MMA has been a leader in driving innovative analytic solutions for 30 years. MMA has grown every year for the past decade – more than 400% overall.  Candidates need to be able to work and thrive in an evolving, fast moving, growth-oriented business.

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

Candidates with these additional skills are preferred:

• Experience with Tableau
• 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:

• Data and Project Management
• Analytics and Project Management
• Product Development and Innovation
• Global Client Management
• Strategic Consulting

ABOUT IPSOS MMA

MMA is a leading global analytics company that provides Fortune 500 organizations with forward looking, predictive solutions that drive 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.   

The salary range for this role in New York, NY is $60,000 to $125,000. Your final base salary will be determined based on several factors which may include but are not limited to location, work experience, skills, knowledge, education and/or certifications. 

 #LI-AB1 #LI-onsite

Required Skills Required Experience

• Proficient in discipline specific design software (GEOPAK and/or OpenRoads)
• Proficient in Microsoft Office
• Written and oral communication skills