Saama Technologies Inc
ETL SQL Data Engineer (Snowflake)-Intermediate
Skills
Job description
JOB SUMMARY
- Designing and developing E…
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