Lucas Hammonds

Analytics and Automation Engineer focused on LLM-powered classification, workflow automation, and systems integration across Sales, Operations, and Support.

Talent

CharlotteMember since July 15, 2026

PythonSQLPostgreSQLSnowflakeRedshiftJavaScriptNode.jsGoogle Apps ScriptLLM / OpenAI APIsAI workflow automationcase classification & summarizationREST APIsZapiercustom workflow designSlack APISalesforceZendeskJiraAsanaClickUpSupabaseGoogle CloudCloud Rundata pipelinesChrome ExtensionsGmail APIGoogle Calendar APIRetoolSlack Bolt

Hire this person

Send a job offer directly to this candidate

PythonSQLPostgreSQLSnowflakeRedshift

About

Automation engineer who audits broken processes and replaces them with reliable, auditable, low-cost software. Builds internal AI solutions and workflow automations — LLM-powered classification, agentic workflows, and API integrations — using Python, SQL, Google Apps Script, and REST APIs across Sales, Operations, and Support. Delivered $798K in annual savings, prevented $100K in erroneous payouts per incident, and cut 15 hours of weekly reporting overhead.

Experience

Technical Operations Engineer at Roadie (2022-01 – 2025-01)

Integrated OpenAI APIs into internal support systems to automatically classify and summarize incoming cases, cutting manual triage and review time for the support team.
Identified a location-spoofing vulnerability by querying system logs with SQL and Python, then partnered directly with engineering to deploy automated production fixes.
Built a custom Slack app on the App Home API to centralize cross-departmental documents and contact directories, raising new-agent post-training readiness scores by 10%.

Analytics & Automation Engineer at ClickUp (2021-01 – 2022-01)

Built a self-service workforce reporting tool in Snowflake and JavaScript, replacing manual data extraction and eliminating 15 hours of weekly reporting overhead.
Automated shift-swap and call-out management by connecting the Slack API to ClickUp, removing manual scheduling coordination for agents.
Designed a zero-cost pipeline that pushed Snowflake metrics into Google Sheets and Slides and triggered automated daily Slack reports to leadership, avoiding third-party data exposure.

Business Systems Developer at DoorDash (2018-01 – 2021-01)

Rewrote flawed Retool payout logic and optimized SQL joins, reducing erroneous driver payments by 80% and saving ~$100K+ per app outage.
Engineered an algorithmic scheduling and automated Slack-notification workflow in Google Apps Script, achieving 100% weekend on-call coverage and eliminating leadership no-shows.
Streamlined financial report generation from 68 clicks to 8 using Google Apps Script and structured spreadsheets, removing extended after-call work for support agents.

Process Automation Specialist at DoorDash (2017-01 – 2018-01)

Digitized manual onboarding with QR codes and iPads that triggered real-time Checkr background checks, cutting orientation time from over an hour to 30 minutes.
Built a Google Apps Script tool with a one-click UI to deduct issued driver gear from a master database, moving inventory counts from weekly to quarterly and saving $30K annually.