Data Engineer

External job listingat Pyramid Consulting, Inc

Hiring: Snowflake Data Engineer / Snowflake DeveloperLocation: 100% Remote Role OverviewWe are looking for an experienced Snowflake Data Engineer with strong ha

External source - not verified16 hours agoOpen until: Dec 18, 2026

Salary

Not provided

Location

Remote

Employment type

Full time

Workplace

Remote

Data Engineer

Remote

Job description

Hiring: Snowflake Data Engineer / Snowflake DeveloperLocation: 100% Remote
Role OverviewWe 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 ResponsibilitiesDesign, 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 & QualificationsStrong 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 SkillsExperience 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 CandidatesIf 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

Similar jobs