Job Title: Project Coordinator IV - Technical Product Operations Specialist 
Location: Remote (Open to Hybrid – New York, NY, Menlo Park CA, Washington DC, Seattle WA)
Duration: 4+ Months (potential extension)
 
Job Description:

• The Product & Regulatory Operations org is a vital part of Client's commitment to user and business safety on its platforms, delivering operations for emerging and critical priorities across Client and Global Operations and in close partnership with product/eng, legal and XFN stakeholders.
• As a Technical Product Operations Specialist, you will work on projects that drive growth, engagement, and quality of Client's products through data-driven decision making and technical tooling. We are looking for experienced professionals with strong technical acumen and product sense who can independently build analytical solutions, leverage AI tools to accelerate workflows, and drive programmatic improvements through data analysis and automation.

 
Must-Have Skills:

1. 8+ years in strategy/operations/program management — with a focus on technical product operations and proven ability to manage multiple workstreams independently.
2. Advanced SQL proficiency — CTEs, window functions, joins, and data transformations, combined with the critical thinking to leverage data for decision-making.
3. AI & tooling fluency — experience with AI agents/assisted workflows and expert-level Google Workspace (especially Sheets), with the adaptability to pick up new tools quickly.

 
Nice-to-have Skills:

1. META Experience (Prod Ops teams preferred)
2. AI-assisted development & prototyping — comfortable with vibe coding, low-code/no-code tools, and AI-assisted code generation in environments like VS Code.
3. Data visualization & pipeline knowledge — experience building dashboards (Unidash, Tableau, Looker) and familiarity with ETL/data infrastructure concepts.

 
 
Responsibilities:

• Support program execution strategy for multiple products and platforms – includes kickstarting 0 to 1 efforts, accelerating execution, and improving quality/outcomes for product objectives via programmatic and technical solutions
• Write and optimize SQL queries to collect, transform, and analyze product data from various sources, identifying trends, patterns, and insights that inform business decisions
• Build and maintain dashboards, reports, and visualizations (e.g., Unidash, Google Sheets) to effectively communicate findings to stakeholders and support real-time decision-making
• Leverage AI Agents and tools (e.g., Client’s Worldclass Tooling) to accelerate data analysis, automate repetitive tasks, and prototype solutions
• Proactively identify program risks, develop data-backed mitigation plans, and communicate rationale and updates clearly across cross-functional teams
• General program management to identify opportunities and predict roadblocks through data analysis, strengthen cross-functional relationships, and execute on plans with technical rigor

 
Minimum Qualifications:

• 8+ years of relevant experience in consulting, strategy, operations, or equivalent program management experience with particular focus on technical product operations
• Proficient in SQL – able to write advanced queries including CTEs, window functions, joins, aggregations, and data transformations
• Experience with AI Agents and AI-assisted workflows – comfortable prompting and iterating with AI tools to accelerate work
• Expert-level proficiency in Google Workspace, especially Google Sheets – able to create detailed, step-by-step documentation, complex formulas, pivot tables, and automated workflows
• Strong multi-tasking abilities with demonstrated experience managing multiple workstreams simultaneously
• Self-starter mentality – able to work independently, take initiative, and drive projects forward without close supervision
• Eager to learn new tools, technologies, and domains quickly; adapts to changing technical requirements
• Effective critical thinking and experience leveraging data to anticipate and unblock problems and drive solutions
• Proven time-management and organizational skills

 
Preferred Qualifications:

• Experience with VS Code or similar development environments
• Vibe Coding experience – comfortable with low-code/no-code prototyping or AI-assisted code generation
• Experience building dashboards and data visualizations (Unidash, Tableau, Looker, or similar)
• Familiarity with data pipelines, ETL processes, or data infrastructure concepts
• Experience working with engineering teams on technical specifications and requirements
• Background in quality assurance, triage operations, or ML/AI validation workflows
• Experience with testing, developing and implementing test strategies (manual and automated) for products and features.

 
Story Behind the Need – Business Group & Key Projects
Surrounding team & key projects

• Delivers operations for user/business prodOps across Client's platforms, partnering with product/eng, legal, and XFN stakeholders.

1. Drive program execution — launch 0→1 efforts, accelerate delivery, and improve product outcomes through programmatic and technical solutions across multiple products/platforms.
2. Analyze & visualize data — write/optimize SQL, build dashboards (Unidash, Sheets), and surface trends and insights that inform business decisions in real time.
3. Leverage AI & automation — use AI agents and internal tooling to accelerate analysis, automate repetitive work, and prototype solutions.
4. Manage risk & cross-functional coordination — proactively identify program risks, build data-backed mitigation plans, and communicate clearly across teams to unblock and drive execution.
5. Forecasting

 
Interview Process:

• How many rounds of interviews? 2
• Types of Interviews: Behavioral + Technical
• Interview Duration: 30 mins

 
  
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.This position's pay range is $60.00/hr - $70.00/hr.