Senior Data Modeler (Snowflake)

Location: Barcelona, Spain

Company

hirify.global delivers digital transformation and consulting solutions for clients in the life sciences industry.

What you will do

• Design and implement scalable, performant, and maintainable physical data models in Snowflake.
• Translate conceptual and logical models into Snowflake schemas, tables, and views.
• Collaborate with data engineers on ETL/ELT processes and data integration patterns.
• Align data models and metadata with governance standards and tools such as Collibra.
• Document modeling and transformation logic to support traceability and compliance.
• Support performance tuning and optimization of data pipelines.

Requirements

• 4–7 years of experience as a Data Modeler or in a similar role.
• Expertise in Snowflake physical data modeling and SQL.
• Understanding of data integration and ETL/ELT principles.
• Experience with metadata and data governance platforms, ideally Collibra.
• Knowledge of data modeling practices including star schema, normalization, and data vault.
• Ability to work independently in a remote, cross-functional environment with strong communication and documentation skills.

Nice to have

• Experience with dbt, Matillion, or Fivetran.
• Familiarity with AWS services, particularly S3.
• Experience with pharmaceutical or life sciences data and regulatory frameworks.
• Familiarity with data quality tools such as Ataccama.

Culture & Benefits

• Collaborative, flat-structured organization with cross-functional and global teamwork.
• Up to 25 days per year of remote work from any global location.
• Flexible time off and a team integration budget.
• CHF 1,500 annual professional development budget, workshops, and training.
• Financial assistance for relocation, including help with visas, permits, and international assignments.
• Competitive salary and benefits package, referral rewards, and loyalty benefits from the third year.

Hiring process

• CV review by the Talent Acquisition team.
• Introductory call followed by a technical interview.
• Client interview when applicable, followed by final feedback.