Client Data Analyst II

Mosaic is a leading North American Integrated Agency, specialized in connecting with consumers through Experiential Marketing, B2B, Sales & Merchandising, and Shopper Marketing. At Mosaic, we are never satisfied with the status quo and are in constant search for new ideas and new ways to help our clients build their brands amidst the evolving dynamics of empowered consumers and leveraging new technologies.

The Client Data Analyst II (analyst) position is responsible partnering with our clients and teams to drive their initiatives with strategy, analytics and actionable insights, optimizing program measurement to drive field team success, and constantly engaging with the team to better understand where they can have the greatest impact. The analyst will leverage business and market relevant information to make data-driven decisions that allow Mosaic to achieve its sales and marketing objectives and quickly adapt tactics. The analyst will play a key role in evolving, leading, and growing the data-driven discipline within the program they support.

The Incumbent(s) in this position should exhibit the following values:

People Minded – Must show dignity and respect to all people

Integrity – Must exemplify the highest degree of ethical behavior

Results Oriented – Must show passion, pride and commitment to succeed

Trust – Must be honest, sincere and confident

Teamwork – Must build trusting relationships

Innovation – Must progress through a combination of creativity, common sense and vision

Balance – Must maintain an optimistic attitude and keep perspective on what is important in life

Responsibilities:

• Collect, inspect, cleanse, transform, model and diagram of complex data sets
• Daily use of various business intelligence and analytical software tools
• Interpret data, formulate reports, and make recommendations to the team
• Design or collaborate on specific research methods such as questionnaires and market testing approaches (A/B testing, multi-variate, etc)
• Remain fully informed on market trends, other parties research and implement best practices with a willingness to evolve and grow skillset
• Leading the standardized measurement first strategy for clients and team leaders
• Report and present findings, including recommendations for go-to-market strategy
• Remain fully engaged in the program, understanding strategic vision, key performance indicators, and the day-to-day tactical activities
• Regularly attend client and internal team meetings, and in-field ride alongs to stay in tune with program activities
• Creating and maintaining data management strategy for internal data sets, focusing on efficient ETL processes.
• Other assigned duties

Qualifications:

• Remain fully informed on latest marketing and data trends, practice, and process
• 3-5 years of related work experience
• 1-2 years of project management experience
• Intermediate (advanced is ideal, not required) Microsoft Excel or Google Sheets skills including formulas, pivot tables, V-look-up
• Fundamental data architecture and design skills
• Intermediate knowledge of SQL and strong data transformation skills
• Intermediate statistical analysis skills; experience with SPSS, Python, R, or other stats software
• Intermediate PowerBI or Tableau skills; other data visualization platform skills a plus
• Ability to tell a relevant, powerful story with data that matters to clients
• Ability to lead research activities including developing a plan, collecting data, and taking action
• Ability to execute standard measurement strategies within a project
• Strong analytical and critical thinking with the ability to disseminate insight from large datasets
• Develop understanding of all areas phases of Mosaic business to find new opportunities for insights, measurement and analytics
• Proven ability to timely complete projects and achieves results in an ambiguous work environment