- Company Name
- VDart
- Job Title
- Snowflake Sr. Developer with Alation
- Job Description
-
**Job Title**
Senior Snowflake Developer with Alation
**Role Summary**
Lead and own Snowflake development, administration, and Alation Data Catalog operations. Design and implement scalable, secure data pipelines, optimize performance and cost, mentor cross‑regional teams, and serve as a client‑facing technical advisor.
**Expectations**
- 5+ years of Snowflake development and administration.
- Strong leadership in multi‑region teams with Agile, CI/CD, and SDLC expertise.
- Proven client engagement and support experience.
- Snowflake‑centric certifications (SnowPro Advanced/Developer) preferred.
- Hands‑on with Alation cataloging, data product discovery, contract management, and access governance.
- Advanced SQL, performance tuning, and Snowflake features (Streams, Tasks, Time‑Travel, Cloning, Sharing).
- Familiarity with cloud storage (AWS S3, Azure Blob, GCP) and data ingestion from APIs, flat files, and streams.
**Key Responsibilities**
1. Lead Snowflake operations, coordinating on‑shore/off‑shore teams.
2. Manage Snowflake accounts, roles, permissions, and security policies (masking, encryption, compliance).
3. Implement and maintain Alation Data Catalog for metadata governance and data product lifecycle.
4. Design and build scalable pipelines using Streams, Tasks, and Stored Procedures.
5. Optimize SQL queries, data models, and compute/resource usage.
6. Drive technical delivery: architecture, coding standards, DevOps, and CI/CD pipelines.
7. Provide L2/L3 support, ensuring high availability and rapid incident resolution.
8. Mentor engineers, enforce best practices, and support unit/integration testing.
9. Collaborate with cross‑functional teams and clients to gather requirements and translate them into secure, scalable solutions.
10. Maintain detailed documentation of processes, configurations, and best practices.
**Required Skills**
- Snowflake architecture, virtual warehouses, resource monitors.
- Advanced SQL and performance tuning.
- Snowflake features: Time Travel, Cloning, Streams, Tasks, Stored Procedures, Data Sharing.
- Alation Data Catalog (Discovery, Catalog/Contract, Access Process).
- ETL/ELT tools: dbt, Informatica, Talend, Matillion.
- Cloud platforms: AWS (S3), Azure Blob, GCP Storage.
- Role‑based access control, data masking, encryption.
- CI/CD pipelines, scripting (Python, Shell) for automation.
- Finance Data Layer, Data Mart design, data warehousing principles.
- Strong communication, client‑facing, and team‑lead abilities.
**Required Education & Certifications**
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- Snowflake certifications (SnowPro Advanced / Developer) preferred.
- Certifications in data governance or cloud platforms (AWS/Azure/GCP) are a plus.