Business Intelligence Reporting Analyst

Description

Position at Canadian Medical Protective Association

■ 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

Reporting to the Manager, Data and Business Intelligence, the BI Reporting Analyst is primarily responsible for working with internal clients to understand their reporting needs and then developing and producing BI reports accordingly. The incumbent will also assist users in the creation of their own reports based on corporate and/or operational requirements. The BI Reporting Analyst provides input and guidance on the data modelling process and design of data marts, has a working knowledge of the technologies utilized in the BI system, and can apply the techniques and methods in the definition of business requirements. The incumbent has a strong understanding of corporate ERP systems and processes which the business intelligence team uses in its capacity to support corporate information management and performance reporting.

POSITION ACTIVITIES

Report Development

• Develops corporate and operational reports and dashboards and detailed functional specifications
• Supports the BI Solutions Analysts with data modelling activities
• Writes SQL scripts to extract data in support of report development and data analysis
• Collaborates with others in Data and Business Intelligence to ensure clients’ requirements are met through report design
• Works with business representatives to develop testing strategies and plans, as well as the execution of test plans
• 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 internal clients to understand their reporting requirements and business questions
• Assists users in creating their own reports, dashboards, and ad-hoc data extractions

Other Activities

• Facilitates and organizes meetings with clients as required
• Performs gap analysis and data analysis as required
• Remains vigilant of industry and technological changes to improve knowledge and working skills related to areas of expertise and new technologies
• Provides user training on systems and reporting capabilities
• Maintains documentation and stored metadata
• Maintains knowledge of CMPA business processes and business rules and industry best practices
• Performs performance tuning of reports
• Develops sections and/or provides input into the project plan and schedule throughout the life cycle of a project and when unforeseen issues arise
• Troubleshoots and fixes reporting-related issues as they arise
• Assists other CMPA teams to ensure smooth and timely integration of new technologies

Education And Experience

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

Skills And Abilities

• Strong interpersonal skills and the ability to collaborate with clients to meet their needs
• Strong verbal and written communication skills in English
• “Power User” competency with Business Intelligence Online Analytical Processing and reporting tools and applications (IBM Analytics, SAS, Tableau, Power BI, Excel, etc.) is highly desirable
• Ability to analyze and provide creative and innovative solutions to business problems
• Ability to maintain high productivity amidst competing priorities and tight timelines
• Strong SQL coding skills are essential; Oracle, PL/SQL, and Unix scripting experience are considered an asset

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.