AI & Data Analysis Expert

We're looking for an AI & Data Analysis expert to lead the integration of intelligent tools within the business platform. You'll connect Google Ads, marketing data files, and operational data sources to build AI agents via Claude that support business decision-making across our pet retail operations. Key Responsibilities Design and configure Claude-powered agents using tool use, structured prompts, and automated workflows for data analysis Integrate the Google Ads API to extract campaign metrics and feed decision-making dashboards Ingest, clean, and structure CSV, Excel, and other marketing data formats for agent processing Generate automated narrative reports and actionable visualizations for the executive and marketing teams Maintain and iterate on data pipelines connecting advertising, sales, and inventory data Required Technical Skills Claude API / Anthropic MCP (Model Context Protocol) Prompt engineering and LLM tool use / function calling Google Ads API Python or JavaScript (for pipelines and integrations) SQL / PostgreSQL / Supabase Pandas / NumPy or equivalent data libraries REST API consumption and integration Advanced Excel / Google Sheets Nice to have: Google Analytics, BigQuery, Looker, Power BI Ideal Profile Proven experience building data pipelines or LLM-powered tools in a production environment Hands-on familiarity with the Anthropic API and agent/tool-use patterns Ability to translate raw data into clear, actionable business recommendations Self-directed — can propose and build solutions without exhaustive specs Initial Projects Campaign ROI Agent — connects Google Ads + business sales data to generate automatic performance alerts and recommendations Marketing File Pipeline — ingests CSV/XLSX marketing files and produces AI-generated summaries and insights Executive Dashboard — decision-support interface with Claude-generated action recommendations based on live data