Job Description

About the job
The Mars Agency is an award-winning, independently owned global commerce marketing practice with a growth-for-clients focus. With talent spanning the Americas, Europe and Asia, we create breakthrough, connected commerce solutions by balancing the smartest humanity with the latest technology. The agency’s latest MarTech platform, Marilyn®, is the industry’s first and only end-to-end commerce advisor.

We’re looking for a Junior Analyst to work in a hybrid remote capacity from Detroit. The Junior Analyst plays a critical role in all aspects of analytic client engagements. As part of the integrated team, the Junior Analyst engages in analytic project planning, preparing and analyzing data, generating reports, and making action-oriented recommendations to help move our clients business forward. The ideal candidate must be able to proactively communicate ideas and opportunities, execute with a high level of accuracy and demonstrate strong project management skills.

What You’ll Do:

Contribute to the development of the Performance Analytics capability for the agency
Work closely with cross-functional agency and client teams to define analytic needs and recommend methodologies with the ability to execute independently
Develop a strong partnership with the agency Data Scientist to support the needs of Shopper Marketing Mix Modeling
Implement a data automation workflow to cleanse and prepare data
Collaborate with internal partners to improve work flows and data quality within defined areas
Implement a data visualization process to aid in the data quality checking process
Synthesize data from a variety of sources including IRI, ACNielsen, media, customer specific POS, shopper loyalty databases, consumer research and category management tools to identify and prioritize business-building opportunities
Perform data hygiene and recoding as necessary
Both assist in the creation of, and owning the creation of client-ready reports with a focus on visual story telling
Automate labor intensive data processing routines to drive efficiency

Skillsets Required:

Bachelor’s degree
Minimum of 1-3 years of experience working with data; experience in consumer marketing, retail and CPG industries a plus
Passion for data and analytics and the value of data driven decision making
Ability to tell a visual story that leads to results and decision making
Detail orientated with the ability to handle multiple clients and projects simultaneously
Ability to work proactively and efficiently with a very high level of quality
Team player with strong relationship building, communication, and presentation skills
Knowledge of digital and/or marketing analytics preferred but not required
Experience working with IRI or Nielsen data preferred
Strong Microsoft Office Suite (Word, Excel and PowerPoint) skills
Strong experience with Tableau, PowerBi, or any similar data visualization tools
Experience in SQL, Python, and R is a plus
A ‘Clients First’ approach to everything you do. We work for and on behalf of our clients and always produce the very best results we possibly can

The Mars Agency is an Equal Opportunity Employer and will recruit, hire, train and promote persons in all job classifications without regard to race, ancestry, creed, color, sexual orientation, gender identity, age, national origin, disability or handicap, HIV, veteran, marital or family status, or any other status or condition protected by applicable state and/or federal laws, except where a bonafide occupational qualification applies.

The Mars Agency has developed a wide variety of inclusive benefit plans and policies that address and promote the needs of all employees and their family members, including comprehensive group health plans, a parental leave program that includes paid maternity and paternity benefits for pregnancy, adoption and surrogacy, flexible paid time off, a broad and confidential employee assistance program, ongoing wellness support initiatives, trusted financial health advice and guidance, promotion of education through tuition support and assistance, and a flexible and supportive work environment and culture.