Business Intelligence Partner, Regular Full Time

1 week ago


Ottawa, Ontario, 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 adhoc 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, Ontario, Canada Political Intelligence Full time

    Political Intelligence, a leading consulting firm specializing in government relations, public relations, and public opinion polling, is seeking an Associate Consultant to support the Vice President of Government Relations and Indigenous Affairs in facilitating discussions and negotiations between First Nations communities and the federal and provincial...


  • Ottawa, Ontario, Canada NSERC Full time

    A written examination and an interview will be administered.If you are looking for a dynamic and challenging work environment with a fun, diverse and dedicated team, the Social Sciences and Humanities Research Council (SSHRC) and Natural Science and Engineering Research Council's (NSERC) is the place for you We are growing our team and looking for dedicated...


  • Ottawa, Ontario, Canada Canada Post - Postes Canada Full time

    Job Requisition Id: 166763Business Function: FinancePrimary City: OttawaOther Location(s):Province: OntarioEmployment Type: Full-TimeEmployment Status: PermanentLanguage Requirement: English EssentialEmployee Class and Level: CPMGA02Number of Vacancies 1Job Closing Date (MM/DD/YYYY): 03/16/2023JOB DESCRIPTIONThe Manager Finance Business Partner plays a key...


  • Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    BUSINESS INTELLIGENCE SOLUTIONS ANALYSTCONTRIBUTING TO THE CMPAIn collaboration with all CMPA departments, the Strategy and Program Management department leads several enterprise management processes. The core functions include strategic planning and strategic issues analysis, business planning and performance management, business intelligence, enterprise...


  • Ottawa, Ontario, 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, Ontario, Canada Egg Farmers of Canada Full time

    Egg Farmers of Canada (EFC) is presently seeking an Economist to join our Market Intelligence team. Reporting to the Manager of Market Intelligence, the primary responsibilities of the role include conducting accurate, comprehensive, and timely analysis, forecasts, reports and recommendations with respect to Egg Farmers of Canada's operational requirements. ...


  • Ottawa, Ontario, Canada Egg Farmers of Canada Full time

    Egg Farmers of Canada (EFC) is presently seeking an Economist to join our Market Intelligence team. Reporting to the Manager of Market Intelligence, the primary responsibilities of the role include conducting accurate, comprehensive, and timely analysis, forecasts, reports and recommendations with respect to Egg Farmers of Canada's operational requirements. ...


  • Ottawa, Ontario, Canada BGIS Full time

    Who We AreBGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6, 500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients' businesses. Globally, we manage over 320...


  • Ottawa, Ontario, Canada Canadian Blood Services Full time

    Job category: Human resourcesJob posting ID: 5021Employment status:Regular full-timeClassification:PTS/MGT/IT BSalary/Rate of pay:$105,000 to $121,000Application deadline:Together, we can make all the difference in the lives of others.Be part of a dynamic, collaborative and caring organization committed to saving and improving lives. Thousands of patients...


  • Ottawa, Ontario, Canada Cintas Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Select how often (in days) to receive an alert: Title: Sales Representative -First Aid and Safety - Bilingual Location: Ottawa, ON, CA, K1N 9C3 Requisition Number :Job Description Cintas is seeking a Sales Representative -First Aid and Safety - Bilingualto focus on...


  • Ottawa, Ontario, Canada Canadian Security Intelligence Service Full time

    Job Summary:POSITION A - REQUIREMENTS OFFICERThe Requirements Officer is responsible for producing CSIS Intelligence Reports (CIRs) for dissemination to other government departments in accordance with established intelligence requirements (IRs)Major responsibilities: Maintain knowledge of CSIS IRs, Government of Canada Intelligence Priorities and relevant...


  • Ottawa, Ontario, Canada Canada Post - Postes Canada Full time

    Job Requisition Id: 169995Business Function: FinancePrimary City: OttawaOther Location(s):Province: OntarioEmployment Type: Full-TimeEmployment Status: TermLanguage Requirement: English EssentialEmployee Class and Level: CPMGA02Number of Vacancies 3Job Closing Date (MM/DD/YYYY): 06/27/2023The Manager Finance Business Partner plays a key role with business...


  • Ottawa, Ontario, Canada Lrostaffing Full time $80,000 - $90,000

    Partnering with a rapidly growing NGO, LRO Staffing is conducting a professional search for a Bilingual Business Partner, People & Culture. Reporting to the Director, People & Culture, this position is focused internal stakeholder relations, employee engagement and ongoing culture transformation. Participate in the annual succession and workforce planning...


  • Ottawa, Ontario, Canada NOKIA Full time

    Business Intelligence Co-op/InternCome create the technology that helps the world act togetherWe are a B2B technology innovation leader pioneering the future where networks meet cloud.At Nokia you will have a positive impact on people's lives and help build the capabilities needed for a more productive, sustainable, and accessible world.Be part of a culture...


  • Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    BUSINESS INTELLIGENCE REPORTING ANALYSTCONTRIBUTING TO THE CMPAThe Research, Analytics and Privacy group captures and manages corporate and medico-legal data, generates insights and translates knowledge to inform data-driven business decisions and evidence-informed safe medical care products. This group also leads support for the CMPA on privacy matters,...


  • Ottawa, Ontario, Canada Avaya Full time

    About Avaya:Businesses are built by the experiences they provide, and every day, millions of those experiences are delivered by Avaya. Organizations trust Avaya to provide innovative solutions for some of their most important ambitions and challenges, giving them the freedom to engage their customers and employees in ways that deliver the greatest business...


  • Ottawa, Ontario, Canada QNX Software Systems Full time

    Worker Sub-Type:Regular Job Description: Are you the person we are looking for?BlackBerry QNX is a global leader in the embedded software industry. We are a well-respected and established software provider, trusted across multiple high-performance industries. With increasing demand for complex embedded software systems BlackBerry QNX is well positioned for...


  • Ottawa, Ontario, Canada Black & McDonald Limited Full time

    The Human Resources Business Partner (HRBP) plays a key role in the achievement of all people related goals for their assigned client groups at the Black & McDonald.The HRBP acts as a business partner providing strategic thought leadership, sound guidance and support to the functional leaders in areas including hiring, employee relations, benefits, training,...


  • Ottawa, Ontario, Canada Avaya Full time

    About AvayaBusinesses are built by the experiences they provide, and every day, millions of those experiences are delivered by Avaya. Organizations trust Avaya to provide innovative solutions for some of their most important ambitions and challenges, giving them the freedom to engage their customers and employees in ways that deliver the greatest business...


  • Ottawa, Ontario, Canada Avaya Full time

    About AvayaBusinesses are built by the experiences they provide, and every day, millions of those experiences are delivered by Avaya. Organizations trust Avaya to provide innovative solutions for some of their most important ambitions and challenges, giving them the freedom to engage their customers and employees in ways that deliver the greatest business...