16 hours

IT Lead Analyst, ETL/Data

Dendreon Corporation
  • Job Code
Careers Center | IT Lead Analyst, ETL/Data
  • IT Lead Analyst, ETL/Data

    Location US-NJ-Bridgewater
    Job ID
    Pos. Type
    Full Time
  • Overview

    The IT Lead Analyst – ETL/Data will be a member of the Valeant IT Commercial Operations team supporting Data and ETL based processes related to Healthcare Practitioner (HCP), Healthcare Organization (HCO), Field Sales Hierarchy, Roster, and other types of Master Data. This role demands a high degree of pharmaceutical domain knowledge in the commercial area.

    Activities include: develop and maintain current and future state business architecture, business process design, data analysis & requirements, design and configuration specifications, test case development, production implementation and support.



    Technology Architecture

    • Design & oversee implementation of relational databases
    • Design & oversee implementation of ETL processes related to pharmaceutical commercial operations.
    • Deliver architectural initiatives for the quarterly Call Plan process
    • Deliver architectural initiatives to support daily operations and integrations with vendor data providers
    • Maintain an in depth knowledge of the organizations technologies and architecture
    • Develop, communicate, and deploy Enterprise Architecture processes.
    • Prepare solution design specifications employing use case documents, diagrams and screen mockups as required.
    • Develop test plans and test cases and support the business in its execution of user acceptance testing activities.
    • Function as subject matter expert on architecture techniques and supervise the creation of detailed specifications for the business

    Data Architecture

    • Understand Valeant’s Call Plan data flows and daily/weekly processes
    • Develop best practices for managing data.
    • Identify data risks and propose alternative solutions to data management
    • Knowledge of ETL Processes, Data Mapping, Data Quality, Data Integration

    Project Management

    • Work directly with the project manager for development of the project plan and needs
    • Provide Architectural direction to Enterprise Architects, Business Architects and Solution Architects.
    • Responsible for the project when the project manager is not available.
    • Support the project throughout the life cycle of the project.
    • Work directly with Onshore and Offshore Architects, Developers and QA testers.


    • CRM Applications (Salesforce.com, Veeva, Dynamics CRM)
    • Call Plan Processing
    • Master Data Management Systems (Reltio, Informatica MDM)
    • Data Warehousing (SQL Server, MS SQL Data Warehouse)
    • Informatica (PowerCenter, Cloud)
    • SQL Server Integration Services


    Desired Experience

    • B.S. - Computer Science or Information Systems related degree
    • 6+ years supporting CRM applications
    • 5+ years pharmaceutical industry experience
    • 2+ years supporting Call Plan processes in a Pharmaceutical environment
    • 4+ years supporting data integration to and from Salesforce.com/Veeva.

    Personal Competencies

    • Work well both as a team leader and independently
    • Strong customer service orientation and interpersonal skills with the ability to achieve results by influencing others in a positive and effective manner
    • Detail-oriented, analytical, problem solver, swift decision maker
    • Able to handle customer requests from multiple sources and to balance competing priorities
    • Must adapt well to changing business needs
    • Ability to thrive in a fast paced environment
    • Excellent communication skills; both oral and written
    • Strong business knowledge and analysis skills

    Be Aware of Recruiting Fraud

    Job Applicants should be aware of job offer scams perpetrated through the use of the Internet and social media platforms.


    To learn more please read Valeant’s Job Offer Fraud Statement.



    Valeant Pharmaceuticals International, Inc. is committed to leveraging the talent of a diverse workforce to create great opportunities for our business and our people. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.


    Before you go...

    Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

    Share this job:

    IT Lead Analyst, ETL/Data

    Dendreon Corporation

    Share this job

    IT Lead Analyst, ETL/Data

    Dendreon Corporation

    Separate email addresses with commas

    Enter valid email address for sender.

    Join us to start saving your Favorite Jobs!

    Sign In Create Account
    Powered ByCareerCast