
Data Engineer, Marketing Science
Power Digital14 hours ago
Remote, ColombiaMid Level
Responsibilities
- Build and maintain Snowflake data marts for MMM, combining paid media, ecommerce, site, email/SMS, and other marketing drivers with consistent channel, currency, and timezone definitions.
- Build geographic media and sales tables at DMA, state, and zip levels across major advertising, commerce, CRM, CMS, and retail data sources for MMT workflows.
- Automate Snowflake and dbt data quality tests and alerts covering gaps, spend and revenue anomalies, duplicates, unmatched markets, outliers, restatements, and source freshness.
- Maintain versioned model logs and exported outputs such as contributions, response curves, adstock, and optimization results.
- Support measurement-client onboarding by mapping feeds, validating history and data quality, and identifying gaps before modeling begins.
- Develop client-specific overrides, channel mappings, and marts while deciding what belongs in the shared core versus a client layer.
- Use and document AI-assisted coding workflows for production development.
- Support data requests from analysts, app users, and clients and iteratively improve measurement data systems.
Requirements
- 3+ years of experience in data or analytics engineering, including 1+ year owning a production dbt project of meaningful size.
- Advanced SQL and Python skills with production-grade pipeline development experience.
- Deep dbt expertise, including incremental models, full refreshes, Jinja, macros, tests, snapshots, source freshness, exposures, and DAG management.
- Strong Snowflake skills, including semi-structured and VARIANT data, dynamic per-client queries, query and cost tuning, and permissions across separate client databases.
- Hands-on marketing and ecommerce data experience with ad-platform APIs, UTMs, attribution windows, conversion reconciliation, and Shopify order and refund logic.
- Understanding of measurement-data requirements such as continuous time series, consistent granularity, stable channel definitions, sufficient history, and data-quality impacts on models.
- Experience building multi-client data models and determining when logic belongs in shared or client-specific layers.
- Experience with Git and automated testing workflows.
- Experience adopting AI-assisted development workflows.
- Comfort shipping iteratively based on analyst and app-user feedback.
- Advanced spoken and written English proficiency.
- Preferred experience with MMM or incrementality tools and methods such as Meridian, Robyn, PyMC-Marketing, synthetic control, causal impact, or geo-lift.
- Preferred experience with DMA and zip mappings, population and market-size data, Hex, similar BI or notebook tools, or agency, consultancy, or martech environments.
Benefits
- Fully flexible work environment with full-remote, in-office, or hybrid options.
- 15 paid vacation days per year.
- Up to 4 hours per quarter of paid Volunteer Time Off.
- Prepaid medical plan and Employee Assistance Program.
- 17 observed Colombian national holidays plus 2 mental health recharge days per year.
- Legal benefits including Prima and Cesantias, plus paid Social Security.
- One-time 320.000 COP work-from-home stipend added to the first paycheck.
- Employee development programs, growth and leadership opportunities, quarterly awards, and participation in DEI initiatives.
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.