Job Description

12 month contract
Salary range: $76,898 to $96,123

Sinai Health Foundation raises and stewards funds to support Sinai Health. Sinai Health is Canada\xe2\x80\x99s leading integrated health system and comprises Circle of Care; Hennick Bridgepoint Hospital; Lunenfeld-Tanenbaum Research Institute; and Mount Sinai Hospital, Joseph & Wolf Lebovic Health Complex. The generous support of our community fuels everything we do from seamless care to scientific discovery. People are excited to come to work every day at Sinai Health Foundation. As a world-class institution, we have a unique and rich personality. We are driven to make a positive impact for patients, their families and society. We love the clash of ideas that lead to better solutions. Innovation is encouraged. Collaboration will allow us to push forward. We recognize that the pace of change continues to accelerate and understand flexibility is vital. We take our work seriously and have a lot of fun doing it! We have built a community at Sinai Health Foundation. We embrace and celebrate differences, and have great respect for each other and our strengths, perspectives, opinions and lifestyles. We have high expectations of each other, but even higher expectations of ourselves. We adapt to rules and processes; we hold each other and ourselves accountable. We do all that we can do\xe2\x80\xa6and then we find a way to do a little bit more. We embody creativity, imagination and a fierce determination to make the world a better place.

Reporting to the Senior Manager, Business Intelligence & Information Systems, the Business Intelligence Analyst will play a crucial role in transforming raw data into actionable insights that will guide our strategic decisions. The Business Intelligence Analyst will work closely with cross-functional teams to understand their data needs, design data solutions, and ensure data quality and integrity. The role will also be responsible for creating and maintaining reports, dashboards, and visualizations that provide valuable insights to drive Foundation business growth. Responsibilities include but are not limited to: Data Management:

• Design and maintain Foundation databases to ensure data accuracy, reliability, and security
• Develop and implement data governance policies and best practices
• Assist the IT team optimizing data infrastructure and storage

Data Analysis and Reporting:

• Conduct in-depth data analysis to extract meaningful insights
• Create, update, and manage reports, dashboards, and visualizations using BI tools (e.g., Qlik Sense, Power BI)
• Translate complex data into actionable recommendations for the business

Business Intelligence:

• Collaborate with stakeholders to identify data requirements and develop data-driven solutions.
• Proactively identify trends, patterns, and opportunities within the data
• Support decision-making by providing timely and accurate business intelligence to all business units across foundation.

Data Integration:

• Integrate data from various sources to create a unified, comprehensive dataset
• Develop ETL processes to automate data extraction and transformation
• Support the IT team with the development and maintenance of a data warehouse.

• Documentation and Training: Create documentation for data processes, models, and reporting
• Train team members on using data tools and interpreting insights.

Position requirements:

• A successful completion of an undergraduate degree or diploma from an accredited educational institution in Computer Science, Business or a related field. Proven equivalent and recent related education, training and experience may be considered
• 3 \xe2\x80\x93 5 years experience in data management, business intelligence, or data analysis. Experience in the charitable sector, preferably in healthcare fundraising, is preferred
• Proficiency in data visualization tools such as Qlik, Power BI, or similar
• Intermediate SQL skills for data querying and transformation
• Knowledge of data modeling and ETL processes
• Excellent communication and presentation skills
• Ability to work collaboratively in cross-functional teams
• Strong problem-solving and analytical skills
• Experience with Blackbaud CRM systems (Raiser\xe2\x80\x99s Edge, Financial Edge, Luminate Online) would be an asset
• Experience with Python, R or other programming languages and knowledge of data warehousing and cloud-based data solutions would be an asset
• A professional aligned with Sinai Health Foundation\xe2\x80\x99s five values: accountability, collaboration, community, flexibility and innovation.