Business Intelligence Reporting Analyst

2 weeks ago

Ottawa, Canada Canadian Medical Protective Association Full time

**BUSINESS INTELLIGENCE REPORTING ANALYST**

**CONTRIBUTING TO THE CMPA**

The 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, which includes maintaining the privacy framework, implementing, and maintaining the corporate privacy plan. This group contributes to the key strategic objective of advancing safe medical care, in collaboration with other internal departments and stakeholders, by leveraging our knowledge and expertise to identify member needs, better understand their medico-legal risks and create corporate and safe medical care analytic and knowledge translation products.

The Data and Business Intelligence (BI) team oversees all infrastructure that supports the data analysis and data management of CMPA business information and enables data governance teams that are federated across the CMPA. BI administers and maintains analytical systems and maintains an enterprise data warehouse that provides historical, current, as well as predictive views of business operations. The team services all internal users with traditional report development and distribution, complex custom ad-hoc information requests, and supports the needs of other analytics teams by providing and regularly updating data subsets.

**POSITION OVERVIEW**

**POSITION ACTIVITIES**
- Report Development_
- Works with internal clients to understand their reporting requirements and business questions
- Assists users in creating their own reports, dashboards, and ad-hoc data extractions
- Develops corporate and operational reports and dashboards and detailed functional specifications
- Collaborates with others in Data and Business Intelligence to ensure clients’ requirements are met through report design
- Writes SQL scripts to extract data in support of report development and data analysis
- Supports the BI Solutions Analysts with data modelling activities
- Creates and maintains comprehensive user documentation, tutorials, reports, and other information
- Supports the implementation of BI Tools and systems so as to best meet delivery of services to clients
- Works with business representatives to develop testing strategies and plans, as well as the execution of test plans
- Other Activities_
- Provides user training on systems and reporting capabilities
- Develops sections and/or provides input into the project plan and schedule throughout the life cycle of a project and when unforeseen issues arise
- Remains vigilant of industry and technological changes to improve knowledge and working skills related to areas of expertise and new technologies
- Assists other CMPA teams to ensure smooth and timely integration of new technologies
- Facilitates and organizes meetings with clients as required
- Performs gap analysis and data analysis as required
- Troubleshoots and fixes reporting-related issues as they arise
- Performs performance tuning of reports
- Maintains documentation and stored metadata
- Maintains knowledge of CMPA business processes and business rules and industry best practices

**EDUCATION AND EXPERIENCE**
- Four-year Bachelor’s Degree in computer science or a related field of study
- Minimum four years of relevant experience developing reports directly supporting BI related projects or operations
- Strong understanding of data warehousing methodologies
- Previous IBM Analytics (Cognos) experience is preferred
- Strong understanding of business processes (Finance, Customer Relationship Management (CRM), Risk Management, and Corporate Performance Measurement)
- Experience interacting with all levels within an organization
- Experience working in cross-functional teams in a project based environment
- Previous experience in business analyst or data analyst roles is an asset
- Experience working with cloud based technologies; Workday and/or SugarCRM experience is an asset
- Experience working with medical-legal data and/or financial reporting experience is an asset
- Experience writing data definitions and maintaining metadata is an asset
- Experience creating training guides and materials
- Experience developing and implementing reporting strategies (dashboards, executive information systems, and reporting templates)
- Experience with training and coaching

**SKILLS AND ABILITIES**
- Strong verbal and written communication skills in English
- Strong SQL coding skills are essential; Oracle, PL/SQL, and Unix scripting experience are considered an asset
- Strong interpersonal skills and the ability to collaborate with clients to meet their needs
- Ability to analyze and provide creative and innovative solutions to business problems
- Ability to maintain high productivity amidst competing priorities and tight timelines

The CMPA is an equal opportunity employer and is committed to being responsi

  • Business Strategy Analyst

    4 weeks ago

    Ottawa, Canada Canadian Medical Protective Association Full time

    **BUSINESS STRATEGY** **ANALYST** **CONTRIBUTING TO THE CMPA** - Working closely with all CMPA departments, the Strategy & Program Management (SPM) department leads nimble and adaptable enterprise management processes. The core functions include strategic planning and strategic issues analysis, business planning and performance management, and program...

  • Sector Intelligence Analyst, Country and Sector

    4 weeks ago

    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....

  • Network Exploitation Analyst

    4 weeks ago

    Ottawa, Canada Canadian Security Intelligence Service Full time

    **Important**: **Closing Date** 2023-12-03 **Reference Number** 23-968-VAR-121 **Job Category** Subject Matter Expert **Who Can Apply** Canadian Citizens **Location** Ottawa, Ontario **Salary Range** $84,050 - $102,250 $95,350 - $116,060 **Allowance** These positions are eligible for the Technology Market Modifier, which is valued at 7% of the basic...

  • Business Analyst

    3 weeks ago

    Ottawa, ON, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategies Our client has a requirement for the...

  • Business Intelligence Partner

    3 weeks ago

    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...

  • Business Systems Analyst

    6 days ago

    Ottawa, Canada Maplesoft Group Full time

    Maplesoft Group is currently seeking a Business Systems Analyst for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Under the direction of the Senior Manager, Business Analysis Payments Modernization: - Participate in a Data as a Product scrum team to gather and convert...

  • Front Line Analyst

    6 days ago

    Ottawa, Canada Canadian Security Intelligence Service Full time

    **Important**: **Closing Date** 2024-02-22 **Reference Number** 23- 968-05-141 **Job Category** Entry Level **Who Can Apply** Canadian Citizens **Location** Ottawa, Ontario **Salary Range** $57,960 - $70,500 **Status** Indeterminate (permanent) **Language Requirement** Bilingual Non Imperative - BBB **Job Summary**: **Front Line Analyst**: - Review...

  • Bhjob15656 19994 - Business System Analyst

    4 weeks ago

    Ottawa, Canada Myticas Consulting Full time

    Myticas Consulting's Ottawa-based client is looking for a Business System Analyst for a 3 year HYBRID contract. This requirement requires the resource to have a valid **Secret Level Security Clearance.** **Under the direction of the Senior Manager, Business Analysis Payments Modernization**: - Participate in a Data as a Product scrum team to gather and...

  • Student, Business Intelligence

    5 days ago

    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...

  • IBM Cognos Business Intelligence

    4 weeks ago

    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...

  • Student, Business Intelligence

    1 week ago

    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...

  • Data and Reporting Analyst

    5 days ago

    Ottawa, Canada Carleton University Full time

    Duties and Responsibilities: Reporting to the Manager, Strategy and Quality, the Data and Reporting Analyst serves as an administrative resource on all matters pertaining to data collection and reporting for the Sprott School of Business. The Data and Reporting Analyst is the subject expert on comparative analyses and reporting and assists the Manager,...

  • Data and Reporting Analyst

    6 days ago

    Ottawa, Ontario, Canada Carleton University Full time

    Duties and Responsibilities: Reporting to the Manager, Strategy and Quality, the Data and Reporting Analyst serves as an administrative resource on all matters pertaining to data collection and reporting for the Sprott School of Business. The Data and Reporting Analyst is the subject expert on comparative analyses and reporting and assists the Manager,...

  • Business Support Analyst

    4 weeks ago

    Ottawa, Canada Bank of Canada Full time

    **Business Support Analyst** **Take a central role** The Bank of Canada has a vision to be “a leading central bank—dynamic, engaged and trusted—committed to a better Canada.” No other employer in the country offers you the unique opportunity to work at the very center of Canada’s economy, in a diverse and inclusive organization with significant...

  • Research and Business Intelligence Officer

    4 weeks ago

    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....

  • Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing

    3 weeks ago

    Ottawa, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategiesOur client has a requirement for the provision...

  • Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing

    2 days ago

    Ottawa, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategiesOur client has a requirement for the provision...

  • Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing

    4 weeks ago

    Ottawa, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategiesOur client has a requirement for the provision...

  • Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing

    3 weeks ago

    Ottawa, Canada Annex Consulting Group Full time

    Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing Our valued Public sector client is in need of a Intermediate Business Analyst to fulfill Performance Measurement functions, particularly developing and/or reviewing or expanding performance measurement strategiesOur client has a requirement for the provision...

  • Manager, Market Intelligence

    7 days ago

    Ottawa, Canada Egg Farmers of Canada Full time

    **Manager, Market Intelligence** **Scope**: **Duties and Responsibilities**: Research and Analysis - Manage macro - and micro-analytical activities relevant to Canadian egg markets - Produce reports and presentations outlining the research and analysis and results - Provide insight and recommendations to senior management - Provide ad hoc analysis, with a...