Associate Analyst, Data Analytics

CMI Media Group has a passion for innovation in the pharmaceutical and healthcare industries. We use that passion to help leading organizations that are dedicated to improving the health of our society achieve their business goals by creating experiences that inform, educate, and stimulate behaviors that improve the quality of life.

The Associate Data Analyst is responsible for monitoring and organizing the day-to-day data operations related to advertising campaigns for assigned clients. Services include target list matching, collation of data for performance reports, data ingestion and extraction, cleansing, organization and visualization, as well as campaign monitoring.

Primary Accountabilities 

Generate campaign performance reports for assigned brands. Tasks include, but are not limited to:

• Extract and organize data from multiple internal and external data sources and platforms.
• QA, organize, and create visualization of data based on provided measurement plans.
• Monitor inbound data receipt, identify and troubleshoot any issues or missing data, and follow up with Supplier Partners and other internal teams.
• Proactively identify and resolve issues that arise including reporting discrepancies, data inaccuracies, and report visualization changes.
• With assistance, analyze reports and provide any observations to the Business Insights team.

Regularly monitor all live campaigns. Tasks include but are not limited to:

• Ensure proper serving, click through action and conversion events.
• Review monitoring reports and communicate any unusual activity related to non-human. trafficking, advertising blocks or alerts, viewability, and invalid traffic.

Coordinate day-to-day operations of list match services, including, but not limited to:

• Conduct regular campaign list matching requests.
• Upload Client target lists as requested.
• Scrub target lists for removal of “opt-out” physicians as requested.
• Export target buy lists to meet client requests.
• Coordinate all ad hoc list match requests.
• Troubleshoot target- list related issues as they arise.
• Ensure compliance with confidentiality protocols as they relate to data transfers. 

Maintain and build relationships with key customers and partners.

Success Factors 

• Thorough knowledge of our datasets and how they tie together
• Ability to work fairly independently on assigned tasks
• Demonstration of proactivity
• Completion of tasks with minimal error

Requirements 

• Advanced knowledge of Microsoft Excel and PowerPoint
• Strong analytical and mathematical skills
• Keen attention to detail, organization, and strong follow up skills
• Ability to manage deadlines and multiple/simultaneous competing projects/initiatives
• Excellent teamwork skills
• Self-Motivated
• Willingness to learn and adapt to a changing environment
• SQL/Python/R experience or coursework a plus
• Tableau, or similar visualization tools, experience or coursework a plus

The base salary for this position at the time of this posting may range from $35,000-$65,000. Individual compensation varies based on job related factors, including business needs, experience, level of responsibility and qualifications. We offer a competitive benefits package, please visit https://www.wpp.com/people/wellbeing/benefits-at-wpp-in-the-us for more details.