This site uses cookies. To find out more, see our Cookies Policy

Business Intelligence Analyst in Oakville at Innomar Strategies

Date Posted: 5/30/2018

Job Snapshot

Job Description

Reporting to the Manager, Business Intelligence, the Business Intelligence Analyst will be responsible for working with internal and external clients to develop reporting/analytics solutions in response to requests of a diverse scope.

This individual will be accountable for the design, implementation and management of all aspects of the solutions, including interaction with the IT department to support development of the reporting/analytics tools necessary to accomplish the appropriate solution(s).

The individual must be able to work independently and as a team member with minimal supervision while providing the necessary solution(s) to the client.


  • Creating solutions for clients (internal and external) in a number of formats, including Excel, Crystal Reports, Business Objects Enterprise;
  • Training of end users on the analytical tools developed by the Business Intelligence team;
  • Analyzing large amounts of data to provide concise, targeted reports for internal and external clients;
  • Provide project management for IT implementations and database updates;
  • Working with the development team and IT group to design reporting analysis tools for internal and external use;
  • Writing functional and/or technical documents; 
  • Working with the technical team to establish protocols to extract data in a standardized process from a variety of data sources; 
  • The Business Intelligence Analyst will also be assigned other duties and tasks as required from time to time.

Job Requirements

  • Min 5 to 7 years' experience in similar Business Analytics position(s)
  • Advanced working knowledge with MS Office, SQL, Business Objects, Crystal Reports
  • Good understanding and knowledge of working with Databases, SQL and scripts. 
  • Must possess strong analytical and problem-solving skills;
  • Familiar with Database design and modeling techniques, and ETL process.
  • Experience with pharmaceutical industry or wholesales distribution industry would be an asset; 
  • Experience with IT project management would be an asset;
  • Ability to read data models and comprehend database structures and relationships;
  • Strong oral and written presentation skills;
  • Strong ability to gather and analyze report requirements;
  • Works well cross-functionally and within a small team;
  • Excellent team player, and is not afraid to offer feedback.


  • Advanced knowledge of pharmaceutical distribution industry
  • Working knowledge of automated warehouse operating system
  • Strong business and financial acumen
  • Strong analytical and mathematical skills
  • Ability to communicate effectively both orally and in writing
  • Effective interpersonal and leadership skills
  • Effective organizational skills; attention to detail
  • Ability to consistently meet deadlines
  • Excellent problem-solving skills; ability to resolve issues effectively and efficiently
  • Excellent presentation skills
  • Knowledge of Microsoft Word, Excel, PowerPoint and other Office Programs