Remote

Advanced english

Primary Skillset

- Data Modeling & ELT: Design, develop, and optimize data models and ELT processes using Snowflake for efficient data processing and analytics.

- Design and implement end-to-end ELT pipelines for loading data from various sources into Snowflake using Fivetran.

- Implement data transformation logic using SQL and dbt ensuring the integrity, accuracy, and consistency of data.

- Optimize data loads and transformations for scalability and performance using Snowflake’s micro-partitioning and clustering features.

- Collaborate with data architects and business stakeholders to understand data requirements.

- Create Streamlit apps for user enablement and maintenance tasks

- Develop and maintain documentation for data processes and solutions.

- Ensure data quality, governance, and security within the Snowflake environment.

- Troubleshoot and resolve issues related to the Snowflake data warehouse.

- Stay updated with the latest Snowflake features and best practices.

- API Integrations: Work on integrating Snowflake with external APIs for seamless data extraction and transfer using Fivetran.

DevOps Integration - Secondary

- Github Experience: Proficiency with Github for:

- Source control management

- Automating deployments

- Deploying Snowflake scripts and dbt models across different environments





- Managing ELT pipeline deployments

Qualifications

- Proven experience as a Snowflake Developer with hands-on experience in Snowflake data warehousing solutions.

- Data Architecture: Strong understanding of Snowflake platform features, including micro-partitioning, file processing from AWS S3, and data quality practices.

- Expertise in writing and optimizing SQL queries, including complex queries, CTEs, and stored procedures (using JavaScript within Snowflake).

- Solid experience in working with dbt.

- Knowledge of Python for data engineering tasks and automation.

- Familiarity with designing and managing data pipelines and ELT processes.

- Excellent communication skills and the ability to collaborate effectively with cross-functional teams.

Preferred Skills

- Experience in using the ETL tools like DBT/SnapLogic for building ELT pipelines, testing, and deploying transformation models. DBT/SnapLogic is preferred.

- Hands-on experience with AWS services and DevOps tools (e.g., CloudFormation, Terraform) for deploying AWS resources such as Lambda, SQS, and SNS.

- Familiarity with legacy Microsoft SQL platforms and integrating these with modern cloud-based data solutions.

- Strong problem-solving skills and the ability to thrive in a collaborative and fast-paced environment.

📌 Salesforce Dev (México)
🏢 Turtle Trax
📍 México