DE&A - Core - Cloud Data Engineering - Snowflake Developer
Posted Updated
Summary
Designs, builds, and maintains enterprise data warehouse solutions on Snowflake — developing data pipelines, ELT/ETL workflows, optimized SQL, dimensional data models, and RBAC-based security. Core tech: Snowflake, SQL, Python/Shell/Java, AWS/Azure/GCP, and tools like Informatica, Matillion, ADF, Airflow, and dbt.
We are seeking a skilled Snowflake Developer to design, develop, optimize, and maintain enterprise data warehouse solutions on the Snowflake platform. The ideal candidate should have strong expertise in data warehousing, ETL/ELT development, SQL optimization, cloud technologies, and data integration.
- 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
Skills
- Agile
- Airflow
- API
- AWS
- Azure
- Azure Data Factory
- Bash
- CI/CD
- Cloud
- Data Engineering
- Data Governance
- Data Lake
- Data Modeling
- Data Pipelines
- Data Quality
- Data Warehousing
- dbt
- DevOps
- Dimensional Modeling
- ELT
- ETL
- GCP
- Git
- Java
- Looker
- Master Data Management
- MDM
- Power BI
- Python
- RBAC
- Snowflake
- SQL
- Stakeholder Management
- Tableau
- Talend