Analyst-PS Systems & Data

Posted: July 03, 2020

Region: Ottawa, ON


Do you want to make a difference?

Join the world’s largest humanitarian network. The Canadian Red Cross Society, a not for profit, humanitarian organization dedicated to helping the most vulnerable in Canada and throughout the world, is currently seeking a Human Resources Systems & Data Analyst.

Reporting to the Director, Information Systems & Technology Projects, the Systems & Data Analyst is a key member of the PS Systems team and will work closely with PS leadership and collaborate with Information Services (IS), subject matter experts, technical teams and consultants in the development, testing, deployment and enhancement of various human capital and payroll management platforms.  This role is also responsible for identifying opportunities for system improvement, optimization and process automation.

 Other areas of responsibility include system administration and configuration; end-user support; performing data audits and analysis; and resolving system issues. Additional duties include data retrieval and interpretation; custom report design; dashboard assembly in Power BI; facilitating interface development initiatives; and participating in system implementation and data migration projects.
 


You will Enjoy:

Culture: an organization that is guided by our fundamental principles of humanity, impartiality, neutrality, independence, voluntary service, unity and universality

Flexibility: alternative work arrangements and paid time off for those “life happens moments”

Employee Benefits: comprehensive health and dental plan, pension plan with matching contributions and competitive vacation entitlements

Meaningful Work: you will be making decisions and developing strategy that will create an impact at a global level

 

In this role you will:

Systems & Technology Analysis and Administration                                                                                                                                                                                                                     

  • Responsible for system analysis, maintenance and administration of various HCM and compensation platforms and interface utilities;

  • Ensure system compliance with all legislative, union and business requirements;

  • Liaise with People Services leadership, Information Services, technical teams, vendors, consultants and other stakeholders to troubleshoot and resolve escalated system issues; help define, analyze and validate functional business requirements; and translate those needs into effective system solutions;

  • Develop, organize, and maintain various spreadsheets and systems;

  • Perform periodic system health checks and ensure functionality and features are up to date;

  • Accountable for application enhancements, system and interface development, data process mapping, change testing, and monitoring interface error logs to resolve payroll data transfer issues;

  • Administer system release testing, identify potential impact, establish test groups, execute and validate testing plans and user-acceptance, ensure data integrity and system functionality;

  • Investigate incoming system questions and concerns; and provide analysis or data pertinent to the issue;

  • Manage the employee and volunteer onboarding forms and environment, including the coordination of policy and training material, links and videos presented on self-serve portals and management systems;

  • Remain current on HR system trends, issues and best practices;

  • Evaluate, recommend and implement improvements to existing system processes, procedures, configurations, and functionality to maximize and optimize the use of PS technologies;

  • Communicate new developments, system releases, and enhancement rollouts to people service leadership, partners and compensation teams;

  • Support and contribute to business change initiatives and project implementation support;

  • Maintain an annual roadmap of enhancements and identify additional functionality by taking advantage of new capabilities as they are released.

  • Facilitate, test and support mass data migration efforts;

  • Participate in disaster planning, preparation and response efforts, applying system support as required.

 Reporting and Analytics                                                                                                                     

  • Leverage PS systems to produce meaningful data insights;

  • Design reports and create analytics and dashboards metrics to identify trends, concerns and progress;

  • Prepare monthly, quarterly and annual PS reports summarizing key data into charts and visuals;

  • Effectively communicate key issues and trends and recommend appropriate courses of action based on the results of completed analyses;

  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality;

  • Acquire data from primary or secondary data sources and maintain data systems;

  • Compile, analyze and interpret trends or patterns in complex data sets;

  • Compile, filter and “clean” data from multiple sources for complex table imports;

  • Work with management to prioritize business and information needs;

  • Conduct research and keep up-to date on best practices for PS technologies, data analysis and analytics;

Coaching, Mentoring & Support                                                                                                        

  • Provide system guidance and respond to escalated queries from internal and external clients;

  • Maintain effective working relationships, fostering a client driven, continuous improvement culture;

  • Coach, mentor and support team members in developing the skills needed to perform their roles by leveraging PS technology use and functionality;

  • Identify training gaps and needs, developing opportunities and ensuring team members are knowledgeable and capable of navigating PS technologies;

  • Offer system input, guidance and direction to the People Services team;

  • Conduct system ‘train the trainer’ sessions and offer advanced internal instruction on HCM and compensation administration functionality to PS, Total Compensation and Transformation & Technology staff;

  • Coach team members to resolve technology issues identified across all PS platforms;

  • Provide second level support on complex system escalation issues;

  • Author advanced training and administrative ‘how-to’ instruction material as required;

  • Contributes to a healthy and safe working environment;

  • Performs other duties, as required.

     

We are looking for somebody with:

Education and experience

  • Bachelor’s degree or Diploma in Information Technology, Computer Science, Finance, Business Administration or equivalent experience

  • A minimum of 5 years’ experience in HR or compensation technologies

  • Human Resources (CHRP) or Payroll Accreditation (CPP) or working toward certification an asset.

  • Experience investigating, analyzing, testing and implementing system applications

  • Experience migrating, compiling, manipulating, and merging considerable sized datasets

  • Experience in workforce analytics or data analysis a considerable asset

  • This position requires a satisfactory Canadian criminal record reference check.

Knowledge and Skills

  • Strong report writing and design capabilities using different HR technologies

  • Knowledge of the principles, concepts, standards, methods and techniques of HR business metrics and analytics—including interpretation

  • Knowledge of Microsoft Suite of products

  • Expertise in Excel (macros, pivot and VLOOKUP tables, advanced formulas, charts) is mandatory

  • Knowledge of SQL databases and programming (XML, Javascript, or ETL frameworks) is a definite asset

  • Expertise in data models, database design development, data mining and segmentation techniques an asset

  • Knowledge of statistics and statistical packages for analyzing datasets (Excel, SPSS, SAS etc) an asset

  • Knowledge of data visualization tools: PowerBI and Bi360

  • Proficiency with Taleo Business Edition, MS Dynamics AX, and Kronos Time & Attendance is a definite asset

  • Knowledge of Moodle, Video Capture Utilities, SharePoint, survey applications, Raiser’s Edge.

  • Solid understanding of core HR processes including benefits, payroll, recruitment & on-boarding, time and attendance tracking, employee life-cycle maintenance

  • Fluency in written and spoken English

  • Fluency in French an asset

 

CRC Core competencies

  • Accountability: respects, inspires trust, is dependable, and uses judgment;

  • Team excellence: adapts, demonstrates commitment, collaborates and builds relationships;

  • Results focused: plans and organizes work, is goal/task oriented, is solution oriented, focuses on continuous learning;

  • Service excellence: is service oriented;

 

Working conditions

  • The majority of the work is performed remotely.

  • May, on occasion, be required to work non-traditional hours.

  • Collaboration within a virtual team.


The Canadian Red Cross is committed to gender equality and social inclusion in our workplace. All qualified applications will receive consideration without regard to sex, gender identity, gender expression, sexual orientation, race, ethnic origin, color, religion, nationality, disability, age, or any other characteristic protected by applicable law. We encourage all qualified persons to apply particularly Indigenous peoples, persons with disabilities, ethnic minorities, visible minorities, and others who share our values and contribute to fostering an inclusive and diverse workplace.

Please notify us as soon as possible of any adaptive measures you might require at any stage of the recruitment process.
 

Click here to apply