ETL SQL Data Engineer (Snowflake)-Intermediate

JOB DESCRIPTION

Job Description

Design, develop and maintain data solutions for data generation, collection, and processing. Create data pipelines, ensure data quality, and implement ETL (extract, transform and load) processes to migrate and deploy data across systems.

Key Responsibilities:

• Lead and implement Snowflake solutions across data ingestion, storage, transformation, and access
• Lead end-to-end implementation of solutions using Snowflake’s latest features.
• Develop reusable frameworks, UDFs, and components using Snowpark or SQL scripting
• Develop performance-optimized pipelines using Snowflake-native capabilities and modern ELT tools
• Establish data governance, security models, RBAC, and masking policies in line with compliance standards
• Conduct performance tuning, workload monitoring, and optimization.
• Design and implement scalable and efficient data storage solutions using Snowflake.
• Write, optimize, and troubleshoot SQL queries within the Snowflake environment.
• Integrate Snowflake with various data sources and third-party tools.
• Ensure data security and compliance with industry standards.
• Collaborate with cross-functional teams to meet data-driven business objectives.
• Stay updated with the latest Snowflake features and best practices.

Required skills and experience:

• Proficient in SQL and familiar with ETL processes
• Experience with data modeling and cloud computing environments
• Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
• Understanding of data compliance and security best practices
• Familiarity with BI tools integration, such as Tableau or Looker
• Proven track record of data migration and optimization within Snowflake
• Ability to translate business needs into technical specifications
• Experience in performance tuning and cost optimization in a cloud data platform