Specialist Business Analyst - Training Projects (JP4873)
Thousand Oaks, Ca.
24 months with possible extension
Global HCC Policy, Training & Communication
3Key Consulting Inc. is looking for Specialist Business Analyst
with 3 - 5 years’ experience in managing training projects, experience in Health Care or related industries, and intermediate to expert level proficiency in Microsoft Excel, for a global, CA-based, bio-pharmaceutical company.
Ideal candidate: Looking for a team player willing to take on new challenges, who has great analytical and vendor management Skills. The individual should be strong in Excel, SharePoint 365 and highly self-sufficient in these two systems . 3+ years' experience managing training projects, experience in Health Care or related industries, Intermediate to expert level proficiency in Microsoft Excel (Pivot tables, Excel formulas: VLOOKUPs, Match, IF AND statements) and SharePoint (Creating forms and relational tables). Other systems proficiency needed for the job are Outlook, Word and using BOX on a daily basis.
As a member in Policies, Training and Communication, this individual will lead the day to day management of Amgen’s third-party training including tracking of training activities, New vendor review (SIF Process), Code of Conduct Exclusions, reporting and review of CW’s staff processed outside of the primary MSA vendor. Other activities include vendor training notifications, exemptions and working as the liaison between management and third-party points of contact and the vendor used to host the training platforms. This individual will participate and drive automation and process improvement within the current defined processes. This individual will require strong vendor management and advanced Excel skills to be considered a resource for the broader team to assist on department goals.
Must Have Skill Sets:
Day to Day Responsibilities:
- Advance Excel skills (V-lookups)
- SharePoint skills preferable SharePoint 365
- Proven experience managing external vendors.
This position is a very tactical role with a lot of excel use. The day to day requirement for this individual will be to pull training reports, slice and dice the report for overdue users using Excel formulas. Use SharePoint relational table to send training reminders on a daily bases. Must be able to troubleshoot the SharePoint relational tables if there are issues. Manage team’s training mailbox and work with our external suppliers on all training needs.
Employee Value Proposition:
Resume with no proven analytical experience and or SharePoint experience (previous SharePoint version experience is fine as 365 is new). Resume that does not show tactical experience in Microsoft Excel will be a red flag.
We are looking to fill this position as soon as possible. Interview will entail a phone interview and in person interview on site (this will include a mini Excel quiz on lookups)
We invite qualified candidates to send their resume to email@example.com. If you decide that you’re not interested in pursuing this position, please feel free to look at the other positions on our website www.3keyconsulting.com. You are welcome to also share this posting with anyone you think might be interested in applying for this role.