Senior Data Engineer (Snowflake)

Location: Remote; candidates must be located in Colombia or Costa Rica only.

Company

hirify.global provides engineering services focused on building scalable software and data solutions for enterprise environments.

What you will do

• Design, develop, and maintain scalable Snowflake data pipelines and data warehouse solutions.
• Build staging, integration, reporting, and Golden Layer tables, including Bronze, Silver, and Gold data architectures.
• Consolidate and transform raw data into structured, analytics-ready datasets for BI platforms and downstream applications.
• Design dimensional models using star schemas, fact tables, and dimension tables, and optimize complex SQL transformations.
• Integrate data from enterprise systems, databases, APIs, files, and streaming pipelines using ETL/ELT workflows.
• Implement data quality checks, monitoring, automated workflows, troubleshooting, documentation, and continuous improvements while collaborating with technical and business stakeholders.

Requirements

• 5+ years of professional Data Engineering experience, including designing and maintaining production data pipelines and data warehouse solutions.
• Strong hands-on Snowflake experience, including developing, maintaining, and optimizing warehouse structures and building staging, integration, reporting, and Golden Layer tables.
• Strong SQL skills covering complex queries, transformations, joins, aggregations, and performance optimization.
• Experience with dimensional data modeling, including star schemas, fact tables, and dimension tables.
• Hands-on experience with ETL/ELT pipelines, data integration workflows, and data preparation for Power BI, Tableau, Looker, or similar BI platforms.
• Experience integrating multiple data sources and understanding data warehouse architecture, data quality, data consistency, and performance optimization.
• Experience with Python or another programming language for data processing and automation, plus cloud-based data platforms such as AWS or similar enterprise environments.
• Strong troubleshooting, analytical thinking, problem-solving, independent ownership, and communication skills with technical and business stakeholders.
• Strong English communication skills.

Nice to have

• Experience with dbt, Apache Airflow, Dagster, or similar transformation and orchestration tools.
• Familiarity with Snowflake Dynamic Tables, Streams, Tasks, Materialized Views, and other advanced Snowflake features.
• Experience with Kafka, Snowplow, Fivetran, or similar real-time data streaming and integration tools.
• 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 in data engineering workflows.

Culture & Benefits

• Full-time remote work restricted to candidates located in Colombia or Costa Rica.
• Autonomous, hands-on ownership of data engineering initiatives.
• Collaboration with engineering and business stakeholders on enterprise analytics and data integration needs.