Data Engineer

Attention Arc•Irvington, NY

7h•$90,000 - $120,000•Hybrid

About The Position

As part of our Technology & Analytics team, the Builders and Translators, you help design the systems that turn complexity into clarity and data into action. Your work connects strategy to execution, ensuring our insights are scalable, reliable, and ready to move the business forward. In this role, you will modernize the infrastructure that powers planning, activation, attribution, and optimization across the agency, building systems that make teams faster, smarter, and more connected. As a Data Engineer, you will play a hands-on role in building, modernizing, and maintaining the data infrastructure that powers Attention Arc's media and analytics ecosystem. This role requires deep experience working with advertising technology and data across Google Marketing Platform, specifically Display & Video 360 (DV360) and Campaign Manager 360 (CM360). You will partner across disciplines to build scalable systems, improve workflows, and ensure media data moves efficiently from activation through reporting, attribution, and optimization. This is not a general data engineering role. We're looking for someone who understands how advertising data flows through a media agency and has firsthand experience supporting media teams, campaign reporting, measurement, and attribution.

Requirements

2 to 5 years of experience in Data Engineering, ETL Engineering, Database Development, or a similar technical role within a digital media agency, advertising agency, or advertising technology organization.
Hands-on experience with both Display & Video 360 (DV360) and Campaign Manager 360 (CM360) is required.
Previous experience supporting digital advertising data, campaign reporting, media measurement, attribution, and analytics within a media agency environment is required.
Strong command of SQL with hands-on experience in Microsoft SQL Server environments.
Proven experience designing, building, and maintaining ETL/ELT pipelines and orchestrated workflows.
Strong understanding of relational and dimensional data modeling principles.
Experience working with Snowflake data warehouse environments, including data modeling, pipeline integration, performance optimization, and scalable analytics workflows.
Familiarity with modern cloud-based data architecture and migration strategies, including Snowflake best practices for data transformation, orchestration, and governance.
Working knowledge of Python, PowerShell, or similar scripting languages for automation and workflow optimization.
Familiarity with JavaScript as it relates to tagging, tracking, and data collection implementations.
Experience working across Linux and Windows server environments.
Strong understanding of data quality, system reliability, and technical documentation best practices.
Ability to communicate technical concepts clearly to technical and non-technical stakeholders.

Nice To Haves

Experience modernizing or refactoring legacy SSIS-based workflows.
Experience with SSAS, SSIS, or SSRS.
Experience with Google Ads, Search Ads 360 (SA360), Google Analytics 4 (GA4), or additional Google Marketing Platform products.
Experience integrating APIs from advertising and marketing technology platforms.
Exposure to Azure or AWS cloud platforms.
Experience supporting machine learning or advanced analytics workflows.
Familiarity with tag management systems, CDNs, identity solutions, or marketing pixel infrastructure.
Relevant technical certifications such as Microsoft Azure, Snowflake, MCSE, or MCSA.

Responsibilities

Design, build, and maintain scalable ETL/ELT pipelines that ingest and process data from internal systems, media platforms, and third-party vendors.
Build, maintain, and optimize data pipelines that ingest, transform, and reconcile data from Display & Video 360 (DV360), Campaign Manager 360 (CM360), and other digital advertising platforms.
Design scalable integrations between Google Marketing Platform products, internal data warehouses, and reporting solutions that support campaign performance, attribution, optimization, and business intelligence.
Partner closely with Media, Ad Operations, Analytics, and Technology teams to ensure advertising platform data is accurate, complete, and available for business decision making.
Troubleshoot data discrepancies across trafficking, ad serving, media buying, and reporting platforms.
Refactor and modernize legacy workflows to reduce complexity, improve reliability, and streamline onboarding and maintenance.
Standardize data pipelines and integration frameworks to support scalable and repeatable client implementations.
Manage and optimize workflow orchestration tools, including Airflow and related automation frameworks.
Develop and maintain high-performance relational and analytical data models that support reporting, planning, optimization, and attribution.
Build and support Microsoft SQL Server environments and integrations with internal and external systems.
Ensure best practices for database security, backup and recovery, performance monitoring, and data quality.
Create and maintain reporting tables, views, and data structures used across the agency.
Support tracking, tagging, and measurement infrastructure, including JavaScript implementations and vendor pixel management.
Partner with vendors and internal stakeholders to troubleshoot attribution and measurement solutions.
Support privacy-conscious measurement strategies, identity frameworks, and evolving advertising technologies.
Automate repetitive workflows using scripting, orchestration, and tooling solutions to improve efficiency and consistency.
Evaluate emerging cloud technologies and modern data platforms to improve scalability and business impact.
Collaborate closely with analysts, planners, activation teams, developers, and client teams to translate business needs into technical solutions.
Establish and document best practices for data engineering, systems architecture, and workflow design.
Maintain clear technical documentation and communicate effectively with both technical and non-technical stakeholders.