Job Title

JOB TITLE: Analyst - Commercial Insights & Analytics - Rare DiseaseLOCATION: Plainsboro, NJ hybrid (2-3 days in-office per week)DURATION: 6 months with potential to extendSCHEDULE: 9 to 5pm EST TIMEApply promptly! A high volume of applicants is expected for the role as detailed below, do not wait to send your CV.TOP MUST HAVES:1. Experience with Tableau2. Ability to present data with meaningful insight.3. Ability to function effectively in a fast-paced environment.PURPOSEProvide analytical and reporting support to CI&A Rare Disease team managing day to day data handling activities, ad-hoc analysis and data requests and reporting activities of assigned departments.RELATIONSHIPSReports to Commercial Insights & Analytics leader supporting Rare Disease business. Internal relationships include close interactions with CI&A Rare Disease team, cross functional colleagues in other Commercial Insights & Analytics groups like Data Strategy and Advanced Analytics, Finance, Marketing, Medical, Market Access as well as global partners.External relationships include interactions with external data partners and consultants.ESSENTIAL FUNCTIONSDATA MANAGEMENT, ANALYSIS AND REPORTING:Updates and processes secondary data feeds from industry sources (e.g. Komodo, IQVIA, Decision Resources, prescriber, payer, patient and promotional sources, etc.) and internal data (call files, sales data, etc.) into excel and/or other custom programsManages and employs data to create market trend and product performance analysis Design, develop and maintain recurrent monthly /quarterly and ad-hoc reports using advanced query techniques for customers; provides analysis and interpretation of the report dataEnsure distribution pre-established on-going (weekly, monthly) reports and dashboards in line with business needs and objectivesMaintains and develops (in close collaboration with internal data strategy) databases and analytic applications in environments such as Tableau, SAP, Excel/Access, and/or other proprietary environmentsContribute to hypothesis driven investigations into detailed channel dynamics, prescriber, patient and transactional dataMaintains catalogue of standardized market definitions and analytical business rules used within the analyses and reports, while proactively monitoring areas of concern or opportunity for enhancementsLeverages internal data systems and tools to efficiently maintain data and reporting processes to minimize manual data updatesEnsures timely receipt of data from vendors and ensures data integrity and quality throughout all processesCOLLABORATION & COMMUNICATION:Develop and sustain close working relationships with key business partners, including commercial, medical and operations business colleagues (US & Global) as requiredProactively monitors areas of concern or opportunity for enhancements and provides recommendations/proposals, supports relevant analysis as neededDevelopment and execution of presentations with clear storylines, grounded on holistic business concepts and communicate key conclusions and business recommendations /implications (what/so what and now what) to business partners and peers through formal and informal channelsAnalytical thinker and creative problem solver, ability to influence others with verbal and written communicationCrafts clear narrative, uses it to develop own perspective and recommendations, even if others may disagree, and takes a standQUALIFICATIONSBachelor's degree required; advanced degree preferred2+ years of analytics and reporting experience required, preferably in a pharmaceutical industry, - consumer packaged goods, or marketing organization consideredAble to create effective reports that present data in meaningful and cohesive story telling presentation for commercial team consumption - not just data dumpExperience manipulating and analyzing complex datasets including specialty pharmacy, Komodo, IQVIA (Xponent, DDD), Patient Level Claims Data, and other proprietary sourcesProficiency working with Tableau, Excel and other data manipulation and analysis platformsStrong PowerPoint and Excel skillsDemonstrated ability to work on multiple projects with conflicting deadlinesPositive and eagerness to learn, collaborate and partner with internal business colleaguesDemonstrated ability to work on multiple projects with conflicting deadlinesExcellent verbal, writing, presentation, project management and effective influencing skills requiredWork independently - Gather input about needs from business partners and set own direction accordingly