Data Analyst - 12 Month Contract

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

The opportunity

(Please note this is a 1-year contract and remote working role within 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 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 business intelligence 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 

• Ability to take raw data and provide summary analysis 
• Perform data testing to ensure data accuracy and completeness 
• Design, develop  and deploy data outputs and reports using SQL Server Reporting Services and BI tools 
• Develop automated and reusable routines for extracting requested information in suitable formats such as extractions, reports, graphical, and pivots   
• Provide accurate estimate delivery time for solution to business partner  

Data Validation 

• Troubleshoot and correct data upload and exceptions due to inaccuracies 
• Compiling, sorting and verifying data before it is imported into CRM database 
• 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 
• Perform end to end testing for system upgrades, application patches, customizations, and other features  as necessary 
• Monitor scheduled jobs - status, investigate , troubleshoot and resolve issues to completion 

Other 

• As necessary, conduct specific training as needed. 
• 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) 
• Keep well-informed of trends and best practices in the BI industry to strengthen organizational and technical knowledge as it relates to enterprise information 

Experience

Who we need

• Experience in not-for-profit and fundraising organizations preferred
• 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) 

Education

• Bachelor degree or college diploma in computer science, information systems, business administration or related field 

Skills

• Experience importing and exporting data files in a variety of formats 
• Excellent troubleshooting and problem solving skills   
• Demonstrated analytical skills to review, synthesize information and produce analytical reports  
• Knowledge of and experience with Software Development Life Cycle  
• Demonstrated proficiency in understanding and implementing business workflows and processes 
• Knowledge and experience with MS Power Platform, Power BI, Power Apps 
• Strong analytical skills and ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy 
• Ability to work independently and in a team environment 
• Ability to partner with multi-disciplinary teams and vendors 
• Expert level of working experience in XML and HTML code 
• Excellent oral and written communications skills in English 
• 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 Azure Data Factory is an asset 
• An exceptional customer service attitude  
• Ability to work on multiple assignments and achieve objectives and deadlines 
• Results-driven and metrics focused with a passion for continuous improvement  
• Experience with CRM applications an asset 
• Proven ability to identify and document business requirements and translate into useful reports and processes 
• Knowledge and experience with SQL Server, query development and stored procedures 

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 September 1, 2023.

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

H&S has a vaccination policy that requires all employees to be fully vaccinated unless they have a valid exemption. You can view our policy

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!

Powered by JazzHR

zV4RYIPDCj