Senior Snowflake Developer & Administrator at E-solutionsinc.com | Torre

Senior Snowflake Developer & Administrator

You will architect scalable data ecosystems by mastering advanced Snowflake and Talend integration.
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Freelance
Recurrent
Provide your expected compensation while applying
location_on
Remote (anywhere)
Match
skeleton-gauges
You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Review preferences
Shared by
Jose Aldave
1 day ago

Requirements and responsibilities


We are seeking a highly skilled Senior Snowflake Developer & Administrator with extensive hands-on experience in developing, administering, and optimizing enterprise-scale Snowflake data platforms. The ideal candidate should have deep expertise in advanced Snowflake capabilities, strong administration skills, and experience integrating Snowflake with ETL tools such as Talend. Exposure to Snowflake AI capabilities is a distinct advantage. The role requires excellent client-facing communication, analytical thinking, and problem-solving skills.Key ResponsibilitiesSnowflake DevelopmentDesign, develop, and maintain scalable ELT/ETL solutions on Snowflake.Develop complex SQL, Stored Procedures, UDFs, Streams, Tasks, Dynamic Tables, and Snowpark applications.Design dimensional models and optimize data pipelines for performance and scalability.Implement metadata-driven and reusable data ingestion frameworks.Perform query optimization and warehouse tuning to improve performance and reduce costs.Snowflake AdministrationAdminister Snowflake environments across Development, QA, UAT, and Production.Configure and manage Virtual Warehouses, RBAC, Security, Resource Monitors, Data Sharing, Replication, Time Travel, and Network Policies.Monitor platform health, usage, security, and optimize compute/storage costs.Support deployments, environment migrations, and production releases.Talend & Data IntegrationDevelop and maintain Talend ETL/ELT jobs integrating diverse source systems with Snowflake.Design reusable Talend frameworks and orchestrate end-to-end data pipelines.Experience integrating Talend with cloud storage (AWS S3/Azure Blob/GCS), APIs, and databases.Advanced Snowflake ExpertiseHands-on experience with:Snowpark (Python preferred)Dynamic TablesStreams & TasksSnowpipe / Snowpipe StreamingExternal TablesIceberg TablesSearch Optimization ServiceMaterialized ViewsZero Copy CloningQuery Profile Analysis & Performance TuningSecure Data SharingNative Apps (preferred)AI (Preferred)Exposure to one or more of:Snowflake Cortex AICortex AnalystCortex SearchSnowpark MLDocument AIAI/LLM integrations with SnowflakeRequired SkillsStrong hands-on experience in Snowflake Development and AdministrationAdvanced SQL programming and performance tuning.Strong experience with Talend ETL/ELT development and data integration.Good understanding of Data Warehousing, Data Vault, and Dimensional Modeling.If you're interested, you can contact at the email address mentioned below