Remote Jobs RockRemote Jobs Rock

Senior Data Engineer - R01572077

🕒 21 days ago
📍 🇮🇳 Pune - Hybrid🎸 Senior🛢️ Data Engineer💼 Full-Time
SnowflakeAdvanced SQLPythonETL
Apply Now

📜 Description

  • Develop complex Snowflake SQL queries, joins, CTEs, views, stored procedures, and data transformations.
  • Use Snowflake Cortex AI functions to build AI-powered data processing and analytics solutions.
  • Ingest, transform, and manage structured and unstructured data in Snowflake.
  • Validate data, perform quality checks, and troubleshoot data integrity issues.
  • Optimize SQL queries and Snowflake workloads for performance and cost.
  • Support generative AI use cases and collaborate with engineers, analysts, and business teams on tailored solutions.

🛠️ Requirements

  • 2 to 4 years of hands-on experience in Snowflake engineering and advanced SQL development.
  • Advanced SQL skills, including joins, CTEs, views, and stored procedures.
  • Understanding of Snowflake architecture, data warehousing, and data transformation.
  • Experience with Snowflake Cortex AI functions and structured and unstructured data.
  • Preferred: generative AI use cases, Snowflake workload optimization, and cloud data security and governance.
  • Desired: bachelor's degree in a related discipline and Snowflake or SQL certification.
Full job description
Senior Data Engineer

Primary Skills

  • DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures

    • Specialization

  • Snowflake Engineering: Data Engineer

    • Job requirements

  • Experience Range: 2 to 4 years of hands-on experience in Snowflake engineering and advanced SQL development Key Responsibilities: 1. Develop complex SQL queries, joins, common table expressions (CTEs), views, stored procedures, and data transformations within Snowflake 2. Leverage Snowflake Cortex AI Functions such as AI_COMPLETE, AI_CLASSIFY, AI_EXTRACT, AI_SENTIMENT, AI_EMBED, and AI_SUMMARIZE_AGG to build AI-powered data processing and analytics solutions 3. Work with structured and unstructured data in Snowflake, ensuring efficient data ingestion, transformation, and management 4. Perform rigorous data validation, quality checks, and troubleshooting to maintain data integrity and reliability 5. Optimize SQL queries and Snowflake workloads for enhanced performance and reduced cost 6. Support development and deployment of Generative AI use cases, including summarization, classification, information extraction, and semantic search 7. Collaborate with data engineers, analysts, and business teams to gather requirements and deliver tailored Snowflake solutions Required Skills: 1. Advanced SQL skills, including joins, CTEs, views, and stored procedures 2. Strong understanding of Snowflake architecture and data warehousing concepts 3. Experience with Snowflake Cortex AI Functions 4. Knowledge of data transformation techniques within Snowflake 5. Ability to work with structured and unstructured data in Snowflake Preferred Skills: 1. Experience implementing generative AI use cases such as semantic search or information extraction in Snowflake 2. Familiarity with optimizing Snowflake workloads for analytics 3. Knowledge of data security and governance in cloud data platforms 4. Certification in Snowflake or cloud data engineering Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline 2. Snowflake SnowPro Core Certification 3. Relevant certification in SQL (e.g., Microsoft Certified: SQL Database Specialist)
    • Apply Now

    Similar jobs

    Search more Data Engineer jobs
    View more Data Engineer jobs

    Trusted by Remote Workers