Data Architect (Snowflake / Dbt / Matillion / Python / Terraform, Azure Cloud)

Itransition Group; Madrid; Presencial; EUR 90.000 - 125.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Projects for major clients

Flexible working hours

Remote options within EU

Medical insurance

English courses

Training and conferences

Gym membership

Paid sick leave

Descripción de la vacante

Itransition Group in Madrid is seeking a Data Architect to lead the design and evolution of a Snowflake-based enterprise data platform. You will shape end-to-end data solutions across ingestion, transformation, governance, analytics and activation, collaborating with data engineering, cloud, security and business teams.

This hands-on role blends strategic thinking with engineering excellence, defining standards, reusable patterns and data contracts, while ensuring security, scalability and

Formación

• Enterprise-scale cloud data platform design experience.
• Snowflake architecture, performance optimization, security, and cost optimization.
• Data Vault 2.0 and Data Mesh concepts including domain ownership, data products and federated governance.
• dbt for data transformation, modelling, testing, documentation, and CI/CD.
• Matillion for data ingestion, orchestration and integration.
• SQL and Python proficiency; data activation and reverse ETL experience.
• CI/CD and DataOps practices; governance, lineage, metadata and observability.

Responsabilidades

• Define and evolve the Snowflake-based enterprise data platform architecture.
• Design end-to-end data solutions including ingestion, transformation, governance, analytics and activation.
• Establish standards and reusable patterns across Snowflake, dbt, Matillion, Python, and Terraform.
• Define and govern Data Vault 2.0 and Data Mesh implementations with domain ownership and data products.
• Design scalable ingestion/transformation patterns for batch, API, SaaS, database and file-based data.
• Define data modelling standards across Raw Vault, Business Vault and analytical data products.
• Design data activation and reverse ETL patterns for operational platforms.
• Optimize Snowflake for performance, security, reliability and cost.
• Drive CI/CD, DataOps, automated testing, and infra-as-code practices.

Conocimientos

Strong SQL

Python

Strong communication skills

Agile delivery

Herramientas

Snowflake

dbt

Matillion

Terraform

Azure

Snowpark

Descripción del empleo

We're looking for a Data Architect to lead the design and evolution of a modern enterprise data platform built around Snowflake.

The platform supports end-to-end data capabilities across ingestion, transformation, modelling, governance, analytics, data activation, and reverse ETL use cases.

Snowflake, dbt, Matillion, Python, and Terraform form the core of the technology stack, with Data Vault and Data Mesh principles playing a key role in how data is modelled, governed, owned, and delivered across business domains.

You’ll be responsible for defining scalable architecture patterns, designing robust data models and integration frameworks, establishing governance and platform standards, and enabling trusted data products that can support analytics, operational applications, customer-facing use cases, and downstream activation platforms.

This is a hands‑on architecture role for someone who combines strategic thinking with strong engineering expertise.

You’ll work closely with data engineering, analytics, cloud, security, architecture, and business teams to define standards, guide implementation, and ensure the platform remains scalable, secure, governed, and maintainable.

office remoteEuropean Union

Requirements

• Strong experience designing and delivering enterprise-scale cloud data platformsDeep hands‑on experience with Snowflake, including architecture, performance optimization, security, workload management, and cost optimization
• Experience with Data Vault 2.0.
• Experience with Data Mesh, including domain ownership, data products, federated governance, and data contracts
• Strong experience with dbt for data transformation, modelling, testing, documentation, and CI/CD
• Hands‑on experience with Matillion for data ingestion, orchestration, and integration
• Strong SQL skills and good Python experience
• Experience with data activation and reverse ETL use cases
• Strong understanding of data governance, quality, lineage, metadata, observability, security, and access-control principles
• Experience with CI/CD, Git-based development, automated testing, and DataOps practices
• Strong communication skills with the ability to translate business requirements into scalable architectural solutions
• Nice to have
• Experience with infrastructure-as-code tools such as Terraform and Azure
• Experience with Snowpark, stored procedures, tasks, streams, or other Snowflake-native development patterns
• Experience improving pipeline reliability through automated testing, monitoring, alerting, or operational dashboards
• Experience working in Agile delivery environments with distributed or cross-functional teams

Responsibilities

• Define and evolve the architecture for a modern Snowflake-based enterprise data platform
• Design end-to-end data solutions covering ingestion, transformation, modelling, governance, consumption, and activation
• Establish architecture standards and reusable patterns across Snowflake, dbt, Matillion, Python, and Terraform
• Define and govern Data Vault 2.0 and Data Mesh implementation patterns, including domain ownership, data products, and federated governance
• Design scalable ingestion and transformation patterns for batch, incremental, API, SaaS, database, file-based data
• Define data modelling standards across Raw Vault, Business Vault, dimensional models and analytical data products
• Design data activation and reverse ETL patterns for operational platforms
• Optimize Snowflake architecture for performance, scalability, security, reliability, and cost
• Define standards for data quality, lineage, metadata, observability, access control, and governance
• Drive CI/CD, DataOps, automated testing, and infrastructure-as-code practices across the data platform
• Provide architectural guidance, review technical designs, and support engineering teams with complex platform and data challenges

Benefits

• Projects for such clients as PayPal, Wargaming, Xerox, Philips, Adidas and Toyota
• Competitive compensation that depends on your qualification and skills
• Career development system with clear skill qualifications
• Flexible working hours aligned to your schedule
• Options to work remote
• Corporate medical insurance covering services of private and public medical centers
• English courses online
• Corporate parties and events for employees and their children
• Internal conferences, workshops and meetups for learning and experience sharing
• Gym membership compensation
• 5 days of paid sick leave per year with no obligation to submit a sick-leave certificate