Senior Data Analyst
BioSpace - Palo Alto, CA
Apply NowJob Description
Salary Range: $114,000 - $131,000The following information aims to provide potential candidates with a better understanding of the requirements for this role.The pay range for this position is expected to be between $114,000 - $131,000 annually; however, the base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. The total compensation package for this position also includes medical benefits, 401(k) eligibility, vacation, sick time, and parental leave. Additional details of participation in these benefit plans will be provided if an employee receives an offer of employment.If hired, the employee will be in an "at-will position" and the Company reserves the right to modify base salary (as well as any other payment or compensation program) at any time, including reasons related to individual performance, Company or individual department/team performance, and market factors.Scilex Holding Company is committed to equal employment opportunities, and a workplace that embraces diversity and inclusion for qualified individuals of all backgrounds.About ScilexSCILEX HOLDING COMPANY (Nasdaq: SCLX, "Scilex"), is an innovative revenue-generating company focused on acquiring, developing, and commercializing non-opioid pain management products for the treatment of acute and chronic pain. We are uncompromising in our focus to become the global pain management leader committed to social, environmental, economic, and ethical principles to responsibly develop pharmaceutical products to maximize quality of life.The company's lead product ZTlido (lidocaine topical system) 1.8%, is a marketed prescription lidocaine topical product approved by the U.S. Food and Drug Administration for the relief of pain associated with Post-Herpetic Neuralgia (PHN), which is a form of post-shingles nerve pain. ZTlido possesses novel delivery and adhesion technology designed to address many of the limitations of current prescription lidocaine patches by providing significantly improved adhesion and continuous pain relief throughout the 12-hour administration period.We have acquired two FDA approved non-opioid pain products, GLOPERBA and ELYXYBTM, for the treatment of gout in adults and oral solution for the acute treatment of migraine, with or without aura, in adults. We launched ELYXYBTM in the U.S. in April 2023 and are planning to commercialize GLOPERBA in 2024.Our three product candidates are (i) SP-102 (10 mg, dexamethasone sodium phosphate viscous gel) ("SEMDEXATM"), a Phase 3, novel, viscous gel formulation of a widely used corticosteroid for epidural injections to treat lumbosacral radicular pain, or sciatica and has received Fast Track Status from the FDA. Currently, there is no FDA approved non-opioid epidural injection to treat lumbosacral radicular pain, or sciatica; (ii) SP-103 (lidocaine topical system) 5.4%, ("SP-103"), a Phase 2, next-generation, triple-strength formulation of ZTlido, for the treatment of low back pain ("LBP") and has received Fast Track Status from the FDA; and (iii) SP-104 (4.5 mg, low-dose naltrexone hydrochloride delayed-release capsules) ("SP-104"), a novel low-dose delayed-release naltrexone hydrochloride being developed for the treatment of fibromyalgia. If these product candidates are approved by the FDA, we believe each of them could become the treatment option for their respective indications in the United States.Role And ResponsibilitiesThe Senior Data Analyst acts as the SME for commercial data, reporting, and analytics workstreams for Scilex portfolio, including in-market, late stage, and early-stage pipeline products. This position will report to Associate Director, Sales Ops & Commercial Analytics within the Commercial Department. Will be primarily responsible for collection, curation of commercial data, creation, and delivery of standard reports & dashboards for executive and other home office decision makers and targeting/secondary data analytics.Conducts thorough data analysis and develops data flows aligned to strategic vision. Understands and considers the business implications of data and communicates with impacted groups, as necessary. Implements appropriate processes for defining data requirements with external and internal partners. Coordinates internally & externally to define, document, and execute the setup, quality, cadence, and method of delivery of data files. These efforts will provide a fact-based way to measure and monitor business performance. As such, the Sr. Data Analyst will help set the foundation to identify and address business-critical questions along with other insights and outputs delivered by the larger Commercial team.Key ResponsibilitiesCollaborate with the Commercial team to help synthesize insights in a streamlined manner.Architect complex data-centric and business intelligence solutions.Support advanced analytics efforts, such as HCP/account segmentation/targeting, subnational field effort analytics, marketing mix optimization, commercial ROI studies, and operational specialty pharmacy/specialty distributor channel analytics.Develop first-hand knowledge of datasets and function as data expert to navigate emerging business needs and evolving data landscape.Execute reporting suite for Commercial decision makers to enable "one view" of the market, ensuring single-source-of-truth reporting in collaboration with Commercial stakeholders. Master all Commercial data via governance and stewardship.Continuously improve quality of data content, context, and associated business rules to ensure front-end usability of commercial data.Consult with data custodians/IT to ensure safe custody, transport, and storage of commercial data and implementation of business rules.Manage complexities of fragmented data sets from Scilex Holding's distribution partners in the context of specialty distribution model for applicable products.Partner with IT and other functions to design and operate the customer master data management process, including business rule definitions and process flows to ensure data integrity and quality.Identify and track key performance indicators, such as product market share, duration of therapy, patient compliance, etc., using select claims and electronic health record data sources.Ensure that data flows and calculations are properly implemented on an ongoing basis.Ensure that the reporting suite is continuously relevant and meets emerging business needs by performing periodical audits.Monitor automated data collection, analytics, and cleansing infrastructure.Capture, develop, and document data definitions, business rules, and data quality requirements. Perform Quality Checks and implement controls for Sales and Marketing data.Lead KPI definitions effort in partnership with various functional and operational leaders. Document and manage KPI definitions.Qualifications And Education RequirementsBachelor's degree (business discipline preferred).5-7 years' experience as a Data Analyst or in a similar role working directly with clinical healthcare data (e.g., medical claims, pharmacy claims, population-health data, EMR etc.)Working knowledge of pharmaceutical industry data sources (e.g., IQVIA/ICON/Veeva Compass, BioMed Tracker, Analysource).Prior experience developing business requirements documents and managing data projects.Experience designing enterprise reporting solutions driven by a data lake, data warehouse, or operational data store.Strong analytical/critical thinking skills to address situations with operational complexity.Coding skills and/or Analytical Tools experience (Alteryx/R/SAS/SQL/Tableau etc.) preferred.Experience with using retail and specialty pharmacy data preferred.Adept communication skills, including ability to summarize complex issues concisely and listen effectively to concerns and problems.Cross-functional collaboration skills. Ability to work with people at various levels of the organization, including but not limited to, Marketing, Sales, Sales Operations, Managed Markets, Access Teams, Finance, IT, and other functions within and outside of Commercial.Experience in implementation and/or management of CRM/SFA platforms, Sales Reports & Analytics, and business systems.Good understanding of data security concepts.Experience in coding ETL extraction tools.Experience working with AWS databases, especially Redshift and EMR.The role may require occasional travel (0-25%).Preferred SkillsExperience with business intelligence tools/platforms is a plus.Experience using Power Query, Power Pivot, Alteryx a plus.Experience analyzing healthcare data a plus.Understanding of medical coding system (CPT, ICD-10, DRG, etc.) a plus.Experience managing data and/or analytics vendors preferred of business rules.#J-18808-Ljbffr
Created: 2024-10-16