Data Engineer/Assoc. Commercial Data Architect

Key Responsibilities Translate business needs into data architecture; partner with sales, product strategy, market access, and finance to design data models. Document solutions (BRDs, functional specs, data dictionaries, ERDs, process flows) for technical and business audiences. Design usable, scalable data solutions aligned with KPIs; support a business-facing data layer for consistent, trusted metrics and self-service analytics. Use Databricks and Azure to build Lakehouse patterns, medallion architectures, and structured SQL Server schemas. Own commercial data domains: customers, sales effectiveness, master data, specialty pharmacy; ensure consistency, lineage, and reliability. Structure data for dashboards, forecasting pipelines, and performance tracking. Support integration/governance of pharmaceutical data sources (e.g., IQVIA Xponent, 867 data, specialty pharmacy feeds). Bridge technical and business teams; validate requirements and clarify ambiguity. Uphold data quality and governance via standards, naming conventions, and early pipeline quality controls. Qualifications / Required Skills 3+ years in data roles (data engineering/analytics engineering/BI or similar). Bachelor’s degree in a technical field. Strong data modeling and SQL; modern data platforms (Databricks preferred; Azure Synapse/Snowflake acceptable). Knowledge of commercial app architecture (CRM, MDM, reporting platforms). Hands-on SQL and cloud platform experience. Qualifications / Preferred Skills Exposure to ETL/ELT, star vs. normalized models, and lakehouse patterns. Experience working with business stakeholders. Familiarity with pharmaceutical data (Xponent Plantrak, 867, specialty pharmacy, marketing, finance, customer data). Experience creating BRDs, functional specs, data dictionaries, or process diagrams. Proven alignment of data initiatives with business outcomes; clear communication and strong problem-solving. #J-18808-Ljbffr Scorpion Therapeutics