Director, Data Architecture Development

Title

Director, Commercial Data Architecture Development

Conshohocken, PA or Waltham, MA (Hybrid)

Full-time

The Director, Commercial Data Architecture Development will lead key development initiatives within the scope of Madrigal’s Commercial Data Warehouse (CDW). This hands‑on technical leader will serve as both architect and team lead for developers, driving the design and implementation of scalable, high‑performance data solutions that enable commercial reporting, analytics, and data‑driven decision‑making. This position plays a critical role in defining the foundation of Madrigal’s commercial data ecosystem and ensuring alignment with business needs, data governance standards, and technical best practices.

The role reports to the Senior Director, Commercial Data & Analytics.

• Lead the design, build, and implementation of key programs leveraging Microsoft Fabric
  , Databricks
  , Synapse
  , and related tools.
• Serve as architect and technical team lead, providing hands‑on development and guidance to data engineers in building efficient, scalable data pipelines.
• Define and implement data architecture frameworks aligned with Medallion (Bronze, Silver, Gold) principles.
• Design and oversee ETL/ELT processes for transformation of commercial datasets.
• Maintain data quality, integrity, and governance processes across all commercial data assets.
• Collaborate with Commercial Operations, Market Access, Analytics, and IT teams to ensure the data environment supports reporting and analytical needs.
• Define data modeling standards, master data management approaches, and harmonization across multiple data domains.
• Develop and maintain metadata management and documentation for the Commercial Data Warehouse.
• Partner with internal and external technology resources to optimize performance and scalability.
• Continuously evaluate and enhance architecture design to meet evolving business and analytical requirements.

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related discipline.
• Minimum of 15 years of experience in pharmaceutical commercial data management, data engineering, or data architecture roles.
• Proven track record designing and developing commercial data warehouses in cloud environments, preferably Microsoft Azure.
• Expertise with Azure Synapse, Databricks, Fabric, SQL, and Power BI integration.
• Deep understanding of pharmaceutical commercial datasets, including:
  • Patient‑level data (APLD): IQVIA, Komodo, Purple Lab, etc.
  • Formulary data: MMIT
  • Projected national data:
    Xponent, NSP, NPA, etc.
  • International data: MIDAS
  • Drug distribution data: IQVIA DDD
  • Reference data:
    One Key, Open Data
  • Specialty pharmacy / Specialty distributor data (SP/SD)
• Strong understanding of data modeling, performance tuning, and Medallion architecture design principles.
• Hands‑on technical development experience with the ability to function as both architect and lead developer.
• Excellent problem‑solving, communication, and cross‑functional collaboration skills.

• Experience with in or providing consulting support for launch‑stage or growth‑stage biotech organizations.
• Familiarity with data tokenization and privacy compliance (e.g., Datavant).
• Experience implementing data governance frameworks and metadata management.
• Demonstrated ability to mentor and provide technical direction to development teams.

Base salary range for this position is $212,000 - $259,000 per year.

All employees receive equity as part of the Total Rewards strategy, with a base salary determined by qualifications, skills, education, experience, business needs, and market demands.

All full‑time employees are eligible for comprehensive benefits including:

• Flexible paid time off
• Medical, dental, vision, and life/disability insurance
• 401(k) offerings (traditional, Roth, and employer match)
• Supplemental life insurance, legal services, and other voluntary benefits
• Employee Assistance Program for mental health benefits

Please be aware that we have received reports of individuals misrepresenting themselves as Madrigal Pharmaceuticals’ Hiring Managers, seeking…