Title: Information Analyst

Location: Remote

Employment status: Permanent, full-time

Salary band: $61,382 - $78,216/year

The Canadian Red Cross (CRC) – one of the most inspirational not-for-profit organizations on this planet and an awardee on the Forbes list of Canada’s Best Employers 2022 is seeking an Information Analyst to join our PS Systems and Projects team.

We are guided by our Fundamental Principles of humanity, impartiality, neutrality, independence, voluntary service, unity, and universality. We help people and communities in Canada and around the world in times of need and support them in strengthening their resilience.

Starting with the hiring process, we are committed to having an accessible, diverse, inclusive, and barrier-free work environment where everyone can reach their full potential. We encourage all qualified persons who share our values and want to contribute to fostering an inclusive and diverse workplace to apply.

The incumbent will collaborate with the People Services (PS) Data Lead, the Information Analyst is a key member of the PS Systems and Projects team. This role is responsible for managing a Smartsheet resource database, maintaining the data within it, and producing critical stakeholder reports and dashboards on PowerBI. This includes compiling and analyzing information, troubleshooting discrepancies, identifying areas for improvement, automating processes where possible, and working with end-users to ensure data integrity and effective information integration in the database. The Information Analyst will use their skills and experience to structure people data and perform periodic audits, maintenance tasks, and adhere to accurate recordkeeping habits.

This role centres heavily on the ability to understand business processes related to resource contracting, hiring, recruiting, training and allocation. It requires the incumbent to engage and relate with stakeholders to understand their business practices and information needs, and to identify and track this data and capture emerging requirements. Additional duties include adhering to data governance practices and standards; providing custom and ad hoc Smartsheet/Power BI reports as needed; and training new users in the use of the Smartsheet management roster and application.

In this role, you will:

Responsibility 1 - Data Management, Visualization and Reporting:

• Develop a strong understanding of the Smartsheet database, how it is used to support operations and reporting, process integration, and the roles that are required to maintain the data
• Maintain system’s integrity via strong understanding of system input, output, and interdependencies and provide guidance and training to end-users responsible for inputs
• Assess and fulfill system change requests, notification needs, or automation requirements
• Ensure system and data integrity
• Build reporting tools and dashboards both in Smartsheet and Power BI to support internal and external reporting requirements
• Ensure reporting of high-quality data to external partners
• Maintain a change request log
• Facilitate, test and support mass data merge/migration efforts
• Engage key stakeholders on system changes and ensures good communication to all impacted system users
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
• Documents business process related to data management as required

Responsibility 2 - Data & Business Process Maintenance

• Conduct regular auditing of data to ensure that key information is populated and follows up with users where information is missing/inaccurate
• Conduct research and keep up-to date on best practices for PS technologies, data analysis and analytics
• Perform periodic system health checks and ensure functionality and features are up to date
• Support daily and weekly system back-ups
• Support stakeholders by maintaining database business process maps, adjustments via change requests and ensuring efficiency / lean approach to overall database management
• Support the business requirements and migration from Smartsheet to future CRM technologies
• Ensures adherence to data privacy requirements

Responsibility 3 - Stakeholder Support

• Process and track access request to ensure adequate level of permissions
• Provide basic onboarding, training and supporting materials to new users of the database
• Basic technical troubleshooting and escalate as required
• Maintain effective working relationships, fostering a client driven, continuous improvement culture
• Support additional projects duties as required

What we are looking for:

• Bachelor’s degree or diploma in Information Technology, Computer Data Science, Information Management, Business Administration or equivalent experience.
• Strong familiarity with the use of Smartsheet & Power BI for data management and reporting, Smartsheet/Power BI certified or willingness to obtain certification within first three months.
• Expertise in data models, database design development, data mining and segmentation techniques an asset.
• Expertise in Excel (macros, pivot and VLOOKUP tables, advanced formulas, charts) is mandatory.
• Knowledge of SQL databases and programming (ETL frameworks) and data visualization tools: PowerBI, Tableau and Bi360 is an asset.
• Knowledge of Taleo Business Edition, MS Dynamics AX, Kronos Time & Attendance, Moodle, Video Capture Utilities, SharePoint, survey applications, Raiser’s Edge is an asset.
• At least 4 years related work experience or an equivalent combination of education and experience.
• Experience migrating, compiling, manipulating, and merging considerable sized datasets.
• Experience in project management, workforce analytics, HR data analysis, data assembly or dashboard design.
• Experience providing services directly to non-technical stakeholders.
• Exceptional organizational, time management, information management, technical and numeracy skills.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Collaborative team workers with ability to effectively develop strong cross-functional working relationships at all levels.
• Strong commitment to skill development and learning.
• Able to provide sound judgment and exercise a high level of confidentiality and discretion while working with sensitive information.
• Effective and comfortable working with vendors to resolve issues.
• Excellent verbal and written communication and interpersonal skills, including ability to train others on use of tools.
• Ability to quickly comprehend opportunities and issues presented from end users, investigate root causes, and offer solutions and insight.
• Ability to work effectively in a fast paced and changing environment with multiple conflicting demands.

Working Conditions:

• Eligibility to work in Canada: At this time, we welcome applications from candidates eligible to work in Canada. If you are not a citizen or permanent resident of Canada, we encourage you to carefully review your visa to find out whether you are eligible to work in the job you are considering applying for. Refer to our FAQ for more information.
• If you are selected for this role, you will be required to complete a successful pre-employment screening process which includes a satisfactory Enhanced Police Information Check (E-PIC).
• Full vaccination against COVID-19 may be requested to participate in in-person activities.

This position is open until filled, however qualified applicants are encouraged to apply as soon as possible. Qualified applicants who apply after the selection process has started, may be held for a second review if needed OR reviewed for alternative roles. We appreciate the time and effort it takes to apply and thank you in advance.

If you require accommodation measures during any phase of the hiring process, please notify us as soon as possible. All information received in relation to accommodation requests will be kept confidential.