Engenheiro de Dados Sênior (Redshift, Airflow e DBT)

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Engenheiro de Dados Sênior (Redshift, Airflow e DBT) based in Brazil. This is a senior-level opportunity for a Data Engineer who wants to combine hands-on engineering with architectural ownership. You will design, build, and operate reliable data platforms supporting critical business and regulatory needs. The role covers data warehouse modeling, ingestion standards, transformation layers, governance, performance, and cost optimization. You will work extensively with Amazon Redshift, Apache Airflow, dbt, SQL, and Python in a cloud-based environment. Your work will ensure that data powering executive dashboards, client reporting, and regulatory obligations is accurate, traceable, and auditable. You will collaborate with business and technology teams while serving as a technical reference for other data engineers. This is a fully remote position in a demanding environment where engineering rigor, autonomy, and data quality are highly valued. Design, build, and maintain production-grade data ingestion and transformation pipelines orchestrated with Apache Airflow , applying consistent standards for retries, idempotency, alerts, dependencies, and SLAs. Develop and evolve dbt transformation models , organizing staging, intermediate, and mart layers with appropriate testing, documentation, and version control. Implement ingestion pipelines for heterogeneous sources, including transactional databases, third-party APIs, regulatory files, and operational spreadsheets. Define and evolve the data warehouse architecture, selecting appropriate dimensional, Data Vault, or hybrid modeling approaches and establishing keys, granularity, historization, and handling of retroactive corrections. Establish and enforce MPP warehouse standards covering distribution, sorting, partitioning, compression, and related optimization practices, particularly within Amazon Redshift . Lead database and query performance optimization by analyzing execution plans, workload management, concurrency, maintenance requirements, query rewrites, and materializations while balancing performance and cost. Implement data observability and automated quality controls covering freshness, volume, data contracts, source-to-target reconciliation, and other critical reliability indicators. Define data layers and contracts between teams, establishing sources of truth, ownership boundaries, and the data exposed to BI and downstream consumers. Ensure end-to-end data lineage and traceability, allowing business metrics to be connected back to their source and the code version that produced them. Apply appropriate access controls, data segregation, and governance practices aligned with LGPD and relevant industry requirements. Document architectural decisions, maintain a living data dictionary, participate in code reviews and pair programming, and establish sustainable engineering standards. Act as a technical reference for other engineers through mentoring, knowledge sharing, architectural guidance, and constructive technical reviews. Translate business requirements into sustainable data solutions, proactively identifying risks and avoiding shortcuts that create unnecessary technical debt. Requirements 6+ years of professional experience in Data Engineering , including at least 2 years with architectural responsibility and ownership of data platform design decisions. Proven experience deploying and operating analytical data platforms in production, including experience handling incidents, operational responsibilities, and real-world reliability requirements. Advanced SQL skills, including window functions, recursive CTEs, execution-plan analysis, and diagnosis of skew and disk spill. Strong Python experience applied to data engineering, with modular, testable, version-controlled code, including experience with pandas or Polars, typing, and automated testing.