Business Intelligence Solutions Analyst

Canadian Medical Protective Association; Ottawa; Remote; CAD 100,000 - 135,000; Full time

Job summary

A healthcare protection association is seeking a BI Solutions Analyst to develop business intelligence solutions, collaborate with various teams, and enhance decision-making through data. The ideal candidate has extensive experience with BI tools, including IBM Analytics, and strong analytical capabilities. This is a remote full-time position based in Ontario or Québec, with a competitive salary range of $100,400 - $134,300.

Benefits

Equal opportunity employer

Support for disabilities

Culture of inclusion

Qualifications

• 7+ years of relevant work experience, 3+ years with IBM Analytics or similar.
• Experience with SQL and understanding of database architecture.
• Client-focused with strong interpersonal skills.

Responsibilities

• Develops BI solutions and reports for internal clients.
• Collaborates with teams to gather requirements.
• Maintains existing BI solutions and provides data extracts.

Skills

Client relationship skills

Strong problem-solving skills

Communication skills

Analytical skills

Education

Minimum four-year Bachelor’s Degree

Tools

IBM Analytics (Cognos)

Informatica

Job description

POSITION OVERVIEW

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 operational 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 Business Capability Enablement team, other BI Analysts, and the Data Management team to support the achievement of corporate priorities and plans while also working effectively independently to gather and define internal client requirements, build end user reports, and seek to answer business questions via data analysis. 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 others on the team, 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
• Installs, configures, and maintains BI application software (IBM Cognos, Informatica)
• Plays a key role in data quality management with key CMPA stakeholders (data owners, data stewards, source system experts, and knowledge experts)
• Maintains 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
• Works collaboratively with ITS development teams and other technical groups to evolve application architecture, manage technical debts, mitigate risks, and plan for technology changes

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 preparing and performing complex data analyses (data cleaning and preparation, analysis and critical thinking, data visualization, communication)
• 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 (Medico-Legal, Finance, Customer Relationship Management (CRM), Risk Management, and/or 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 analyse and provide creative and innovative solutions to business problems
• Sound problem-solving skills and the ability to multi-task, set priorities, and meet deadlines
• Excellent interpersonal, communication, and networking skills, with the ability to facilitate discussions and decision making using strong written/verbal skills to present complex issues in an understandable manner
• Ability to understand the strategic level view and draw connections between organizational considerations and external factors is essential
• Proven ability to work independently and as a team member, possessing good judgement and initiative to set and achieve goals
• Excellent verbal and written communication and presentation skills in English
• Ability to lead projects (e.g., development of complex reporting, adoption and implementation of new technologies)
• Ability to communicate effectively in a group setting or one-on-one to explain complex concepts clearly to both technical and non-technical team members and to instruct others in the use of new data, technology, and/or processes
• Strong analytical and problem solving skills with the ability to interpret analytical results and report findings in a meaningful way to the intended audience
• Ability to foster a positive, collaborative team environment

POSTING DETAILS

• Job type: This is a regular full-time opportunity.
• Salary range: $100,400 - $134,300 – this role is classified as a level 9
• Location: Fully Remote - working from a home-based office anywhere in the provinces of Ontario and Québec
• Skill assessment: selected candidates may be required to complete a skill assessment
• Application deadline: October 14, 2025 at 4:00pm EST

The CMPA is an equal opportunity employer and is committed to being responsive to those living with disabilities and strives to prevent and remove barriers to accessibility. The CMPA will provide support and accommodation in its recruitment processes to applicants living with disabilities. If you are invited to participate in an interview and/or skills assessment and have accommodation needs, please let us know.

Equity, diversity, and inclusion (EDI) is a key priority, and we actively strive to build a culture of inclusion where employees can be their authentic selves and are valued for their diverse experiences and perspectives.

We welcome and encourage candidates from diverse backgrounds and a variety of lived experiences to apply.