Analytics Engineer

This is a fully remote position, open to applicants in Colombia.

📋 Description

• Take ownership of Addi’s marketing data platform, including pipelines and integrations with Braze, AppsFlyer, GTM, Marketplace, and the App.

• Ensure marketing data is reliable, efficient, governed, and self-service by leveraging AI agents as the standard operating procedure.

• Map the marketing data platform from end to end within the first 90 days.

• Document sources, jobs, tables, and integrations for both personnel and AI agents.

• Identify issues and present a prioritized roadmap for improvements.

• Implement tests and alerts for essential marketing pipelines.

• Achieve a minimum of 99% on-time data delivery for key tables and integrations.

• Decrease data incidents by 50% and identify root causes within two business days.

• Launch at least two AI agents or agentic workflows into production by the sixth month.

• Automate recurring marketing data tasks such as audience requests, data quality triage, and documentation maintenance.

• Provide runbooks and enhance deployed agentic workflows.

• Lower the cost or runtime of primary marketing pipelines by at least 30% by the ninth month.

• Eliminate unused or duplicated tables and jobs.

• Maintain a catalog of marketing tables, events, and attributes, including ownership and approval rules.

• Confirm that marketing-tool data originates from official pipelines.

• Collaborate effectively with Marketing, Growth, Marketplace, and both technical and non-technical stakeholders.

⛳️ Requirements

• Demonstrated experience in writing and debugging complex SQL without the assistance of AI.

• Proficient in managing joins at scale, window functions, CTEs, and incremental logic.

• Ability to identify incorrect query results and articulate reasons for discrepancies.

• Experience in creating clean, reusable tables and data marts.

• Proven track record in constructing and operating ELT pipelines on a modern data platform.

• Hands-on experience with dbt, Airflow or similar tools, Git, and conducting code reviews.

• Familiarity with SQL warehouses, notebooks, and scheduled jobs.

• Understanding of catalogs, schemas, tables, and permissions management.

• Experience with tests, monitoring, and alerts; comfortable with on-call duties and root-cause analysis.

• Ability to automate and integrate using Python.

• Experience in creating scripts and API integrations that are user-friendly.

• Daily usage of coding agents such as Claude Code, Codex, Cursor, or similar tools.

• Capability to draft specifications, assign multi-step tasks to agents, and review the outcomes.

• Experience in developing agents or agentic workflows that chain LLM calls with tools such as SQL, APIs, or MCP servers.

• Understanding of agent failure modes, guardrails, and testing with real inputs.

• Experience in validating AI outputs and implementing verification checks.

• Proficient in writing documentation and runbooks that are accessible to teammates and AI agents.

• Ability to translate the needs of Marketing, Growth, and Marketplace into suitable data solutions.

• Capable of managing an independent backlog and delivering results with minimal guidance.

• Strong communication skills with both technical and non-technical audiences.

• Proficiency in English is essential.

• Desirable: experience with marketing tools such as Braze, AppsFlyer, or GTM.

• Desirable: familiarity with reverse ETL or CDP.

• Desirable: expertise in advanced pipeline tools, Spark performance tuning, or a data platform certification.

• Desirable: knowledge of LLM APIs, LiteLLM, or MCP servers.

• Desirable: experience with A/B testing and basic statistical analysis.

• Desirable: understanding of data privacy regulations, including consent, opt-out, and Habeas Data.

• Desirable: experience in AWS and within fintech or regulated industries.

🏝️ Benefits

• Competitive compensation.

• Equity in the company.

• Comprehensive benefits that exceed the basics.

• Flexibility to work remotely.

• Opportunities for professional growth.

• Collaborate with a world-class team.

• Option to opt-out of interview recording without affecting candidacy.

• Feedback will be given regardless of the hiring outcome.