> Markdown version of [/jobs/ext/4201962-data-modeler-snowflake](https://www.wearedevelopers.com/jobs/ext/4201962-data-modeler-snowflake). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeler (Snowflake)

- **Company:** Fusion
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Amazon S3, Data Cleansing, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Vault Modeling, Data Warehousing, Metadata, SQL Databases, Snowflake, Collibra, Star Schema, Physical Data Models, Data Pipelines
- **Published:** October 6, 2026
- **Apply:** https://www.dice.com/job-detail/a9b9b9c2-5cb3-4df3-9b5b-d7e323a5fb07

## About the Role

* 4-7 years of experience as a Data Modeler or similar role.
 * Strong expertise in Snowflake data modeling and SQL.
 * Strong business partnering, communication, and stakeholder management skills, with the ability to gather, challenge, and translate business requirements into scalable data solutions.
 * Proven experience working directly with business users, product owners, and technical teams to define data requirements, business rules, and data models.
 * Strong understanding of ETL/ELT and data integration concepts; experience with dbt, Matillion, or Fivetran is a plus.
 * Data Vault 2.0 experience is required.
 * Experience with metadata and data governance platforms, ideally Collibra.
 * Familiarity with AWS S3 is a plus.
 * Solid understanding of data modeling methodologies, including Data Vault, Star Schema, and Normalization.
 * Excellent communication, presentation, and documentation skills, with the ability to explain technical concepts to non-technical stakeholders.
 * Ability to work independently in a remote, cross-functional environment.

Preferred

 * Experience within pharmaceutical or life sciences organizations.
 * Familiarity with data quality tools such as Ataccama.
 * Experience working in Agile environments and facilitating requirements-gathering workshops.

## Description

We are looking for a skilled and motivated Data Modeler (Snowflake) to support the integration of regional data warehouses into a centralized Snowflake-based data platform for our clients in the pharmaceutical industry. This mid-level role is ideal for candidates with a strong foundation in physical data modeling and implementation, particularly within Snowflake, and who can collaborate across data engineering, architecture, and governance teams. You'll play a vital role in ensuring the data platform is efficient, scalable, and compliant with best practices and governance standards.

What You Will Be Doing:

 * 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., Attend a Technical Interview - Participate in a 30-minute session with one of our experts to discuss your skills and experience in more detail.

Participate in a Client Interview (if applicable) - For some roles, you may be invited to a client-facing discussion (30-60 minutes online).

Receive Final Feedback - We aim to share timely feedback and move forward quickly.

Fusion is an equal opportunity employer. We value diversity and are committed to fostering an inclusive workplace for all.