SCILEX 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 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 Responsibilities

• Collaborate with 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 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 audit.
• 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 Requirements

• Bachelor’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 Skills

• Experience 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.
• Manage complexities of fragmented data sets from Scilex Holding’s distribution partners in 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 audit.
• 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.