Job Summary:
We are seeking a highly skilled Senior Snowflake Developer with over 10 years of experience in data engineering and cloud data warehousing. The ideal candidate will have deep expertise in Snowflake development and architecture, along with a solid understanding of modern data pipelines, data modeling, and performance optimization. This role will be instrumental in building scalable data solutions that support enterprise analytics and business intelligence initiatives.
Key Responsibilities:
- Design, develop, and optimize Snowflake data warehouse solutions to support business reporting and analytics needs.
- Build robust and reusable ELT/ETL pipelines to ingest data from various sources (cloud/on-prem) into Snowflake.
- Create and manage schemas, tables, views, stages, and file formats in Snowflake.
- Implement Snowflake best practices around security, performance tuning, resource monitoring, and cost management.
- Collaborate with data analysts, data scientists, and business stakeholders to gather and translate requirements into data models and pipelines.
- Leverage tools such as dbt, Apache Airflow, or Informatica/Talend for orchestration and transformation.
- Optimize SQL queries and Snowflake configurations for large-scale datasets.
- Implement role-based access control (RBAC) and follow data governance standards.
- Work with CI/CD pipelines and version control tools (e.g., Git) to manage deployment workflows.
- Mentor junior developers and help define coding standards and development guidelines.
Required Skills & Qualifications:
- 10+ years of experience in data engineering, with 3–5+ years of recent hands-on Snowflake development.
- Strong SQL expertise and experience with Snowflake-specific features like Virtual Warehouses, Streams, Tasks, Time Travel, and Cloning.
- Experience working with cloud platforms: AWS, Azure, or Google Cloud Platform (GCP).
- Strong knowledge of data modeling techniques – star schema, snowflake schema, and normalized/denormalized models.
- Experience with data ingestion tools and frameworks (e.g., Talend, Informatica, Matillion, Fivetran).
- Proficient in scripting languages like Python or Shell for automation and orchestration.
- Familiarity with data governance, data quality, and compliance standards (GDPR, HIPAA, etc.).
- Hands-on experience with CI/CD, Git, Jira, and agile development practices.
- Excellent problem-solving, debugging, and communication skills.