Business Intelligence Partner, Regular Full Time

3 weeks ago


Ottawa, Canada Home and Community Care Support Services Champlain Full time

**Home and Community Care Support Services Champlain** is one of 14 Home and Community Care Support Services organizations in Ontario. We are dedicated to ensuring our more than 64,000 patients annually receive the highest-quality health care and services at home. Our patient-care coordination teams help develop care plans for people of most ages, focused on maintaining each patient's independence and dignity. We also provide long-term care home placement services, and facilitate our patients’ access to the community-based services they need.

**Position Summary**:
The Business Intelligence Partner is responsible for obtaining, summarizing, analyzing, interpreting, and presenting organizational, program and patient data to support strategic objectives and facilitate efficient and effective service operations across the organization. To support this work, the Business Intelligence Partner participates in the ongoing development and maintenance of existing reports, data warehouse and data infrastructure. Further, the Business Intelligence Partner provides education and recommendations to management and staff with respect to the use of information and actions to be taken, based upon analysis of information. This position acts as a partner to internal clients to leverage analytical skills, and enhance business decisions.

**Primary Responsibilities**:

- Responsible for Data Extraction, Analysis, Interpretation and Reporting for the organization. Develops and maintains a SQL database warehouse, SQL scripts, GIS analysis infrastructure and utilizes Business Intelligence tools
- Develops and provides ad-hoc information requests and performance improvement reports to management and staff through the creation of graphs, charts, worksheets, standardized reports, metrics, and individual consultations by utilizing reporting analysis tools to access information, analyze the meaning of information, and to present information in such a way as to influence and create actions
- Performs information analysis in order to provide the most relevant and useful information to the organization
- Consults with management on business needs, translating business needs into analytics/reporting requirements and interfacing with management to ensure successful delivery of analysis or information reporting
- Consolidates statistical analysis from various information systems to provide a summarized view in the most appropriate and effective manner, assisting management in taking appropriate actions for organizational and individual improvements
- Researches, develops, and provides effective methods for information collection, information usage, and the ability to forecast future needs in order to support business strategies and operations
- Provides relevant, accurate information and key insights in a timely manner and, based on the information results, makes relevant recommendations to the client
- Establishes and maintains effective working relationships with all levels of management, staff, and external stakeholders to discuss and provide advice in developing reporting needs
- Prepares and provides Business Intelligence overviews and presentations to a wide variety of audiences (internal and external stakeholders)
- Provides support and education to management and staff on the use of information, analyzing trends and linking data quality to information, in order to enhance the organization’s capacity for managing the business

**Education and Experience**:

- Completion of a Master’s Degree in Computer Science, Computer Engineering, Data Science, Health Informatics or Epidemiology coupled with one year of relevant experience; or
- Completion of a Bachelor’s Degree in Computer Science, Computer Engineering, Data Science, Health Informatics or Epidemiology with relevant experience normally attained over a period of five years
- Extensive experience with Report Writing (e.g. PowerBI, Paginated Reports) / SQL Server queries
- Experience with Database Administration, ETL processes, Microsoft Business Intelligence environments (SSIS, SSAS, SSRS, SSDT) preferred
- Experience in a quality analysis through statistical techniques, and/or trending analysis against benchmarking

**Knowledge**:

- Thorough knowledge of MS Office Suite, SQL databases, ETL Processes, Microsoft Business Intelligence environments (SSIS, SSAS, SSRS, SSDT), Microsoft reporting tTools (Paginated Reports, PowerBI, Power Query) - Required
- Knowledge of GIS tools and concepts will be considered a preferred asset
- Knowledge of MS Azure Concepts and Azure Data Services a preferred asset
- Knowledge of outcome measurement and performance improvement approaches with proven ability in using statistical approaches to information analysis
- Knowledge of Champlain Home & Community Care Support Services programs and organizational structure
- Knowledge of the Canadian healthcare environment and the role of the Champlain Home & Community Care Support Services within it
- Un



  • Ottawa, Canada Home and Community Care Support Services Full time

    Position Summary: The Business Intelligence Partner is responsible for obtaining, summarizing, analyzing, interpreting, and presenting organizational, program and patient data to support strategic objectives and facilitate efficient and effective service operations across the organization. To support this work, the Business Intelligence Partner...


  • Ottawa, Canada Canadian Air Transport Security Authority Full time

    The Canadian Air Transport Security Authority (CATSA) has 2 exciting student opportunity from May 6th, 2024 to August 23rd, 2024 within the Technology branch at CATSA Headquarters. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference...


  • Ottawa, Canada Canadian Air Transport Security Authority Full time

    The Canadian Air Transport Security Authority (CATSA) has 1 exciting student opportunity from January 9th, 2023 to April 14th, 2023 within the Technology branch at CATSA. This position represents an opportunity for career-driven individuals seeking a position within an organization that inspires growth and promotes excellence to make a difference and...


  • Ottawa, Canada The Royal Ottawa Mental Health Centre Full time

    **Position Information** **Posting Number**: - ROM23-414E**Title**: - Research and Business Intelligence Officer (TFT 1.0 FTE)**Position Status**: - Temporary Full-time**FTE**: - 1**Job Schedule**: - Days**Department**: - Foundation**Union**: - Non-union**Site**: - Royal Ottawa Mental Health Centre**About The Royal** We’re breaking down stigmas....


  • Ottawa, Canada CMHC Full time

    Job Requisition ID: 10128 Position Status:  Permanent Full Time  Position Type:  Hybrid Office Location:  Ottawa (ON); Toronto (ON) Travel Requirement:  Travel not required  Language Designation:  English Essential  Language Skill Levels (Read/Write/Speak):  ZZZ  Salary:  Our salaries generally range from $ 83038.35 to...


  • Ottawa, Canada Canadian Security Intelligence Service Full time

    **Important**: **Closing Date** 2023-06-30 **Reference Number** 23-968-08-081 **Job Category** Experienced **Who Can Apply** Canadian Citizens **Location** Ottawa, Ontario **Salary Range** $84,050 - $102,250 **Status** Indeterminate (permanent) **Language Requirement** Bilingual Non-Imperative (CBC/CBC) **Job Summary**: The Intelligence Analyst...


  • Ottawa, Canada CMHC - SCHL Full time

     Job Requisition ID: 10128  Position Status: Permanent Full Time Position Type: Hybrid   Office Location: Ottawa (ON); Toronto (ON)Travel Requirement: Travel not required Language Designation: English Essential Language Skill Levels (Read/Write/Speak): ZZZ Salary: Our salaries generally range from $ 83038.35 to $ 103797.93 and are based...


  • Ottawa, Canada N12 Consulting Full time

    N12 Consulting is a leading Enterprise Performance Management (EPM) firm in Ottawa, with a team of experienced consultants who specialize in unifying Performance Management and Business Intelligence (BI). We accomplish this bysupporting a broad range of strategic, financial and operational management processes to provide a complete and integrated system...


  • Ottawa, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada EDC Full time

    **Sector Intelligence Analyst, Country and Sector Intelligence Team (CSI)** - 0004FC **Posting Date**: Aug 10, 2023, 10:38:20 AM **Primary Location**: Ontario-Ottawa **Job Type**: Permanent **Schedule**: Full-time Export Development Canada (EDC) is a financial Crown corporation dedicated to helping Canadian businesses make an impact at home and abroad....

  • Divisional Partner

    4 days ago


    Ottawa, Canada Canadian Blood Services Full time

    Canadian Blood Services is looking for a **Divisional Partner** to join our dynamic **Talent Planning & Change** **team. **Job category**: Human resources **Job posting ID**: 4618 **Employment status**:Regular full-time *** **Salary/Rate of pay**:$105,000 to $121,000 **Application deadline**: 2023-06-20 **Somewhere in Canada there’s a life you can...


  • Ottawa, Canada Avaya Full time

    ABOUT THE OPPORTUNITY The HR Business Partner will play an integral role collaborating and partnering with the Senior HR Business Partner across different functions in the organization. In this position, you will be responsible for HR programs including, but not limited to, performance management, employee relations, resource planning, HR metrics and...


  • Ottawa, Canada Central East Local Health Integration Network Full time

    Community Engagement Specialist, Regular Full Time Position ID: J0524-0424 Job Title: Community Engagement Specialist, Regular Full Time City/Province: Posting Date: May 9, 2024 Posting Expiry Date: May 24, 2024 Manager, Community Engagement Home and Community Care Support Services Champlain is one of 14 Home and Community Care...


  • Ottawa, Canada Central East Local Health Integration Network Full time

    Community Engagement Specialist, Regular Full Time Position ID: J0524-0424 Job Title: Community Engagement Specialist, Regular Full Time City/Province: Posting Date: May 9, 2024 Posting Expiry Date: May 24, 2024 Manager, Community Engagement Home and Community Care Support Services Champlain is one of 14 Home and Community Care...


  • Ottawa, Canada Central East Local Health Integration Network Full time

    Community Engagement Specialist, Regular Full Time Position ID: J0524-0424 Job Title: Community Engagement Specialist, Regular Full Time City/Province: Posting Date: May 9, 2024 Posting Expiry Date: May 24, 2024 Manager, Community Engagement Home and Community Care Support Services Champlain is one of 14 Home and Community Care...

  • HR Business Partner

    4 weeks ago


    Ottawa, Canada Castillo HR Consulting Inc. Full time

    The Memory Clinic/ Clinique de la Mémorie (TMC/CM) has two clinics dedicated to researching and fighting Alzheimer's disease (AD). TMC/CM also partners with pharmaceutical companies to conduct clinical trials for AD. Alzheimer's disease (AD) is the most common type of dementia, making up approximately 70% of all cases. Those over the age of 65 are at a...


  • Ottawa, ON, Canada Canadian Armed Forces Full time

    Non-Commissioned Member | Full Time, Part Time Upon the enrolment and successful completion of Regular Force Basic Training (Basic Military qualification (BMQ)), you will be eligible for an accelerated pay increment if you enrol in one of the designated occupations. Browse Careers to find out which occupations are eligible for this offer. As a member of...


  • Ottawa, Canada GLOBE Series, The Delphi Group Full time

    **Human Resources Business Partner** **Permanent Full Time - Reporting to the VP Finance in Ottawa, Ontario. Flexible work arrangements, including hybrid work model (1-2 days in office per week).** If you’re serious about making a difference and want to work in a dynamic, supportive environment with diverse growth opportunities, consider a career with...