Snowflake Python Developer

Unclassified - Wilmington, DE

Full-time

Wilmington, DE

About the position

The Snowflake Python Developer role is focused on designing, developing, and implementing data pipelines within the Snowflake platform. The ideal candidate will leverage their expertise in Python programming and data engineering to optimize data flow, ensure data quality, and enhance system performance. This position requires collaboration with data engineers and architects to manage complex data operations and contribute to the overall architecture of the data warehousing solution.

Responsibilities

• Design, implement, and maintain data pipelines in Snowflake using Python.
• Build and manage complex SQL queries, Snowflake functions, and stored procedures.
• Work with large datasets to develop scalable and efficient data models in Snowflake.
• Collaborate with data engineers and architects to optimize data flows and performance within the Snowflake environment.
• Integrate third-party data sources and ensure data quality, security, and governance.
• Automate workflows using Python scripts and Snowflake's native features.
• Ensure smooth data ingestion and manage the transformation of structured and unstructured data.
• Perform ETL (Extract, Transform, Load) operations to move data between Snowflake and other platforms.
• Monitor and troubleshoot performance issues and resolve technical challenges.
• Contribute to the architecture, performance tuning, and scaling of Snowflake databases.
• Document technical solutions and procedures to ensure maintainability and scalability of the systems.

Requirements

• 5+ years of experience as a Python Developer in data engineering or data warehousing.
• 3+ years of experience working with Snowflake as a data warehouse solution.
• Strong experience in Python scripting and automation.
• Expertise in SQL and Snowflake-specific query optimization.
• Experience with ETL tools and processes.
• Knowledge of cloud platforms such as AWS, Azure, or GCP, and familiarity with cloud-based data solutions.
• Familiarity with version control tools like Git and CI/CD pipelines.
• Experience in handling both structured and unstructured data.
• Ability to troubleshoot, tune, and enhance the performance of Snowflake databases.
• Excellent problem-solving skills, communication, and collaboration abilities.

Nice-to-haves

• Knowledge of Data Science workflows and integration with Snowflake.
• Hands-on experience with Snowflake's advanced features like Snowpipe, Data Sharing, or Time Travel.
• Experience with big data technologies like Spark or Hadoop is a plus.
• Relevant certifications in Snowflake, Python, or cloud platforms are an advantage.