Junior Analyst
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.
#dp
#LI-EG1
#LI-Hybrid