Technical Product Operations Specialist (Technical + LLM)

Overview We are seeking an experienced Technical Product Operations Specialist to support product, engineering, and cross‑functional teams across multiple platforms. This role blends technical analysis, AI‑assisted workflows, data operations, and program management to improve product quality, accelerate execution, and support large‑scale initiatives. The ideal candidate brings strong technical acumen, advanced SQL proficiency, experience with AI/LLM‑assisted workflows, and the ability to independently drive complex projects from start to finish. This is a full‑time, remote U.S.‑based contract role. Key Responsibilities Program & Product Operations Support execution strategies across multiple products and platforms, including early‑stage (01) initiatives and ongoing optimization efforts. Drive programmatic improvements that enhance product quality, operational efficiency, and user outcomes. Identify risks, develop mitigation plans, and communicate updates clearly to cross‑functional partners. Strengthen relationships with engineering, product, legal, and operational teams to ensure alignment and smooth execution. Data Analysis & Technical Tooling Write and optimize advanced SQL queries (CTEs, window functions, joins, aggregations) to collect, transform, and analyze product data. Identify trends, patterns, and insights that inform product strategy and operational decisions. Build and maintain dashboards, reports, and visualizations using tools such as Google Sheets or internal BI platforms. Support real‑time decision‑making through accurate, timely, and actionable data outputs. AI‑Assisted Workflows & LLM Operations Leverage AI agents and AI‑assisted tools to accelerate analysis, automate repetitive tasks, and prototype solutions. Apply prompt‑driven workflows to streamline operations and reduce manual overhead. Support labeling, annotation, and training workflows for large language models across product quality teams. Collaborate with technical partners to improve LLM performance, data quality, and evaluation processes. Program Management Manage multiple concurrent workstreams with strong organizational discipline and minimal supervision. Document processes, workflows, and technical requirements with clarity and precision. Anticipate operational roadblocks and proactively identify opportunities for improvement. Ensure consistent execution across teams through structured communication and follow‑through. Minimum Qualifications 8+ years of experience in consulting, strategy, operations, or program management with a focus on technical product operations. Advanced proficiency in SQL, including CTEs, window functions, joins, and data transformations. Experience with AI agents and AI‑assisted workflows; comfortable prompting and iterating with AI tools. Experience with data annotation, labeling, or LLM training workflows. Expert‑level proficiency in Google Workspace, especially Google Sheets (complex formulas, pivot tables, automated workflows). Demonstrated ability to manage multiple workstreams simultaneously. Strong critical thinking and data‑driven problem‑solving skills. Self‑starter with the ability to work independently and adapt quickly to new tools and domains. Excellent time‑management, communication, and organizational skills. Preferred Qualifications Experience with VS Code or similar development environments. Familiarity with low‑code/no‑code prototyping or AI‑assisted code generation. Experience building dashboards or data visualizations (e.g., Tableau, Looker, Unidash‑style tools). Understanding of data pipelines, ETL processes, or data infrastructure concepts. Experience collaborating with engineering teams on technical specifications. Background in quality assurance, triage operations, or ML/AI validation workflows. Experience developing and implementing manual or automated test strategies. What Makes This Role Unique Opportunity to work across multiple high‑impact product areas. Blend of technical analysis, AI‑assisted workflows, and program management. High autonomy with the ability to influence product quality and operational excellence. Exposure to complex technical ecosystems and cross‑functional teams. Ideal for candidates who enjoy solving ambiguous problems with data‑driven solutions. Location: Remote (United States) Role type: Contract 6 Month Position Expected hours: 40 per week Benefits: Dental insurance Health insurance Health savings account Life insurance Paid time off Retirement plan Vision insurance Schedule: 8 hour shift Monday to Friday Application Question(s): Do you or will you in the future require any sponsorship to work in the US? Language: English (Required)