Data Engineer Lead/ Data Architect

We are seeking an experienced Data Architect with a deep understanding of data modeling, AWS, AWS Analytics services, and Snowflake. The Data Architect will be responsible for designing robust data models, creating cloud-based data solutions, and ensuring seamless data flow across the organization. Exposure to the pharmaceutical industry is a plus, particularly in commercial operations.

Key Responsibilities:

1. Data Architecture & Modeling

• Design and develop data models for OLTP and OLAP systems, optimizing for scalability and performance.
• Build and maintain conceptual, logical, and physical data models in line with business requirements.
• Implement data normalization, dimensional modeling, and entity-relationship diagrams (ERD).

1. Cloud Expertise (AWS & Snowflake)

• Leverage AWS services such as S3, Athena, Glue, Lambda, and Kinesis for building scalable cloud-based data solutions.
• Design and implement Snowflake solutions for data warehousing and real-time analytics, ensuring integration with AWS services.

1. ETL Pipelines & Data Integration

• Design and manage ETL/ELT pipelines to handle large volumes of structured and unstructured data from various sources.
• Ensure seamless integration between different data platforms and third-party systems.

1. Data Governance & Security

• Apply data governance policies to ensure data quality, lineage, and access controls.
• Implement security measures in line with compliance standards such as GDPR and HIPAA, ensuring secure cloud environments.

1. Cross-Functional Collaboration

• Work with engineering, analytics, and business teams to understand their data needs and provide architectural solutions.
• Communicate data architecture and model designs to both technical and non-technical stakeholders.

1. Data Strategy & Innovation

• Define data strategy to optimize storage, processing, and analytics in a cloud environment.
• Stay updated on the latest data trends and implement best practices to enhance architecture and data models.

Nice to Have:

• Pharmaceutical Commercial Knowledge
• Familiarity with Pharma industry operations, commercial analytics, and regulatory requirements.
• Experience working on pharmaceutical analytics projects or handling sensitive healthcare data.

Qualifications:

• 5+ years of experience in data architecture and data modeling.
• Strong expertise in AWS cloud services, Snowflake, and data modeling tools.
• Proven experience in designing scalable data architectures and ETL pipelines.
• Knowledge of data governance, security, and compliance practices.
• Excellent communication and collaboration skills.
• Experience with DBT (Nice to have)