Data Integration Director

Shire Pharmaceuticals, Inc.Founded in 1986, Shire Pharmaceuticals Inc. is a global specialty pharmaceutical company. Our mission is to develop and market medicines that improve the quality of life for patients and their caregivers.Shire succeeds because of our people. Through teamwork, commitment, innovative thinking and energy, Shire will continue to grow as a world-class pharmaceutical organization. Due to our extended growth, we currently have a need for the following position:The Data Integration Director will be responsible for providing general direction supporting the design, development, integration, implementation and ongoing support of the data integration activities throughout the global organization. This accountability will include selection and management of external service providers, management of internal staffing, and management of commercial software licensing across the enterprise data integration solutions including FTP (file transfer protocol), ETL (extract, transform, load), Master Data Management, data transport monitoring, and exception handling processes. The principal responsibilities of the Director include:? Commercial and operational management of approved external service providers, including performance measurement against approved SLAs and financial management aligned to approved budgets? Significant collaboration with IS Business Partners to successfully plan and deliver the Data Integration needs of Business Partner approved projects within approved budgets.? Establishment and management of the Shire enterprise master data management approach, in significant collaboration with Shire Business Master Data Stewards and responsible Business Management ? Establishment and maintenance of key support processes and standards/guidelines aligned to data transports ? Provide operational leadership in the successful delivery and supporting the data integration support needs across the global Shire enterprise.Competencies for this position include:? Strong commercial experience focused on the selection and management of key IS service partners/providers? Demonstrated success in managing large projects that span the enterprise and delivering within budgets ? Demonstrated experience in managing a team comprised of both in-house and external resources in a ?co-source? environment, encompassing both project and ?Business As Usual? work? Prior experience with extraction, transformation, and load (ETL) technologies (Informatica PowerCenter 7.x or 8.x preferred).? Prior experience with DBMS systems (Oracle 10g and Netezza Performance Server preferred).? Prior experience with data extraction from ERP packages (Seibel CRM, SAP R3 and/or SAP BW preferred).? Prior experience with enterprise scheduling packages (UC4 preferred).? Understand data modeling and data warehouse methodologies (Dimensional modeling of Star/Snow Flake Schemas, Facts and Dimensions, Slowly Changing Dimensions, ODS, Data Marts).? Prior experience with FTP protocol and data migration techniques.? Prior experience with Data Quality packages (Informatica Data Quality preferred).? Prior experience with Data Profiling packages (Informatica Data Profiling or Informatica Data Explorer preferred).* Commercial and operational management of approved external service providers, including performance measurement against approved SLAs and financial management aligned to approved budgets (15%)* Significant collaboration with IS Business Partners to successfully plan and deliver the Data Integration needs of Business Partner approved projects within approved budgets (20%)* Establishment and management of the Shire enterprise master data management approach, in significant collaboration with Shire Business Master Data Stewards and responsible Business Management (20%)* Establishment and maintenance of key support processes and standards/guidelines aligned to data transports (20%)* Provide operational leadership in the successful delivery and supporting the data integration support needs across the global Shire enterprise. (15%)* Stay aware of commercially available technology solutions underpinning this area and evaluate for potential value to Shire (5%)* Commitment to Shire?s information security policy process and appropriate regulations (ex: SOX). Applying global data privacy controls as appropriate to Shire?s global enterprise data bank. (5%)Internal Information Services Contacts:1. IS Business Intelligence and ERP Center of Excellence2. IS Infrastructure Team members3. IS Help Desk4. IS Business PartnersInternal Shire Business Project Managers:External Vendor Contacts1. Data Warehouse Project implementation vendors2. Software Vendors3. Service ProvidersShire is committed to providing high quality, competitive, and appropriate health care benefits for employees and their families.Shire is an Equal Employment Opportunity and Affirmative Action Employer.Requirements: * Minimum 10 years IS experience within industry or service/consulting sectors with at least 3 of these years in a Senior role with Line Management responsibilities, preferably in a highly matrixed organization. * Minimum of 3 years demonstrated experience in developing and maintaining ETL and/or FTP solutions, ideally within a fast moving pharmaceutical or biotechnology company. Minimum of 2 years hands-on experience with Informatica PowerCenter.* A Bachelor?s degree is required in Information Technology or related field.Strong Knowledge of Systems Development Life Cycle.* Possess strong technology skills.* Excellent written and verbal communication skills across all levels of the Shire organization * Strong people skills enabling effective coaching and management of assigned staff * Demonstrated ability to delivering quality customer service* Strong results-orientation* Strong project management* Ability to effectively deliver services in a highly matrixed organization model* Ability to work independently with limited supervision. * Ability to operationally manage an environment being supported by both Shire staff and external partners/consultants.* Must be able to be flexible, multi-task and work in a fast-paced, high-performing environmentAutonomy:Works under general supervision. Uses discretion in identifying and resolving complex problems and assignments. Specific instruction is usually given and work is reviewed at frequent milestones. Influence:Interacts with and influences Business Management in developing the Shire enterprise approach to master data management. Some external contact with customers and suppliers.Complexity:Broad range of work, both management and operational.Business skills:Understands and uses appropriate methods tools and applications. Demonstrates strategic thinking to help underpin enterprise level support needs. Uses analytical and systematic approach to problem solving. Plans the work of teams. Can plan, schedule and monitor own work (and monitor work of IS vendors) competently within limited time horizons. Is able to absorb and apply new technical information. Is able to work to required standards and to understand and use the appropriate methods, tools and applications. Appreciates wider field of IS, how own role relates to other IS roles and to the business of the employer or clientApply to Shire