Data Analyst
At Heart & Stroke our mission is to promote health, save lives and enhance recovery. We are committed to a culture that exemplifies our core values: champion health, practice humility, embrace change, drive impact, learn and grow and be heartfelt as we work together to beat heart disease and stroke.
We believe in equity, diversity and inclusion ― it’s embedded in our values and core mission work to support all people in Canada to lead healthier lives. We are committed to applying this principle to cultivate a welcoming environment that embraces diversity among our employees. Candidates from diverse backgrounds, including but not limited to, Indigenous peoples, racialized communities, 2SLGBTQIA+ communities, women, and people living with disabilities are encouraged to apply.
To learn more about our mission, values, commitment to EDI, and the difference Heart & Stroke makes in the lives of people in Canada at every age, please visit our website
The opportunity
This is a 12-month contract and remote working role.
Candidates can work from anywhere in Canada.
Reporting to the Senior Manager, Software Development, the Data Analyst is responsible for data analysis and reporting from Heart and Stroke Constituent Relationship Management System (CRM). The position will work closely with the internal business partners to gather criteria to build data extractions and data lists. In addition, the Data Analyst will work on data processes such as data integration, data clean up, data analysis, segmentation and other project activities. The position will focus on building a range of data outputs from ad-hoc queries, data exports using Microsoft SQL server tools and data warehouse solutions.
The role will collaborate within a multi-site team setting with a variety of stakeholders, including internal business partners and external vendors and suppliers.
How you will make an impact every day
Data Analysis and Reporting
Design, develop and deploy data outputs and reports using SQL Server Reporting Services and BI tools
Ability to take raw data and provide summary analysis
Develop automated and reusable routines for extracting requested information in suitable formats such as extractions, reports, graphical, and pivots
Perform data testing to ensure data accuracy and completeness
Provide accurate estimate delivery time for solution to business partner
Data Validation
Compiling, sorting and verifying data before it is imported into CRM database
Troubleshoot and correct data upload and exceptions due to inaccuracies
Provide end user support and work with external vendors to troubleshoot and resolve issues
CRM Administration
Coordinate with external vendors to develop, setup, execute data transfer processes and improve the efficiency
Assist in CRM configuration, set up, and development of standards as necessary
Monitor scheduled jobs - status, investigate , troubleshoot and resolve issues to completion
Perform end to end testing for system upgrades, application patches, customizations, and other features as necessary
Other
Contribute to system process improvement effort
Document and maintain data requests, processing and data validation procedures
Prepare and maintain appropriate documentation related to technical versioning and best practices knowledge
Deliver solutions according to Systems Development Life Cycle (SDLC)
As necessary, conduct specific training as needed.
Keep well-informed of trends and best practices in the BI industry to strengthen organizational and technical knowledge as it relates to enterprise information
Who we need
Education
Bachelor degree or college diploma in computer science, information systems, business administration or related field
Experience
3+ years working experience in a data analyst role
3 + years of MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS)
Experience importing and exporting data files in a variety of formats
Experience with the MS Power Platform, Power BI, Power Apps
Expert level of working experience in JSON, XML and HTML code
Strong analytical skills and ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy
Demonstrated proficiency in understanding and implementing business workflows and processes
Ability to work independently and in a team environment
Experience in not-for-profit and fundraising organizations preferred
Skills
Strong knowledge and experience of MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS)
Knowledge of SQL Server, query development and stored procedures
Knowledge and experience with MS Power Platform, Power BI, Power Apps
Knowledge of Azure Data Factory is an asset
Knowledge of Python is an asset
Proven ability to identify and document business requirements and translate into useful reports and processes
Demonstrated analytical skills to review, synthesize information and produce analytical reports
Ability to work on multiple assignments and achieve objectives and deadlines
Knowledge of and experience with Software Development Life Cycle
Excellent troubleshooting and problem solving skills
Excellent oral and written communications skills in English
An exceptional customer service attitude
Results-driven and metrics focused with a passion for continuous improvement
Ability to partner with multi-disciplinary teams and vendors
Experience with CRM applications an asset
What we offer
In addition to a competitive salary, Heart & Stroke believes that time off is integral to the personal health and wellness of our employees. We offer paid wellness days and personal days. In addition, we provide health, medical, dental and vision benefits. Furthermore, our staff enjoy flexible hybrid working arrangements and support with reimbursement for mobile phones and home office set up.
Apply now
If you want to join the fight to beat heart disease and stroke while building an engaged and giving community, apply by November 20, 2024. Applicants must be currently residing in Canada and legally entitled to work in Canada.
To learn more about our mission, our values and the difference Heart & Stroke makes in the lives of people in Canada at every age, please visit our website.
We are committed to fostering an inclusive, barrier-free and accessible environment. If you have been contacted for an interview and require accommodation to participate in the recruitment and selection process, please advise and we will work with you. At this time, interviews are currently being conducted via phone or video call, so we look forward to ‘virtually’ meeting you!