Job Openings >> Business Intelligence Analyst
Business Intelligence Analyst
Title:Business Intelligence Analyst
Location:Virtual (North America)

Morneau Shepell is in the business of helping organizations help their people because we believe that engaged people are the driving force for society. Every day, the expertise of our employees is recognized as essential to the financial security, health and productivity of our clients and their people.

We are always looking for talented professionals and strategic leaders who will listen and work together with colleagues to form long-term relationships and to deliver integrative solutions that fit.

As we continue to grow, we’re presently engaging with exceptional candidates interested in the following opportunities. Read on to see if we have a career solution for you.

Lifeworks by Morneau Shepell – Operations

LifeWorks by Morneau Shepell’s industry leading employee assistance program supports employees and eligible family members in assessing their work, life, and health issues and is delivered in-person, telephonically, video counselling, first chat, and our MyEAP mobile application.

Based in our Morneau Shepell Office and reporting to the Supervisor of Business Intelligence, this role will be responsible for the analysis, design, development and deployment of BI applications using Microsoft Business Intelligence tools and Cognos. This role will provide highly valued client and business intelligence that drives the planning, management and measurement of our business.

The ideal candidate will have the ability to communicate effectively in technical and non-technical environments. Additionally, they will display excellent collaboration and organizational skills, including the ability to maintain exceptional client support and prioritize tasks.

Responsibilities include, but are not limited to:

  • Lead and/or partner with clients in planning, designing, implementing, optimizing, administering, and evaluating BI solutions, including big data solutions, open data, queries, reports, dashboards, and other visualizations based on stakeholders needs
  • Leverage business and statistical knowledge to transform data into information
  • Elicit, document, and confirm business requirements and technical specifications
  • Define standards for the integration and governance of enterprise data
  • Design metadata management programs and scripts
  • Define and evaluate conceptual, logical, and physical BI solution architectures
  • Design healthcare business information structures (cubes, dimensions, facts, tables, etc.)
  • Perform data quality assessments, data transformation, and data cleansing
  • Develop test scripts and perform testing of BI solutions
  • Mentor and coach clients and Client Success team members on BI knowledge and skills


  • Experience confirming clinical and business requirements from a broad community of stakeholders
  • 3+ years’ experience in the design, development and management of databases, data warehouses, data lakes, reports, dashboards and other forms of visualizations
  • Demonstrable experience with a wide variety of BI tooling, including: Tableau, Microsoft Power BI, Information Builders; Quilk, IBM Cognos, SAP, MicroStrategy, Sisense, Salesforce, etc.
  • Knowledge and experience with statistical applications, such as SAS, R, GNU Octave and PSPP
  • Ability to write advanced SQL queries
  • Proficient with the Microsoft Office suite of tools (Word, Excel, PowerPoint, Visio)
  • Effective verbal and written communication skills
  • Demonstrated leadership and people management skills
  • Ability to work both independently and collaboratively with Business Intelligence stakeholders
  • Demonstrable organizational, analytical and innovative thinking skills
  • Excellent interpersonal and facilitation skills
  • Strong time management skills (ability to simultaneously manage multiple tasks and projects).

Nice to haves:

  • Experience in facilitating meetings with diverse groups of stakeholders (e.g. technical, clinical, executive)
  • Proficient public speaker
  • Experience leading project teams
  • Experience evaluating design options to support the implementation of a system
This opening is closed and is no longer accepting applications
Powered by ApplicantStack