I'm a data analyst who owns recurring reporting end to end and makes sure the numbers are right before anyone else sees them. I work remotely for College Hunks Hauling Junk & Moving, a US franchise company with 100+ locations, supporting revenue management, finance, and marketing.
What I've delivered there:
Built automated partner-billing and marketing ROI pipelines in Python and SQL, replacing manual monthly processes, and flagged late-completing jobs that were never being billed.
Optimised 28 slow Metabase queries to run 4 to 10 times faster with identical results.
Traced missing ad spend across 62 locations to its source and recovered 16 through a re-pull, and fixed a join that was inflating reported ad spend.
Reconciled revenue between the operational database and the accounting system, and corrected the same-store cohort from 93 to 102 locations.
Maintain 20+ dashboards and weekly and monthly reports, including a KPI report that goes to the company's owners.
Tools: SQL (MySQL, Redshift), Python (pandas), Metabase, Excel, and Google Sheets, with Cursor and Claude for AI-assisted development.
I'm looking for a remote data analyst or marketing analytics role, part-time or full-time, and I'm available on US Eastern hours.
