Data Engineer, AI & Analytics
Power Digital2 months ago
Colombia (city not specified)Mid Level
Responsibilities
- Design, build, and maintain ingestion pipelines, data models, data marts, and serving layers for agency, client, internal, and AI consumers.
- Handle advertising-platform API changes, deprecated fields, rate limits, and retroactive conversion restatements without corrupting downstream models.
- Reconcile spend, impressions, conversions, and revenue across Meta, Google, TikTok, Amazon, LinkedIn, and Microsoft, with customer-level joins across Shopify, Klaviyo, GA4, and client CRMs.
- Build client-specific models, overrides, and marts that extend the shared data foundation without creating unnecessary forks.
- Create semantic layers and metric definitions that support consistent AI-generated SQL results.
- Use AI-agentic coding workflows to accelerate development and document reusable team patterns.
- Collaborate with product, engineering, AI/innovation, client, BI, tagging and tracking, and data operations teams.
- Monitor data quality and optimize multi-client pipelines for cost, performance, and reliability.
Requirements
- At least 3 years of experience in data or analytics engineering, including at least 1 year owning a meaningful dbt project in production.
- Advanced Python and SQL proficiency for production-grade pipeline and modeling work.
- Deep dbt expertise, including incremental strategies, full-refresh tradeoffs, Jinja, macros, packages, tests, snapshots, source freshness, exposures, DAG management, and materializations.
- Strong Snowflake expertise and familiarity with the surrounding cloud data stack.
- Experience modeling in multi-tenant environments and managing shared versus client-specific data layers.
- Working knowledge of marketing and advertising data, including UTMs, attribution windows, and platform-versus-warehouse conversion differences.
- Experience managing end-to-end data lifecycles from ingestion through serving for BI and AI applications.
- Familiarity with GCP and infrastructure-as-code principles.
- Practical experience using Cursor, Claude Code, or GitHub Copilot for coding, debugging, and architecture.
- Experience architecting AI-ready data models, including feature stores and semantic layers.
- Experience with Git, automated testing, and CI/CD practices.
- Advanced spoken and written English proficiency is required.
- Agency, consultancy, services, measurement, incrementality, media mix modeling, server-side tagging, or retail and marketplace data experience is helpful but not required.
Tech Stack
Categories
Data Engineering
About Power Digital
Power Digital is a privately held marketing services firm that provides SEO, PPC, social, creative, web development, and conversion rate optimization to consumer and ecommerce brands. Founded in 2012 and headquartered in San Diego, it augments client work with nova, a proprietary platform that analyzes first-party data to inform channel and budget decisions. Engagements are typically retainer- or project-based.