Senior AI Analyst

Role Description

This role sits within a Transformation Team - a small, high-impact group of data analysts and analytics engineers responsible for Improvado's transformation layer: SQL DataMarts, custom pipelines, and analytics products (Martech Recipes, Attribution/MMM, DataPrep) that turn raw marketing data into clean, client-ready datasets. As Senior AI Analyst, you'll own technical delivery on complex client accounts, build and automate analytics workflows, and drive product quality through a combination of deep SQL expertise and applied AI. This is a hands-on individual contributor role — you'll be writing transformation logic, building automation, and directly solving hard problems, not coordinating from a distance.

Responsibilities

• Own end-to-end delivery on complex client implementations: SQL DataMarts, custom pipelines, Martech Recipes, Attribution, and DataPrep
• Build and maintain automated analytics workflows using AI tools, scripting, and modern data stack
• Troubleshoot and resolve production data pipeline issues, including direct client-facing escalations
• Identify opportunities to replace manual processes with scalable, AI-driven solutions
• Collaborate with Product, BI, and CSM/TCS teams on architecture decisions and client data requirements
• Contribute to SOPs and documentation for transformation processes

Qualifications

• Demonstrated experience applying AI tools to automate analytics or data workflows: Claude Code, prompt engineering, agentic coding to accelerate development, write tests, optimize complex problems, and ship faster
• Build and scale an AI agent and be able to make it reliable
• Product ownership mindset — able to take a problem end-to-end with minimal hand-holding
• Strong SQL skills required; dbt or similar transformation-tooling experience strongly preferred
• Hands-on ETL/ELT pipeline experience (BigQuery, Snowflake, Redshift, or ClickHouse)
• Experience troubleshooting production data pipelines and resolving data quality issues
• Marketing or revenue data domain experience
• Availability to work full US Eastern Time (ET) hours

Nice to have

• Python for data processing and automation
• Experience working directly with clients on technical requirements
• BI tools (e.g., Superset) for operational reporting

Benefits

• Remote-first environment
• Strong product/market fit: marketing data product for US-based enterprises
• 20 working days of PTO per year
• US holidays and additional days off
• Professional development reimbursement