Data Engineer, AI & Analytics

📋 Description

• Own core data foundation: ingestion, modeling, data marts for agency, clients, and AI needs.
• Build robust ingestion handling API changes and rate limits without breaking downstream.
• Model across sources to reconcile spend, impressions, conversions, and revenue.
• Contribute to client-specific and core data solutions; extend patterns rather than fork.
• Develop semantic layers and metrics for AI-ready SQL results.
• Adopt AI agentic workflows to accelerate data infrastructure development.

🎯 Requirements

• 3+ years in data or analytics engineering; 1+ year owning a dbt project in production.
• Advanced Python and SQL for production pipelines and modeling.
• Deep dbt expertise: tests, snapshots, materializations, Jinja/macros.
• Strong Snowflake proficiency and cloud data stack autonomy.
• Multi-tenant experience; know when client requests belong in core vs client layer.
• Experience with marketing datasets, UTMs, attribution windows, and warehouse reporting gaps.

🎁 Benefits

• Power Digital is an Equal Opportunity Employer valuing diverse backgrounds and experiences.
• Collaborative culture focused on growth, innovation, and results.