Job Number: JR102577 Job Title: Manager, Data Systems and Reporting Department: TSHF Foundation CEO Job Category: Foundation Hospital Location: General Site Job Type: Permanent, Full time Number of Positions: 1 Hours: Days Scarborough Health Network is a leading community teaching health network, consisting of three hospitals and eight satellite sites in Scarborough, one of the most diverse communities in Canada. Our Foundation works with generous donors, volunteers and community members to raise funds for state-of-the-art infrastructure and medical technology to support the hospital’s mission to improve lives through exceptional care. SHN Foundation is raising the profile of our hospitals through the Love, Scarborough marketing and fundraising campaign. The extraordinary success of Love, Scarborough has helped generate mass awareness, has inspired transformational gifts, and has shown needed attention onto healthcare inequity and gaps in Scarborough. The Foundation has seen tremendous growth all around (staff, events, donations, media coverage, partnership, etc.). It’s an exciting time to join the organization as we continue to build upon this momentum! Find out more about this compelling campaign by visiting lovescarborough.ca. Job Description: What you’ll be doing: Do you have a track record of managing technology systems in support of fundraising, and ensuring accurate data capture and optimization? Do you have the experience and motivation to bring forth actionable reporting, harvesting insights from a variety of systems through data integration? Are you ready to play a leadership role in developing and maintaining the integrity and functionality of the foundation’s data assets through supporting an effective data governance framework and providing technical leadership? SHN Foundation is seeking an enthusiastic professional to join our team in the new role of Manager, Data Systems and Reporting. Reporting to the AVP, Campaign Operations, you will be responsible for executing the organization’s Technology, Digital and Data strategy and will help the foundation grow fundraising and engagement through data management and new technologies. A leader and mentor to power users and data champions across the foundation’s departments, and with day-to-day accountability for systems management, reporting and data governance, you will be a key part of the foundation’s success. Your responsibilities: Systems Management (20% of Time) Provide management and technical support for the CRM database and other software products. Act as the project lead for large technology projects that are part of the overhaul of the foundation’s technology stack. Ensure all users are fully leveraging system capabilities and entering clean data. Train new users on systems. Assist the AVP with monitoring user requirements and satisfaction. Manage in-system security requirements and structure for the Foundation. Work closely with the central IT team of the hospital to leverage resources in support of cross-cutting initiatives, such as data warehousing. Maintain an accurate inventory of corporate software licenses and hardware. Data Lead (25% of Time) Understand the needs of each business group and how data architecture can best be exploited in order to allow the foundation to use the fundraising system and available data more effectively. Provide leadership on the Data Governance Committee, whose purpose is to guide efforts toward high-quality data, including data structure, data hygiene, data definitions, data use, data enhancement, and data integration. Develop and implement an organization-wide data quality framework. Establish and enforce data quality standards in consultation with the AVP and the Data Governance Committee. Develop procedures (including appropriate timelines) and ensure all data maintenance activities are completed as needed. Ensure clean data in support of fundraising, events and donor activities. Support data users to ensure data quality, error and defect management and the remediation of data quality issues. Develop and implement a data dictionary and training curriculum on key data processes for consistency. Make recommendations on any external assistance for data and systems to the AVP, if required. Reporting Lead (35% of Time) Assist the AVP in evaluating reporting needs, assessing feasibility and prioritizing requests. Implement a reporting strategy under the direction of the AVP to leverage Power BI and RE NXT dashboards and reports to create a fulsome suite of reporting for all teams over the next several years, prioritizing areas most important to fundraising success. Ensure accurate, timely delivery of required reports and lists for foundation operations, in particular in support of Events, Annual Giving, Major Gifts and Marketing. Serve as the lead administrator of any future data warehouse, ensuring continuous data integration between CRM and the data warehouse, and its day-to-day functioning and performance. Provides technical direction for the design, enhancement, and deployment of data warehouse technologies. Develop reporting structures and data standards to ensure consistency across the foundation. Act as the lead on data integration, championing the development and use of Omatic software to enhance data consistency and enhance data entry and automation into RE NXT. Develop a comprehensive set of business rules and data integrity rules and scripts for data integration and reports to ensure consistency in data management (such as duplicate matching, bad data identification). Business Solutions (10% of Time) Work with the Data Governance Committee to elicit and understand requirements, and identify/recommend optimal solutions that provide accurate and relevant data to support fundraising. Design and manage data systems workflows, including roles and responsibilities of all involved. For technical, workflow or permissions issues, including the importing of third-party data sources, proactively carry out any necessary research, diagnose and report emerging issues/risks, make recommendations for solutions, and liaise with individuals or teams as required. Independently or through delegation, resolve varied and moderately complex issues, informing the AVP/other key stakeholders and making recommendations where there is cross-foundation risk or impact. Proactively creates effective change communication, process documentation, training resources and data quality procedures. Identify and support risk mitigation and opportunities for improvement by developing and monitoring performance and quality control plans, creating and implementing test plans for various data quality processes, and coordinating with the Data Governance Committee to design data standards and ensure data quality and consistency. Provides recommendations for improving or modifying business processes to improve data quality to support the foundation’s goals. Relationship Management (10% of Time) Develop and maintain strong working relationships with foundation staff, modelling donor stewardship and using influence, persuasion, and compelling arguments to provide timely and high-quality technical support, solutions, and training. Plan and carry out complex consultations with key stakeholders (e.g., Data Governance Committee, power users), building on relationships to listen, provide expert advice, and manage expectations to diagnose business needs and translate them into accepted solutions. Build strategic and effective relationships with external vendors (Blackbaud and other systems, consulting partners, and third-party hosting technical and support staff) to troubleshoot complex technical issues and help leverage platforms and software. Resolve escalated issues from foundation team members, ensuring positive relationships with stakeholders are restored/preserved. Foster strong relationships with the hospital’s Information Technology team to ensure excellent IT support of foundation team members and compliance with SHN IT processes for the foundation. Supports the AVP as required, including representing the team on internal and external committees. Foster strong relationships with power users across the foundation for different software. Mentor, coach and support all members of the foundation on best practices in IT, systems and data. What you bring to the position: Minimum five years of data/technology experience. Experience with non-profit CRM, online donation platforms, and/or IT experience in a non-profit setting. Post-secondary education, preferably in information technology or a related field, or equivalent combination of experience. Broad knowledge of modern web and cloud technologies and services. Advanced knowledge of best practices in relation to data systems and management. Demonstrated experience leading and implementing new systems or upgrades is a strong asset. Experience using Microsoft Power BI and SQL Server Reporting Services. Ability to interpret and write SQL queries, stored procedures and integration packages using SSIS (SQL Service Integration Services). Experience with Omatic is a strong asset. Experience building and implementing data warehouse solutions. Experience with administration and customization of CRM systems. Experience specific to BlackBaud products, such as Raiser’s Edge and/or BlackBaud Certification in Raiser’s Edge NXT is an asset. Strong organizational skills to determine priorities and manage multiple projects. A PMP designation is an asset. Ability to assess, document, and optimize data and reporting processes and procedures (both operational and technology-based). Understands business processes across a foundation or non-profit, with a focus on data integration and the ability to report. Understanding of the foundation’s key performance indicators, metrics and reporting requirements. Maintains a good grasp of basic training methods and how different individual learning styles can be accommodated. Excellent written and verbal communication skills. High level of proficiency in Excel, Word, and Outlook. Familiarity with digital fundraising and email marketing is an asset. Your competencies include: Highly developed, proactive and responsive customer service skills, i.e. takes a donor-centric approach. Highly developed ability to think critically and analytically while working in a fast-paced environment – respond to requested changes, validate needs against existing system capabilities and any future product roadmap and provide optimal recommendations. Excellent listening skills and proven technical acumen, with the ability to fully understand business requirements and pain points and translate them into functional design. Good presentation and training skills with an ability to explain technical functions to colleagues both familiar and new to the topic. The ability to provide leadership and training to team members who are not direct reports. Strong troubleshooting skills and proactive in identifying the root cause of issues and developing solutions. Positivity and a strong commitment to continuous learning of new technologies. Demonstrated tact, diplomacy, and interpersonal skills to build consensus and support change management. Strong attention to detail and accuracy – you love data, reporting and data governance. Knowledge of principles and techniques used in hospital fundraising. Accommodation and Diversity Statement: Scarborough Health Network (SHN) embraces and celebrates our community’s unique multicultural heritage and diversity. SHN is an equal opportunity employer, dedicated to a culture of inclusiveness and diversity reflecting our diverse patients, staff and community alike. We are committed to fostering an environment of equity and inclusivity where every person can work and receive care safely, openly and honestly. All qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, nation of origin, genetics, disability, age, veteran status, marital or family status, belief system, or other factors related to one’s personal identity and/or values. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Learn more about our exciting opportunities by following SHNCareers on Instagram, Twitter, and Facebook. At Scarborough Health Network (SHN), our people are our greatest asset. They come from all over the world and bring diverse perspectives to enhance the compassionate and innovative care we provide our patients and their loved ones. We celebrate what makes people unique and believe that a safe, fulfilling and balanced work environment is just the start. We recognize and reward our teams, prioritize access to continuing education and create meaningful opportunities for growth and development. At SHN, you can enhance your career while by opening doors to new experiences and possibilities within our vibrant and inclusive community. Bring your passion to work. Start your journey today. We are proud to be an inclusive, equitable and accessible workplace, where everyone feels valued, respected, supported, and has a rich sense of belonging through our organizational drive to build and sustain an exceptional work environment where healthcare professionals can flourish both personally and professionally. Learn more about us by following SHN Careers on Instagram! SHN is proud to be recertified as one of Canada’s Most Admired Corporate Cultures™ for 2023-2024 by Waterstone Human Capital, one of Canada’s fastest-growing cultural talent management and retained executive search firms specializing in recruiting for fit and cultural assessment. We are a culture that empowers and inspires. This means everyone feels welcomed, respected, supported and valued and able to fully participate in the workplace. We are doing this through by creating awareness, providing education resources, empowering staff-led Communities of Inclusion, and providing growth and career opportunities. We are proud to offer mentorship programs to encourage collaboration and to support international employees, and our EnRoute training and career advancement programs designed to provide hands-on experience to fast-track certifications and placements in different care units. We are always in search of individuals with unique strengths to enhance the world-class care we provide to our patients within a welcoming environment. Experience why we continue to be a Greater Toronto’s Top Employer and an affiliated teaching hospital of the University of Toronto. We are proud to offer our staff comprehensive perks, including: Defined Benefit pension plan through the Healthcare of Ontario Pension Plan Comprehensive insured benefits package including health and dental benefits New Graduate Initiative Enroute Program Critical Care Sponsorship Program Employee Discount and Incentive Programs Employee and Family Assistance Program (EFAP), along with other comprehensive wellness offerings, including our Spiritual Care team of registered psychotherapists for spiritual, religious or emotional care; mental health supports; and on-site wellness rounding Recognition events Leadership Development and Learning Programs Tuition Assistance Program Please allow some time for our recruiters to review your application. We will contact those applicants who are chosen for an interview. We’re always looking for skilled, compassionate and committed individuals to join our dynamic team in providing exceptional quality care. Subscribe to our Career Alert or share your journey with us and see where it might lead you!
