Senior Data Engineer, Snowflake

This is a fully remote position, open to applicants in Colombia, +1 more country.

📋 Description

• Design, develop, and sustain scalable data pipelines and data warehouse solutions utilizing Snowflake.

• Construct and manage staging, integration, reporting, and Golden Layer tables for analytics and downstream applications.

• Transform and consolidate raw data into structured, dependable, and business-ready datasets.

• Implement Bronze, Silver, and Gold data layers adhering to contemporary data engineering practices.

• Create and refine dimensional data models using star schemas, fact tables, and dimension tables.

• Develop and enhance complex SQL queries, transformations, and data processing workflows.

• Establish and uphold ETL/ELT pipelines that integrate data from enterprise systems and external sources.

• Prepare datasets for business intelligence platforms such as Power BI, Tableau, Looker, or similar tools.

• Facilitate integrations with downstream applications, APIs, and business systems.

• Implement data quality checks, validation, monitoring, and automated workflows.

• Diagnose data pipeline failures, performance issues, and data consistency challenges.

• Collaborate with business stakeholders regarding reporting, analytics, and data integration needs.

• Participate in discussions about data architecture, technical decisions, and ongoing improvements.

• Develop documented, maintainable, and reusable data solutions.

⛳️ Requirements

• Over 5 years of professional experience in Data Engineering, which includes designing and maintaining production data pipelines and data warehouse solutions.

• Extensive hands-on experience with Snowflake, particularly in developing, maintaining, and optimizing data warehouse structures.

• Proven experience in building staging, integration, reporting, and Golden Layer tables within Snowflake.

• Experience in consolidating, transforming, and modeling raw data into analytics-ready datasets for BI platforms and downstream systems.

• In-depth knowledge of SQL, encompassing complex queries, transformations, joins, aggregations, and performance optimization.

• Experience in designing dimensional data models, including star schemas, fact tables, and dimension tables.

• Practical experience in building and maintaining ETL/ELT pipelines and data integration workflows.

• Experience in preparing and structuring data for use by BI and reporting platforms such as Power BI, Tableau, Looker, or similar tools.

• Experience in integrating data from diverse sources, including databases, APIs, files, or streaming pipelines.

• Strong understanding of data warehouse architecture, data quality, data consistency, and performance optimization.

• Proficiency in 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 abilities.

• Capability to work independently, take ownership of technical initiatives, and communicate effectively with both technical and business stakeholders.

• Proficient in English communication.

• Candidates must reside in Colombia or Costa Rica.

• Bonus: Familiarity with dbt, Apache Airflow, Dagster, advanced Snowflake features, Kafka, Snowplow, Fivetran, semantic layers, marketing analytics, customer data platforms, infrastructure as code (including Terraform), and AI-assisted development tools.

🏝️ Benefits

• Remote work arrangement.

• Full-time employment.