Senior Associate HR Data Analysis VBA

Amgen is seeking a Sr Associate HR Data Analysis for the VBA Reporting and transformation which rolls up to HR Systems & Solutions. The successful incumbent will act in a capacity to gather business requirements, design, develop and test, then deliver solutions for HR and Managers. You will work directly with clients to effectively research, troubleshoot, and resolve HR data requests and issues by using VBA, Excel and other data transformation tools.

• Candidate will transform HR data by using advanced VBA coding language
• Run existing reports using VBA transformations and audit the results to ensure accuracy
• Candidate will have the technical ability to seek code optimization techniques while following documentation standards
• Implement Excel optimization techniques and performance improvement strategies while leaning on previous experience with web resources for VBA learning
• Must be able to work independently and willingness to own the project, suggest improvements or strategies or even alternatives
• Strong programming collaboration skillset
• Balance concurrent projects that require inputs from cross-functional partners while managing expectations and impact on end users.
• Deliver reports while taking advantage of Workday best practices to ensure consistent data definition and interpretation.

What we expect of you

We are all different, yet we all use our unique contributions to serve patients.

Basic Qualifications:

• Master's degree and 1 to 3 years of HR IS experience OR
• Bachelor's degree and 3 to 5 years of HR IS experience OR
• Diploma and 7 to 9 years of HR IS experience
• 5 years minimum experience Microsoft Excel, including Pivot tables/charts
• 3 years minimum advanced experience programming in VBA for Excel
• 3 years minimum experience Workday Advanced Reporting and Microsoft Windows OS
• 1 year minimum previous experience of structured programming language other than VBA
• 1 year minimum of Workday Worksheets
• Advanced VBA programming skills
• Advanced functions capability in Excel
• Experience with ServiceNow and JIRA case management
• Experience working in an agile environment

Preferred Qualifications:

Soft

Skills:

• Excellent analytical and troubleshooting skills
• Strong verbal, written communication and presentation skills
• Ability to work effectively with global, virtual teams
• Strong technical acumen, logic, judgement and decision-making
• Strong initiative and desire to learn and grow
• Ability to manage multiple priorities successfully
• Solid understanding of databases
• Consultative approach (Presenting ideas, demonstrations, explaining complex functionality, developing ability to influence)
• Exemplary adherence to ethics, data privacy and compliance policies