Data Engineer

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.