Roles and Responsibilities
Under close guidance or supervision, responsible for creating and maintaining the IMS database.
Will be part of the Phoenix Parallel team.
Implements database setups of development, user acceptance test, and production environments
Participates in database analysis and database design tasks to meet required operational standards and performance levels
Optimizes queries, stored procedures, etc. for high throughput, availability, scalability, redundancy, superior performance and quick recoverability
Monitors, manages, and supports multiple local and remote SQL server instances on Windows boxes
Resolves production related issues and requests, and clarifies issues with relevant production teams Interacts with production teams to update details of all production related binding documents
Participate in data supplier calls to monitor the status of data issues and ensure follow ups are done and progress is being tracked.
Monitors data loading jobs across different IQVIA systems
Assures the accuracy and timeliness of additions and modifications to the IMS sales databases through input from internal and external sources, while understanding the impact of data trends and on all stakeholders.
Identifies assigned supplier and database exceptions through Quality Control review and / or maintenance within the file and resolves data issues.
Ensures all maintenance performed rules and protocols.
Makes daily verification supplier processing and output and applies corrections as needed.
Assures that decisions made follow the protocols. Visually monitors data for any trends in the weekly client information.
Maintains documentation of Quality Control Procedures.
List of required skills for this role :
Bachelor’s / College Degree in Computer Science, Information Technology, Mathematics, Statistics, Actuarial Science, Business, Communication or equivalent preferred
Minimum of 2 years relevant work experience preferred Proficient in Windows applications (Excel, Word, Access, PowerPoint, etc.).
Basic SQL skills is preferred.
Excellent written and oral communication skills
Can effectively communicate with various levels of the organization
Strong ability to deal tactfully with internal and external clients through emails or calls
Excellent organizational and time management skills are required Demonstrate strong problem solving and analytical skills, can process and understand large amounts of data to isolate issue in question, identify patterns and trends in data sets
Experience working in a mainframe environment preferred. Knowledge and understanding of the pharmaceutical industry is a plus.
Knowledge and relevant background on IQVIA syndicated sales and prescription data, and in-depth understanding of the US pharmaceutical industry and market dynamics is a plus
Time Management skills and ability to work independently.
Ability to resolve basic problems pertaining to database issues.
Ability to identify / eliminate repetitive problems and standardize the processes by using existing research tools.