Data Warehouse Architect at Philadelphia, PA (Hybrid)

Job Title:

Data Warehouse Architect Location:

Philadelphia, PA (Hybrid)

Duration:

1+ Year. .

TAX TERMS

: ONLY W2 Job Description About the job Data Warehouse Architect to design and govern enterprise-scale data and analytics platforms across clinical, R D, manufacturing, quality, regulatory, and commercial domains. This role will shape scalable, compliant data ecosystems that power advanced analytics, reporting, and enterprise decision-making in a regulated life sciences environment. Key Responsibilities Design scalable, secure, and high-performance data warehouse and data lake architectures Develop conceptual, logical, and physical data models for complex life sciences datasets Define integration patterns across clinical, R D, manufacturing, regulatory, and commercial systems Architect cloud, on-prem, and hybrid data solutions aligned to enterprise needs Data Integration and Engineering Oversee data ingestion from systems such as EDC, CTMS, LIMS, QMS, ERP, and CRM platforms Define ETL and ELT frameworks, pipelines, and transformation standards Ensure consistent, high-quality, and timely data across integrated sources Collaborate with engineering teams on implementation and performance optimization Governance and Compliance Ensure alignment with GxP, FDA 21 CFR Part 11, GDPR, HIPAA, and other regulations Establish data governance, metadata standards, and lineage frameworks Support validation processes and documentation in regulated environments Partner with compliance teams during audits and inspections Analytics Enablement Enable self-service BI, reporting, and advanced analytics capabilities Optimize data structures for dashboards, analytics, and data science use cases Support clinical analytics, real-world evidence, and operational reporting needs Strategy and Stakeholder Collaboration Translate business requirements into scalable architectural solutions Define data warehouse roadmap aligned with digital transformation strategy Evaluate platforms, tools, and vendors for enterprise adoption Mentor junior architects and data engineers on best practices Required Qualifications Bachelor's degree in Computer Science, Engineering, Information Systems, or related field 7 12+ years of experience in data architecture or data warehousing, preferably in life sciences or regulated industries Strong expertise in data modeling and enterprise architecture Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform Strong understanding of GxP and validated systems Preferred Qualifications Advanced degree in a relevant field (MS, PhD, or MBA) Experience in clinical trials, R D analytics, or regulatory submissions Hands-on experience with platforms such as Snowflake, Redshift, BigQuery, Synapse, or Databricks Familiarity with Master Data Management and governance frameworks Cloud or data architecture certifications Key Skills Enterprise data architecture and modeling ETL and ELT design and optimization Cloud and hybrid data platforms Regulatory compliance in life sciences systems Strong stakeholder communication and strategic thinking