[The logo is protected from the company]

Celgene Corporation

Celgene is a global biopharmaceutical company committed to improving the lives of patients worldwide.At Celgene, we seek to deliver truly innovative and life-changing drugs for our patients. Our mission as a company is to build a major global biopharmaceutical corporation while focusing on the discovery, the development, and the commercialization of products for the treatment of cancer and other severe, immune, inflammatory conditions.There are more than 300 clinical trials at major medical c... Read More

Address      86 Morris Avenue Summit, NJ 07901
Website      www.celgene.com
Holding      No Holding Details

View Company Page
Apply to job

Lead Analyst

Celgene Corporation is committed to delivering innovative therapies designed to improve the lives of patients worldwide. We are a global biopharmaceutical company with operations in more than 70 countries that is helping to turn incurable cancers into chronic, manageable conditions. We are seeking talented professionals as we continue to grow and advance our efforts in oncology, hematology and immune and inflammatory disease. If you would like to join a company where you can make a difference, please consider the Celgene family.


- 10 years of BI/Data Warehousing experience.
- Expertise with Business Objects and another leading BI and Reporting tool (e.g. OBIEE, Cognos, Qlikview, Informatica, DataStage).
- Maintains a working knowledge of the Business Intelligence (BI, OLAP, ROLAP) tools in the market.
- Bachelor’s degree required. Business Objects Certifications desired.


This position is responsible for taking a lead role in business intelligence (BI) and data warehousing (DW) solutions; including but not limited to: project planning; directing the work of others (consultants and employees); driving high-level BI solution directions; BI solution design and development; tool architecture, design, administration and deployment/upgrade strategy; dimensional modeling; report creation and distribution; development, documentation and presentation of BI standards and guidelines; logical and physical data model design, database tuning/optimization, design and development of ETL processes. Additionally, this person will have responsibility for analyzing customer requirements as well as identifying and implementing strategies. This is a hands-on technical leadership individual contributor role.

Responsibilities will include, but are not limited to, the following:

- Architects and develops proof of concept prototypes for Business Intelligence next-generation toolset. Champions and promotes the proposed toolset to the internal community while maintaining exist tool set.
- Facilitates clients, both internal and external in defining software requirements for BI solution to add business value.
- Designs and documents BI & DW requirements by preparing diagrams, logic charts and programming specifications as required.
- Participates in problem resolution tasks and documents approach for support when applicable.
- Lead and /or participation in analysis, design, development, testing, deployment and support of “Small to Large” project efforts for dashboards, reports, integration.
- Oversees administration of BI tool set & metadata,
- Analyzes and proactively monitors current reporting/BI environment recommending and implementing improvements
- Work with Business Partners to set up or perform training on BI tools and core competencies
- Act as expert in BI technologies and deployed tools, and report/dashboard creations with those tools
- Architects, develops configuration or improvements to configuration of BI environment

Skills/Knowledge Required:

- 11 years of Data Warehousing Experience
- Able to function as a Business Intelligence Architect and/or Data Architect
- Possess knowledge of the inherent challenges for a Data Warehouse/Business Intelligence Implementation
- Ability to leverage past experience to perform Data Warehouse Business Intelligence tool evaluations
- Expertise with Business Objects and another leading BI and Reporting tool (e.g. OBIEE, Cognos, Qlikview). Maintains a working knowledge of the Business Intelligence (BI, OLAP, ROLAP) tools on the market.
- Knowledge of Best Practices for the following: Information Delivery Architecture, Data Architecture
- Ability to estimate Data Warehouse and Business Intelligence resource requirements for projects
- Knowledgeable with both Entity Relational and Dimensional Models.
- Knowledge of SQL and database technologies (e.g. partitioning, indexing)
- Working knowledge of Extract, Transform, Load (ETL) tools and their use (Datastage, Kalido, Informatica)
- Ability to quickly grasp the Pharma business and how to apply tools to add business value
- Ability to work effectively in a team environment and independently
- Ability to communicate effectively and professionally to both technical and business staff
- Demonstrate an openness to learning new things
- Listen with the intent to understand, not with the intent to reply
- Focus equally on financial excellence, customer satisfaction, and workplace quality
- Complete work to the expected standards (quality, cost, schedule, behavior)
- Adjust to unexpected demands and other contingencies
- Seek and share information
- Explore different ideas, information or trends to identify new thinking

Celgene is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status.

Celgene complies with all applicable national, state and local laws governing nondiscrimination in employment as well as employment eligibility verification requirements of the Immigration and Nationality Act. All applicants must have authorization to work for Celgene in the U.S.

Employment applicants requiring immigration sponsorship must disclose, when initial application for employment is made, whether or not they are legally authorized to work in the U.S. and, if so, whether that authorization permits them to work in the job they seek. In no case should Celgene support of a potential employee’s temporary visa application be construed to guarantee success of that application or amend or otherwise invalidate the "at-will" employment relationship between the employee and Celgene.

Other Job Information

Vacancy type:

Full Time

Contact Mode:

not provided


not provided

Contact Name:

not provided

Job Duration:

not provided




not provided

News - Celgene Corporation

Related Jobs

System/Project Executive

Project Management Represent Consumer Sales ...   [more]

Technical Project Manager Translation & Interpreta

Translation Processing - Establish Computer Aided Trans ...   [more]

System Administrator

DescriptionNucor Steel Louisiana, LLC is seeking qualifi ...   [more]

Business Process Analyst

Job Function            The primary job of this position ...   [more]

Business Process Analyst

Job Function            The primary job of this position ...   [more]

IT Integration Programmer Analyst

Integration Programmer Analyst responsible for the desig ...   [more]

Sr Programmer Analyst

The Sr. Programmer Analyst position performs a key role ...   [more]

Staff Systems Analyst

This Systems Analyst position will have definition, desi ...   [more]