Senior Data Modeler (Snowflake)

Location: Seda, Latvia

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 platforms such as Collibra.
• Document modeling and transformation logic for 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.
• Proven expertise in Snowflake physical data modeling and SQL.
• Understanding of data integration and ETL/ELT principles; experience with dbt, Matillion, or Fivetran is beneficial.
• 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 pharmaceutical or life sciences data and regulatory frameworks.
• Familiarity with AWS services, particularly S3.
• Experience 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 allowance, workshops, and training.
• Relocation assistance and support with visas, permits, and international assignments.
• Competitive salary and benefits, referral rewards, and loyalty benefits from the third year.

Hiring process

• CV submission followed by profile review.
• Introductory call with Talent Acquisition and a technical interview.
• Client interview where applicable, followed by final feedback.