Manager, Commercial Analytics Horizon Pharma
THIS JOB HAS EXPIRED Description
The Manager, Commercial Analytics will assume ownership of multiple database servers and databases within a start-up pharma organization. The majority of the databases being administered will have an analytics focus however some will be operational in nature. The activities called upon will include routine activities such as backups and system health management as well as availability planning including DR and business continuity; additionally operations activities to include scheduled job management and maintenance.
Perform day to day operational and maintenance and administrative actives in support of Development, Test and Production Databases
Design, develop and plan data integration and processes across multiple sources of data to improve data consistency and query speed.
Provide strategic leadership around the implementation of a new data warehouse and business intelligence solution.
Define, document and enforce standards for naming, describing, managing, modeling, storing, cleansing, transforming, searching and delivering data in and out of the data warehouse.
Review current BI solutions and make suggestions for potential enhancements.
Recommend strategic initiatives for data growth as new data sources are integrated (maintaining high scalability and availability).
Develop process for capturing and maintaining metadata from all data warehouse and data mart components.
Provide leadership and direction by setting priorities and managing follow-through.
Qualifications and Skills Required:
Information Technology Degree
5+ year?s experience with Microsoft SQL Server 2008 including backup, recovery, upgrade, high availability, administration, monitoring, tuning, data partitioning, indexing, ETL (SSIS), cubes (SSAS) and reports (SSRS).
7+ year?s experience with database architecture and data modeling.
7+ year?s experience with database security, performance, scalability and tuning
Highly effective collaboration skills and the experience and ability to operate across organizational disciplines; up, down and throughout the organization.
PREFERRED SKILLS and EXPERIENCE:
Pharmaceutical industry experience
SQL Server 2012 experience
Redgate SQL Toolbelt
VLDB experience (exceeding 2 TB)
Excellent verbal, technical writing and documentation skills
High degree of independence and exceptional work ethic
Excellent problem-solving skills
Strong interpersonal and communication skills; able to translate complex analysis into persuasive recommendations, tailored for multiple audiences. Professional, proactive demeanor.
Essential Core Competencies:
Drive for Results
Dealing with Ambiguity
||Deerfield, IL |
THIS JOB HAS EXPIRED