Senior Data Modeler (Snowflake)

Fusion Consulting•New Haven, CT

1d•Remote

About The Position

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.

Requirements

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 Data Vault 2.0 is a must
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.

Nice To Haves

Experience in pharmaceutical/life sciences data and regulatory frameworks.
Familiarity with data quality tools such as Ataccama.

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.

Benefits

Work from Anywhere: Enjoy up to 25 days per year of remote work from any global location.
Flexible time off—beyond standard holiday allowances.
Team's integration budget to meet, collaborate, and bond.
Special gift from Fusion on your birthday.
CHF 1,500 annually for professional development.
Regular workshops and trainings to strengthen technical and soft skills.
Competitive salary and benefits package.
Referral program rewards.
Loyalty-based benefits starting from your third year via the Unity Scheme.
Financial assistance when moving for work.
Help with visas, permits, and international assignments.
Perks tailored to your country of residence.