Senior Data Platform Engineer, AWS

This is a fully remote position, open to applicants in Colombia, +1 more country.

📋 Description

• Take charge of the data associated with a campaign-management platform that oversees paid search and social media campaigns across Google Ads and Meta accounts for automotive dealerships.

• Develop the Salesforce budget synchronization, encompassing budget line items and enrollments, maintaining strict separation of budget families, and preventing campaigns from running without corresponding line items.

• Create the dealer crosswalk, linking dealers to Google Ads, Meta, Salesforce, and inventory-feed records, featuring exception reporting and automatic onboarding processes.

• Ingest daily VIN-level inventory from Snowflake, along with offers from S3 and an offers API, as well as manufacturer enrollment files, ensuring freshness and completeness checks.

• Establish data contracts with the client’s data team and utilize shared platform-pod contracts where relevant.

• Develop pacing detection using the current-day ad-platform spending and month-end projections.

• Construct the Incentive Sync engine, validating offers against manufacturer rules and ensuring expired offers are removed precisely once.

• Model manufacturer rules, allowed values, and model lineups as versioned, effective-dated data.

• Provide dealer and inventory data to the playbook renderer and support inventory-driven campaign selection.

• Design migration-wave orchestration and an evidence pipeline that includes aggregates, ID checks, settings differences, tracking audits, and zero-spend checks.

• Produce pilot-wave data in month five, along with scorecards for client approval.

• Manage the data components of five production waves, including budget binding, settings carryover, tracking audits, and pacing calibration.

• Oversee production operations during migration, including observability, incident response, API quota monitoring, and rollback drills.

• Transfer pipelines, runbooks, environments, and data contracts to the client’s teams and verify the handover by having them run it.

• Document decision records, runbooks, and relevant documentation while collaborating with client engineers.

• Facilitate data working sessions with the client’s data team and Salesforce administrators.

• Make reversible data design decisions in the absence of the Solutions Architect, document these decisions, and present them for review.

• Prepare the data component of wave sign-off packs and act as the primary responder for migration data issues.

• Identify blockers early and document them in writing with assessments of schedule, scope, or quality impacts.

⛳️ Requirements

• A minimum of six years of experience in building and managing production data or integration systems.

• Experience with production Salesforce integration: custom objects, SOQL, bulk reads, and change detection.

• Proficiency in Snowflake extracts, S3 file feeds, REST APIs, and employing a pipeline orchestrator on AWS.

• Expertise in data quality and identity resolution: conducting freshness checks, reconciling between systems, generating actionable exception reports, and halting work when a match is uncertain.

• Familiarity with spend or financial calculations supported by scenario-based automated tests.

• Experience with bulk operations that can tolerate partial failures and operate idempotently.

• Knowledge of production operations on AWS: managing incidents, monitoring, quotas, runbooks, and infrastructure as code.

• Strong experience with Azure is acceptable if a demonstrated method for transitioning to AWS is available.

• Solid skills in SQL, production Python or PHP, and secure management of production credentials.

• Daily utilization of AI coding tools with rigorous review practices: testing and rejecting generated code, and recognizing the limitations of these tools.

• Proficiency in clear written and spoken English.

• Comfort in presenting work to US client stakeholders.

• Preferred: Experience with Google Ads or Meta Marketing API reporting, including provisional spending and rate limits.

• Preferred: Familiarity with Merchant Center or Meta catalogs, or vehicle listing and automotive inventory ads.

• Preferred: Knowledge of PHP and Laravel.

• Preferred: Understanding of automotive retail data: VIN-level inventory, manufacturer incentive programs, and dealer data.

• Preferred: Experience in ad operations, live migrations with a tested rollback plan, rules engines, or containers on AWS.

🏝️ Benefits

• Complete Gorilla Logic's internal AI engineering training prior to commencing work in the client’s environment.

• Utilize approved AI delivery tools under the client's least-privilege credentials.

• Review every AI-generated artifact before it is integrated into the codebase or deliverable.

• Ensure client code or data is never used to train a model.