Director, Data Architecture Development

Role Summary

Director, Commercial Data Architecture Development will lead key development initiatives within 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.

Responsibilities

• 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.

Qualifications

• 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, PurpleLab, etc.
  • Formulary data: MMIT
  • Projected national data: Xponent, NSP, NPA, etc.
  • International data: MIDAS
  • Drug distribution data: IQVIA DDD
  • Reference data: OneKey, OpenData
  • 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 within 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.