Principal Data Architect
Access SystemsSalary not specified
Full Time
Expert & Leadership (9+ years)
Not SpecifiedCompensation
Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level
Full TimeJob Type
UnknownVisa
Pharma, Biotech, Clinical TrialsIndustries
Requirements
- 10+ years of experience in data architecture, data engineering, or related roles
- Deep expertise in Snowflake, SQL Server, and NoSQL databases, as well as modern data transformation and orchestration frameworks such as DBT and advanced data pipelines
- Strong experience with DBT and data pipeline orchestration (e.g., Dagster, Airflow, or similar)
- Demonstrated ability to optimize Snowflake for cost and performance in production environments
- Deep understanding of data modeling (3NF, Star Schema, cDISC standards)
- Bachelor’s degree in Human Resources, Business Administration, a related field, or an equivalent amount of related professional experience (preferred)
- Experience working with Greenhouse Applicant Tracking System – or a closely related tool (preferred)
- Experience working with UKG or a similar HRIS system (preferred)
Responsibilities
- Own the end-to-end data architecture strategy, covering integrations, data warehousing, analytics, and operational data flows
- Define and enforce best practices for data modeling, governance, lineage, and metadata management
- Lead the transition from legacy SQL Server workloads to Snowflake and cloud-first solutions
- Provide architectural oversight for NoSQL use cases (e.g., MongoDB, Cosmos DB) to support unstructured and semi-structured data needs
- Architect robust ETL/ELT pipelines leveraging modern orchestration tools and DBT for transformation consistency
- Guide the design of real-time and batch integrations between operational systems, external partners, and sponsor-facing analytics
- Ensure pipelines meet performance, resiliency, and compliance requirements for clinical trial data
- Design and implement cost-efficient Snowflake solutions, including optimal warehouse sizing and scaling, storage optimization (micro-partitioning, clustering, pruning), and performance tuning (query optimization, caching, result sets)
- Partner with Finance and Engineering to monitor and forecast Snowflake spend
- Establish cost guardrails and automated monitoring for Snowflake usage
- Act as the subject matter expert on all data architecture decisions
- Mentor data engineers, analysts, and developers in data design and DBT best practices
- Collaborate with product managers and clinical data SMEs to align data design with business goals
- Represent the Data Architecture function in governance, compliance, and sponsor-facing initiatives
Skills
Snowflake
SQL Server
NoSQL
DBT
Dagster
Airflow
Data Modeling
3NF
Star Schema
cDISC
ETL
ELT
MongoDB
Cosmos DB
Data Pipeline Orchestration
YPrime
eClinical solutions for clinical trial management
About YPrime
YPrime specializes in providing electronic Clinical Outcome Assessment (eCOA) and Interactive Response Technology (IRT) systems for the pharmaceutical and biotech industries. These systems are essential for managing clinical trials, which assess the effectiveness and safety of medical treatments. YPrime's eCOA solutions enable the electronic collection of patient data, making the process more efficient and accurate compared to traditional paper methods. The IRT systems help manage randomization and drug supply logistics, ensuring that clinical trials operate smoothly and in compliance with regulations. Unlike many competitors, YPrime focuses specifically on the highly specialized and regulated market of clinical trial technology and data management. The company's goal is to enhance the efficiency and effectiveness of clinical trials, improve data quality, reduce costs, and accelerate the time it takes to bring new treatments to market.
9 Great Valley Pkwy, Malvern, PA 19355, USAHeadquarters
2006Year Founded
$10MTotal Funding
SEEDCompany Stage
Biotechnology, HealthcareIndustries
201-500Employees
Risks
Emerging eClinical providers may erode YPrime's market share.
Rapid AI advancements could outpace YPrime's current offerings.
Integration of Tryl poses operational risks and challenges.
Differentiation
YPrime's eCOA 7.0 platform offers revolutionary features for clinical trials.
YPrime's acquisition of Tryl enhances capabilities for decentralized clinical trials.
YPrime is recognized as a Trailblazer in patient engagement for clinical trials.
Upsides
Growing demand for decentralized trials aligns with YPrime's Tryl acquisition.
Increasing adoption of wearables supports YPrime's new glucometer feature.
Cloud-based solutions expansion benefits YPrime's eClinical offerings.
Related Jobs
RemoteRemoteHead of Global Solutions Architect
PingCAPSalary not specified
- Full Time
- Expert & Leadership (9+ years)
RemoteDirector of Data Architecture and Engineering
HometapSalary not specified
- Full Time
- Expert & Leadership (9+ years)
RemoteSenior AI Data Architect
HumanaSalary not specified
- Full Time
- Senior (5 to 8 years)
RemoteLead Data Engineer
LumosSalary not specified
- Full Time
- Expert & Leadership (9+ years)
RemotePlatform Architect
TetraScienceSalary not specified
- Full Time
- Expert & Leadership (9+ years)
RemotePrincipal Enterprise Data Architect
SmarshSalary not specified
- Full Time
- Senior (5 to 8 years), Expert & Leadership (9+ years)
RemoteCloud Engineering Architect
Accurate BackgroundSalary not specified
- Full Time
- Expert & Leadership (9+ years)