Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Pyramid Consulting, Inc

NewBe an early applicant

Data Engineer

Posted

Description

Hiring: Snowflake Data Engineer / Snowflake Developer

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.
  • Experience developing Streamlit applications.

Interested Candidates

If you have strong experience in Snowflake, Fivetran, dbt, and SQL, we would love to hear from you!

Please share your updated resume or apply directly.

#Hiring #Snowflake #SnowflakeDeveloper #DataEngineer #Fivetran #dbt #SQL #DataEngineering #ELT #Python #AWS

Skills

Apply

See also

Data Engineering jobs by country — openings, pay and top skills →