Salesforce Dev

Valce Talent Solutions

United States

Remote

USD 120,000 - 180,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Turtle Trax S.A. is seeking a remote Snowflake Developer to design and optimize data models, ELT pipelines, and data transformations in Snowflake. You will leverage dbt, Fivetran, Python, and APIs to build scalable analytics and ensure data quality and security.

Collaborate with data architects and business stakeholders, create Streamlit apps for enablement, and maintain comprehensive documentation. The role suits strong SQL, Snowflake features, and cloud experience in a fast-paced, remote US

Qualifications

  • Proven Snowflake data warehousing experience
  • Strong SQL with complex queries, CTEs, and JS in Snowflake
  • Hands-on with dbt and ELT pipelines
  • Familiarity with Python for data engineering tasks
  • Experience with AWS services and DevOps tools is a plus

Responsibilities

  • Design and optimize Snowflake data models and ELT processes
  • Build end-to-end ELT pipelines using Fivetran
  • Implement data transformations with SQL and dbt
  • Optimize loads with Snowflake micro-partitioning and clustering
  • Collaborate with data architects and stakeholders
  • Create Streamlit apps for user enablement
  • Maintain docs for data processes and solutions
  • Ensure data quality, governance, and security in Snowflake
  • Troubleshoot Snowflake data warehouse issues
  • Stay updated on Snowflake features and best practices
  • Integrate Snowflake with external APIs via Fivetran

Skills

Snowflake Dev
SQL Pro
dbt
Python
ELT pipelines
Data modeling
APIs
Streamlit

Tools

GitHub
dbt
Fivetran
Snowflake
AWS CloudFormation
Terraform
Streamlit

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Pyramid Consulting, Inc • United States

Remote
MXN 2,028,000 - 2,950,000
Snowflake Data Engineer
Snowflake Data Engineer

NewVision • United States

Remote
USD 140,000 - 200,000
Senior Snowflake Developer
Senior Snowflake Developer

TekDallas • Boston (MA)

Hybrid
USD 130,000 - 185,000
Snowflake Dev with strong ETL / SQL Lake Mary, FL
Snowflake Dev with strong ETL / SQL Lake Mary, FL

Executive Staff Recruiters / ESR Healthcare • Florida

On-site
USD 100,000 - 130,000
Senior Snowflake Developer | NY, NJ | Contract (C2H) / FTE
Senior Snowflake Developer | NY, NJ | Contract (C2H) / FTE

Healthcare Triangle, Inc. • New York (NY)

On-site
USD 140,000 - 190,000
Sr. Snowflake Data Engineer & DBA
Sr. Snowflake Data Engineer & DBA

Jobs via Dice • Dallas (TX)

On-site
USD 80,000 - 120,000
Senior Data Engineer
Senior Data Engineer

SRM Technologies LLC • United States

Remote
USD 150,000 - 190,000
Snowflake - Data Engineer
Snowflake - Data Engineer

TechDigital Group • Boca Raton (FL)

On-site
USD 80,000 - 120,000
Data Engineer
Data Engineer

TechDigital Group • Portland (OR)

On-site
USD 90,000 - 130,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000