12 nov
|
Turtle Trax
|
México
12 nov
Turtle Trax
México
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