- Enterprise Data Architecture & Solution Design
- Expertise in designing scalable multitenant data architectures for Life Sciences Pharma and Healthcare Data Platforms.
- Strong experience in delivering Data Warehouse (DWH) and Patient Data Aggregation implementations for Pharma clients.
- Deep understanding of Data Warehousing concepts including Fact/Dimension modeling Type 1/Type 2 SCD and Data Mart design.
- Experience designing Conformed Dimensions via MDM Integration and aligning data models with Pharma industry standards.
- Experience with metadatadriven and modular data processing architectures for largescale patient data aggregation.
- Data Integration & ETL/ELT Frameworks
- Strong experience with ETL/ELT tools like DBT Python SSIS Informatica or PowerCenter for highvolume Pharma data integration.
- Expertise in data orchestration frameworks scheduling and workflow automation.
- Experience with batch and realtime data processing pipelines.
- Extensive experience with Snowflake including performance tuning cost optimization and multitenant architectures.
- Experience delivering Azure or AWSbased data solutions (Data Lake Event Hubs Lambda Glue etc. in Life Sciences/Pharma settings.
- Familiarity with Data Security Access Control and Compliance (HIPAA GDPR GxP and 21 CFR Part 11 for Pharma clients.
- MDM & Data Governance
- Expertise in Master Data Management (MDM) integration for conformed dimensions and golden records ensuring data harmonization across Pharma and Clinical Data sources.
- Experience implementing data governance strategies for patient data aggregation clinical trials and commercial pharma datasets.
- Knowledge of data lineage tracking metadata management and data quality frameworks to support regulatory compliance in Pharma.
Roles and Responsibilities:
- Lead architecture design and implementation of Data Warehousing (DWH) and Patient Data Aggregation solutions for Pharma clients.
- Define data integration strategies across ETL/ELT MDM and BI layers ensuring seamless interoperability between Pharma Payer and Provider data sources.
- Design and optimize multitenant scalable data platforms on Snowflake to support Life Sciences data workloads.
- Establish best practices for data modeling governance and security in Pharma & Healthcare environments.
- Provide technical leadership to Data Engineers DBT Developers and Data Scientists for building scalable data pipelines.
- Define data orchestration and transformation frameworks to ensure accurate realtime and compliant patient data aggregation.
- Work closely with client IT and business stakeholders to align architecture decisions with business needs and regulatory requirements.
- Implement data security privacy and compliance standards specific to Pharma including HIPAA GDPR and GxP.
- Define MDM integration strategies for harmonizing Pharma patient data and establishing golden records for commercial clinical and realworld evidence (RWE) datasets.
- Lead data quality initiatives ensuring accurate consistent and validated patient data across multiple pharma business units.
- Collaborate with regulatory and compliance teams to ensure data platforms meet FDA EMA and other regulatory body requirements.
- Act as the primary technical point of contact for Pharma clients ensuring successful project delivery.
- Collaborate with business stakeholders data analysts and BI teams to ensure the architecture supports analytics reporting and realworld evidence generation.
- Lead technical discussions POCs and architectural reviews for Pharma data solutions.
- Document technical architecture best practices and operational guidelines for DWH and Patient Data Aggregation implementations.
Qualifications :
What youll bring to the table:
- Bachelors or Masters degree in Computer Science Data Engineering or related field.
- 10 years of experience in Data Architecture Solution Design or Data Engineering.
- 5 years working with Snowflake DBT and modern cloudbased data platforms in Pharma/Life Sciences.
- Proven experience delivering Data Warehousing (DWH) and Patient Data Aggregation solutions for Pharma clients.
- Experience with Pharma data domains including EMR Claims EHR Clinical Trials and RealWorld Data (RWD).
- Certifications in Snowflake DBT or Cloud Platforms (Azure AWS) are a plus.
- Experience with AI/MLdriven patient data solutions is a plus.
#LIZG1
Additional Information :
What does IntegriChain have to offer
- Mission driven: Work with the purpose of helping to improve patients lives!
- Excellent and affordable medical benefits nonmedical perks including Flexible Paid Time Off 401(k) Plan with a Company Match to prepare for your future Parental Leave Student Loan Reimbursement and much more!
- Robust Learning & Development opportunities including over 700 development courses free to all employees.
IntegriChain is committed to equal treatment and opportunity in all aspects of recruitment selection and employment without regard to race color religion national origin ethnicity age sex marital status physical or mental disability gender identity sexual orientation veteran or military status or any other category protected under the law. IntegriChain is an equal opportunity employer; committed to creating a community of inclusion and an environment free from discrimination harassment and retaliation.
Our policy on visa sponsorship for US based positions: Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by IntegriChain.
Remote Work :
Yes
Employment Type :
Fulltime