EU remote
Senior Data Modeler (Snowflake)
About this role
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. 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.
Preferred : Experience in pharmaceutical/life sciences data and regulatory frameworks. Familiarity with data quality tools such as Ataccama. WHY YOU SHOULD JOIN FUSION: At Fusion, you’ll join a diverse team of talented professionals from around the world, united by a passion for delivering impactful digital transformation in the life sciences industry. You’ll be part of a flat-structured, collaborative organization where decisions are made efficiently, and your expertise directly shapes client outcomes.