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
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
Featured candidates
- ISO 9001
- ISO 14001
- ISO 45001
- Responsable
- Comprometida
- Honesta
- Ruby
- Python
- JavaScript
- Soporte técnico y atención especializada
- Diagnóstico de fallas electrónicas
- Software de dispositivos móviles