Job 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, integral environment with both technical and business stakeholders.

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.

Preferred :
- Experience in pharmaceutical/life sciences data and regulatory frameworks.
- Familiarity

📌 Senior Data Modeler (Barcelona)
🏢 Fusion Consulting
📍 Barcelona