Data Engineer, Advertising Measurement Attribution

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, our Builders and Translators architect the systems and models that turn raw data into action and innovation. We unify, activate, and illuminate performance so the entire agency can think smarter, make better decisions, and move faster. WHAT YOU’LL DO As a Data Engineer focused on Advertising Measurement & Attribution, you will build the data infrastructure and analytical models that help us understand how media exposure translates into measurable business outcomes. You will work across large, complex datasets from multiple sources, designing intentional data models that enable measurement, attribution, reporting, and media optimization. This role requires more than executing predefined transformations. You will need to understand the analytical question behind the data, work through ambiguity, identify the right assumptions and business rules, and translate complex information into reliable datasets that teams can use to make better decisions. Strong SQL and analytical reasoning are at the center of this role. You will also work extensively with Snowflake and dbt while using modern AI-assisted development tools to accelerate research, implementation, debugging, testing, documentation, and analysis. AI can accelerate the work, but you remain accountable for understanding, validating, and ensuring the quality of what you build. Key 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. The data products you create will help our teams answer questions such as: - Which media exposures are associated with conversions? - How should conversions be attributed to media activity? - How did a campaign perform across channels, placements, or audiences? - What happened after a user or household was exposed to an advertisement? - How should data from different measurement systems be reconciled? - Which datasets should be considered authoritative when sources disagree? - How should high-volume event and exposure data be modeled so analysts can efficiently uncover meaningful insights? WHAT YOU’LL BRING Experience & Technical Expertise - 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. - Advertising, media, marketing, attribution, or measurement experience is strongly preferred. - Experience with event-level or impression-level datasets is particularly valuable. - Experience joining datasets with different grains, keys, and identifiers is highly valuable. - Familiarity with advertising attribution or measurement methodologies is a plus. Capabilities - 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. 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 craft and sound judgment to your work, using data, insight, and expertise to produce reliable, high-quality outcomes. You investigate the why behind the data and build solutions people can trust. - Clarity | You organize technical thinking, documentation, and outputs in a way that makes complex information easy to understand and act on. You make assumptions, definitions, and tradeoffs visible. - Connection | You work effectively across teams and disciplines, translating business needs into technical solutions and contributing to shared outcomes through alignment, transparency, and collaboration. - Care | You demonstrate accountability and professionalism, recognizing that the quality and integrity of the data you build directly affects clients, colleagues, and business decisions. - Culture & Character | You take ownership of your growth, approach challenges with curiosity, use new technology thoughtfully, and contribute positively to the standards and expectations of the team. Together, these behaviors define what it means to do great work here, 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 to make better decisions possible. 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 $100,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 that gives you time to bond with your family - Hybrid work model with in-office collaboration - 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 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, Wednesday, and Thursday, to fully experience the energy of our teams and build meaningful connections. Candidates must reside in and be able to commute to one of the following office locations three days a week. - Irvington, New York 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.