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 ORBachelor's degree and 3 to 5 years of HR IS experience ORDiploma and 7 to 9 years of HR IS experience5 years minimum experience Microsoft Excel, including Pivot tables / charts3 years minimum advanced experience programming in VBA for Excel3 years minimum experience Workday Advanced Reporting and Microsoft Windows OS1 year minimum previous experience of structured programming language other than VBA1 year minimum of Workday WorksheetsAdvanced VBA programming skillsAdvanced functions capability in ExcelExperience with ServiceNow and JIRA case managementExperience working in an agile environmentPreferred Qualifications :
Soft
Skills :
Excellent analytical and troubleshooting skillsStrong verbal, written communication and presentation skillsAbility to work effectively with global, virtual teamsStrong technical acumen, logic, judgement and decision-makingStrong initiative and desire to learn and growAbility to manage multiple priorities successfullySolid understanding of databasesConsultative approach (Presenting ideas, demonstrations, explaining complex functionality, developing ability to influence)Exemplary adherence to ethics, data privacy and compliance policiesSkills Required
Jira, Servicenow, Pivot Tables, Hris, Vba, VBA programming