Open to staff & lead rolesRemote US or Houston · no sponsorship needed
available
Taking consulting projectsCost audits, dbt reliability, fractional lead
30-minute intro callsWeekdays · Google Meet · synced with my calendar
Pick a time in your own time zoneBook a call
Data & AI engineering lead

Data that paysfor itself.

I’m Artur Kochetkov. I build Snowflake and dbt platforms, reliability systems and LLM tooling, including a program that cut six figures a month from a marketplace’s warehouse bill.

The stack I work in every day

SfdbAfPyLkAI
How I work

Less firefighting. More shipping.

A query that costs too much. A table that’s late again. A feature that needs tracking before it ships. I make each of those visible, owned and fixed, so the team can get back to building.

Sf
Warehouse costSnowflake
Saved

Find what drives the bill

Price every query by data scanned and credits, then fix the expensive ones first.

db
fct_campaign_perfdbt · tier 1
On time

Keep tables inside their SLA

Freshness and uptime targets by tier, so on-call knows what’s late before analysts do.

Pw
PillwaveiPhone app
Pre-launch

Ship products end to end

From data model to App Store, including the backend, the site and the launch.

Case study · LLM SQL optimization

4,000 queries. One cost model.

Every legacy query got a price tag: data scanned, runtime and Snowflake credits. An LLM grounded in table metadata and that cost profile proposed a rewrite, and each rewrite was proven to return the same results before anyone reviewed it.

legacy-sqlprogram

4,000+ SQL files across marketing and analytics pipelines. Rule one: the numbers must not change.

snowflakeairflow
measurestage 1
query_historycreditsGB scanned
rewritestage 2
LLMtable metadatacost profile
provestage 3
result diffpriorityreview
campaign_spend_daily.sqlprofiled
lifecycle_email_feed.sqlprofiled
attribution_last_touch.sql−68% scanned
signup_funnel_hourly.sqlneeds review
kpi_hire_events.sql−41% credits
report_campaign_perf.mdhigh priority
diff_attribution.sqlresults match

File names and per-query figures are illustrative. Program totals below are real.

4,000+legacy queries analyzed
80%+had actionable fixes
6 figuressaved every month
−70%engineering review time

Measure

Execution time, data scanned and credits from query history, so every file has a cost before anyone touches it.

Rewrite

An LLM, given the query, its table metadata and its cost profile, proposes SQL that keeps the original intent.

Prove

Before and after results are compared, savings simulated, and each file gets a diff, an estimate and a priority.

Read the full case study (PDF) →

Selected work

From raw events to numbers people act on.

Cost is a feature

I treat warehouse spend like latency: measured per query and per team, with a budget.

Tests before trust

Contracts, generic and singular tests, and parity checks so incremental output equals a rebuild.

SLAs people can read

Every published table has a tier, an owner and a freshness target anyone can check.

LLMs with guardrails

AI tooling grounded in metadata and hard constraints, with a human reviewing the diff.

Teams of 5 to 10

Hiring, roadmaps, code review and standards, as a Director, a Head and a Lead.

One definition of a KPI

Registration and hire count the same in product and finance, because the events are configured once.

Findable data

Catalog metadata on every published table: dataset, owner and grain, without asking.

Marketing-native

Social, lifecycle, attribution and live shopping: I’ve owned that data from first touch to purchase.

A builder, too

I ship my own products, so I know what “done” costs on the other side of the dashboard.

Pillwave · coming to iPhone

I build products too. Pillwave, end to end.

Pillwave reminds people to take their medication. You snap the pill in your hand to check in, and family members get a quiet “✅ took the pills.” I designed it, built it and run its launch.

The whole stack, solo. Expo and React Native on the phone, SQLite offline-first storage, Supabase sync with per-row access rules, and a static site on Cloudflare.

Privacy is the product. Check-in photos never leave the phone. Without a linked family member, nothing does.

An AI marketing team. 23 Claude agents draft posts, check them against medical-claim rules and queue them for my approval.

~/pillwave
▾ src
▸ app today, check-in, family
▾ domain pure logic, unit-tested
ts reminders.ts when to ping, snooze
ts doseState.ts taken, late, missed
ts supply.ts days of pills left
▸ data SQLite, offline first
▸ photos stay on the device
▸ remote Supabase sync
▾ supabase
▸ migrations row-level security
▾ marketing
▸ team 23 agents, compliance gate
Pillwave Today screen showing the next dose and taken, late and upcoming pills
Works with

Keep the stack you already run.

I work inside your warehouse, orchestrator and BI tool. No rip-and-replace, no new platform to buy.

Sf
Snowflake + dbtModels, tests, contracts and cost.
AI
LLM toolingGrounded in your metadata, reviewed by people.

Daily drivers

SfSnowflakedbdbtPyPythonSQLSQLAfAirflowLkLooker

Also at home in

BigQueryGA4 exportDuckDBTableauBrazeGitHub ActionsSupabaseCloudflare WorkersExpo / React Nativescikit-learnpandasKafka

Certified in Data Engineering, Big Data and ML on Google Cloud, and in ETL pipelines with Airflow and Kafka.

Portrait of Artur Kochetkov

Artur Kochetkov
Houston, TX · Remote, US
B.S. Business Administration, CSU Channel Islands

About

11 years in data. Still hands on.

I’ve led teams of 7 and 10 as a Director and a Head, and I still write the SQL. I care about the parts that make data trustworthy: tests, SLAs, clear ownership and a warehouse bill nobody is afraid of.

2022 – now
Data Engineering Lead · Upwork

LLM SQL optimization across 4,000+ queries. Led marketing data engineering with 5 engineers, moving lifecycle feeds onto dbt, and built the platform reliability view with SLA tiers.

2021 – 2022
Director of BI & Engineering · proGroupX

Led a team of 7. Rebuilt the BI platform for full-funnel marketing visibility and built predictive models on marketing spend.

2019 – 2021
Head of Social Analytics · Alibaba Group (AliExpress)

Led a team of 10 and a real-time performance portal. +38% new-buyer LTV from social channels.

2015 – 2019
Analytics & business roles · TSUM Moscow, Lazurit & K, Floral Supply Syndicate

Forecasting, OLAP reporting and Tableau. Opened the company’s first profitable Moscow store in 19 years.

Full resume (PDF) →

Work with me

Hire me, or hire my help.
It starts with one call.

Intro call

Open now

For hiring managers and recruiters.

For teams with a data problem to scope.

30minutes · free · video
Book a call ↗

Roles I’m a strong fit for.

  • Data engineering leadLead a team of 3–10 and ship alongside them. What I do today.
  • Staff data engineerDeep work on a platform that must get faster, cheaper and more reliable.
  • Head of dataOwn BI and the data platform end to end, as at proGroupX and AliExpress.
  • Remote US or HoustonUS work authorization. No sponsorship needed.

Projects I take on.

  • Warehouse cost audit · 2 weeksWhat drives your Snowflake or BigQuery bill, and what to fix first.
  • Reliability build-out · 6–8 weeksFragile SQL jobs onto tested dbt models with SLAs.
  • Social LTV and attributionChannel value at 180 days, multi-touch attribution and experiments.
  • Fractional data leadA few days a week of senior leadership before a full-time hire.

Consulting rates depend on scope and are shared after the intro call.

Cost visibility works best when it is proactive, not a monthly surprise. Lesson from the LLM SQL optimization program

Go deeper

Questions

A few things you might be wondering.

Are you open to remote and on-site roles?

Yes. I’m based in Houston, TX and work remotely across US time zones. I’m happy to be on site in Houston, and I travel for planning weeks.

Do you need visa sponsorship?

No. I’m authorized to work in the United States and don’t need sponsorship.

Can you consult while employed full-time?

I take a small number of scoped projects that don’t conflict with my employer. If I join your team full-time, you come first.

Which warehouses and tools do you work with?

Mostly Snowflake and dbt, orchestrated with Airflow, reported in Looker or Tableau. I’ve also worked with BigQuery and the GA4 export, and my public projects run on DuckDB.

Can I see code?

Yes. social-commerce-ltv and marketing-data-reliability are public, with tests and CI. Employer work is shown as anonymized case studies.

How did you raise LTV by 38% at AliExpress?

By judging social channels on what buyers were worth months later, not on the first order, then segmenting early behaviour and shaping campaigns toward repeat purchase. The social-commerce-ltv project shows the same method on synthetic data.

Do you use AI in your work?

Daily, with guardrails: grounded in real metadata, held to hard constraints like “results must match”, and reviewed by a person before anything ships.

What is Pillwave’s status?

Pillwave is in pre-launch for iPhone with a public waitlist at pillwave.app. I built the app, the backend, the site and its marketing system myself.

How fast do you reply?

Usually within a day. The quickest route is to book a call; you’ll see my open times in your own time zone.

Let’s make your data pay for itself.

A role to fill, or a warehouse bill nobody can explain. Either way, 30 minutes is enough to know if I can help.

Free intro call · Central Time · Usually replies within a day