Entry Level Excel Pivot Table Jobs in Chicago, IL

Company Description

PHM is the leading health media agency in the US. We are designed for-and dedicated to-delivering best-in-class solutions that connect people with meaningful health and wellness solutions every day. Guided by our genuine passion for health and wellness, our work across the entire media ecosystem helps real patients navigate the most pivotal moments of their healthcare journeys.

While we have grown to be the No. 1 agency in our industry, at heart we're still a startup. It's that energy and spirit of innovation that allows us to create bold and meaningful "health media firsts" for our clients, and to do it all with #phmlove.

Overview

The Paid Social Sr. Associate is responsible for planning and managing paid social tactics for assigned clients. The primary function of the Sr. Associate role is to have a deep understanding of client goals, monitor campaign quality, and consistently and proactively evaluate new opportunities to maximize performance.

Responsibilities

• Understands the relationship between paid, owned, and earned social media tactics
• Deep understanding of social media platforms such as Meta, Twitter, Linkedin, Snap, TikTok, Pinterest, Reddit, etc.
• Intermediate level understanding of Excel functions (ie. VLook-up, Pivot Table, chart building) and PowerPoint
• Monitors the latest trends in social media, including advertising formats, channels and technologies in order to improve campaign performance and provide recommendations on how clients can best leverage new tools and services
• Familiarity of monitoring campaign financials, budgets, and processing invoices
• Drives decisions around campaign architecture and setup
• Proactively identifies optimization opportunities; tracks and analyzes results
• Pulls platform data & prepares reports for clients including campaign analysis
• Monitor and update pacing documents to planned campaign budgets while maintaining performance goals
• Participates in client and creative agency communications: attends meetings, produces high-quality client deliverables, fields questions as they relate to paid social media campaign details including performance
• Grows partnerships with key vendors
• Trains Paid Social Associate(s) & manages Associate-level delegation, workflows and timelines
• Partners with Supervisor to coach Associate-level employees and responsible for Associate's career progression

Qualifications

• Exhibits integrity and trust
• Adherence to agency procedures and processes
• Proficiency in computer skills used to manage day-to-day workflow (e.g., Microsoft Office Suite)
• Ability to multi-task, manage one's time, and demonstrate personal organization and ability to meet deadlines

• Bachelor's degree required
• 3 years biddable social media campaign management experience
• Healthcare industry knowledge a plus
• Meta Blueprint Certification desired

Additional Information

Our Publicis Groupe motto "Viva La Difference" means we're better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com.

Compensation Range: $59,850 - $82,740 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 10/03/2025.

All your information will be kept confidential according to EEO guidelines.

#LI-BB1

#DNI

 Compensation Range: USD $ - . This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 6/30/2025.Employment Type: OTHER