Overview

We're looking for a Senior Data Engineer – dbt to join our team in Portugal in a remote working mode. This role focuses on designing, building and optimizing scalable data transformation solutions using dbt. You will ensure clean, maintainable architectures and production-grade pipelines that support analytics at enterprise scale. The position requires deep expertise in SQL, data modeling, and modern ELT practices, alongside strong skills in cloud-based data platforms and CI/CD integration.

Responsibilities

  • Design and implement modular dbt models using best practices for staging, intermediate and mart layers
  • Develop and maintain reusable Jinja macros, custom materializations and dbt tests for data quality validation
  • Optimize SQL queries for large analytical workloads and ensure warehouse performance tuning
  • Manage version control using Git and integrate dbt workflows into CI/CD pipelines
  • Orchestrate dbt jobs with tools such as Airflow, Dagster or Prefect, ensuring reliability and SLA compliance
  • Collaborate with stakeholders to translate business requirements into robust data models and semantic layers
  • Implement observability practices including automated testing, data monitoring and lineage tracking
  • Lead technical discussions, establish coding standards and mentor junior engineers
  • Identify and resolve performance bottlenecks in data transformations to reduce compute costs
  • Drive adoption of engineering best practices across the data team

Requirements

  • Proven experience as a Data Engineer with extensive hands-on exposure to dbt and modern ELT patterns
  • Advanced SQL expertise including query optimization, CTEs and warehouse functions
  • Experience with major cloud data warehouses such as Snowflake, BigQuery, Databricks or Redshift
  • Familiarity with Git workflows, branching strategies and CI/CD integration for dbt projects
  • In-depth knowledge of data modeling principles including dimensional modeling (Kimball)
  • Strong understanding of data quality frameworks and observability tools (e.g., dbt tests, Great Expectations, Soda)
  • Proficiency in orchestrating workflows using Airflow, Dagster, Prefect or dbt Cloud
  • Ability to implement Infrastructure as Code (e.g., Terraform) for environment automation
  • Excellent communication skills with the ability to convey technical concepts to non-technical audiences
  • Strong problem-solving mindset and capability to troubleshoot and optimize data pipelines

Portugal

  • Competitive compensation depending on experience and skills
  • Variety of projects within one company
  • Being a part of a project following engineering excellence standards
  • Individual career path and professional growth opportunities
  • Internal events and communities
  • Flexible work hours