The company is seeking a Snowflake Data Analyst to design, manage, and optimize their Snowflake environment to enable secure, accurate, and business-aligned data access across client and downstream systems.
Requirements
- Advanced SQL proficiency for Snowflake (DDL, DML, views, secure views, schemas).
- Strong experience with Snowflake security and RBAC.
- Demonstrated ability in data modeling and schema design (star/snowflake schemas).
- Hands-on experience with ETL tools (FiveTran preferred; Boomi a plus).
- Strong understanding of data governance, QA, and documentation practices.
Responsibilities
- Create and manage tables, views, secure views, and schemas within Snowflake.
- Implement role-based access control (RBAC) and least-privilege data access patterns.
- Design and maintain data models (e.g., star and snowflake schemas) to support reporting and analytics use cases.
- Build and manage ETL processes using FiveTran (preferred) or Boomi.
- Configure and maintain connectors for moving data between Snowflake and external systems
- Develop ETL logic for transformations, error handling, schema drift, and incremental data loads.
- Ensure data integrity and consistency across syncs and integrations.
Other
- Partner with the client's teams to translate business rules (deduplication, funnel stages, attribution, KPIs) into Snowflake views.
- Collaborate with Enterprise Architecture (EA) and downstream tool owners to ensure integration, governance, and security compliance.
- Document technical workflows, permissions, and integration details for cross-functional stakeholders.
- Support QA and governance processes to maintain high data quality standards.
- Excellent collaboration skills with both technical and business stakeholders.
