Project Coordinator I (Non-It)

Max Bill Rate: ***
Location: Lake County - Hybrid Position: Onsite M, T, Thur; Remote is Wed and Fri
Contract: 1 year - based on performance and business needs
Dermatology Project Coordinator/Analyst
Role: A dedicated Project Coordinator/analyst to serve as the marketing/brand liaison between the field, marketing and logistics vendor as it relates to Dermatology Peer-to-Peer Marketing.
Key responsibilities will include:
Program and Speaker Analytics:
Work with the logistics vendors, CA&O and the marketing team to analyze raw data in order to develop and create weekly reporting that will include, but not be limited to: speaker utilization, program attendance, program cancellations, salesforce data for Field and Marketing leadership team on a weekly basis.
Speaker Contracting:
Point of Contact (POC) with logistics vendor in the processing to onboard or re-contract a speaker. Responsibilities include acceptance of the candidate's CV, monitoring of rates for appropriate FMV (fair market value), collaboration with logistics vendor and compliance department to execute contracts and rate re-evaluation requests as needed and manually submit into system for approvals as needed.
Communicate with field regarding status of bureau and follow up
Field Liaison:
POC for the field regarding weekly P2P communications, speaker recommendations, speaker status, speaker caps, and any questions regarding overall Peer-to-Peer programming processes and requirements. edited
Speaker Liaison:
POC for the field and/or logistics vendor for transactional issues, i.e., contracting, travel logistics, etc. Occasional communication with speakers may be necessary on behalf of the brand team for questions outside the scope of logistics vendor or field responsibilities.
Logistics Vendor Liaison:
Work closely with the logistics vendor as the POC for speaker communications, speaker budgets / speaker FFS Cap Management, Speaker Handler Lists, Speaker Portal Updates, Speaker Contracting, Speaker Bureau Management, Submissions for Presentation Detail Approvals, review of weekly program reports and program management.
Program Materials:
Manage speaker program associated print inventories with vendor partners. Review approval extension list from promotional coordinator, consult with marketing and update deck status. Partner to develop and route ancillary program materials (Product Theater invites, schedules, Field Materials etc.).
Commercial Operations / Field Operations Liaison:
Work directly with Field Operations to help align marketing driven initiatives for Speaker Programs operational capabilities and compliance guardrails. Partner with Field Ops when necessary to manage logistic vendor support and project priorities, identify new improvements and define processes within the digital survey team.
Brand Liaison:
Assist Marketing in providing updates to the field regarding program activities, speaker engagements, speaker program feedback/analytics, speaker utilization and compliance status. Collaborate with Area Marketing Managers as needed for management of reserving speaker programs, speaker caps, contract status and fair market value.
Technical requirements:
High level of proficiency at Excel at an intermediate-high level (VLOOKUP, INDEX/MATCH, PivotTables/PivotCharts, customize graphs with raw data, creating a weekly dashboard).
Attendance at internal *** meetings, including National Sales Meetings, Speaker Training, and brand tactical planning meetings as necessary.
Education: Bachelors desired, any major
Position Title: Derm P2P Project Coordinator/Analyst
# of Positions 1
Length of Contract: 1 years - although this is too complex to hire and train again in 12 months...
Tentative Start date: January 1 2024
End date: December 31 2024 (Candidate should be prepared for 2 year position)
Location/Site: ABV1, degree of remote allowed (Hyrbid Schedule - 3 days onsite / 2 remote)
Legacy Affiliation: ***
Max Bill Rate Requested: ***
Description Details:
1. Are you open to look at candidates willing to relocate? Can't see why we'd need to look outside of IL for this position but if someone is already moving here then yes. We will not pay for relocation
2. What are the top 3-5 skills requirements should this person have?
Strong knowledge of Excel and spreadsheets; proficient at an intermediate level (VLOOKUP, INDEX/MATCH, PivotTables/PivotCharts, customize graphs with raw data, creating a weekly dashboard).
Ability to analyze, summarize and present data to small groups
Organizational skills with strong ability to multitask projects
Understanding of and ability to meet deadlines through prioritization
3. What is a nice to have (but not required) regarding skills, requirements, experience, education, or certification? Ability to stay calm under pressure; sense of humor is pretty key with the team
4. What type of environment is this person working in?
o Combination of team and independent
o Team
o Independent
5. Work Schedule (Define days,# of hours)/ Is Overtime offered or required? If yes, how many hours, what impact to scheduled working hours? M-F 40 hours/week. Occasional evening hours depending on projects
6. Does this position offer the ability to work remotely on a regular basis or is it an on-site role? If remote opportunity exists, what are the options (i.e. 1 day remote, 4 days on-site) Derm is onsite M, T, Thur; Remote is Wed and Fri
7. Is the worker onshore or offshore? Onshore
8. Will there be Domestic and/or International Travel? In 2024 potentially a small amount of domestic travel, no more than 2-3 trips. I'd like them to visit MEI in Evansville IN for training