Back to jobs

Data Engineer

Irvington, New York

Technology & Analytics | The Builders and Translators

We are a 1,000-piece puzzle.

Each of us is essential, interconnected, and intentionally designed. Together we create something powerful: media that matters, growth that lasts, and a culture we are proud to build.

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.

WHAT YOU'LL DO

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.

Key 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.

WHAT YOU'LL BRING

Experience & Technical Expertise

Required Qualifications

  • 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 Have

  • 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.

Capabilities

  • Strong analytical thinking and structured problem-solving skills.

  • Ability to balance technical excellence with practical business outcomes.

  • Excellent communication and documentation skills.

  • Collaborative mindset with strong cross-functional partnership abilities.

  • Strong organizational skills and attention to detail.

  • Curiosity and a passion for learning emerging technologies.

  • Ability to prioritize work in a fast-paced agency environment while supporting multiple concurrent initiatives.

WHO YOU ARE

At Attention Arc, how you work is just as important as what you deliver. Our core competencies define the skills and behaviors that drive strong performance and meaningful impact.

Credibility

You apply strong technical expertise and sound judgment to build reliable, scalable systems that teams trust and depend on.

Clarity

You simplify complexity by organizing systems, workflows, and communication in ways that make information easier to understand and act on.

Connection

You collaborate openly across disciplines, building trust through transparency, responsiveness, and a shared commitment to solving problems together.

Care

You approach your work with accountability, integrity, and empathy, considering how your systems and decisions impact both teammates and clients.

Culture & Character

You bring curiosity, ownership, consistency, and a growth mindset to your work, contributing positively to the standards and culture of the team.

Together, these behaviors define what it means to do great work here by building trust, driving impact, and creating a culture where people and ideas thrive.

WHO WE ARE

We're a media agency built for brands that value intention. At Attention Arc, we combine deliberate media craft with technology designed to amplify it. We build trusted partnerships so every decision stays aligned with what matters most. Media doesn't fail because of technology. It fails when intention is missing.

That's why we exist.

To restore intention to media.

At 160 people across four offices in Phoenix, Durham, Irvington, and New York City, we occupy a deliberate sweet spot: big enough to handle major brands and complex business, nimble enough to actually move, make decisions, and drive impact. No unnecessary layers. No slow-moving bureaucracy. Just sharp thinking, fast execution, and technology built around people.

Our culture is shaped by our values:

  • All In | We show up with intensity and ownership.

  • No Sidelines | We collaborate without ego or boundaries.

  • Move With Curiosity | We ask why, explore boldly, and learn fast.

  • Truth With Heart | We communicate with honesty and empathy.

OUR COMMITMENT TO INCLUSION

At Attention Arc, we believe people do their best work when they feel they belong. Inclusion isn't just about representation. It's about creating an environment where people feel seen, supported, and comfortable showing up as themselves.

We value different lived experiences and perspectives and actively create space for those voices to shape our work. We're committed to building an agency where everyone has a genuine seat at the table and is trusted to step in and contribute, fostering collaboration, encouraging curiosity, and creating opportunities for people to take ownership and make an impact.

Because when people feel heard, respected, and confident to step forward, we all move forward together.

WHAT WE OFFER

Compensation: The estimated range for this role is $90,000 to $120,000. Compensation packages are based on the skill level and experience each candidate brings to the role.

We're committed to rewarding our people fairly and supporting their growth with intention. Our salaries are competitive, thoughtfully benchmarked, and designed to ensure equity across roles, experience, and impact. Growth at Attention Arc isn't tied to a calendar. It's driven by performance, progress, and potential. We continuously invest in our people through ongoing feedback, development, and opportunities to take on more, so you can keep building your career in meaningful ways.

We know that great work starts with people who feel genuinely supported, inside the office and out. Our benefits are designed with your whole self in mind: your health, your family, your financial future, and your wellbeing day to day.

Here's what you can expect:

  • Flexible Paid Time Off

  • Comprehensive Medical, Dental, and Vision plans

  • Competitive Parental Leave

  • Hybrid work model with in-office collaboration

  • Mental health support

  • Annual agency contribution to 401(k)

  • Flexible Spending Accounts (FSAs) and Healthcare FSA

  • Commuter benefits and corporate discounts

  • Carrot Fertility and family-building support

  • Employee Assistance Program (EAP)

  • Casual work environment, team building, and social events

LOCATION

We operate on a hybrid, in-office model designed to foster collaboration, mentorship, and hands-on learning. Employees are expected to work from the office three days per week, Tuesday through Thursday, to fully experience the energy of our teams and build meaningful connections.

Candidates must reside in and be able to commute to Irvington, New York three days per week.

RIGHT TO WORK IN THE US

You must be authorized to work in the United States for any employer. At this time, we are not sponsoring or providing assistance with obtaining work authorization.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Attention Arc’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.