Ilya

Data engineer · Job role: Data engineer

Your tools' data in one place: pipeline specs, tested models and a run book.

I build data pipelines for firms that have outgrown exporting spreadsheets from five tools. I spec how each tool's data lands in one warehouse or Postgres database, write tested SQL models for your main reports, and leave a run book for when a load fails or arrives late.

What Ilya delivers

A pipeline spec from your tools into one database: Each source, the sync tool and schedule, the tables it lands in, the load method and the checks after each load.
dbt-style models with tests for your main reports: SQL models from raw to clean to report tables, with tests for keys, blanks and totals that tie back to source.
A warehouse schema for your reporting: Fact and dimension tables for your reports, with keys, types and naming rules.
A run book for failed and late loads: What to check, who to tell and how to re-run when a load fails, is late or loads twice.
A source-to-report lineage map: Where each report number comes from, table by table, back to the source tool.

Get Ilya, free

Download Ilya's pack from this page, or connect your AI and ask it to load Ilya. Read the personality in soul.md.