Data Engineer, Marketing Science
New
P
Power DigitalMarketing analytics
Remote - MexicoFull-TimeMiddle
SalaryBase salary paid in USD + commission opportunities
Apply NowOpens the employer's application page
Job Details
- Languages
- Proficiency in spoken and written English at an advanced level is required for this role.
- Experience
- 3+ years in data or analytics engineering, including 1+ year owning a production dbt project of meaningful size.
- Required Skills
- PythonSQLGitShopifySnowflakeCI/CDdbt
Requirements
- Have 3+ years in data or analytics engineering.
- Have 1+ year owning a production dbt project of meaningful size.
- Demonstrate advanced SQL and Python skills and production-grade pipeline coding.
- Bring deep dbt expertise, including incremental models, full refreshes, Jinja, macros, tests, snapshots, source freshness, exposures, and DAG management.
- Have strong Snowflake skills, including semi-structured/VARIANT data, dynamic per-client queries, query and cost tuning, and permissions across separate client databases.
- Have hands-on marketing and ecommerce data experience, including ad-platform APIs, UTMs, attribution windows, conversions, and Shopify order and refund logic.
- Understand measurement-model data needs, including continuous time series, consistent granularity, stable channel definitions, and sufficient history.
- Have experience building multi-client data models and deciding which logic belongs in a shared core or client layer.
- Have Git and CI/CD experience with automated testing.
- Have adopted AI-assisted development workflows.
- Be comfortable shipping iteratively based on feedback from analysts and app users.
- Have advanced spoken and written English proficiency.
Responsibilities
- Own the MMM data layer in Snowflake and build model-ready daily and weekly marts for each client.
- Build geo-level media and sales tables for MMT across platforms and CMS, CRM, Amazon, and retail datasets.
- Automate Snowflake/dbt data quality tests and alerts for gaps, anomalies, duplicates, drift, and source freshness.
- Maintain structured, versioned model logs and exported model outputs.
- Support onboarding of new measurement clients by mapping data feeds and checking data history and quality.
- Write client-specific overrides, channel mappings, and marts, and determine whether logic belongs in the shared core or client layer.
- Use AI coding tools and document effective patterns for team adoption.
View Full Description & ApplyYou'll be redirected to the employer's site