Clean Inputs
Nothing downstream is trusted more than the record it came from. Ingestion, deduplication, validation and reconciliation against a source of truth, with every value traceable back to something that can be re-checked.
open to work · Fort Worth, Texas
AndrewRocha
Data Operations & Data Quality Analyst
- Data entry
- Data cleaning
- Data validation
- Quality assurance and QA review
- Records management
- Data consolidation
- Spreadsheet hygiene
scroll, it gets louder
01 — the short version
I make messy data trustworthy and repetitive work disappear.
I clean, validate and reconcile records — then build the workflows that keep them clean. I design the system and hold the judgment; the machine does the volume.
Repeatable Systems
Work that runs the same way twice without supervision. Bounded scheduled loops, hard requirement gates, human-in-the-loop review on anything that writes, and documented best practices in an SOP written before the process is handed off.
Proof It Works
A result nobody verified is not a result. Test suites, offline smoke runs, freshness gates, real-browser verification, and a validation report shipped beside the data as the evidence.
02 — what I actually use
The sticker wall
Tools I reach for weekly, not a list of things I once opened.
Data operations
- Data entry
- Data cleaning
- Data validation
- Quality assurance and QA review
- Records management
- Data consolidation
- Spreadsheet hygiene
- Source-of-truth reconciliation
Automation and systems
- Python workflows
- CLI automation and scripting
- AI-assisted workflow automation
- Prompt engineering workflows
- Form-fill automation
- AI output validation
- ETL and data ingestion pipelines
- Process documentation
- SQL — Supabase and PostgreSQL
Reporting and marketing ops
- Meta Ads Manager
- Campaign data QA
- Performance reporting
- Lead and conversion tracking
- Content and asset organization
Platforms
- Microsoft Excel
- Microsoft Office
- Word
- Outlook
- Google Sheets
- Google Workspace
- SaaS dashboards
- Project management tools
- Web/CMS platforms
Work style
- Independent remote work
- Async communication
- Attention to detail
- Confidentiality
- Accuracy under repetition
- English/Spanish translation (fluent)
03 — the road so far
Work journey
Every stop was accuracy work before it was systems work. That order is the point.
-
Mar 2025 – Present
Founder / Data Operations & Automation Lead
YAHWAYLOVE LLC · Fort Worth, TX / Remote
- Build repeatable data workflows for complex client projects, campaign exports, research output, and internal records across multiple platforms
- Use Python, CLI tooling, and AI-assisted workflows to ingest, organize, deduplicate, and validate data from exports, dashboards, forms, and research sources
- Run verification-heavy quality assurance workflows with source-aware checks, so every record traces back to something that can be re-checked and an inconsistency can be run down to root cause
-
Apr 2025 – Present
Data & Campaign Operations Support
414 Creative · Remote
- Monitor, clean, and organize Meta Ads performance data across multiple client accounts
- Analyze campaign metrics, targeting signals, lead data, and reporting exports to identify inconsistencies and trends before they reach a decision
- Supported improvements in targeting precision and cost-per-lead within 2-3 months through organized campaign data review and operational support
-
Aug 2024 – Feb 2025
Independent Contractor
Miracle Method / Tub Done Refinishing · Orange, TX & Boca Raton, FL
- Managed contract work independently from intake through completion, including scheduling, materials, job detail, timelines, and quality checks
- Maintained accurate project notes and customer records while working with limited supervision
- Demonstrated reliability, self-direction, and consistency in detail-heavy service work
-
Sep 2023 – Mar 2024
Documentation & Records Specialist
Lake Arenal Real Estate · Nuevo Arenal, Costa Rica
- Captured, organized, and maintained property records, client detail, listing information, media files, and supporting documentation
- Standardized property data and listing assets so records were easier to retrieve, compare, and update
- Supported accurate bilingual documentation by translating between English and Spanish for clients and internal teams
-
May 2018 – Apr 2021
Operations / Valet
Corinthian · Marina Del Rey, CA
- Provided high-trust customer service for residents while maintaining accuracy, organization, and accountability in daily vehicle operations
- Implemented process improvements that increased parking capacity by 20%
- Recognized as Employee of the Month for reliability and consistent service quality
where I worked clients served: Northern California · Fort Worth, TX · Orange, TX · Indianapolis, IN · Stuart, FL
Point at or tap a pin to see the stop.
Based in Fort Worth, Texas — remote only, not relocating. 2 of 5 roles never sat anywhere on a map at all.
04 — things that run
Built, shipped, still running
Each one exists because a manual process was costing real hours.
School-Data Vault Platform
A year of records that outlives the system holding them
A complete private archive of a year of coursework, built so the data survives losing access to the system it came from: every course, lesson, grade, file, video transcript and email pulled out of a hosted LMS, normalised, and stored somewhere retrievable. 127 commits, 648 tracked files. This is records management as a migration problem — get it all, keep it faithful to the source, and make it findable afterwards.
- Python
- TypeScript
- Structured extraction
- Archival integrity
Client Ministry-Tech Partnership
Their files stay in sync without anyone remembering to sync them
Ongoing client work across five deliverables: an AI proxy holding every API key server-side, a Dropbox-to-library autosync watcher running on a scheduled task, research and hub packs, and a site remodel. Ships behind a definition-of-done gate that has to pass before anything is called finished. 141 commits, 439 tracked files.
- Node
- Vercel
- Scheduled tasks
- Dropbox API
- Verification gate
Document Generation Pipeline
Structured inputs in, a finished 14-page document out
A document pipeline that takes structured inputs — a person's details, written testimony, source references and authorised context from an existing database and document corpus — and assembles a 14-page output from them. 57 commits and 47 tests, because a generator that silently drops an input is worse than no generator.
- Node
- TypeScript
- React
- 47 tests
Automated Job-Search Data Pipeline
A bad run refuses to publish itself
A daily job pipeline: 16 source families scanned into SQLite, run through a hard requirements gate, scored, and rendered into a self-contained dashboard. 153 commits behind three gates — a 29-test pytest suite, an offline pipeline smoke run, and a real-browser harness across three viewports that exits non-zero on accessibility violations, console errors, layout overflow, or a dead interaction.
- Python
- SQLite
- pytest
- Cloudflare Workers
- Playwright
Spreadsheet Cleanup & Validation Service
The proof ships with the data
A productized spreadsheet-rescue service: messy client data in, cleaned and deduplicated data out, plus a validation report showing exactly what changed and why. The report is the deliverable - the guarantee is proof, not a promise.
- Python
- Excel
- Google Sheets
- validation reporting
Automated Browser QA Gate
A green suite stopped being enough
A verification gate that made a green test suite mean something. Drives a real browser at three viewports and fails the build on accessibility violations, console errors, sideways scroll, undersized tap targets, or a page that rendered nothing - the last one because an empty page used to score perfectly.
- Node
- Playwright
- axe-core
05 — questions people actually ask
Straight answers
What roles is Andrew Rocha looking for?
Data operations, records and QA, and data-validation roles — data entry, compliance and records processing, and AI output QA. He targets high-accuracy, low-meeting work he can run asynchronously and increasingly automate.
Is Andrew available for remote work?
Yes — remote is the arrangement, not a preference. He is based in Fort Worth, TX (US Central) and is not relocating, so he works fully remote in an async, low-meeting style, comfortable with distributed teams and written-first communication.
What tools does he use for data work?
Excel and Google Sheets for records and reporting, Python for cleaning, deduplication and validation, and AI-assisted workflows with human QA kept intact. He also builds small automation pipelines and documents the SOP so they run without him.
How does he keep automated work trustworthy?
Every value carries its provenance, anything that writes stays human-in-the-loop, and cleaned data ships with a validation report showing exactly what changed and why. A result nobody verified is not treated as a result.
Does he work in Spanish?
Yes — fluent English and Spanish, including bilingual documentation and translating between clients and internal teams.
06 — say hello
Let's talk
Fort Worth, Texas · remote · async and written-first.