Data Engineer, Advertising Measurement Attribution

Attention Arc is hiring a Data Engineer focused on Advertising Measurement & Attribution to build data infrastructure and analytical models that connect media exposure with measurable business outcomes. The role integrates and reconciles complex data from multiple sources, develops reliable SQL and dbt transformations in Snowflake, and supports measurement, attribution, reporting, and media optimization.

Responsibilities

• Build and maintain data models that support advertising measurement, attribution, reporting, and media optimization
• Transform, integrate, and reconcile data from multiple platforms, systems, and measurement sources
• Develop sophisticated SQL transformations across large analytical datasets
• Build and maintain dbt models, tests, documentation, dependencies, and data-quality controls
• Use Snowflake to store, transform, analyze, and serve analytical data at scale
• Design data models that make complex source data understandable, efficient, and actionable for downstream users
• Translate business, media, and measurement requirements into concrete datasets, definitions, and transformations
• Investigate ambiguous data challenges and determine appropriate assumptions, definitions, joins, business rules, and modeling approaches
• Diagnose unexpected data and determine whether issues originate from source data, business logic, transformations, joins, or model design
• Analyze relationships between media exposure and downstream outcomes to support measurement and optimization
• Work with datasets at different grains and across different identifiers, including event-level and impression-level data
• Reconcile multiple sources representing similar business events and establish clear approaches when sources disagree
• Partner with analytics, media, technology, and other agency teams to ensure data products answer the right business questions
• Use AI-assisted development tools thoughtfully to explore solutions, debug issues, generate documentation and test cases, and identify potential edge cases
• Review and validate AI-generated outputs rather than treating them as inherently correct
• Document technical decisions, assumptions, dependencies, and data models so others can understand and confidently use what you build

Preferred

• Advertising, media, marketing, attribution, or measurement experience is strongly preferred
• Familiarity with advertising attribution or measurement methodologies is a plus
• Advertising
• Marketing
• Advertising Attribution
• Attribution Methodologies
• Measurement Methodologies

Benefits

• Flexible Paid Time Off
• Comprehensive Medical, Dental, and Vision plans
• Competitive Parental Leave that gives you time to bond with your family
• Hybrid work model with in-office collaboration; employees are expected to work from the Irvington office three days per week, Tuesday, Wednesday, and Thursday.
• Mental health support
• Annual agency contribution to 401(k)
• Flexible Spending Accounts and Healthcare FSA
• Commuter benefits and corporate discounts
• Carrot Fertility and family-building support
• Employee Assistance Program
• Casual work environment, team building, and other social events
• Ongoing feedback, development, and opportunities to take on more to support career growth

Company

• Media agency optimizing brand media decisions for measurable growth.
• Durham, North Carolina, USA
• https://attentionarc.com/
• 51-200 employees

Qualifications

• 3+ years of experience in data engineering, analytics engineering, data analytics, or a related technical discipline
• Advanced SQL skills and the ability to reason through complex analytical data problems
• Strong understanding of relational databases, analytical data warehouses, and data-modeling concepts
• Experience designing analytical data models around business questions and downstream use cases
• Experience working with large, complex datasets from multiple sources
• Practical experience with Snowflake or a comparable modern cloud data warehouse
• Experience building SQL-based transformations and data workflows using dbt or a comparable framework
• Working knowledge of Python for data processing, pipeline development, automation, or analytical workflows
• Experience with Git, code review, testing, and other software-development fundamentals
• Experience working with APIs, JSON, or other semi-structured data
• Understanding of data-quality testing, validation, and monitoring practices
• Experience with BI, reporting, or analytical tools and an understanding of how downstream teams consume modeled data
• Experience with event-level or impression-level datasets
• Experience joining datasets with different grains, keys, and identifiers
• Strong analytical thinking with the ability to break complex or ambiguous problems into clear, solvable components
• Ability to identify assumptions, unanswered questions, dependencies, and potential data-quality risks before they become downstream issues
• Sound judgment when determining how data should be modeled, reconciled, and interpreted
• Ability to understand the business question behind a technical request rather than simply implementing instructions
• Clear communication skills and the ability to explain technical decisions to both technical and non-technical stakeholders
• Strong organization and attention to detail, particularly when working with complex dependencies and large datasets
• Comfort working independently while knowing when to bring others into the problem
• Curiosity about unfamiliar technologies, datasets, business questions, and alternative approaches
• A mindset of continuous testing, learning, and optimization
• 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
• Advertising, media, marketing, attribution, or measurement experience is strongly preferred
• Familiarity with advertising attribution or measurement methodologies is a plus
• 3+ years of experience in data engineering, analytics engineering, data analytics, or a related technical discipline.

Required skills

• APIs, Advertising Measurement and Attribution, Analytical Data Warehousing, Data Modeling, Data Quality Testing and Validation, Git, JSON and Semi-Structured Data, Python, Relational Databases, SQL, Snowflake, dbt

Preferred skills

• Analytical Problem-Solving

Experience

• 3+ years