Senior Data Modeler (Snowflake, Pharma)

TL;DR

Senior Data Modeler (Snowflake): Designing and implementing physical data models for a centralized Snowflake-based data platform in the pharmaceutical industry with an accent on scalability, performance, and governance. Focus on translating conceptual models into Snowflake-ready schemas and implementing Data Vault 2.0 architectures.

Location: New Haven, United States (Relocation assistance available)

Company

A global consulting firm specializing in digital transformation for the life sciences industry.

What you will do

• Design and implement physical data models in Snowflake, focusing on scalability and performance.
• Translate conceptual and logical models into Snowflake-ready schemas, tables, and views.
• Collaborate with data engineers to refine ETL/ELT processes and integration patterns.
• Align models and metadata with governance standards using tools like Collibra.
• Ensure all modeling and transformation logic is thoroughly documented for compliance.
• Support performance tuning and optimization of data pipelines.

Requirements

• 4–7 years of experience as a Data Modeler or in a similar role.
• Proven expertise in Snowflake physical data modeling and SQL.
• Experience with Data Vault 2.0 is a must.
• Experience with metadata and data governance platforms, ideally Collibra.
• Ability to work independently in a remote, cross-functional environment.
• Excellent communication and documentation skills.

Nice to have

• Experience with ETL/ELT tools such as dbt, Matillion, or Fivetran.
• Familiarity with AWS services, particularly S3.
• Experience in pharmaceutical or life sciences data and regulatory frameworks.
• Familiarity with data quality tools like Ataccama.

Culture & Benefits

• Annual professional development budget of CHF 1,500.
• Flexible time off and a "Work from Anywhere" perk for up to 25 days per year.
• Financial assistance for relocation and support with visas and permits.
• Team integration budget for collaboration and bonding events.
• Loyalty-based benefits available via the Unity Scheme from the third year.

Hiring process

• CV submission and profile review by the Talent Acquisition team.
• Introductory call to discuss expectations and company fit.
• Technical interview with a subject matter expert.
• Potential client-facing interview.