What are the responsibilities and job description for the Only w2 Candidate -- Snowflake Data engineer (Onsite in NYC,NY) position at EdgeAll?
- A Snowflake Data engineer who designs, builds, and optimizes cloud-based data warehouses and ELT data pipelines
- They are responsible for writing advanced SQL, creating views, Normalizations, managing data ingestion, and ensuring data security and platform performance.
Key Responsibilities
- Data Pipelines: Build, maintain, and optimize robust ELT pipelines to process large volumes of structured and semi-structured data.
- Snowflake Architecture: Configure and manage virtual warehouses, stages, Snowpipe, streams, and tasks.
- SQL Development: Write clean, highly optimized SQL queries, stored procedures, and User-Defined Functions (UDFs).
- Performance Tuning: Monitor query performance and apply tuning techniques like clustering keys, materialized views, and result caching.
- Security & Governance: Implement Role-Based Access Control (RBAC), row/column-level security, and data masking.
- Integration & Transformation: Work with transformation tools like dbt, or use Snowpark with Python/Java for advanced analytics.
Essential Qualifications
- Experience: 4 to 5 years of hands-on experience building cloud-native data platforms, with at least 3 years specifically in Snowflake.
- Technical Skills: Advanced SQL, Data Modeling (Star/Snowflake schema), and scripting (Python, Bash).
- Tools: Proficiency with cloud environments (AWS, Azure, or Google Cloud Platform) and ELT/ETL integration tools.
- Soft Skills: Strong analytical problem-solving, capability to translate business requirements into technical data structures, and Agile/Scrum team collaboration.