Data Modeler Lead (Snowflake)
Core
Design and implement physical data models in Snowflake to integrate regional data warehouses into a centralized platform for pharmaceutical clients.
Role type
Mid-level Lead Data Modeler (Snowflake)
Builds
Centralized Snowflake-based data platform
Domain
Pharmaceutical industry / Data Engineering
Required skills
Snowflake physical data modeling, SQL, Data Vault 2.0, ETL/ELT principles, metadata governance (Collibra), performance tuning
Preferred skills
dbt, Matillion, Fivetran, AWS S3, Ataccama, pharmaceutical/life sciences regulatory frameworks
Technologies
Snowflake, Collibra, dbt, Matillion, Fivetran, AWS S3, Ataccama
Responsibilities
Design and implement physical data models in Snowflake; Translate conceptual and logical models into Snowflake-ready schemas; Collaborate with data engineers to refine ETL/ELT processes; Align models and metadata with governance standards; Ensure modeling logic is well-documented; Support performance tuning of data pipelines
Seniority
Mid-level, hands-on IC with leading responsibilities