Data Engineer

Pyramid Consulting, Inc

United States

Remote

MXN 2,028,000 - 2,950,000

Full time

3 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Pyramid Consulting, Inc. is seeking an experienced Snowflake Data Engineer for a 100% remote role. You will design, develop, and optimize ELT pipelines using Snowflake, Fivetran, dbt, and SQL, enabling scalable data integration across sources.

The candidate should also handle data modeling, API integrations, and Python-based tooling. You'll collaborate with data architects and stakeholders, implement data governance and quality checks, and contribute to deployment pipelines using GitHub.

Qualifications

  • Strong hands-on Snowflake data warehousing and architecture.
  • Experience with Fivetran for ELT pipeline development.
  • Proficient in SQL with complex queries, CTEs, and stored procedures.
  • Hands-on with dbt for data transformation, testing, and modeling.
  • Knowledge of Python for data engineering, automation, and scripting.
  • Experience with GitHub for source control and deployment management.

Responsibilities

  • Design, develop, and optimize data models and end-to-end ELT pipelines using Snowflake and Fivetran.
  • Build and maintain data integration pipelines to extract and load data from multiple sources into Snowflake.
  • Develop data transformation models using dbt and advanced SQL.
  • Optimize Snowflake performance using micro-partitioning, clustering, and query optimization techniques.
  • Implement data quality checks, data governance, and security practices.
  • Develop and maintain Python-based Streamlit applications for user enablement and maintenance activities.
  • Integrate Snowflake with external systems and APIs for seamless data extraction and transfer.
  • Troubleshoot and resolve data warehouse and pipeline-related issues.
  • Collaborate with data architects and business stakeholders to understand data requirements.
  • Maintain technical documentation and follow data engineering best practices.

Skills

Snowflake Data Warehousing
Fivetran
SQL
dbt
Python
GitHub
API Integrations
Data Modeling
Data Pipelines
Data Governance

Tools

Streamlit
Terraform
CloudFormation
AWS S3
Lambda

Job description

Location: 100% Remote

Role Overview

We are looking for an experienced Snowflake Data Engineer with strong hands‑on expertise in Snowflake, Fivetran, dbt, and SQL to design, develop, and optimize scalable data integration and ELT pipelines.

The ideal candidate should have experience in data warehousing, data modeling, data transformation, and API integrations, along with knowledge of Python and GitHub‑based deployment processes.

Key Responsibilities
  • Design, develop, and optimize data models and end‑to‑end ELT pipelines using Snowflake and Fivetran.
  • Build and maintain data integration pipelines to extract and load data from multiple sources into Snowflake.
  • Develop data transformation models using dbt and advanced SQL.
  • Optimize Snowflake performance using micro‑partitioning, clustering, and query optimization techniques.
  • Implement data quality checks, data governance, and security practices.
  • Develop and maintain Python‑based Streamlit applications for user enablement and maintenance activities.
  • Integrate Snowflake with external systems and APIs for seamless data extraction and transfer.
  • Troubleshoot and resolve data warehouse and pipeline‑related issues.
  • Collaborate with data architects and business stakeholders to understand data requirements.
  • Maintain technical documentation and follow data engineering best practices.
Required Skills & Qualifications
  • Strong hands‑on experience with Snowflake Data Warehousing and its architecture.
  • Expertise in Fivetran for data integration and ELT pipeline development.
  • Strong proficiency in SQL, including complex queries, CTEs, and stored procedures.
  • Hands‑on experience with dbt for data transformation, testing, and modeling.
  • Understanding of data modeling, ELT processes, and data pipeline architecture.
  • Knowledge of Python for data engineering, automation, and scripting.
  • Experience with Snowflake features such as micro‑partitioning, clustering, and AWS S3 data loading.
  • Familiarity with API integrations and data extraction processes.
  • Experience with GitHub for source control and deployment management.
Good to Have / Preferred Skills
  • Experience with SnapLogic or other ETL/ELT tools.
  • Exposure to AWS services such as Lambda, SQS, SNS, and S3.
  • Knowledge of Terraform or CloudFormation for infrastructure deployment.
  • Experience with CI/CD pipelines and automated deployments.
  • Familiarity with Microsoft SQL Server and legacy database integrations.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Data Engineer
Snowflake Data Engineer

Fa Ewjt Saasfaprod1 • New York (NY)

On-site
USD 120,000 - 170,000
Data Engineer (Snowflake)
Data Engineer (Snowflake)

Tek Ninjas • United States

Remote
USD 100,000 - 130,000
Data Engineer
Data Engineer

GBIT (Global Bridge InfoTech Inc) • Richardson (TX)

On-site
USD 90,000 - 130,000
Data Engineer (Snowflake) | Jobs in US
Data Engineer (Snowflake) | Jobs in US

DigitalXNode • United States

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

EXL Talent Acquisition Team • New York (NY)

On-site
USD 120,000 - 170,000
Salesforce Dev
Salesforce Dev

Valce Talent Solutions • United States

Remote
USD 120,000 - 180,000
Data Engineer (Snowflake + Databricks + Python)
Data Engineer (Snowflake + Databricks + Python)

Apexon • Alpharetta (GA)

On-site
USD 120,000 - 150,000
Sr Data Engineer
Sr Data Engineer

FlexStaf IT • Irvine (CA)

Hybrid
USD 120,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
Data Engineer
Data Engineer

Root It Services • Snowflake (AZ)

Hybrid
USD 104,000 - 146,000