Ampstek

Software Engineer

Posted: 9 minutes ago

Job Description

Role: Snowflake DeveloperLocation: Poland100% RemoteB2B Contract Primary Skillset:• Data Modeling & ETL: Design, develop, and optimize data models and ETL processes using Snowflake for efficient data storage and analytics.• Design and implement end-to-end ETL pipelines for loading data from various sources into Snowflake.• Utilize Snowflake’s built-in features such as tasks, streams, and Snowpipe to automate the ETL process for continuous and batch data loads.• Implement data transformation logic using SQL, Snowflake Stored Procedures (SQL and Python), and ETL tool to ensure the integrity, accuracy, and consistency of data.• Optimize data loads and transformations for scalability and performance using Snowflake’s micro-partitioning and clustering features.• Optimize and tune Snowflake queries, Data Storage, Warehouse for performance and efficiency. DevOps Integration - Secondary• Azure DevOps Experience: Proficiency with Azure DevOps for:• Deploying Snowflake scripts across different environments• Managing ETL pipeline deployments• Proficiency in DevOps tools and best practices, with experience deploying Snowflake and ETL tool services. 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 Snowflake’s micro-partitioning, file processing from AWS S3, and optimizing data models.• Strong knowledge of Python for data engineering tasks and automation.

Job Application Tips

  • Tailor your resume to highlight relevant experience for this position
  • Write a compelling cover letter that addresses the specific requirements
  • Research the company culture and values before applying
  • Prepare examples of your work that demonstrate your skills
  • Follow up on your application after a reasonable time period

You May Also Be Interested In