Canada DBA Job


DBA Resources



Business Intelligence (BI) Team Lead, Global Services - Johnson & Johnson Inc.

More Database and SAP Jobs in Toronto, Ontario

Business Intelligence (BI) Team Lead, Global Services - Johnson & Johnson Inc. - Guelph, Markham or Toronto, ON, JOHNSON & JOHNSON

Toronto, ON, CANADA
Posted Mar 30, 2011 1 Position(s)


Johnson & Johnson companies are equal opportunity employers.

Business Intelligence (BI) Team Lead, Global Services - Johnson & Johnson Inc. - Guelph, Markham or Toronto, ON-0931110110


Johnson & Johnson Inc. is a member of the Johnson & Johnson Family of Companies, the world's most comprehensive and broadly based manufacturer of health care products, as well as a provider of related services, for the consumer, pharmaceutical, and medical devices and diagnostics markets. In Canada, Johnson & Johnson Inc. markets innovative consumer products focusing on skin and hair care, baby care, wound care, oral health and women's health as well as a broad range of well-known and trusted over-the-counter products through our McNeil Consumer Healthcare division.
At Johnson & Johnson Inc. our purpose is to "Bring Science to the Art of Healthy Living" by providing Canadians with some of the most world's most widely used and trusted brands including; JOHNSON'S ® Baby, NEUTROGENA®, AVEENO® LISTERINE®, BAND-AID® Brand Adhesive Bandages, TYLENOL®, REACTINE® , BENYLIN® , NICORETTE®, NICODERM® and many more. Based in Markham, Ontario, Johnson & Johnson Inc. employs approximately 400 people and is supported by two manufacturing sites and two R&D facilities located in Guelph, Ontario and Montreal, Quebec.
Position Summary:
The Business Intelligence Team Lead, Global Services is responsible for managing all project and design activities he/she is assigned on behalf of the Global Services BI Team, supervising and developing more junior staff and developing and managing ongoing business relationships with other BI and affiliate functional partners. Affiliate partners include Pharma (Janssen), Consumer and J&J Medical Companies.
Key functions:
Practices effective project management including requirements gathering, design, development, testing, training and documentation
Assumes the key lead role for BI Team tasks on all BI projects
Serves as the primary IT/Business partner for BI Team related functions
Provides technical support to all supported systems
Translates business requirements into system solutions
Collaborates with affiliate power users to develop program and report specifications
Gathers data, researches and analyzes specific business problems with end users
Ensures consistent application of and compliance with Global Services/J&J change management practices
Troubleshoots any functional and technical system problems
Investigates future software releases and opportunities, assessing the impact on affiliate companies.
Liaises and partners effectively with Global Services teams, Partners, and outside vendors supporting Cognos and SAP BW technical requirements (Basis, ABAP, security/profiles, Cognos consultants, vendor help desk, etc.).
Defines continuous improvement opportunities for Global Services BI.
Develops technical specifications, documentation, and processes in accordance with J&J systems SDLC.
Works with the Manager, Business Intelligence to create and manage activities for more junior staff
Develops recommendations for work streams to make the BI team more efficient.
Manages workloads of external consultants.
Travel required to other Canadian J&J operating companies and to the U.S. occasionally.


Bachelor degree or above in Computer Science, Science or Business Degree required
A minimum of 5 years hands on experience in a BI environment utilizing Cognos Business Intelligence and SAP BW required
Excellent skills in ETL technologies (SQL scripting and one of Cognos Data Manager or Informatica ETL) required
A minimum of 3 years experience in Database Design, Architecture and Data Modeling required
Active participation in at least two Cognos or SAP BW implementations or upgrade projects required
Good troubleshooting and decision making skills required
Strong leadership and project management skills to lead and direct a technical team required
Ability to translate business requirements into system solutions required
Excellent written and verbal communication skills and facilitation skills required
PMP designation an asset
Healthcare or CPG industry experiences an asset

Primary Location

North America-Canada-Ontario-Toronto


Janssen Inc. (7710)

Job Function

Info Technology

Last updated on April 2, 2011