
Data Engineer, Marketing Science
Posted 5 hours ago

Posted 5 hours ago
This is a fully remote position, open to applicants in Colombia.
• Take ownership of the MMM data layer in Snowflake by developing and sustaining model-ready daily and weekly client marts that integrate paid media, ecommerce, site, email/SMS, and non-media data.
• Manage the MMT geographic data layer by constructing media and sales tables at the DMA/Comscore, state, and ZIP code levels across major platforms and data sources.
• Create and automate data-quality tests and alerts in Snowflake/dbt to identify gaps, zero activity, mismatches, duplicates, outliers, restatement drift, and source freshness.
• Maintain organized, versioned model logs and exported outputs that include contributions, response curves, adstock, and optimization results.
• Assist in the onboarding of new measurement clients by mapping feeds, verifying historical data and quality, and flagging any gaps prior to modeling.
• Address client-specific data requirements through overrides, channel mappings, and marts while determining the balance between shared-core and client-layer logic.
• Utilize AI coding tools such as Claude Code, Cursor, Copilot, and Hex's AI agent, while documenting reusable patterns.
• Collaborate with the Data Team to support, maintain, and engineer measurement and marketing-metric data sources.
• Ensure the delivery of clean, model-ready data and prevent data issues from impacting models or test readouts.
• Minimum of 3 years in data or analytics engineering, including at least 1 year managing a production dbt project of significant size.
• Proficient in SQL and Python, with experience in writing production-grade pipeline code.
• Extensive dbt knowledge: understanding of incremental models versus full refreshes, Jinja and macros, tests, snapshots, source freshness, exposures, and managing a large Directed Acyclic Graph (DAG).
• Strong expertise in Snowflake: working with semi-structured/VARIANT data, creating dynamic per-client queries, optimizing queries and costs, and managing permissions across separate client databases.
• Practical experience with marketing and ecommerce data: familiarity with ad-platform APIs, UTMs, attribution windows, differences between platform-reported and warehouse-reported conversions, and Shopify order and refund logic.
• Knowledge of measurement model data requirements: continuous time series, consistent granularity, stable channel definitions, adequate history, and impacts on data quality.
• Experience in building multi-client data models and determining whether logic should reside in the shared core or a client layer.
• Proficient in Git and CI/CD practices with reliable automated testing.
• Genuine engagement with AI-assisted development workflows.
• Ability to deliver iteratively based on feedback from analysts and application users.
• Advanced proficiency in spoken and written English is mandatory.
• Beneficial but not essential: direct experience with MMM or incrementality; experience with geographic data; familiarity with Hex or similar BI/notebook tools; background in agency, consultancy, or martech sectors.
• Competitive base salary plus commission opportunities.
• Prepaid Medicine Plan.
• 15 days of paid vacation (PTO) each year.
• Up to 4 hours per quarter for paid Volunteer Time Off (VTO) for charitable activities.
• Flexible work environment: fully remote, in-office, or hybrid options available.
• One-time Work From Home (WFH) stipend of 320.000 COP automatically included in your first paycheck.
• Access to an Employee Assistance Program (EAP).
• 17 recognized Colombian national holidays plus 2 mental health recharge days annually.
• Legal benefits such as Prima and Cesantias.
• Paid Social Security contributions.
• Unlimited opportunities for growth and leadership in a rapidly expanding company.
• Continuous employee development programs for both personal and professional advancement (Hedgehog and Vital 5s).
• Quarterly awards that include monetary prizes and recognition for exceptional performance.
• Opportunities to participate in company Diversity, Equity, and Inclusion (DEI) initiatives.
Power Digital Marketing
Power Digital Marketing
Power Digital Marketing
Get handpicked remote jobs straight to your inbox weekly.