
Data Engineer, Marketing Science
Power Digital14 hours ago
Remote, BrazilMid Level
Responsibilities
- Own and maintain Snowflake data marts for MMM, including paid media, ecommerce, site, email/SMS, and non-media drivers.
- Build and maintain DMA, state, and ZIP-level MMT media and sales tables across major advertising, ecommerce, CRM, CMS, and retail data sources.
- Automate Snowflake and dbt data quality tests and alerts for gaps, duplicates, freshness issues, outliers, reconciliation problems, and other measurement risks.
- 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.
- Develop client-specific overrides, channel mappings, and marts while deciding what logic belongs in shared or client-specific layers.
- Use and document AI-assisted coding workflows and collaborate iteratively with analysts and application users.
- Meet defined KPIs for measurement coverage, data quality, pipeline reliability, onboarding speed, client requests, and reusable AI-assisted development patterns.
Requirements
- At least 3 years of experience in data or analytics engineering, including at least 1 year owning a meaningful production dbt project.
- 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 experience with semi-structured and VARIANT data, dynamic per-client queries, query and cost tuning, and permissions across separate client databases.
- Hands-on experience with marketing and ecommerce data, including ad-platform APIs, UTMs, attribution windows, conversion reconciliation, and Shopify orders and refunds.
- Understanding of the data requirements of measurement models, including continuous time series, consistent granularity, stable channels, and sufficient history.
- Experience building multi-client data models and deciding when logic belongs in shared or client-specific layers.
- Experience with Git and automated testing in CI/CD workflows.
- Demonstrated adoption of AI-assisted development workflows.
- Comfort shipping iteratively based on feedback from analysts and app users.
- Helpful qualifications include MMM or incrementality experience with Meridian, Robyn, PyMC-Marketing, synthetic control, causal impact, or geo-lift; geographic data experience; Hex or similar BI/notebook experience; and agency, consultancy, or martech experience.
- Advanced spoken and written English proficiency is required.
Benefits
- Base salary paid in USD with commission opportunities; no specific salary amount is stated.
- Unlimited time off available from day one.
- Fully flexible work environment with full-remote, in-office, or hybrid options.
- Offices are available in Buenos Aires, Medellin, San Diego, New York, and Atlanta.
- $50-per-month healthcare stipend.
- National holidays and two mental health recharge days per year.
- Growth and leadership opportunities plus ongoing employee development programs.
- Quarterly awards with prize money and recognition.
- Opportunities to participate in company 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.