11 часов назад
Senior Data Modeler (Snowflake)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Текст:
TL;DR
Senior Data Modeler (Snowflake) (Snowflake/data governance): Designing and implementing physical data models for a centralized Snowflake data platform integrating regional pharmaceutical data warehouses with an accent on scalability, performance, maintainability, and compliance. Focus on translating conceptual and logical models into schemas, optimizing ETL/ELT pipelines, aligning metadata with Collibra governance standards, and documenting transformation logic for traceability.
Location: Lisbon, Portugal
Company
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 to support traceability and compliance.
- Support performance tuning and optimization of data pipelines while collaborating with technical and business stakeholders.
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 metadata and data governance platforms, ideally Collibra.
- Strong 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
- Work from any global location for up to 25 days per year.
- Flexible time off, team integration budget, and birthday recognition.
- CHF 1,500 annual professional development budget with workshops and training.
- Financial assistance for work-related moves and support with visas, permits, and international assignments.
- Flexible local benefits and collaboration in a diverse, global environment.
Hiring process
- CV review followed by an introductory call with Talent Acquisition.
- Technical interview with a subject-matter expert.
- Client interview where applicable, followed by final feedback.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →