# Ryan Newkirk > Software Engineer @ Hive AI | Computer Science @ Northwestern Location: San Francisco, California, United States Profile: https://flows.cv/ryannewkirk ## Work Experience ### Software Engineer II @ Hive Jan 2026 – Present Lead developer (L4) for an AI-Powered B2B platform for Media Intelligence (Mensio), enabling granular, cross-platform measurement of advertising, branded content, and sponsorship in TV/streaming/digital media. I own the full lifecycle of feature development, from database design to deployment, while managing the data pipelines that power our AI analytics. ### Software Engineer @ Hive Jan 2024 – Present | San Francisco Bay Area - Designed and optimized large-scale data pipelines and backend services (TypeScript, Python, Scala/Spark), delivering high-performance computation for logo detection, social/viewership analytics. - Optimizing query performance and database indexing to significantly reduce report latency. Ensuring data integrity through CI/CD workflows and Grafana monitoring, and led enterprise-scale backfills, data audits/deduplication, schema upgrades. Refactored querying system to reduce execution time for a majority of logo detection reports by more than half. - Built and maintained Apache Spark/Scala data pipelines for TV brand transcription. Developed internal admin tooling and custom data ingestion scripts, streamlining operations for cross-functional teams and enterprise clients. - Managed on-call incident response, live TV channel recording, social data pulls, and daily pipeline operations, performing direct client requests to ensure high system availability and support business analytics teams. ### Software Engineer Intern @ Square Jan 2023 – Jan 2023 | Chicago, Illinois, United States Integrated user testing capabilities into the Web Payments SDK reference. Used Svelte, Optimizely, OneTrust, internal service APIs, Cypress, GitHub. Created and deployed an A/B test for a frontend feature. Authored Design Doc, Experimentation Doc, and Runbook. Led scrum meetings using Jira, Trello. Ran testing party. Prototyped an automated phone calling system for Square sellers using OpenAI GPT, Square APIs, Twilio, Amazon Lex. ### Software Engineer Intern @ Square Jan 2022 – Jan 2022 Full Time Internship at Square as part of the Developer Experience team. Developed a new front-end feature for Square’s Web Payments SDK website allowing users to write and preview code in-browser. Wrote an Engineering Design Doc, Developed with a spike, Svelte (HTML/CSS/JS), Cypress, Visual Studio Code, GitHub Source Control. Prototyped an ecommerce site using Square Payment API and JavaScript. Developed a cross-platform discount and marketing promotion sharing tool for Cash App/Square Seller Dashboard. Used Node.js servers and the Square Payment API. ### Software Engineer Intern @ Argonne National Laboratory Jan 2021 – Jan 2022 Developed Python scripts and a MySQL database to collect real-time customer outage data from 232 million US residents for power outage forecasting. Designed and implemented geo-mapping functions for comprehensive power outage analysis. ### Google Computer Science Summer Institute @ Google Jan 2020 – Jan 2020 Learned how to build web applications using the p5 Library, APIs, Node.js, and ExpressJS. ## Education ### Master's degree in Computer Science Northwestern University ### Bachelor's degree in Computer Science Northwestern University ### High School Diploma in STEM Young Magnet High School ## Contact & Social - LinkedIn: https://linkedin.com/in/rnewk --- Source: https://flows.cv/ryannewkirk JSON Resume: https://flows.cv/ryannewkirk/resume.json Last updated: 2026-04-11