Senior Data Engineer - dbt
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
