
Closed
Posted
I’m standing up a brand-new business-intelligence stack in Snowflake and need a reusable migration framework built with dbt and solid SQL. The framework has to pull from two kinds of sources—existing relational databases and the steady stream of CSV/Excel flat files our teams export—then land, cleanse, validate, and automate each load all the way into analytics-ready tables. Here’s what I’m after: • A dbt project structured for easy extension, complete with models, seeds, macros, and tests that enforce data-quality rules at every stage. • Parameterised SQL and Snowflake tasks/procedures that orchestrate fully automated loads, from raw landing zones through staging to final marts. • Built-in monitoring and reporting—leveraging dbt tests, Snowflake query history, or a lightweight dashboard—so I can track load status, row counts, and any data-quality exceptions in near real time. If you’ve already solved similar migration challenges in Snowflake with dbt, let’s talk and get this framework in place. This is more of remote connect project
Project ID: 40205649
101 proposals
Remote project
Active 2 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
101 freelancers are bidding on average $23 USD/hour for this job

As a top-rated authority with over 18 years of experience in web and app development, our team at CnELIndia is equipped to provide you with an unparalleled level of expertise for your Snowflake + dbt migration framework. Our skills in Database Programming and SQL, combined with our ability to leverage tools like MySQL and PHP, make us the perfect fit for this project. Our speciality in React Native demonstrates our adaptability to new technologies and an intention to stay ahead of the curve. This will greatly benefit your project as we have already solved challenges similar to yours in Snowflake using dbt. What sets us apart is not just our capability, but our passion for crafting innovative solutions. We understand the importance of a streamlined data process, from landing zones through staging to final marts, and promise to build a reusable migration framework that caters perfectly to your needs. Let's leave no stone unturned: we'll incorporate monitoring and reporting functionalities into your framework so you can track load status, row counts in near real time, ensuring you are always aware of any exceptions. Choose CnELIndia for unmatched expertise, unwavering dedication to meeting project goals within the given timeframe and budget constraints, and proven customer satisfaction. Let's connect remotely and get ready to bring life to your brand-new business-intelligence stack!
$20 USD in 40 days
9.0
9.0

Hi there, I’ve read your Snowflake + dbt migration needs and I’m confident I can deliver a scalable, reusable framework that supports ingestion from both relational sources and CSV/Excel exports, with cleansing, validation, and automated loading into analytics-ready marts. I will create a dbt project structure with models, seeds, macros, and tests to enforce data quality at each stage, plus parameterized SQL and Snowflake tasks/procedures to orchestrate the flow from raw landing zones to staging and final marts. Built-in monitoring will surface load status, row counts, and data-quality exceptions via dbt tests and Snowflake history, with a lightweight dashboard for near real-time visibility. If you’ve solved similar migration challenges, I can tailor patterns to your environment and accelerate delivery. I can start with a skeleton within a week and ship an MVP in 7–10 days, then iterate based on feedback. What is the current Snowflake environment size and schema for landing, staging, and marts? 2. Which data sources (source DBs, CSV/Excel locations) will feed the framework, and how are credentials managed? 3. Do you have CI/CD or orchestration preferences (Airflow, Dagster, dbt Cloud) for Snowflake tasks? 4. What data quality rules are critical at each layer (null checks, row counts, referential integrity, duplicates)? 5. How should parameterization be handled for dev/stage/prod environments and data source connections? 6. What monitoring/visualization requirements and
$25 USD in 32 days
8.6
8.6

Dear , We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time. We are 25 years in this business and our technical specialists have strong experience in PHP, SQL, MySQL, Database Programming, Data Warehousing, Data Cleansing, ETL, Snowflake and other technologies relevant to your project. Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews. Please contact us via Freelancer Chat to discuss your project in details. Best regards, Sales department Tangram Canada Inc.
$25 USD in 5 days
8.8
8.8

I can design and implement a reusable, production-grade dbt framework on Snowflake that cleanly handles both relational sources and recurring CSV/Excel file ingests end to end. I’ll structure the dbt project with modular models, macros, seeds, and robust tests, and wire it to Snowflake tasks/procedures for fully automated, parameterized loads from raw → staging → marts. The solution will include built-in data-quality enforcement, load monitoring, and clear visibility into row counts, failures, and exceptions so you can operate it confidently as the stack grows. This is well-suited for a remote, collaborative engagement and aligns closely with BI migrations I’ve delivered in Snowflake + dbt environments.
$20 USD in 40 days
8.1
8.1

As a seasoned full-stack developer, I have the unique ability to deliver comprehensive solutions that align with your needs, which is exactly what your Snowflake + dbt migration framework requires. My strong command of SQL combined with my ample experience in PHP and MySQL enables me to meticulously design custom solutions to handle complex data pipelines efficiently. I've successfully harnessed these skills in past projects, with notable relevance to your requirements. For instance, I developed a sophisticated CRM system using similar technologies, from organizing data from varied sources to automating real-time analytics-ready tables. Additionally, my knowledge of CI and CakePHP would be leveraged for creating robust pipelines that seamlessly incorporate diverse flat files - an important consideration for your business model. Moreover, you can rely on my meticulous approach to incorporate built-in monitoring and reporting features into the framework as you seek. I can leverage not only dbt tests but also the Snowflake query history effectively. Plus, having worked remotely in various domains, I am well-accustomed to the dynamics of such projects and can ensure a fruitful collaboration no matter the distance between us. With Regards!
$15 USD in 40 days
7.9
7.9

Hi, Here is the Senior Full Stack developer with 10+ years of experience in SQL management. I got your requirements and I am sure I am the best candidte for this project. I have deep knowledge in Snowflake and SQL management. And I am familiar with CSV/Excel management logic and familiar with web frameworks like Laravel, Node, React, Vue, Angular. I'd like to discuss more details with you. Looking forward to your response. Thanks
$25 USD in 40 days
6.9
6.9

Hi there, I'm excited about the opportunity to collaborate on your brand-new business-intelligence stack in Snowflake. With extensive experience in building reusable migration frameworks using dbt and SQL, I am confident in my ability to deliver a solution tailored to your needs. My background in data warehousing and ETL processes means I can ensure a seamless transition from existing relational databases as well as from CSV/Excel sources. I specialize in creating dbt projects that are easily extensible, complete with models, seeds, macros, and tests to maintain robust data quality at every phase. My approach will involve parameterized SQL, automated loading using Snowflake tasks, and comprehensive monitoring features. I can implement a lightweight dashboard to provide near real-time insights into load statuses and data-quality exceptions. Let’s connect to discuss how we can kick off this project efficiently! What specific data sources do you anticipate we'll be migrating from, and what volume of data should we expect?
$30 USD in 36 days
6.4
6.4

I'm experienced in creating migration frameworks in Snowflake using dbt and SQL. I can develop a robust dbt project with models, seeds, macros, and data-quality tests. My expertise lies in designing parameterized SQL scripts and Snowflake tasks for automated data loading and transformation. Additionally, I can implement monitoring solutions for tracking load status and data quality exceptions in real-time. Let's discuss further to establish this framework efficiently.
$25 USD in 40 days
6.6
6.6

Hello I am writing to express my interest in building your Snowflake and dbt migration framework. With over nine years of software development experience and hands-on expertise in SQL, ETL pipeline architecture, and data quality automation, I have solved similar migration challenges and can deliver a reusable framework that handles both your relational database sources and flat file streams cleanly. My approach would be to structure the dbt project with clear separation between landing, staging, and mart layers, using parameterised models and macros that make adding new sources straightforward without duplicating logic. For orchestration, I would build Snowflake tasks and stored procedures that automate the full load cycle from raw ingestion through transformation, with parameterised SQL that handles both your relational extracts and CSV and Excel flat files through Snowflake stages and file formats. The monitoring layer would combine dbt test results, Snowflake query history, and a lightweight dashboard to give you near real-time visibility into load status, row counts, failures, and data quality exceptions. I am comfortable working remotely and available to connect and discuss the project scope in detail. Looking forward to your reply. Regards
$25 USD in 40 days
6.5
6.5

Hello , I checked your project, and it looks interesting. This is something we already work on, so the requirements are clear from the start. We mainly work on PHP, SQL, MySQL, Database Programming, Data Warehousing, Data Cleansing, ETL, Snowflake We focus on making things simple, reliable, and actually useful in real life not overcomplicated stuff. Let’s connect in chat and see if we’re a good fit for this. Best Regards, Ali nawaz
$20 USD in 40 days
6.3
6.3

Hello, I have carefully reviewed your project requirements for the Snowflake + dbt Migration Framework. I understand the need for a robust framework that can efficiently handle data migration from various sources into analytics-ready tables. To achieve this, I plan to create a structured dbt project with models, seeds, macros, and tests to ensure data quality at every stage. Additionally, I will develop parameterized SQL scripts and Snowflake tasks/procedures for automated loads from raw landing zones to final marts. The framework will include built-in monitoring and reporting features for real-time tracking of load status, row counts, and data-quality exceptions. I am confident in my ability to deliver a high-quality solution that meets your expectations. Let's discuss further details and get started on this project. Thank you.
$25 USD in 40 days
6.3
6.3

Hi I have strong experience building Snowflake + dbt frameworks for multi-source migrations, particularly when combining relational systems with recurring CSV/Excel feeds. The main technical challenge is ensuring consistent data quality while automating heterogeneous loads, and I solve this with parameterised SQL models, reusable macros, and dbt tests that validate each layer from raw to marts. I will design a modular dbt project structure with seeds, incremental logic, and standardized staging patterns for easy long-term extension. Automated Snowflake tasks and procedures will orchestrate end-to-end pipelines, including file ingestion, cleansing, schema validation, and load monitoring. I also set up lightweight observability—dbt test dashboards, load-status tracking, and row-count auditing—to surface issues in near real time. My approach ensures reliability, transparency, and a scalable BI foundation you can reuse across future sources. Thanks, Hercules
$50 USD in 40 days
6.3
6.3

Having developed tailored Python web automation, AI, and Web3 projects over the past 13 years, I bring a wealth of experience to deliver a robust and customized solution catering specifically to your Snowflake + dbt migration framework requirement. With my expertise in Python and C-based projects, I can develop the necessary SQL and Snowflake tasks/procedures that will orchestrate fully automated loads, from the raw landing zones through staging to final marts, and handle the extraction and transformation of both existing relational databases and CSV/Excel flat files. Through my Python-Based Web Scraping & Automation skill set, I have dealt with similar scenarios of data cleansing, validation, load automation and have set up real-time monitoring systems for load status in previous projects. By leveraging cloud-based services like AWS or Google Cloud, I can also include lightweight reporting dashboards for tracking purposes in near real time. My proficiency in working with various databases (MySQL, PostgreSQL, MongoDB) ensures I will make the most of Snowflake’s potential in this project. In addition to strong technical capabilities, my commitment to delivering high-quality results and passion for finding cutting-edge solutions aligns well with your objective. I'm adaptable to remote working arrangements and maintain effective communication throughout projects. Let's connect soon to discuss in detail how we can make your business intelligence stack stand out!
$20 USD in 40 days
6.0
6.0

Hello, I have extensive experience in developing custom migration frameworks using Snowflake and dbt, making me the perfect fit for your project. One recent example of my work involved creating a similar framework for a client migrating to Snowflake, ensuring seamless data integration and automation. I understand the importance of structuring a dbt project for scalability and efficiency, incorporating models, seeds, macros, and tests to maintain data quality throughout the process. Additionally, I specialize in designing parameterized SQL scripts and Snowflake tasks to orchestrate automated data loads from various sources into analytics-ready tables. I am keen to discuss how I can tailor this framework to meet your specific needs and provide real-time monitoring and reporting capabilities for enhanced visibility into the data migration process. When would be a good time for us to connect and further explore your requirements? Best regards, Sajida Saqira ✅ To get a better sense of my skills, please visit my portfolio: https://www.freelancer.com/u/SajidaSaqira/SS-Technologies
$18 USD in 40 days
5.4
5.4

✋ Hi there. I can build your Snowflake and dbt migration framework to automate data ingestion, cleansing, validation, and transformation into analytics-ready tables. ✔️ I have solid experience designing Snowflake data pipelines with dbt, parameterised SQL, and automated workflows. In a previous project, I built a reusable migration setup that handled relational sources and CSV flat files, with staged models, dbt tests, and monitoring dashboards to track load status and data-quality checks. ✔️ For your project, I will structure a scalable dbt project with models, seeds, macros, and automated tests. I will create Snowflake tasks and procedures to orchestrate data loads from landing zones to marts, ensuring validation rules and data integrity at each stage. I will also add monitoring using dbt logs and Snowflake query data to provide near real-time insights. ✔️ I will deliver clean SQL scripts, documented workflows, and a reusable framework that your team can extend easily for future data sources and reporting needs. Let’s chat to review your current sources and plan the migration setup. Best regards, Mykhaylo
$20 USD in 40 days
5.4
5.4

Hi, I understand you're building a brand-new business intelligence stack in Snowflake and need a robust dbt migration framework. This is an exciting challenge! I have successfully implemented similar migration frameworks that seamlessly integrate various data sources into analytical platforms, ensuring data integrity and accessibility. ✅My Plan - Develop a structured dbt project with models, seeds, macros, and comprehensive tests for data quality. - Design parameterized SQL and Snowflake procedures to automate data loads from raw to final marts. - Implement monitoring solutions using dbt tests and a lightweight dashboard to track load status and data quality in real-time. I'm looking forward to the opportunity to collaborate on this project! Best regards, Hongqiang Chen
$100 USD in 1 day
5.1
5.1

Hello , I’ve seen your job description for Snowflake + dbt Migration Framework, and I’m confident I can bring your vision to life with creative, high-impact design solutions tailored to your goals. I’d be happy to share samples of my recent work in a private chat. I’m Kiran Shaikh, a Senior Graphic Designer & Digital Content Creator with over 8 years of experience. I specialize in turning ideas into unique, eye-catching visuals that stand out and deliver results. Why choose me? ✅ Original, custom-designed concepts ✅ High-quality, polished outcomes ✅ Fast, clear, and professional communication ✅ 100% satisfaction guaranteed What you’ll receive: ✔ 300 DPI print-ready files ✔ Formats: AI, EPS, PSD, PDF, JPEG, PNG ✨ Let’s Create Something Exceptional Together ✨ Explore my portfolio: https://www.freelancer.com/u/Kiranshaikh2388 I’d love to hear more about your project and how I can contribute to its success. Best regards, Kiran Shaikh
$20 USD in 40 days
5.2
5.2

Hello , I'd like to grab this opportunity and will work till you get 100% satisfied with my work. I'm a software developer with over 8 yrs of experience in PHP. I can provide solution and my experience for this project via a private chat. Let's discuss in more details via chat. I have got ideas brewing for your project, but I'd like to make sure they are aligned what you want. Regards, Toma K.
$20 USD in 40 days
5.1
5.1

With your unique challenge, I am excited to guide you through a solution that optimizes your data management on Snowflake and dbt. At XtrazCon, we pride ourselves on developing high quality, reusable frameworks for seamless data migration and organization. Our mastery in PHP, Snowflake, dbt and SQL has led us to successfully replicate and automate even the most complex of processes. We understand the importance of reliable data for business intelligence and go above and beyond to ensure its quality every step of the way. Our proposed dbt project will encompass all necessary elements - from models, seeds, macros and tests, strictly enforcing data-quality rules - resulting in analytics-ready tables. We also believe in providing full automation. By incorporating parameterized SQL and Snowflake tasks/procedures to orchestrate every load from start to finish, we can offer you effortless synchronization of your diverse data sources. Moreover, our expertise extends beyond development as we specialize in providing real-time monitoring and reporting solutions too. We could leverage dbt tests, Snowflake query history or even design a custom lightweight dashboard for you, so you can track the entire load process in near real-time including row counts. Partner with XtrazCon Technology for a future-proof migration framework that promises speed, precision and 47 years' worth of experience compressed into each task. Let's simplify this together!
$20 USD in 40 days
5.1
5.1

Hi, I am excited about the opportunity to build a reusable migration framework in Snowflake using dbt. With over 7 years of experience in software development and a strong background in database programming, I have successfully executed similar migration challenges. I am skilled in creating dbt projects that are structured for easy extension and have developed automated processes for data cleansing, validation, and loading into analytics-ready tables. I can ensure that the framework includes parameterized SQL, Snowflake tasks for orchestration, and built-in monitoring capabilities using dbt tests and dashboards. Let's discuss the specifics and map out a timeline to set this framework in motion. Best regards, Andrii
$25 USD in 15 days
4.8
4.8

United States
Payment method verified
Member since Oct 6, 2017
$10-30 USD
$10-30 USD
$10-30 USD
$8-15 USD / hour
$15-25 USD / hour
$30-250 USD
min €36 EUR / hour
$25-50 USD / hour
₹600-1500 INR
₹600-1500 INR
£250-750 GBP
₹50000-70000 INR
$10-30 USD
$250-750 USD
$250-750 CAD
$250-750 USD
₹1500-12500 INR
£2-5 GBP / hour
₹1500-12500 INR
$30-250 USD
$10-30 USD
$30-250 AUD
₹12500-37500 INR
₹600-1500 INR