Senior Snowflake Data Modeler for Life Sciences (Remote)

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

Benefits offered by this job

Remote work up to 25 days/year

Learning budget CHF 1,500 annually

Relocation assistance

Job summary

Fusion Consulting seeks a skilled Data Modeler (Snowflake) to consolidate regional warehouses into a centralized Snowflake-based data platform for life sciences clients. The role focuses on physical data modeling, Snowflake implementations, and cross-team collaboration with data engineers, architecture, and governance teams.

The ideal candidate has 4–7 years in data modeling, strong Snowflake, SQL, and knowledge of ETL/ELT patterns, plus exposure to governance tools like Collibra.

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 (e.g., 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 modeling

SQL

dbt

Matillion

Fivetran

Collibra

AWS S3

Data Vault 2.0

Star schema

Normalization

Tools

dbt

Matillion

Fivetran

Job description

Fusion Consulting seeks a skilled Data Modeler (Snowflake) to consolidate regional warehouses into a centralized Snowflake-based data platform for life sciences clients. The role focuses on physical data modeling, Snowflake implementations, and cross-team collaboration with data engineers, architecture, and governance teams.

The ideal candidate has 4–7 years in data modeling, strong Snowflake, SQL, and knowledge of ETL/ELT patterns, plus exposure to governance tools like Collibra.