willschiller

Developed software applications using agile and test-driven development (TDD), wrote unit, fuzz, and invariant tests, and used static analysis tools for code auditing. Built Next.js applications and deployed them using GitHub and basic CI/CD principles. Project lead for on-chain smart contract assessment system using Ethereum and Next.js (https://www.solidityctf.xyz/), providing recruitment data for Encode (https://encode.club) and increasing billable hours for the company by 160 hours. Designed and implemented blockchain data models for on-chain assessment systems. Led technical workshops on Zoom with audiences of 100 or more.

Cleaned, transformed, and visualised data from APIs into Looker Studio reports, allowing senior management to monitor ROI against targets and make iterative adjustments. Built complex SQL queries for data analysis using proprietary tools similar to DBT. Created and maintained KPI measurement frameworks across multiple digital media channels, including social media, display, paid search, apps, and affiliates. Worked closely with the data science team to design and execute A/B tests, evaluating the effects of discontinuing branded keywords in paid search campaigns.

Led the MCM SEO strategy delivery and multiple SEO projects for Nike. Gave presentations to communicate business performance and strategy to senior stakeholders. Automated content updating via Salesforce CMS for MCM, reducing wasted billable hours by 50%, building client trust, and later expanding the account to five other markets. Oversaw and mentored junior staff, implementing and monitoring OKRs to align team performance with strategic objectives, setting tasks, and managing their time. Used SQL to build ETL pipelines for Looker Studio reports and data visualisations.

Managed key client relationships, including onsite and remote training, tech demos, and collaborative workshops, for contracts totalling $780k annually for large companies such as Skyscanner and The Telegraph newspaper. Delivered client training sessions on leveraging Linkdex for insightful SEO analytics and decision-making.