Senior Data Modeler – Snowflake

About the role

Fusion Consulting seeks a Senior Data Modeler specialized in Snowflake to help integrate regional data warehouses into a centralized platform for pharmaceutical clients. This mid‑level position combines physical data modeling expertise with collaboration across data engineering, architecture, and governance teams. You will ensure the platform is scalable, performant, and compliant with best‑practice standards.

Key responsibilities

• Design and implement physical data models in Snowflake, focusing on scalability, performance and maintainability.
• Translate conceptual and logical models into Snowflake schemas, tables and views.
• Collaborate with data engineers to refine ETL/ELT processes and integration patterns.
• Align models and metadata with governance tools such as Collibra.
• Document modeling and transformation logic for traceability and compliance.
• Support performance tuning and optimisation of data pipelines.
• Work in a distributed, global environment with both technical and business stakeholders.

Required profile

• 4–7 years of experience as a Data Modeler or similar role.
• Proven expertise in Snowflake physical data modeling and SQL.
• Understanding of data integration and ETL/ELT principles; experience with dbt, Matillion or Fivetran is a plus.
• Experience with metadata and data‑governance platforms, ideally Collibra.
• Familiarity with AWS services, particularly S3, is a plus.
• Solid grasp of data‑modeling best practices (star schema, normalization, data vault).
• Ability to work independently in a remote, cross‑functional environment.
• Excellent communication and documentation skills.

Required skills

• Snowflake
• SQL
• dbt
• Matillion
• Fivetran
• Collibra
• AWS S3
• Star schema
• Normalization
• Data vault
• Ataccama (optional)

What we offer

• Flexibility & Balance: up to 25 days remote work per year, flexible time off, team integration budget, birthday gift.
• Growth & Development: CHF 1,500 annual learning budget, regular workshops and trainings, inclusive culture.
• Recognition & Reward: competitive salary, referral bonuses, loyalty benefits from year three.
• Global Mobility & Local Support: relocation assistance, visa and permit help, local perks, collaborative global culture.