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.