Senior Snowflake Data Modeler (Pharma) – Remote & Global

Carbon Data Solutions; United States; Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Remote work up to 25 days/year

Professional development allowance CHF

Global mobility support

Job summary

Fusion Consulting is seeking a mid-level Data Modeler (Snowflake) to consolidate regional data warehouses into a centralized Snowflake-based platform for pharmaceutical clients. The role emphasizes physical data modeling, collaboration with data engineering, architecture, and governance teams, and adherence to governance standards.

You will design scalable Snowflake schemas, optimize ETL/ELT patterns with dbt/Matillion/Fivetran, and ensure robust documentation and traceability.

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.
• 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

Data modeling

SQL

Documentation

Communication

Independent work

Tools

Snowflake

dbt

Matillion

Fivetran

Collibra

AWS S3

Job description

Fusion Consulting is seeking a mid-level Data Modeler (Snowflake) to consolidate regional data warehouses into a centralized Snowflake-based platform for pharmaceutical clients. The role emphasizes physical data modeling, collaboration with data engineering, architecture, and governance teams, and adherence to governance standards.

You will design scalable Snowflake schemas, optimize ETL/ELT patterns with dbt/Matillion/Fivetran, and ensure robust documentation and traceability.