What are the responsibilities and job description for the Senior Snowflake Developer and Data modeler position at Ecloud Labs?
Job Details
Our client is a top investment firm that invests in businesses across a range of industry sectors. They create long term value by continuously delivering advisory, transformation and operational support services enabling their portfolio companies to focus on doing and scaling what they do best.
Responsibilities -
We are seeking a highly skilled Senior Snowflake Developer and Data modeler to join the Business Intelligence and Data Warehousing team. The ideal candidate will have extensive experience in Snowflake Cloud Data Platform, Data modeling, ETL processes, and SQL development. This role will be responsible for designing, modeling, developing, and optimizing Snowflake solutions to support data warehousing, reporting, and analytics initiatives.
- Design, model and develop scalable Snowflake data warehouses and optimize performance
- Implement data ingestion, transformation, and ETL pipelines using Snowflake, SQL, and Python
- Develop stored procedures, functions, and views to support business intelligence and reporting
- Integrate Snowflake with cloud platforms (AWS, Azure, Google Cloud Platform) and third-party tools
- Collaborate with data engineers, analysts, and business teams to define data solutions
- Ensure data security, access control, and compliance within Snowflake
- Collaborate with IT Security team to implement Business Continuity and Disaster Recovery process
Must-have Requirements
- 5 years of experience working with Snowflake as a developer or data engineer
- Advanced knowledge in SQL, Change Data Capture, SnowSQL, Snow Pipes, Streams, Tasks, Stored procedures, Functions
- Should have data modeling experience in Snowflake preferably in Data Vault 2.0, along with creating ERD's
- Hands-on Python development experience
- Should have knowledge of Real time or Near-real time streaming data using Kafka with Snowpipe
- Knowledge of Cloud platforms (AWS, Azure, or Google Cloud Platform) and data integration
- Experience with performance tuning, indexing, and query optimization in Snowflake
- Strong problem-solving skills and ability to work in agile environments
Preferred Requirements -
- Snowflake certifications (SnowPro Core, SnowPro Advanced)
- Experience with CI/CD pipelines and DevOps practices for Snowflake
- Knowledge of DBT is a plus
- Snowflake Admin experience