Senior Data Engineer (Snowflake) - AA, Remote: Colombia - Costa Rica, Fulltime

Gorilla Logic

United States

Remote

USD 120,000 - 180,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Gorilla Logic is seeking a Senior Data Engineer with strong Snowflake, SQL, data modeling, and scalable data pipelines to support enterprise analytics and BI workloads.

The ideal candidate will design and implement data warehouse solutions, including staging, integration, and Gold/Golden layer tables, consolidating data from multiple sources for analytics-ready datasets. You will own data engineering initiatives and collaborate with engineering and stakeholders to drive reliable data.

Qualifications

  • 5+ years of professional experience in Data Engineering and data warehouse design.
  • Strong hands-on Snowflake experience building staging, integration, and Golden Layer tables.
  • Experience designing star schemas and dimensional models for BI.
  • Proficient in SQL with complex queries and performance tuning.
  • Experience with Python and cloud data platforms (AWS).
  • Ability to work independently and communicate with stakeholders.
  • Strong English communication skills.

Responsibilities

  • Design, develop, and maintain scalable data pipelines and data warehouse solutions using Snowflake.
  • Build and maintain staging, integration, reporting, and Golden Layer tables to support analytics and downstream applications.
  • Consolidate and transform raw data into structured, reliable datasets.
  • Implement layered data architectures (Bronze/Silver/Gold).
  • Model data using star schemas, fact tables, and dimension tables.
  • Develop and optimize complex SQL queries and data processing workflows.
  • Build and maintain ETL/ELT pipelines from multiple sources.
  • Prepare data for BI tools such as Power BI, Tableau, Looker.
  • Support data integrations with APIs and business systems.
  • Implement data quality checks, monitoring, and automated workflows.
  • Identify and resolve data pipeline failures and bottlenecks.
  • Collaborate with stakeholders to define reporting and data requirements.
  • Contribute to data architecture decisions and best practices.
  • Develop well-documented, reusable data solutions.

Skills

Snowflake
SQL
Data modeling
Data pipelines
ETL/ELT
Python
Cloud platforms
BI tools
Data warehouse
Performance tuning
Stakeholder communication

Tools

dbt
Apache Airflow
Dagster
Terraform

Job description

- This position is open to candidates located in Colombia or Costa Rica only - 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 ideal candidate will have extensive experience designing and implementing data warehouse solutions, particularly building staging, integration, and Golden Layer tables that transform raw data into reliable, analytics-ready datasets. In this role, you will work closely with engineering and business stakeholders to consolidate data from multiple sources, develop well-structured data models, and ensure that information is accessible and reliable for reporting, business intelligence platforms, and other data-driven applications. We are looking for an autonomous, hands-on engineer who can take ownership of data engineering initiatives, troubleshoot complex data challenges, and contribute to the development of scalable and maintainable data solutions.

Responsibilities
  • Design, develop, and maintain scalable data pipelines and data warehouse solutions using Snowflake.
  • Build and maintain staging, integration, reporting, and Golden Layer tables to support analytics and downstream applications.
  • Consolidate and transform raw data into structured, reliable, and business-ready datasets.
  • Implement layered data architectures, including Bronze, Silver, and Gold layers, following modern data engineering practices.
  • Design and optimize data models using star schemas, fact tables, dimension tables, and other analytical modeling techniques.
  • Develop and optimize complex SQL queries, transformations, and data processing workflows.
  • Build and maintain ETL/ELT pipelines to integrate data from multiple enterprise systems and external sources.
  • Prepare and structure datasets for consumption by business intelligence tools such as Power BI, Tableau, Looker, or similar platforms.
  • Support data integrations with downstream applications, APIs, and business systems.
  • Implement data quality checks, validation processes, monitoring, and automated workflows to ensure data accuracy and reliability.
  • Identify and resolve data pipeline failures, performance bottlenecks, and data consistency issues.
  • Collaborate with business stakeholders to understand reporting, analytics, and data integration requirements.
  • Contribute to data architecture discussions, technical decisions, and continuous improvements to data engineering practices.
  • Develop well-documented, maintainable, and reusable data solutions that support evolving business needs.
Technical Requirements
  • 5+ years of professional experience in Data Engineering, including designing and maintaining production data pipelines and data warehouse solutions.
  • Strong hands-on experience with Snowflake, including developing, maintaining, and optimizing data warehouse structures.
  • Demonstrated experience building staging, integration, reporting, and Golden Layer tables in Snowflake.
  • Experience consolidating, transforming, and modeling raw data into analytics-ready datasets for BI platforms and downstream systems.
  • Strong knowledge of SQL, including complex queries, transformations, joins, aggregations, and performance optimization.
  • Experience designing dimensional data models, including star schemas, fact tables, and dimension tables.
  • Hands-on experience building and maintaining ETL/ELT pipelines and data integration workflows.
  • Experience preparing and structuring data for consumption by BI and reporting platforms such as Power BI, Tableau, Looker, or similar tools.
  • Experience integrating data from multiple sources, including databases, APIs, files, or streaming pipelines.
  • Strong understanding of data warehouse architecture, data quality, data consistency, and performance optimization.
  • Experience with Python or another programming language used for data processing and automation.
  • Experience working with cloud-based data platforms and services, such as AWS or similar enterprise cloud environments.
  • Strong troubleshooting, analytical thinking, and problem-solving skills.
  • Ability to work independently, take ownership of technical initiatives, and communicate effectively with technical and business stakeholders.
  • Strong English communication skills.
Bonus Skills
  • Experience with dbt for data transformation and modeling.
  • Experience with Apache Airflow, Dagster, or similar workflow orchestration tools.
  • Familiarity with Snowflake Dynamic Tables, Streams, Tasks, Materialized Views, and other advanced Snowflake features.
  • Experience with Kafka or other real-time data streaming technologies.
  • Experience with Snowplow for event tracking, data collection, and ingestion.
  • Familiarity with modern data integration tools such as Fivetran or similar solutions.
  • Experience designing semantic layers, standardized datasets, or self-service analytics solutions.
  • Experience supporting marketing analytics, customer data platforms, or business intelligence initiatives.
  • Experience with infrastructure as code, including Terraform.
  • Familiarity with AI-assisted development tools and their application in data engineering workflows.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer (Snowflake) | Jobs in US
Data Engineer (Snowflake) | Jobs in US

DigitalXNode • United States

Remote
USD 140,000 - 190,000
Sr. Snowflake Data Engineer
Sr. Snowflake Data Engineer

BravoTECH • Plano (TX)

On-site
USD 120,000 - 150,000
Sr Data Engineer
Sr Data Engineer

Cox Automotive • Atlanta (GA)

On-site
USD 140,000 - 190,000
Senior Snowflake Data Engineer - Talent Pipeline
Senior Snowflake Data Engineer - Talent Pipeline

BlueCloud • United States

On-site
USD 150,000 - 210,000
Sr. Snowflake Data Engineer & DBA
Sr. Snowflake Data Engineer & DBA

Jobs via Dice • Dallas (TX)

On-site
USD 80,000 - 120,000
[8GT] Senior Data Engineer
[8GT] Senior Data Engineer

Software Mind • United States

Remote
USD 120,000 - 190,000
Snowflake Data Engineer (100% Remote)
Snowflake Data Engineer (100% Remote)

Xforia Global Talent & Technology Solutions • United States

Remote
MXN 900,000 - 1,300,000
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000
Data Engineer
Data Engineer

Collectivus Holdings • United States

Remote
USD 100,000 - 150,000