Senior Snowflake Data Modeler: Remote & Global Impact

Fusion Consulting AG; New Haven, Northern (CT, KY); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Remote work flexibility

25 remote days per year

Flexible time off

Integration budget

Birthday gift

Global mobility support

Job summary

Fusion Consulting AG seeks a mid-level Data Modeler (Snowflake) to support regional warehouse integration into a centralized Snowflake-based platform for the pharma sector. Strong Snowflake modeling skills and governance collaboration are required to deliver scalable, compliant data solutions.

You will design Snowflake schemas, optimize ETL/ELT processes with data engineers, and ensure governance alignment across teams in a distributed global environment.

Qualifications

• 4-7 years of experience as a Data Modeler or similar role.
• Strong Snowflake data modeling and SQL expertise.
• Experience with governance, Collibra, and metadata management.
• Proven collaboration with business users, product owners, and tech teams.
• Knowledge of ETL/ELT concepts; familiarity with dbt, Matillion or Fivetran is a plus.
• Data Vault 2.0 and data modeling methodologies (Star schema, normalization).
• Ability to document models and explain technical concepts to stakeholders.

Responsibilities

• Design and implement physical data models in Snowflake for scalable, high-performance warehouses.
• Translate conceptual/logical models into Snowflake 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 modeling and transformation logic is well-documented for traceability and compliance.
• Support performance tuning and optimization of data pipelines.

Skills

Snowflake modeling

SQL

Data Vault 2.0

Collibra governance

DBT

Tools

Matillion

Fivetran

dbt

AWS S3

Job description

Fusion Consulting AG seeks a mid-level Data Modeler (Snowflake) to support regional warehouse integration into a centralized Snowflake-based platform for the pharma sector. Strong Snowflake modeling skills and governance collaboration are required to deliver scalable, compliant data solutions.

You will design Snowflake schemas, optimize ETL/ELT processes with data engineers, and ensure governance alignment across teams in a distributed global environment.