Costa Rica / US Remote

I built an entire data stack
from zero. Then I built an
AI agent on top of it.

I’m Franccesco Orozco — Data Lead at Bloom Growth. I single-handedly architected and deployed the company’s full data infrastructure: dbt models, Snowflake warehouse, Fivetran pipelines, Hightouch reverse ETL, and Hex for analytics.

Then I created Scout — an agentic AI data analyst that plugs into the entire stack and answers questions for the whole company in Slack. Self-taught. No CS degree. Just shipped work.

PythonSQLdbtSnowflakeFivetranHightouchHexRubyLLMs
Featured Project

Scout

Agentic AI Data Analyst

Scout is an AI agent that connects to our full data stack — Snowflake, dbt models, Hightouch syncs — and answers data questions from anyone in the company, directly in Slack.

No more waiting on analysts. No more ad-hoc SQL requests. The entire company can query their own data through natural language, and Scout handles the rest: writing SQL, pulling context from dbt docs, and returning clean answers.

Built entirely by me. From data infrastructure to the AI layer on top.

Agentic AISlack IntegrationSnowflakedbtPython
#general — Slack
PM
Product Manager11:42 AM

@Scout what’s our MRR trend for the last 6 months?

S
ScoutAI11:42 AM

Querying analytics.finance.mrr_monthly ...

Career

From self-taught to data lead

No CS degree. No bootcamp. Just an obsession with building things and the discipline to ship them.

2019 — Present
Bloom Growth

Bloom Growth

Data Lead

Joined as the only person working with data. Built the entire data infrastructure from the ground up — from Excel exports to a full modern data stack.

  • Designed and deployed the complete data platform: Snowflake, dbt, Fivetran, Hightouch, Hex
  • Created Scout — an agentic AI data analyst serving the entire company via Slack
  • Collaborated with Hex (hex.tech) on their AI agent, authored a published article for them
  • Went from solo data person to leading the data function
2022
Deepnote

Deepnote

Customer Data Scientist

Short engagement with the collaborative data science platform. Worked on customer analytics and data science workflows.

  • Applied data science in a product-focused environment
  • Gained experience with collaborative notebook tooling at scale
2014 — 2018
Straive

Straive

Web Research Specialist

Where it all started. Worked in web research while teaching myself Python, building open-source tools, and stacking up GitHub projects until the code spoke louder than any resume.

  • Self-taught Python through relentless side projects
  • Built GSAN — a security tool that earned 300+ GitHub stars
  • Transitioned from research to development through shipped work

Get in touch

Open to new opportunities. If you’re hiring for data engineering, AI, or anything in between — let’s talk.

franccesco@thatai.dev