. The role focuses on working with large datasets, transforming HR data into meaningful insights, and building advanced Excel-based reports and dashboards for HR and leadership teams.
Key Responsibilities
Extract, clean, and analyze large datasets from SAP ECC HCM modules.
Work with Infotypes, Employee Central (EC) tables, and InfoSets to create customized HR reports.
Develop and automate Excel dashboards, scorecards, and reporting tools.
Leverage advanced Excel features (VLOOKUP, Power Query, Power Pivot, VBA/Macros, PivotTables, Array formulas, etc.).
Collaborate with HR and IT teams to identify reporting needs and deliver actionable insights.
Perform data validation, auditing, and ensure accuracy of reporting.
Document processes and maintain SOPs for Excel-based reporting.
Must-Have Skills
Expert proficiency in Microsoft Excel (VBA, Power Query, Power Pivot, advanced formulas, dashboards).
Experience with SAP ECC HCM data, including:
Infotypes (e.g., 0000, 0001, 0002, 0006)
HCM EC tables (e.g., PA0001, PA0002, PA0016)
Custom InfoSets and SAP Queries
Strong ability to manipulate SAP HR data into meaningful reports.
Proven experience in building HR dashboards/scorecards in Excel.
Preferred Qualifications
Bachelor's degree in HR, Information Systems, Data Analytics, or related field.
Familiarity with SAP HR reporting tools (Ad Hoc Query, SAP Query).
Exposure to SAP S/4HANA or SuccessFactors Employee Central.
Knowledge of Power BI or other data visualization tools is a plus.
Soft Skills
Strong analytical and problem-solving mindset.
Clear communication skills for explaining data insights.
Detail-oriented, organized, and deadline-driven.
Ability to manage multiple reporting tasks simultaneously.
Job Type: Fixed term contract
Contract length: 12 months
Application question(s):
How many years of experience you have in in advanced Excel work with SAP HCM/ECC data?
How many years of experience you have in Microsoft Excel?
What is your expected salary?
What is your notice period?
* This is a contract position for 12 months. Are you comfortable?
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.