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!