Senior Data Engineer ID88015

About the role We are looking for a Senior Data Engineer to lead the replacement of a third-party digital ingestion tool with a custom-built ETL pipeline. This person will document existing logic, evaluate build-vs-buy options such as Fivetran, and build a standalone pipeline within an existing AWS environment. Strong SQL and DSP or programmatic advertising experience are central to this role. What you will do Document current ingestion logic inside the legacy tool (TapClicks), including sources, endpoints, schemas, and transformation logic. Build the ETL pipeline to replace the legacy system, handling ingestion from the Amazon API, other DSP platforms, and related digital data sources. Evaluate and decide between off-the-shelf solutions (e.g., Fivetran) and custom-built ETL systems alongside the Infrastructure Lead. Design the pipeline as a standalone, owned system to power Diray's client-facing dashboards. Provide flexible engineering support for MAT and the Impact Engine application and backend work within the AWS environment when directed. Coordinate with data science teams to ensure ingestion output aligns with the attribution and scoring logic of downstream models. Work seamlessly within the existing AWS environment (ECS, S3, RDS) rather than standing up parallel infrastructure. Must haves 4+ years of strong SQL and large-scale data ingestion/pipeline experience (batch ETL, orchestration, schema design). Direct or adjacent experience with digital advertising / DSP data (e.g., Amazon DSP, Amazon Advertising API, or comparable programmatic platforms). Working knowledge of AWS data services (RDS/Postgres, S3, ECS) sufficient to build within an existing cloud environment. Ability to contribute to application and backend work beyond pure ETL to support broader platform needs. Familiarity with, or ability to quickly evaluate, managed ELT tools (such as Fivetran) against custom builds. Ability to ramp into existing attribution and scoring logic so ingestion output aligns with downstream dashboard needs. Upper-intermediate English level. Nice to haves Experience replacing legacy third-party data pipelines with owned, custom infrastructure. Familiarity with MLOps pipelines and how data feeds predictive models. Experience working alongside part-time technical advisory leads to validate architecture decisions. Perks and benefits Growth without limits: build your skills through mentorship, internal TechTalks, challenging projects, and a dedicated annual learning budget Competitive compensation: get recognition that reflects your skills and impact, with regular performance and compensation reviews Flexibility: work 100% remotely with flexible hours that support focus, autonomy, and a healthy work rhythm Meaningful, modern projects: build impactful products using modern technologies alongside global teams and leading brands Collaborative culture: join a supportive environment with zero micromanagement where ideas are welcomed and contributions are recognized Well-being & support: access local well-being programs and people-focused support tailored to your location Job Type: Full-time Work Location: Remote