SQL & Snowflake Engineer

Role overview Develop and maintain data transformations and Snowflake infrastructure that support engineering and reporting needs. The work combines advanced SQL, dbt modeling, platform configuration, and collaboration on data exploration and design.

Responsibilities - Translate engineering requirements into complex SQL queries and dbt models. - Build, test, and maintain scalable ELT pipelines, including model lineage and data quality checks. - Configure Snowflake warehouses, access controls, resource monitors, and performance settings. - Examine and map data schemas to support application logic and downstream use. - Improve query performance and manage Snowflake costs for large data workloads. - Contribute to Agile planning, technical discussions, data exploration, and schema reviews.

Requirements - Experience with Snowflake architecture, warehouse administration, role-based access, cost management, and data sharing. - Hands-on dbt experience across data modeling, transformations, testing, and lineage. - Advanced SQL skills, including common table expressions, window functions, and stored procedures. - Familiarity with ELT processes and data ingestion tools. - Experience versioning database scripts and pipeline changes with Git, Liquibase, dbt, or similar tools.

Nice to have - Cloud data storage and identity/access knowledge in AWS, Azure, or Google Cloud. - Infrastructure as Code experience, such as Terraform, and Python or scripting for automation. - Familiarity with semi-structured formats such as JSON and Parquet.

Benefits and work setup The position is listed as remote and based in Brazil.