DE&A - Core - Cloud Data Engineering - Snowflake Developer

• Design, develop, and maintain data pipelines using Snowflake.
• Build and optimize Snowflake databases, schemas, tables, views, and stored procedures.
• Develop ELT/ETL workflows using tools such as Informatica, Matillion, Talend, ADF, Airflow, or dbt.
• Implement data modeling techniques including Star Schema and Snowflake Schema.
• Develop and optimize complex SQL queries for data transformation and reporting.
• Integrate data from various sources including relational databases, APIs, cloud storage, and third-party applications.
• Monitor and troubleshoot Snowflake performance issues.
• Implement data security, governance, and access controls using Snowflake RBAC.
• Collaborate with Data Engineers, Business Analysts, Architects, and Stakeholders to understand business requirements.
• Ensure data quality, integrity, and compliance with organizational standards.
• Support CI/CD implementation and DevOps practices for data engineering projects.

• Strong experience with Snowflake Data Cloud.
• Advanced SQL programming and query optimization.
• Experience with ETL/ELT development.
• Knowledge of Data Warehousing concepts and dimensional modeling.
• Experience with cloud platforms:
  • AWS
  • Azure
  • Google Cloud Platform (GCP)
• Hands-on experience with:
  • Snowpipe
  • Streams & Tasks
  • Dynamic Tables
  • Materialized Views
  • Cloning & Time Travel
  • Stored Procedures
  • User Defined Functions (UDFs)
• Experience with Python, Shell Scripting, or Java.
• Familiarity with dbt, Airflow, Azure Data Factory, Informatica, or Matillion.

Preferred Skills

• Performance tuning and cost optimization in Snowflake.
• Data Lake integration.
• BI tools knowledge (Power BI, Tableau, Looker).
• Git, CI/CD, and Agile methodologies.

Qualifications

• Bachelor's or master's degree in computer science, Information Technology, Engineering, or related field.
• 3+ years of experience in Data Engineering/Data Warehousing.
• 2+ years of hands-on Snowflake development experience.
• Snowflake Certification is a plus:
  • SnowPro Core Certification
  • SnowPro Advanced Certifications

Experience Level

• 6+ years of IT experience
• 4+ years of Snowflake and Data Engineering experience

Nice to Have

• Experience with migration from on-premise data warehouses to Snowflake.
• Exposure to Data Mesh/Data Fabric architecture.
• Knowledge of Data Governance and Master Data Management (MDM).
• Experience working in Banking, Retail, Healthcare, Manufacturing, or Telecom domains.

Key Competencies

• Analytical and problem-solving skills
• Communication and stakeholder management
• Performance optimization mindset
• Attention to detail
• Team collaboration and ownership