Business Intelligence Solutions Analyst

3 weeks ago

Ottawa, Canada Canadian Medical Protective Association Full time

**BUSINESS INTELLIGENCE SOLUTIONS ANALYST**

**CONTRIBUTING TO THE CMPA**

In 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 risk management, market intelligence and research, as well as change enablement and evaluation.

The Business Intelligence (BI) team oversees infrastructure that supports the data analysis and data management of CMPA business information. The team 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**

Working within the Strategy and Program Management department and reporting to the Manager, Data & Business Intelligence, the BI Solutions Analyst plays a key role to enable fact-based decision making at the Association and the realization of the CMPA’s strategic and tactical goals. This is accomplished by the development of various BI Solutions including data marts, reports, queries, and dashboards.

The BI Solutions Analyst collaborates with the Planning and Performance team as well as other BI Analysts to support the achievement of corporate priorities and plans while also working effectively independently to gather and define internal client requirements and build end user reports. The incumbent also works closely with the BI Architect on the logical and physical model as well as the Data Acquisition (ETL) Analyst for source models. Additionally, the BI Solutions Analyst acts as back up to the Data Acquisition (ETL) Analyst and at times supports data governance activities.

**POSITION ACTIVITIES**
- Works with business representatives to elicit information requirements in support of departmental decision-making and insights generation
- Performs data analysis to support the development of BI solutions that address the information needs of internal clients
- Develops, tests, and maintains corporate or operational reports, queries, dashboards or scorecards
- Plays a key role in data quality management with key CMPA stakeholders (data owners, data stewards, source system experts, and knowledge experts)
- Performs a support function for existing BI solutions and provides data extracts based on ad-hoc requests
- Contributes to the departmental planning, budgeting, and capacity planning processes
- Identifies and leads the resolution and documentation of complex data and/or BI solution issues
- Leads user training on new BI systems prior to system release
- Participates in vendor and/or technology evaluation and selection and makes recommendations as new solutions become available
- Maintains up-to-date knowledge on technology standards, industry trends, emerging technologies, and best practices
- Ensures technical standards and best practices in BI and analytics and data management are followed

**EDUCATION AND EXPERIENCE**
- Minimum four-year Bachelor’s Degree in a related field of study or additional experience equivalent to education may be considered
- Minimum of 7 years of relevant work experience, including a minimum of 3 years of experience developing BI reports utilizing IBM Analytics (Cognos) or a similar toolset
- Certified Business Intelligence Professional (CBIP) or Certified Business Analysis Professional (CBAP) designations considered an asset
- Experience developing and delivering successful Business Intelligence solutions
- Experience working with databases, coding, internal systems and programming
- Sound understanding of Structured Query Language (SQL) required, experience with PL/SQL (Oracle) an asset
- Sound understanding of database architecture
- Strong experience utilizing IBM Analytics (Cognos) or similar toolsets required
- Experience working with senior management
- Understanding of data warehousing methodologies
- Understanding of business processes (Finance, Customer Relationship Management (CRM), Risk Management, and Corporate Performance Measurement) is an asset
- Experience working with cloud-based technologies; Workday and/or SugarCRM experience is an asset
- Experience working in cross-functional teams in a project-based environment
- Experience writing training guides and materials
- Experience with Informatica or other data transformation tools in a data warehouse environment is an asset

**SKILLS AND ABILITIES**
- Client relationship skills; ability to work with clients to identify needs and to investigate solutions
- Ability to interact with all levels of the organization
- Strong interpersonal skills and the ability to collaborate with users to meet their needs
- Ability to analyze and

  • Business Intelligence Solutions Analyst

    2 days ago

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

  • Business Intelligence Analyst

    5 days ago

    Ottawa, Canada NSERC Full time

    **Business Intelligence Analyst (Anticipatory)**: **Location of Position**: - Ottawa, ON**Job Status**: - Term appointment**Job Category**: - Information and Innovation Solutions /**Number of Positions Being Staffed**: - 2**Classification**: - GR-06**Security Clearance Required**: - Reliability**Salary**: - $77,206 - $93,018 per year**Language...

  • Analyst, Business Intelligence

    2 months ago

    Ottawa, Canada EDC Full time

    **Analyst, Business Intelligence** - 00045P **Posting Date**: Feb 7, 2023, 8:24:40 AM **Primary Location**: Ontario-Ottawa **Job Type**: Permanent **Schedule**: Full-time EDC is Canada’s export credit agency, offering information, knowledge and innovative commercial solutions to help Canadian exporters and investors expand their international...

  • Business Intelligence Analyst

    2 weeks ago

    Ottawa, Canada EDC Full time

    **Business Intelligence Analyst** - 0004GB **Posting Date**: Aug 30, 2023, 1:27:52 PM **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. EDC offers financial products and knowledge...

  • Business Intelligence Reporting Analyst

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

  • Business Intelligence Reporting Analyst

    1 day ago

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

  • Business Intelligence Analyst

    3 weeks ago

    Ottawa, Canada BGIS Full time

    **Who We Are** BGIS 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...

  • Business Intelligence Analyst

    2 weeks ago

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

  • Business Intelligence Analyst

    2 days ago

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

  • Business Intelligence Analyst

    1 day ago

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

  • Intelligence Analyst Trainer

    2 weeks ago

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

  • Intelligence Analyst

    2 months ago

    Ottawa, Canada Communications Security Establishment Full time

    As an Intelligence Analyst, you will play an essential role in the foreign intelligence aspect of CSE’s mandate to acquire information from or through the global information infrastructure. You will then use, analyze and disseminate the information for the purpose of providing foreign intelligence, in accordance with the Government of Canada’s...

  • Business Analyst/Business Analyste

    2 days ago

    Ottawa, Ontario, Canada 2i Solutions, Inc Full time

    We have an excellent 5 months contract opportunity with possible extension for a Senior Business Analyst (SAP Procurement) in Ottawa. Work would be done remotely until the pandemic situation normalizes Must haves: Reliability level Federal Security clearance is mandatory 5+ years of extensive experience with SAP MM/SRM/ARIBA P2P/Ariba CIG/FICO 3+ full...

  • Senior ECM Business Analyst

    4 weeks ago

    Ottawa, Canada LeverageTek IT Solutions Full time

    LeverageTek is actively seeking a Business Systems Analyst - OpenText ECM for a 9-month contract with its Ottawa-based customer. Work Location The successful candidate will be required to work on-site at the customer headquarters in Ottawa, ON. Equipment Required You will be expected to have your own laptop to perform the work. A laptop will not be...

  • Senior ECM Business Analyst

    4 weeks ago

    Ottawa, Canada LeverageTek IT Solutions Full time

    LeverageTek is actively seeking a Business Systems Analyst - OpenText ECM for a 9-month contract with its Ottawa-based customer. Work Location The successful candidate will be required to work on-site at the customer headquarters in Ottawa, ON. Equipment Required You will be expected to have your own laptop to perform the work. A laptop will not be...

  • Senior ECM Business Analyst

    4 weeks ago

    Ottawa, Canada LeverageTek IT Solutions Full time

    LeverageTek is actively seeking a Business Systems Analyst - OpenText ECM for a 9-month contract with its Ottawa-based customer.Work Location The successful candidate will be required to work on-site at the customer headquarters in Ottawa, ON.Equipment Required You will be expected to have your own laptop to perform the work. A laptop will not be...

  • Business Analyst

    1 day ago

    Ottawa, Ontario, Canada 2i Solutions, Inc Full time

    There is a 10 month contract opportunity for Business Analyst – INT in Ottawa.Reliability level security clearance is a must.Must have Experience in contributing to the success of a range of small-to-medium initiatives with escalating levels of complexity and business criticality.Experience in a business analyst role and / or in other relevant roles within...

  • Senior ECM Business Analyst

    2 days ago

    Ottawa, Ontario, Canada LeverageTek IT Solutions Full time

    LeverageTek is actively seeking a Business Systems Analyst - OpenText ECM for a 9-month contract with its Ottawa-based customer. Work LocationThe successful candidate will be required to work on-site at the customer headquarters in Ottawa, ON. Equipment RequiredYou will be expected to have your own laptop to perform the work. A laptop will not be provided....

  • Business Analyst

    2 weeks ago

    Ottawa, Canada Canada Foundation for Innovation Full time

    With a bold, future-looking mandate, the Canada Foundation for Innovation equips researchers to _ - be global leaders in their field and to respond to emerging challenges. Our investments in state -of-_ - the-art tools, instruments and facilities underpin both curiosity - and mission-driven research that _ - cuts across disciplines and bridges all sectors....

  • Business Analyst

    1 day ago

    Ottawa, Ontario, Canada 2i Solutions, Inc Full time

    We have an excellent 1 year contract opportunity, with strong possibility of extension, for a Business Analyst, in Ottawa. Work would be done remotely until the pandemic situation normalizes. Reliability level Federal Security clearance is mandatory Experienced in effectively interacting and communicating with business teams; can consolidate business...