Snowflake Lead (Remote)

Role Summary:We are looking for an experienced Snowflake Lead to lead the design, development, migration, and optimization of enterprise data platforms using Snowflake. The candidate will provide technical leadership to data engineering teams and work closely with architects, business stakeholders, and application teams.Key ResponsibilitiesLead the architecture and development of scalable Snowflake data warehouse solutions.Design and develop scalable Azure Data Factory (ADF) pipelines for API-based and batch data ingestion, implementing parameterized workflows, scheduling, and error handling.Build and optimize enterprise Snowflake data warehouse solutions using Snowflake SQL, Streams, Tasks, Stored Procedures, VARIANT data type, and LATERAL FLATTEN for semi-structured JSON processing.Integrate GraphQL and REST APIs using OAuth 2.0, implementing secure API authentication, JSON parsing, and API validation using Postman.Develop cloud-based data ingestion solutions using Azure Data Lake Storage Gen2 (ADLS) as the landing layer and Azure Key Vault for secure credential management.Design metadata-driven ELT frameworks with incremental loading, audit logging, watermark processing, and automated data orchestration.Optimize Snowflake performance through warehouse sizing, query tuning, clustering strategies, Time Travel, Cloning, and warehouse management best practices.Collaborate with DevOps teams using Azure DevOps for source control, CI/CD deployment, release management, and Agile delivery.Design dimensional data models, build curated data marts, and support enterprise reporting and analytics requirements.Develop and maintain Power BI semantic models, datasets, dashboards, and reports; knowledge of DAX, Power Query, and data visualization best practices is preferred.Work closely with business stakeholders, solution architects, and cross-functional teams to deliver secure, scalable, and high-performance cloud data platform solutions.Thanks,Mounika P