About this role
Data Modeling & ELT: Design, develop, and optimize data models and ELT processes using Snowflake for efficient data processing and analytics.
- Design and implement end-to-end ELT pipelines for loading data from various sources into Snowflake using Fivetran.
- Implement data transformation logic using SQL and dbt ensuring the integrity, accuracy, and consistency of data.
- Optimize data loads and transformations for scalability and performance using Snowflake’s micro-partitioning and clustering features.
- Collaborate with data architects and business stakeholders to understand data requirements.
- Create Streamlit apps for user enablement and maintenance tasks
- Develop and maintain documentation for data processes and solutions.
- Ensure data quality, governance, and security within the Snowflake environment.
- Troubleshoot and resolve issues related to the Snowflake data warehouse.
- Stay updated with the latest Snowflake features and best practices.
- API Integrations: Work on integrating Snowflake with external APIs for seamless data extraction and transfer using Fivetran.
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 dbt.
- Knowledge of Python for data engineering tasks and automation.
- Familiarity with designing and managing data pipelines and ELT processes.
- Excellent communication skills and the ability to collaborate effectively with cross-functional teams.