Senior Data Modeler (Snowflake)
Core
Design and implement physical data models in Snowflake to support a centralized data platform for pharmaceutical clients.
Role type
Mid-level IC data modeler (Snowflake)
Builds
Snowflake schemas, tables, views, and optimized data pipelines
Domain
Life sciences / Pharmaceutical industry / Cloud data platforms
Required skills
Snowflake physical data modeling, SQL, ETL/ELT principles, data governance (Collibra), data modeling best practices (star schema, normalization, data vault), performance tuning
Preferred skills
dbt, Matillion, Fivetran, AWS S3, Ataccama, pharmaceutical/life sciences regulatory frameworks
Technologies
Snowflake, Collibra, dbt, Matillion, Fivetran, AWS S3
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 all modeling logic is well-documented; Support performance tuning of data pipelines
Seniority
Mid-level, hands-on IC