Data Solution Architect

• Seeking a Solution Architect with 10+ years in, and MDM, expertise in Snowflake, DBT,(Data build tool) and cloud-based Pharma data platforms, with strong experience in ETL & regulatory compliance and patient data aggregation.

Qualifications: Data Architecture, DWH, ETL

• Experience -15-20
• Relevant exp-9+

Must Have:

• Strong Verbal & Written Communications Skills

Core Skills:

• Enterprise Data Architecture & Solution Design
• Expertise in designing scalable, multi-tenant 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 metadata-driven and modular data processing architectures for large-scale patient data aggregation.
• Data Integration & ETL/ELT Frameworks
• Strong experience with ETL/ELT tools like DBT, Python, SSIS, Informatica, or PowerCenter for high-volume Pharma data integration.
• Expertise in data orchestration frameworks, scheduling, and workflow automation.
• Experience with batch and real-time data processing pipelines.
• Extensive experience with Snowflake, including performance tuning, cost optimization, and multi-tenant architectures.
• Experience delivering Azure or AWS-based 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, Define MDM integration strategies for harmonizing Pharma patient data and establishing golden records for commercial, clinical, and real-world 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