Snowflake Data Integration Support

@Shrutibimpl

Hello, I will design and optimize your Snowflake data pipelines and tune your slow running queries. I will construct clean repeatable ELT pipelines in your development account establishing secure external stages & streams.... I will analyze your execution plans adjust clustering keys implement materialized views or search optimization services where appropriate and make sure partition pruning functions efficiently on large datasets. All code will pushed to your Git repository along with a optimization document. I have extensive experience building scalable Snowflake architectures, implementing automated Snowpipe integrations, and tuning complex analytical SQL queries. 1) From which source systems, such as AWS S3, Azure Blob, or Google Cloud Storage, are the new data feeds originating? 2) Are you currently experiencing query bottlenecks due to queuing times, warehouse sizes, or inefficient join and filtering structures? 3) What is the average data volume and ingestion frequency, such as real-time or batch, that you anticipate for the new pipelines? Thanks, Bharat

@vinod150987

Hi, I’ve worked on Snowflake environments where the focus was building reliable ELT pipelines, integrating new data sources, and optimizing performance as data volumes scaled. For query optimization, I analyze execution plans and query profiles to identify bottlenecks, then improve performance through data modeling, clustering strategies where appropriate, pruning optimization, caching considerations, and SQL rewrites. The goal isn't just making queries faster today—it's ensuring they continue performing well as your datasets grow. I'm comfortable working directly in your Snowflake development environment with role-based access and following Git-based development workflows, including clean commits and collaboration through branches and pull requests. I'm available to start immediately and can join a quick onboarding call to understand your current setup and priorities. I'd be happy to discuss your existing architecture and propose the most effective implementation plan. Looking forward to working together!

@sanarena

Hi, I’m Armin Nikdel. I can help wire the new sources into Snowflake for INR 18000 over 10 days, starting with a bounded first milestone around the initial source set and slow-query samples. My approach would be to map each source into the right landing and transform layers, create stages, streams, tasks, and Snowpipe-based loads where they fit, then commit the ELT SQL/scripts with clear comments through your Git flow. For query tuning, I’d profile the heaviest statements with query history and plans, adjust clustering, filtering, and join patterns where needed, and leave tuned examples that show the performance difference on large scans. I’ll keep access role-based, use controlled dev changes, least-data logging, clear run/error handling, and a concise write-up of the implemented Snowflake patterns. Which source systems and 2-3 slow queries should be included in the first pass?

@dipikaaher31

Hi, I have experience with Snowflake, DBT, SQL, AWS S3, ETL pipelines, and query optimization. I can deliver scalable, production-ready solutions with clear documentation. Let’s discuss your requirements.

@ammarahmed20

With my extensive experience automating complex processes and working with data across various industries, I believe I'm uniquely qualified for your Snowflake data integration project. Over the past 6+ years, my focus has been on building AI-driven systems to address infrastructure problems - exactly what your project entails. My skills in automation, data modeling, and SQL are the bedrock upon which I've developed the ability to design and build clean, repeatable ELT pipelines - precisely what you need. Moreover, I've engineered AI agents that have memory and decision-making capabilities, skills that prove valuable when dealing with large datasets. I understand that you're particularly interested in boosting execution speed and ensuring it remains efficient even when scanning massive volumes of data- areas I thrive in. Finally, my proficiency in Git repositories would certainly simplify our collaborative process; pushing code for review and modifications wouldn't be an issue. I'd love to dive into your dev account role-based access, analyze the existing schemas, identify bottlenecks and work closely with you to implement the best-practice solutions to achieve your desired outcome. Let's take this forward!

@uvucon

You need an experienced Snowflake engineer to wire new data sources into your environment with clean, repeatable ELT pipelines and keep query performance tight as volumes scale. I recently built a similar ELT pipeline for a data platform client, designing automated Snowpipe loads and tuning complex analytical queries that were scanning hundreds of millions of rows — cutting average execution time by over 60%. A couple of clarifying questions: Are the new data sources primarily cloud-based (S3, GCS, Azure Blob) or on-premises databases? And do you have a preferred transformation layer (dbt, stored procedures, or custom SQL scripts)? Here is my approach: 1. Review your current schema design, existing pipelines, and the identified bottlenecks to understand the full data flow 2. Design and implement ELT pipelines with proper stages, streams, and tasks for each new data source, with clear comments throughout 3. Set up Snowpipe automation for continuous, hands-off data loading into your target layers 4. Identify and tune the most demanding queries — optimizing join strategies, aggregation patterns, and scan efficiency on large datasets 5. Produce a concise best-practice write-up covering what we implemented, architecture decisions, and ongoing maintenance guidance Sub-milestones: 30% on pipeline design and initial implementation (stages, streams, tasks), 40% on query tuning and Snowpipe automation, 30% on documentation and best-practice write-up. Happy to start with a quick onboarding call and one data source to confirm fit before rolling out to the rest.

@Melad2020

Two things sink Snowflake work like this, and most bidders won't mention either: people tune queries like there are indexes to add, when speed on big scans comes from partition pruning — clustering on the columns you actually filter by — and they define a Snowpipe but forget it does nothing until cloud event notifications are wired to the stage. I build to prevent both. I'd land data through staged ELT into your bronze/silver/gold layers, drive incremental loads with streams and tasks, and set up auto-ingest properly with the event notifications hooked to the stage, not just a bare pipe. For the heavy queries I'd read the query profile, find what's scanning instead of pruning, and cluster deliberately so reclustering credits stay justified. - Which filter columns dominate the slow queries, and is the data naturally ordered on them? - Cloud provider for the stage — AWS, Azure, or GCP? Snowflake integration and tuning is my core work. Ready to start milestone-by-milestone. Melad

@hlomlan

I understand the challenge you're facing with expanding your Snowflake environment and optimizing data integration for performance as volumes increase. To address this, I will design and implement efficient ELT pipelines, set up stages, streams, tasks, and utilize Snowpipe for automated loads. I will focus on enhancing query execution speed for large datasets to ensure optimal performance. I offer hands-on experience working directly in dev accounts with role-based access, pushing code to Git repositories. My deliverables will include production-ready ELT jobs, optimized sample queries, and a detailed best-practice document outlining the implemented solutions. I provide a free consultation to discuss your specific requirements, current bottlenecks, and preferred approach to Snowflake integration and query tuning. When would be a good time for us to connect and strategize on how to kick off this project effectively?

@warrick1718

This is exactly the kind of project I enjoy working on. I understand the need for clean, professional, and seamless Snowflake data integration. While I am new to Freelancer, I have tons of experience and have done other projects off-site. I specialize in designing ELT pipelines, setting up stages, streams, and tasks, and automating loads with tools like Snowpipe. With a focus on boosting query performance and scalability, I can deliver working ELT jobs, tuned queries, and best practice documentation. If it sounds like a good fit, I'd be happy to discuss the details. Regards, Warrick Van Eeden

@sihalaths9

Hello, I’m glad to have found your project, it aligns perfectly with my skills and professional interests. I understand you need a Snowflake engineer to build and optimize ELT pipelines, integrate new data sources, and improve query performance as data volume grows, while ensuring the architecture remains clean, scalable, and well documented. I have strong experience working with Snowflake environments, including building ELT pipelines using stages, streams, tasks, and Snowpipe, as well as optimizing large-scale SQL queries for performance and cost efficiency. I focus on designing maintainable data models that perform well even as datasets scale significantly. My approach is to first review your current schema and ingestion flows, then design or refine ELT pipelines for reliable automation and clean layering of data. I will also analyze and optimize your most expensive queries, focusing on partitioning strategies, clustering, and execution plan improvements to ensure long-term performance stability. Everything will be documented clearly so your team can maintain and extend it easily. I’d like to go over a few points: What are your current main data sources (APIs, databases, or files)? Are there specific dashboards or queries that are currently causing performance issues? I’m confident I can make this project a success. Thank you for considering my proposal, and I hope we can collaborate soon.

@Sajid293r

Hi there, I hope you are doing well. I have read your project description and would be happy to help expand your Snowflake environment by building scalable ELT pipelines, integrating new data sources, configuring Snowpipe, streams, tasks, and optimizing complex queries for high-performance analytics. I have experience with Snowflake, SQL optimization, Git-based workflows, and production-ready data engineering solutions. Which data sources are you planning to integrate into Snowflake (e.g., APIs, S3, Azure Blob, databases, or SaaS platforms)? Let's have a quick chat to discuss more in detail. I am looking forward to hearing from you. Best, Sajid.

@collenliebenberg

Impressive focus on scaling your Snowflake environment! I see the need for precise ELT pipelines and optimized queries to handle large datasets. How about we swiftly tackle this by setting up efficient pipelines with Snowpipe for automated data loading? I can fine-tune your queries for optimal performance and provide clear documentation for future reference. When can we jump on a call to discuss your schemas and bottlenecks? Looking forward to getting started! Collen

@Hrolgar

Snowflake ELT like this needs the load pattern nailed down early, otherwise streams/tasks/Snowpipe bits become hard to reason about once more sources are added. I'd start by checking the current dev account, repo layout, source formats, roles, warehouses, and how you want failures/retries handled. Then I'd add the new sources with repeatable stage/load patterns, wire the automation with streams/tasks or Snowpipe-style flow where it fits, and tune the heavier queries with actual before/after notes rather than vague advice. One milestone: 37,500 INR over 5 days, covering the implemented ELT flow, committed code in your Git repo, query tuning pass, and concise handover docs for what was built and how to run/support it. This is an indicative estimate from the brief; I'll give you a firm quote once the source count and current Snowflake setup are clear.