
Data Engineer, Snowflake Focus
Posted 3 days ago

Posted 3 days ago
This is a fully remote position, open to applicants in Mexico.
• Design, develop, and enhance Snowflake data models and ELT processes.
• Create and implement end-to-end ELT pipelines utilizing Fivetran.
• Execute data transformations through SQL and dbt.
• Enhance data loads and transformations by leveraging Snowflake micro-partitioning and clustering techniques.
• Integrate Snowflake with external APIs using Fivetran.
• Oversee GitHub source control and automate deployments across various environments.
• Deploy Snowflake scripts, dbt models, and ELT pipelines effectively.
• Develop Streamlit applications for user enablement and maintenance tasks.
• Ensure the quality, governance, security, and documentation of data.
• Troubleshoot issues related to the Snowflake data warehouse.
• Collaborate with data architects and business stakeholders to gather and understand data requirements.
• Demonstrated hands-on experience as a Snowflake Developer / Data Engineer in data warehousing solutions.
• Strong knowledge of Snowflake platform features, including micro-partitioning, file processing from AWS S3, and data quality practices.
• Proficient in writing and optimizing SQL queries, including CTEs and JavaScript stored procedures within Snowflake.
• Extensive experience with dbt and Python for data engineering tasks and automation.
• Familiarity with designing and managing data pipelines and ELT processes.
• Proven expertise with Snowflake, SQL, dbt, Fivetran, Python, and API integrations.
• Proficient with GitHub for source control and automated deployments.
• Hands-on experience focused on data modeling and ELT pipelines.
• Excellent communication and problem-solving abilities.
• Advanced proficiency in Oral English.
• Advanced proficiency in Spanish.
• Preferred: hands-on experience with AWS services (Lambda, SQS, SNS) and DevOps tools (CloudFormation, Terraform).
• Preferred: experience with ETL tools such as SnapLogic.
• Preferred: familiarity with legacy Microsoft SQL platforms and transitioning them to cloud-based solutions.
• Desired: familiarity with cloud-native foundations or AI coding assistants.
• Flexible work arrangement.
• Option for remote work.
• Continuous learning and growth opportunities.
• Exposure to high-impact projects.
• Collaboration within an international network of expertise.
• Access to world-class project opportunities.
Power Digital Marketing
Power Digital Marketing
Power Digital Marketing
Power Digital Marketing
Get handpicked remote jobs straight to your inbox weekly.