Business Intelligence Developer - 3 to 6 Month Contract in Ontario at Innomar Strategies

Date Posted: 4/29/2021

Job Snapshot

Job Description


Reporting to the Manager, Business Intelligence, the Business Intelligence Developer 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.


  • Advanced ETL development skills using SQL server, SSIS
  • Advanced development skills using SAP Business Objects Suite
  • Advanced data modelling and data warehousing skills
  • Creating solutions for clients (internal and external) in a number of formats, including Excel, Crystal Reports, Business Objects Enterprise;
  • Work with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use
  • Working with the technical team to establish protocols to extract data in a standardized process from a variety of data sources;
  • Training of end users on the analytical tools developed by the Business Intelligence team;
  • Writing functional and/or technical documents
  • Analyzing large amounts of data to provide concise, targeted reports for internal and external clients;
  • The Business Intelligence Specialist will also be assigned other duties and tasks as required from time to time and including possible travel (5%)

Job Requirements


  • Bachelor degree or above qualification preferably in Information Systems, Computer Science or equivalent
  • Minimum 7 to 10 years of directly related experience in 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 wholesale 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.
  • Any additional industry certifications would be an asset


  • 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
  • Experience with problem, Change and Incident Management practices (ITIL)
  • 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