Job Description

Job Type:

Contract

Experience:

8+ years in advanced Excel work with SAP HCM/ECC data

---

Job Summary:

We are seeking a highly experienced Microsoft Excel Expert with deep hands-on expertise in working with large datasets from SAP ECC, specifically within the SAP HCM domain.

The ideal candidate will have a strong grasp of HCM-related tables, InfoSets, and SAP reporting tools, and will be responsible for transforming complex data into actionable insights using Excel's advanced capabilities.

---

Key Responsibilities:

Extract, clean, and analyze large datasets from SAP ECC, especially from SAP HCM modules.

Work with HCM infotypes, Employee Central (EC) tables, and custom InfoSets to generate HR reports.

Create and automate advanced Excel dashboards, reports, and models based on SAP HCM data.

Use advanced Excel features such as If, Vlook up, H Look up, Power Query, Power Pivot, VBA, Macros, Array formulas, PivotTables, Conditional Formatting, etc.

Partner with HR and IT teams to identify reporting needs and deliver customized Excel-based solutions.

Perform data validation, cross-checking, and auditing to ensure accuracy and consistency.

Translate complex SAP HR data into readable formats for senior management and stakeholders.

Support integration of Excel reports with other data visualization platforms or HR tools if needed.

Develop SOPs and documentation for Excel report generation from SAP data.

---

Must-Have Skills:

Expert-level proficiency in Microsoft Excel (If, Vlook up, H Look up, Power Query, Power Pivot, VBA, Macros, Array formulas, PivotTables, Conditional Formatting, Advanced Formulas).

Strong experience working with SAP ECC HCM data, including:

o Infotypes (e.g., 0000, 0001, 0002, 0006, etc.)

o HCM EC tables (e.g., PA0001, PA0002, PA0016, etc.)

o Time and Payroll data (optional but preferred)

o Custom InfoSets and SAP Query development

Ability to extract and manipulate data from SAP (directly or via data dumps, reports, or interfaces).

Experience in building Excel dashboards or HR scorecards using SAP data.

---

Preferred Qualifications:

Bachelor's degree in Human Resources, Information Systems, Data Analytics, or related field.

Familiarity with SAP HR Reporting Tools (Ad Hoc Query, SAP Query, SQ01/SQ02/SQ03).

Knowledge of SAP Success Factors also will be an advantage.

Knowledge of SAP S/4HANA and SuccessFactors Employee Central (EC) is a strong plus.

Exposure to Power BI or similar reporting tools is a plus.

---

Soft Skills:

Strong analytical, critical thinking, and problem-solving abilities.

Excellent communication skills to translate data insights for HR/business audiences.

Self-starter with attention to detail and a high standard of quality.

Ability to manage multiple reporting demands and meet tight deadlines.

Job Types: Full-time, Fixed term contract
Contract length: 12 months

Schedule:

Monday to Friday
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? Are you a Canadian citizen or having a work permit? Please specify Are you comfortable working from office in Toronto? This is a contract position for 12 months. Are you comfortable?
Work Location: In person