Junior HR Analyst – Excel & Reporting
Location: West Vancouver, BC
Duration: Approximately 3 months (contract)
Schedule: Monday to Friday, 37.5 hours per week
About the Opportunity
We are looking for a detail-oriented Junior HR Analyst to support a large healthcare organization in West Vancouver, BC.
This role focuses primarily on Excel reporting, data analysis, data extraction and data accuracy.
You will work with large datasets, prepare reports and help maintain accurate workforce information.
Previous HR experience is not required. Candidates with strong Excel, reporting and data analysis skills from other industries are encouraged to apply.
Key Responsibilities
- Extract, organize and analyze data from HR and business systems.
- Create and maintain Excel spreadsheets, reports and tracking tools.
- Work with large datasets to identify trends, errors and inconsistencies.
- Use pivot tables, VLOOKUP, XLOOKUP and Excel formulas to analyze information.
- Prepare regular and ad hoc reports for management.
- Review and validate data to ensure accuracy and completeness.
- Investigate and resolve reporting discrepancies.
- Maintain accurate records and confidential employee information.
- Support improvements to reporting processes and data quality.
What We're Looking For
- Strong Microsoft Excel skills – must have.
- Hands-on experience with pivot tables, VLOOKUP, XLOOKUP and formulas.
- Experience extracting, cleaning and analyzing large datasets.
- Experience preparing reports and maintaining spreadsheets.
- Strong attention to detail and ability to identify data errors.
- Good analytical and problem-solving skills.
- Strong communication and organizational skills.
- Ability to work independently and meet deadlines.
- Comfortable working with confidential information.
Nice to Have
- Experience in HR reporting or workforce analytics.
- Knowledge of PeopleSoft or other HR systems.
- Experience creating dashboards or operational reports.
- Previous experience in healthcare, government or the public sector.