Senior Data Engineer (Snowflake) - Remote Colombia / Costa Rica

About the role

Gorilla Logic is looking for an experienced Senior Data Engineer with strong hands-on expertise in Snowflake, SQL, data modeling and building scalable data pipelines, to support enterprise analytics, business intelligence and downstream applications. The role is remote and open only to candidates based in Colombia or Costa Rica. You will work with engineering and business stakeholders to consolidate data from multiple sources, build well-structured data models and own data engineering initiatives.

Key responsibilities

• Design, develop and maintain scalable data pipelines and data warehouse solutions in Snowflake.
• Build and maintain staging, integration, reporting and Golden Layer tables.
• Implement Bronze, Silver and Gold layer architectures and design star schema models.
• Develop and optimize complex SQL queries and ETL/ELT pipelines.
• Prepare data for BI tools such as Power BI, Tableau or Looker and support integrations with APIs and business systems.
• Set up data quality checks, monitoring and automated workflows, and fix pipeline failures and performance bottlenecks.
• Work with stakeholders on reporting and analytics requirements and contribute to data architecture discussions.

Required profile

• 5+ years of professional data engineering experience, including production pipelines and data warehouses.
• Strong hands-on Snowflake experience, including staging, integration and Golden Layer tables.
• Ability to work independently, take ownership of technical work and communicate with technical and business stakeholders.
• Strong English communication skills.

Required skills

• Snowflake and SQL (complex queries, joins, aggregations, performance tuning)
• Dimensional data modeling (star schemas, fact and dimension tables)
• ETL/ELT pipelines and data integration from databases, APIs, files or streams
• Data quality, consistency and performance optimization
• Python or another programming language; cloud platforms such as AWS
• Bonus: dbt, Apache Airflow or Dagster, Snowflake Streams/Tasks/Materialized Views, Kafka, Snowplow, Fivetran, Terraform, semantic layers, marketing analytics and AI-assisted development tools