Remote Snowflake Data Modeler | Data Vault Expert

Fusion Consulting; Warszawa; Remote; PLN 180,000 - 240,000; Full time

Benefits offered by this job

Remote work up to 25 days/year

Learning budget CHF 1,500 annually

Relocation assistance

Global mobility support

Job summary

Fusion Consulting is seeking a skilled Data Modeler (Snowflake) to help integrate regional data warehouses into a centralized Snowflake-based platform for the pharmaceutical industry. This mid-level role focuses on physical data modeling and implementation, collaborating with data engineering, architecture, and governance teams.

You will design Snowflake schemas, translate models into tables and views, support ETL/ELT processes, align with governance tools like Collibra, document modeling logic,

Qualifications

• 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 tools like 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.
• Experience with Data Vault 2.0 is a must.
• 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.

Responsibilities

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

Skills

Snowflake

SQL

Data Vault 2.0

Data modeling

ETL/ELT principles

Documentation

Cross-functional collaboration

Independent work

Tools

Collibra

dbt

Matillion

Fivetran

AWS S3

Job description

Fusion Consulting is seeking a skilled Data Modeler (Snowflake) to help integrate regional data warehouses into a centralized Snowflake-based platform for the pharmaceutical industry. This mid-level role focuses on physical data modeling and implementation, collaborating with data engineering, architecture, and governance teams.

You will design Snowflake schemas, translate models into tables and views, support ETL/ELT processes, align with governance tools like Collibra, document modeling logic,