Senior Snowflake Lead
- 12-15 Years
- Richardson – Texas – USA
Job description
Need Day 1 onsite
Experience and Architecture
· 15 years of experience in data engineering and data warehousing, with strong hands-on expertise in Snowflake architecture and implementation.
· Ability to design scalable Snowflake data architectures, including databases, schemas, compute warehouses, security, data sharing, and workload management.
· Experience designing enterprise data warehouse, data lake/lakehouse, and analytics architectures that support reporting and downstream consumption.
Data Modelling and Transformation
· Strong hands-on experience in dimensional and relational data modelling, including star and snowflake schemas, facts, dimensions, SCDs, and Data Vault concepts.
· Strong experience using dbt for transformations, reusable data models, testing, documentation, and deployment pipelines.
· Ability to design and implement ELT/ETL pipelines that integrate Snowflake with multiple enterprise source systems, APIs, files, and cloud data platforms.
Performance, Governance, and Security
· Hands-on expertise in Snowflake SQL query optimization, performance tuning, clustering, micro-partitioning, and cost optimization.
· Strong understanding of data governance, security, RBAC, data quality, lineage, and metadata management within the Snowflake ecosystem.
Technical Leadership and Delivery
· Ability to develop and review SQL, dbt models, data models, and technical designs while providing hands-on technical leadership to engineering teams.
· Strong stakeholder communication skills, with the ability to translate business requirements into scalable data architecture and modelling solutions and drive implementation from design through production.
Skills
Mandatory Skills : Snowflake
|
Neha Chaudhary
Survey Link: The survey is anonymous, and the information collected will be analysed in aggregate to support initiatives that improve the total experience across Compunnel.
|
—