Hello,
Greetings from John Mindfore Inc
Job Title: Snowflake Designer/Developer
Location: Remote
Job Description:
The Senior Snowflake Designer/Developer is responsible for handling new enhancements, managing error handling, implementing logging systems, enriching existing
data, performing code refactoring, optimizing queries, and integrating with internal source systems. Strong expertise in Snowflake is essential, and Python experience is a plus for
additional functionality and automation.
Key Responsibilities:
- Design, develop, and maintain Snowflake data warehouse solutions, ensuring scalability, performance, and robustness.
- Create complex data pipelines, tasks, and streams for efficient ETL processing and real- time data flow.
- Should have a good understanding of SnowPark Experience in Snowpark will be plus
- Lead the development and implementation of new features and functionalities based on business needs.
- Collaborate with stakeholders to understand requirements and translate them into Snowflake data solutions.
- Implement comprehensive error handling strategies and logging mechanisms to ensure data integrity and easy debugging.
- Create alerts and monitoring solutions to proactively address issues in the data pipeline.
- Review, refactor, and optimize existing Snowflake code to ensure efficiency and scalability.
- Perform regular code reviews and implement best practices to improve maintainability and performance.
- Optimize complex SQL queries for faster performance, minimizing computational load and reducing query execution time.
- Implement best practices for indexing, clustering, and partitioning to improve the performance of Snowflake queries.
- Integrate data from internal source systems (e.g., transactional systems, external APIs) into Snowflake for downstream analytics and reporting.
- Work closely with data engineers and architects to design and implement smooth integration processes.
Required Skills & Qualifications:
- Snowflake: Deep knowledge of Snowflake’s architecture, including schemas, tables, views, tasks, streams, and Snowflake SQL.
- SQL: Expertise in writing optimized queries, stored procedures, and complex joins.
- Python: Familiarity with Python for automation, script creation, and handling integration tasks (preferred).
- ETL Tools: Added advantage if candidate has experience with ETL tools and data pipeline orchestration (e.g., Apache Airflow, dbt, etc.).
- Version Control: Knowledge of version control systems such as Git.
- Cloud Platforms: Experience working with cloud environments, particularly Azure, or AWS.
- Excellent problem-solving skills, attention to detail, and ability to work independently.
- Strong communication and collaboration skills to work effectively across teams
From:
John,
Mindfore
john@mindfore.com
Reply to: john@mindfore.com