Founding Data & AI Engineer, Creative Engine
- Role
- Data Engineering
- Experience
- Lead
- Employment
- Full-time
Open to BR only. Set where you work from to check your eligibility.
No BS summary
Senior/lead data-first Python/Django engineer in Brazil, working US time zones. Needs 5+ years building production data-heavy apps with PostgreSQL, strong SQL, async pipelines, LLM APIs, agentic coding tools, and third-party API integrations.
Core skills
Required skills
Optional skills
Optional languages
🏔️ About Sierra Studio
Sierra Studio is an innovative product development firm dedicated to empowering founders and business leaders in their quest to create impactful, meaningful products. Our team of experienced professionals is committed to delivering high-quality solutions that drive business growth. We prioritize a culture of good vibes, open communication, and continuous learning, providing our team members with the opportunities and resources they need to thrive.
This role is with one of the teams we help build through our staffing partnerships. When you apply, Sierra manages the hiring process, but you'll be hired directly by and work within the client company.
🏢 About The Company
Our hiring partner is a performance creative agency that makes ads for brands on TikTok, Meta, and TikTok Shop. They work with 2,000+ creators and produce thousands of videos per year. Their internal portal handles the entire workflow: creator onboarding, contracts, campaign management, content review, and payments.
They're now building a Creative Engine that turns creative strategy from gut instinct into a data-driven process. Data today lives in too many disconnected places — the Creative Engine brings it all into one central home, across performance creative, TikTok Shop, and TikTok LIVE, so the team can derive real insights instead of digging through separate platforms. AI watches and tags every video they produce, breaking each one into the hooks, formats, and patterns that drive results, and connects that to the sales and engagement data flowing out of Shop and Live. It all feeds one queryable system, a "brain" a strategist can ask "what are the top hooks for beauty this week?" and get a real answer back. The team reaches it through dashboards, Slack, and Cowork. It starts as the internal engine the creative team runs on, and over time clients log in to it too — this is the core of where the company is headed.
How they work:
- Small team, high ownership. You own your work end to end, from idea (or data model) to deployed UI. No committees.
- AI-assisted everything. Claude Code and coding agents are used daily as a real part of the workflow.
- Ship constantly. They deploy to production multiple times per day. Scope stays small and tight.
- Remote, async. Communication happens via Slack and GitHub. No standups or status meetings for the sake of meetings.
🖼️ About The Role
Our hiring partner is looking for its founding engineer on the Creative Engine, and they're hiring data-first, not app-first. This is a data product at its core, and you'll own the foundation: the pipelines that pull and structure performance data across hundreds of accounts, the LLM workflows that analyze every video they run, and the search layer that turns all of it into answers strategists can query.
You'll own features end to end, including the UI, but you don't need to be a frontend specialist. The heart of this role is the data and intelligence layer — you'll lean on Claude Code and agentic tooling to ship the dashboards and interfaces on top. Get the foundation right and the product follows, so they want someone who's genuinely LLM-fluent and savvy with AI-native development, not just someone who's heard of it.
🔨 What You'll Do
- Design the data foundation: pipelines that pull, store, and structure performance, sales, and engagement data across hundreds of client accounts (performance creative, TikTok Shop, TikTok LIVE, and Meta), handling the messiness of real platform APIs.
- Build the LLM analysis layer, using Gemini to watch and tag every video and Claude for generation, with structured output at scale and sane cost controls.
- Build search and discovery with semantic search via pgvector, so a strategist can ask "what are the top hooks for beauty this week?" and get a real answer, not a keyword dump.
- Build the "brain": connect viral organic references, top-performing ads, content tags, and creator history into queryable creative intelligence, accessible through the web app, Slack, and Cowork.
- Develop creator-performance matching, linking creator history, content tags, and ad metrics to sharpen casting decisions.
- Own the full stack on top of your data work: dashboards, tag browsers, enrichment queues, and export tools in Django + HTMX + Tailwind, moving fast with Claude Code (no dedicated frontend hire required).
- Integrate external APIs (TikTok, Meta, Motion, Cruva) and internal async pipelines (Celery + Redis).
The Stack
- Backend: Django, PostgreSQL, Celery + Redis, Django REST Framework
- Frontend: Django templates, HTMX, Tailwind CSS (server-rendered, no SPA)
- AI/ML: Google Gemini (video analysis), Anthropic Claude (script generation), pgvector (planned)
- Infrastructure: Docker, AWS ECS/Fargate, Backblaze B2, GitHub Actions CI/CD
- Integrations: TikTok API, Meta API, MagicBrief, Cruva, PayPal, DocuSign, Twilio, Slack
🔎 What We're Looking For
Required:
- 5+ years building production, data-heavy applications with Python/Django and PostgreSQL (senior / lead level, autonomous, low-process).
- Strong SQL well beyond basic ORM queries (aggregations, joins, window functions) and comfort designing schemas and data models straight from use cases.
- Experience designing and debugging async data pipelines (Celery + Redis or equivalent).
- Genuinely LLM-fluent: hands-on with LLM APIs in production, prompt engineering, structured output, and cost management.
- Fluent with agentic coding tools (Claude Code, Cowork) and excited to use them to move fast, including building full-stack on top of your own data work.
- Experience integrating messy third-party APIs (rate limits, auth flows, inconsistent data).
- Comfortable owning frontend (Django templates + HTMX + Tailwind) with AI assistance — you ship the whole feature, you just don't need to be a frontend expert.
- Strong written communication and high ownership on a small, async team.
Preferred:
- An AI engineer at heart — you've built agent harnesses, RAG, or LLM eval pipelines (even side projects count).
- Background in or curiosity about ML fundamentals, like knowing when a simple scoring function beats a complex model.
- Experience with video or audio processing pipelines.
- Domain experience in ad tech, creator economy, performance marketing, or marketplace platforms.
- Have worked with a US-based team before — async, English-fluent, knows the drill.
Location: remote, based in Brazil, working US time zones.
What you'll do
- Design data pipelines that pull, store, and structure performance, sales, and engagement data across hundreds of client accounts across performance creative, TikTok Shop, TikTok LIVE, and Meta.
- Handle messy real platform APIs.
- Build the LLM analysis layer using Gemini to watch and tag every video and Claude for generation.
- Implement structured output at scale and cost controls for LLM workflows.
- Build search and discovery with semantic search via pgvector.
- Build a queryable creative intelligence "brain" connecting viral organic references, top-performing ads, content tags, and creator history.
- Make the creative intelligence accessible through the web app, Slack, and Cowork.
- Develop creator-performance matching by linking creator history, content tags, and ad metrics.
- Own the full stack on top of the data work, including dashboards, tag browsers, enrichment queues, and export tools in Django, HTMX, and Tailwind.
- Move fast with Claude Code without a dedicated frontend hire.
- Integrate external APIs including TikTok, Meta, Motion, and Cruva.
- Integrate internal async pipelines using Celery and Redis.
What they require
- 5+ years building production, data-heavy applications with Python/Django and PostgreSQL.
- Senior / lead level, autonomous, low-process engineer.
- Strong SQL well beyond basic ORM queries, including aggregations, joins, and window functions.
- Comfort designing schemas and data models straight from use cases.
- Experience designing and debugging async data pipelines using Celery and Redis or equivalent.
- Hands-on experience with LLM APIs in production, prompt engineering, structured output, and cost management.
- Fluent with agentic coding tools such as Claude Code and Cowork.
- Excited to use agentic coding tools to move fast, including building full-stack on top of your own data work.
- Experience integrating messy third-party APIs with rate limits, auth flows, and inconsistent data.
- Comfortable owning frontend with Django templates, HTMX, and Tailwind with AI assistance.
- Able to ship whole features without needing to be a frontend expert.
- Strong written communication.
- High ownership on a small, async team.
- Must be remote, based in Brazil, and work US time zones.
- Preferred: AI engineer at heart with experience building agent harnesses, RAG, or LLM eval pipelines, including side projects.
- Preferred: Background in or curiosity about ML fundamentals, such as knowing when a simple scoring function beats a complex model.
- Preferred: Experience with video or audio processing pipelines.
- Preferred: Domain experience in ad tech, creator economy, performance marketing, or marketplace platforms.
- Preferred: Experience working with a US-based team in an async, English-fluent environment.
Benefits
- Small team with high ownership.
- Own work end to end from idea or data model to deployed UI.
- No committees.
- AI-assisted workflow using Claude Code and coding agents daily.
- Deploy to production multiple times per day.
- Small and tight scope.
- Remote, async work.
- Communication via Slack and GitHub.
- No standups or status meetings for the sake of meetings.
- Opportunities and resources to thrive.
Sierra Studio is an innovative product development firm dedicated to empowering founders and business leaders in their quest to create impactful, meaningful products. This role is with one of the teams they help build through staffing partnerships; Sierra manages the hiring process, but the hire will work within the client company.