Databricks Lakehouse Architect — Cloud Data Platform Leader

Devoteam; Madrid; Hybrid; EUR 60,000 - 90,000; Full time

Job summary

Devoteam is seeking a Snowflake & DBT Data Engineer in Madrid to manage and optimize our data platform for analytics and business operations in asset management. You will ensure high availability, secure access, and efficient data pipelines across the organization.

You will develop robust DBT Core projects, create reusable macros, and oversee DBT Cloud deployments while collaborating with data engineers and analysts to translate requirements into optimal Snowflake schemas and models.

Qualifications

• Hands-on experience with Snowflake and DBT to manage and optimize data platforms.
• Strong SQL skills and data modelling capabilities.
• Experience with data governance, security, and access controls.

Responsibilities

• Manage Snowflake environments for high availability and performance.
• Perform DBT testing on Snowflake and maintain robust DBT models.
• Configure Snowflake Tasks to orchestrate data pipelines and automate jobs.
• Administer Snowflake accounts, roles, policies, and usage monitoring.
• Develop and maintain DBT Core projects with robust transformations and data quality checks.
• Create reusable DBT macros and promote consistent coding practices.
• Oversee DBT Cloud deployments, environments, jobs, and run configurations.
• Collaborate with data teams to translate requirements into Snowflake schemas and DBT models.
• Monitor data pipelines using platform logs and metrics, troubleshoot issues, and implement remediation.
• Implement data security and governance controls including masking policies and audited data sharing.
• Coordinate with infra and apps teams to integrate Snowflake/DBT with enterprise tools.

Skills

Snowflake

DBT

SQL

Data modelling

Performance tuning

Data governance

Tools

dbt Cloud

Snowflake Console

Job description

Snowflake & DBT Data Engineer

About the role We are looking for a Data Engineer with strong hands‑on experience in Snowflake and DBT to manage and optimize our data platform, supporting analytical and business operations within the asset management area.

Responsibilities

• Manage Snowflake data platform environments to ensure high availability, predictable performance, and secure access for analytical and operational workloads across the organization.
• Perform DBT testing on Snowflake.
• Configure and optimize Snowflake Tasks to orchestrate complex data pipelines, automate recurring jobs, and maintain reliable scheduling and monitoring for critical data processes.
• Administer Snowflake account‑level settings, including roles, policies, resource allocation, and usage monitoring, to support cost‑effective and compliant data operations.
• Develop and maintain DBT Core projects that implement robust transformation logic, enforce data quality checks, and standardize modeling patterns for shared enterprise datasets.
• Create and refine DBT macros that encapsulate reusable transformation logic, streamline project implementation, and promote consistent coding practices across multiple data teams.
• Oversee DBT Cloud deployments by managing environments, jobs, and run configurations, ensuring smooth execution of production and non‑production data workflows.
• Collaborate with data engineers and analysts to translate business requirements into efficient Snowflake schemas and DBT models that enable accurate reporting and advanced analytics.
• Monitor data pipeline health using platform logs and metrics, proactively troubleshoot issues, and implement remediation steps that minimize disruption to downstream consumers.
• Implement robust data security and governance controls within Snowflake, including role‑based access patterns, masking policies, and audited data sharing to protect sensitive information.
• Coordinate with infrastructure and application teams to integrate Snowflake and DBT with enterprise tools such as version control, monitoring platforms, and catalog solutions, supporting hybrid work arrangements.
• Document platform configurations, operational runbooks, and data workflow standards in clear technical references that enable consistent administration and easier onboarding for new team members.
• Drive continuous improvement by analyzing platform utilization trends, recommending optimization strategies, and implementing changes that enhance performance and reduce operational overhead.
• Support asset management operations stakeholders by maintaining