We are in need of a Junior Project Manager. A real Excel wizard. Someone who is crazy organized, excellent at math, understands how to create and generate charts from coded excel documents. This person would assist and report directly to our Creative Accounts Manager. Will be a 6-month gig (to start).
Roles and responsibilities include but are not limited to:
Attend weekly meetings to record information pertaining to the status of each project open for US and DMI
Track projects on a daily basis in Excel and move job bags to appropriate creative, marketing and/or education people
Generate pie and bar charts monthly that show the DMI/US:
YTD Budget for Available Billable Hours
Estimated vs. Actual Costs Briefed by category
Estimated vs. Actual Billable Creative Hours Briefed by category
Management of workflow and schedules to provide 100% visibility of
proposed project timelines to all parties (Global and US)
Assess Creative Team’s workload and assist with prioritization of projects
Management of model rights charts and responsible for delivering image requests to marketing teams
General administrative duties for the Creative Team, including submitting
expense reports and ordering supplies, booking events, etc.