
Closed
Posted
Paid on delivery
I’m looking for an experienced ETL specialist (10 + years) who can step in as my on-call partner during my working hours, 8 am – 3 pm CST, all online and paid monthly. I work in a finance environment that relies heavily on Snowflake and DBT, so the focus is on keeping daily data pipelines healthy, performant, and well-tested. During each session you will help me: • Extract, transform, and load data from multiple sources. • Configure, tune, and troubleshoot Snowflake warehouses. • Design, refactor, and test DBT models. The tech stack you’ll need to be fully comfortable with includes: • SQL for complex queries and performance tuning. • Python for ad-hoc scripts, utilities, and automation. • Apache Spark for the occasional large-scale batch job. Typical tasks range from reviewing my pull requests and fixing failing DBT tests to diagnosing slow Snowflake queries or re-engineering an ingestion workflow end-to-end. Clear explanations are essential—I’m counting on you not just to solve the issue but to show the thinking behind it so I can replicate the solution next time. Deliverables and success markers • Real-time guidance during support hours, with working code or configuration changes that resolve the problem at hand. • Short, written summaries of what we covered and any follow-up actions. • All changes tested, committed, and running without regressions by session end unless we agree otherwise. If you’re confident across ETL fundamentals, Snowflake internals, and DBT best practices—and you can communicate crisply under time pressure—let’s get started.
Project ID: 40436472
16 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₹56,813 INR for this job

Atomic, simplistic, yet elegant is the epitome of my approach to software development. With over a decade of experience in ETL and having worked extensively with Snowflake and DBT, I am the ideal fit for your project. I bring to the table an in-depth knowledge of SQL for complex queries and performance tuning, Python for automation, and Apache Spark for large-scale batch jobs - just what you need to keep those daily data pipelines healthy and optimized. What sets me apart from others is my ability to translate business needs into robust technical solutions. In a finance environment like yours where data integrity is paramount, my skill in designing, refactoring, and testing DBT models will ensure accurate, dependable, and efficient decision-making systems at all times. Additionally, I being comfortable working with tight deadlines understand how crucial clear explanations are; I'll provide you with concise summaries of our sessions so that you can not only replicate but also understand the thinking behind every solution. Finally, I am a true believer in regular and clear communication channels for efficient work. I will provide real-time guidance during your working hours backed by functional code-altering changes that resolve any issues. All changes made will be tested rigorously to ensure data currency and relevancy at session's end unless otherwise agreed upon. Trust me to not only meet your expectations but also exceed them by diligently delivering on all milestones as we collaborate towards efficiently functioning ETL systems!
₹50,000 INR in 90 days
6.2
6.2

Your finance pipelines will fail silently if DBT tests aren't catching schema drift before Snowflake queries hit production. I've debugged this exact scenario for 3 clients where incremental models broke during month-end close because source table columns changed without triggering alerts. Before we structure the support engagement, I need clarity on two things: What's your current Snowflake warehouse auto-suspend policy, and are you running into compute credit overruns? Second, when DBT tests fail at 9 am, what's your rollback strategy - do you have staging environments that mirror prod table structures? Here's how I'll operate during your 8-3 CST window: - SNOWFLAKE QUERY OPTIMIZATION: Rewrite CTEs causing full table scans, implement clustering keys on high-cardinality columns, and tune warehouse sizes to cut query time from minutes to seconds without burning credits. - DBT MODEL REFACTORING: Convert table materializations to incremental where appropriate, add data quality tests that catch upstream issues before they cascade, and document macro logic so you're not reverse-engineering my work. - PYTHON AUTOMATION: Build monitoring scripts that alert you when row counts deviate 15% from historical patterns, automate schema validation between source systems and Snowflake stages. - SPARK BATCH JOBS: Optimize partition strategies and memory configs when you're processing multi-TB datasets that choke on default settings. I've spent 12 years keeping financial data pipelines operational across 5 companies where downtime meant regulatory penalties. I don't just fix the immediate error - I'll walk you through root cause analysis so you understand why the warehouse spilled to disk or why the merge statement locked the table. Let's schedule a 20-minute technical call to discuss your current pain points and confirm this structure works before we lock in monthly terms.
₹54,000 INR in 21 days
5.8
5.8

As an ETL and database specialist with over a decade of experience, I'm well prepared to support your critical systems. With a strong background in maintaining high-intensity data pipelines and resolving performance issues, I'm comfortable working with Snowflake and DBT - as well as complementary technologies like SQL, Python and Apache Spark that you rely on to facilitate these processes. I've built my career on a foundation of collaborative problem-solving and straightforward communication, something that will be crucial for us given the real-time nature of this role. I will not only identify and fix any problems but also provide clear explanations behind each solution so you can replicate them in the future. Additionally, I understand the importance of clearly summarized documentation which I'll provide after sessions for reference. Whether it's reviewing pull requests, optimizing your DBT models, or improving your Snowflake queries, rest assured that I have your back from 8 am – 3 pm CST. My history includes successfully handling complex projects like yours which were characterized by exhaustive data extraction from multiple sources followed by thorough transformation to ensure pipeline healthiness. Let's work together to streamline your data workflows and empower your business!
₹60,000 INR in 7 days
0.0
0.0

Hi, I can support you as an on-call ETL partner during your CST working hours and help troubleshoot, optimize, and maintain your Snowflake + DBT workflows in real time. I have strong experience working with ETL pipelines, SQL optimization, Python automation, and data workflow troubleshooting, including handling performance bottlenecks, DBT model issues, and Snowflake warehouse tuning in production-style environments. What I can help with: • Snowflake query optimization and warehouse configuration • DBT model design, refactoring, testing, and debugging • ETL pipeline troubleshooting and workflow improvements • SQL performance tuning for complex transformations • Python scripting for automation and utilities • Apache Spark support for batch processing tasks • PR reviews, debugging failing jobs, and root-cause analysis I understand that communication and explanation are important for this role, so I focus not only on resolving issues quickly but also explaining the reasoning and best practices behind each solution. What you can expect: • Reliable availability during agreed support hours • Tested solutions with minimal regressions • Clear written summaries and follow-up recommendations • Professional collaboration in a fast-paced environment I’m comfortable working in long-term support engagements and can adapt quickly to existing workflows, repositories, and standards. Best regards, Amar Sajid
₹50,000 INR in 7 days
0.0
0.0

Hello, I’m Nikita Agarwal from Groww Per Click. We reviewed your requirement for an ETL specialist and understand that you need a reliable, experienced partner who can provide real-time support for your Snowflake, DBT, and data pipeline ecosystem during your working hours. We can support you as a dedicated data engineering resource focused on maintaining, optimizing, and troubleshooting your ETL workflows in a finance-grade environment. Our approach includes: ✔ Real-time support for ETL pipelines during working hours ✔ Snowflake performance tuning and warehouse optimization ✔ DBT model design, refactoring, and test troubleshooting ✔ SQL optimization for complex queries and large datasets ✔ Python scripting for automation and ad-hoc fixes ✔ Apache Spark support for large-scale batch processing ✔ Clear explanations of fixes for long-term understanding ✔ Short summaries of all changes and improvements We focus not only on resolving issues but also ensuring you understand the root cause and solution approach for future independence. We would be happy to support your data infrastructure as a long-term technical partner. Best Regards, Nikita Agarwal Groww Per Click
₹50,000 INR in 5 days
0.0
0.0

A dedicated MS SQL Database Administrator with 8.7+ years of experience, Including 2+ Experience of Technical Lead. Skilled in managing large, complex database environments with expertise across SQL Server 2012–2022. With hands-on experience supporting 150+ servers (including 80 production), I specialize in high availability (AlwaysOn), disaster recovery, performance tuning, and end-to-end database administration. Known for strong analytical abilities, commitment to reliability, and a proactive approach to system optimization and incident management. Key Roles & Responsibilities • Installation, configuration, and administration of MS SQL Server environments. • Designing and implementing High Availability & Disaster Recovery (HADR) solutions using AlwaysOn Availability Groups. • Performing performance tuning, including query optimization, DB configuration, memory tuning, and I/O analysis. • Managing database objects—tables, indexes, views—and ensuring optimal application performance. • Monitoring system health, jobs, processes, and proactively handling failures and incidents. • Managing user access, security controls, and supporting development and testing teams. • Ensuring timely and reliable backup strategies and participating in DR drills. • Conducting requirement analysis, building solutions, unit testing, and upgrading applications. • Providing production support, incident management, problem resolution, and coordination with users and stakeholders
₹60,000 INR in 7 days
0.0
0.0

Having good knowledge in ETL development and Migration in Snowflake, DBT, PySpark, AWS Glue. I can try to help you.
₹70,000 INR in 30 days
0.0
0.0

Hi, At APIE Tech, we have strong expertise in ETL pipelines, Snowflake, and DBT — delivering production-grade data engineering solutions for finance-domain clients. Your requirement is clear: an experienced on-call ETL partner who can support your daily Snowflake + DBT workflows during 8am–3pm CST. Here is how we approach this: - Snowflake: warehouse tuning, query optimization, schema design, pipeline health monitoring - DBT: model design, refactoring, test failures, incremental models, source freshness - Python: automation scripts, ingestion workflows, utility tooling - Apache Spark: large-scale batch job support as needed - SQL: complex query writing, performance diagnostics, index and clustering strategies We are comfortable reviewing pull requests, fixing failing DBT tests in real time, diagnosing slow Snowflake queries, and re-engineering ingestion workflows end-to-end. We also document what we do so you can replicate solutions independently. Finance data pipelines require zero-tolerance for regressions — we treat every session with that discipline. All changes are tested and committed before session end. We are available during your support hours and can start immediately. Monthly engagement works well for us. Looking forward to discussing the data stack in more detail. Best, APIE Tech
₹55,000 INR in 7 days
0.0
0.0

Yavatmal, India
Member since Jun 15, 2023
min €36 EUR / hour
₹12500-37500 INR
₹50000-70000 INR
min ₹2500 INR / hour
₹37500-75000 INR
₹600-1500 INR
₹150000-250000 INR
$250-750 USD
$30-250 USD
₹37500-75000 INR
min ₹2500 INR / hour
₹750-1250 INR / hour
£10-15 GBP / hour
₹12500-37500 INR
₹150000-250000 INR