Share this Job

Application Developer - 12 months contract

Date: Jul 22, 2021

Location: Toronto, Ontario, CA, M1B 2K9

Company: Teva Pharmaceuticals

Company Info

Teva is a global pharmaceutical leader and the world's largest generic medicines producer, committed to improving health and increasing access to quality health solutions worldwide. Our employees are at the core of our success, with colleagues in over 80 countries delivering the world's largest medicine cabinet to 200 million people every day. We offer a uniquely diverse portfolio of products and solutions for patients and we've built a promising pipeline centered around our core therapeutic areas.  We are continually developing patient-centric solutions and significantly growing both our generic and specialty medicines business through investment in research and development, marketing, business development and innovation. This is how we improve health and enable people to live better, healthier lives. Join us on our journey of growth!

Job Description

The IT Business Applications the Analyst/Developer is responsible for implementing and supporting Oracle Business Intelligence solutions in Commercial, Finance, Sales & Marketing, Supply Chain Planning and Manufacturing analytics. The incumbent will apply their knowledge in Data warehousing/Data modelling within an Oracle 11g database environment and utilize the various OBIEE 11g and OBI Apps (Informatica / Datawarehouse Administration Console) tools  to build reports and dashboards including ETL design /development

Implement solutions with ability to work in all aspects of the SDLC (Discovery, Design, Development, Testing, Deployment, Maintenance)

  • Production support activities as needed including
    • Technical support for BI end-users
    • Access requests to dashboards/reports
    • Troubleshooting data integrity issues
    • Debugging ETL failures
    • Occasional after-hours support as needed
    • Performance tuning (OBI and database)
  • Elicit/Gather requirements from various stakeholders to enhance or create new reporting solutions
  • Translate the Functional requirements to document the technical design specifications
  • Deliver solutions to support various BI initiatives using OBIEE / OBIA
    • Dimensional Modelling for the Datawarehouse (Oracle 11g)
    • Build the OBI metadata repository (RPD Modeling)
    • Create ad hoc queries for business users
    • Build BI dashboards and analyses including incorporation of prompts, views and graphs
    • Setting up agents to schedule report/dashboard delivery
    • BI Publisher
    • Configuration of security for the various objects (data and object level)
    • Utilize Data Warehouse Administration Console (DAC) and various Informatica client tools for customizing or building new extract, transform and load (ETL) metadata
  • Assist business users with User Acceptance Testing
  • Migration of the various OBI deliverables (RPD, Webcat, Informatica/DAC metadata) to production environment(s)
  • Installation, Configuration and Administration of the BI environment : OBIEE / and OBIA DAC11g & Informatica 9.5.1, as needed



  • Post-secondary degree/diploma in an business administration, computer science, or information technology.
  • 5+ years of experience with Oracle Business Intelligence Enterprise Edition 11g in medium to large manufacturing and commercial organization; 7+ years of experience with Oracle Business Intelligence Enterprise Edition 11g in medium to large manufacturing and commercial organization is preferred.
  • Oracle Business Intelligence Enterprise Edition 11g (certification preferred), Oracle Business Intelligence Applications (Informatica 9.5.1 and DAC 11g), Unix Experience, Oracle 11g Database experience with SQL proficiency including Oracle PL/SQL
  • Pharmaceutical industry and knowledge of GMPs regulations is a strong asset
  • Experience in leading application testing
  • Proven experience with business and technical requirements analysis, modeling, verification
  • Open-minded, creative, strategic and innovative thinker with excellent analytical, mathematical, and creative problem-solving skills


Information Technology

Sub Function

Application Development

Reports To

Director, IT Business Applications

Already Working @TEVA?

If you are a current Teva employee, please apply using the internal career site available on "Employee Central". By doing so, your application will be treated with priority. You will also be able to see opportunities that are open exclusively to Teva employees. Use the following link to search and apply: Internal Career Site

The internal career site is available from your home network as well. If you have trouble accessing your EC account, please contact your local HR/IT partner.

Teva’s Equal Employment Opportunity Commitment

Teva Pharmaceuticals is committed to equal opportunity in employment. It is Teva's global policy that equal employment opportunity be provided without regard to age, race, creed, color, religion, sex, disability, pregnancy, medical condition, sexual orientation, gender identity or expression, ancestry, veteran status, national or ethnic origin or any other legally recognized status entitled to protection under applicable laws.