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 help 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 supports Attention Arc’s media and analytics ecosystem. You will partner across disciplines to create scalable systems, improve workflows, and ensure data can move efficiently from source to insight.

Key Responsibilities:

• Design, build, and maintain scalable ETL/ELT pipelines that ingest and process data from internal systems, media platforms, and third-party vendors
• 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, and optimization workflows
• Build and support Microsoft SQL Server environments and integrations with internal and external systems
• Ensure best practices for database security, backup and recovery processes, 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-based implementations and vendor pixel management
• Partner with vendors and internal stakeholders to troubleshoot attribution and measurement solutions
• Support privacy-conscious data and measurement strategies, including modern attribution and identity frameworks
• Automate repetitive workflows using scripting, orchestration, and tooling solutions to improve efficiency and consistency
• Evaluate emerging platforms and technologies, including cloud services and modern data warehousing solutions, to assess scalability and business impact
• Collaborate closely with analysts, planners, 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

• 2–5 years of experience in data engineering, ETL engineering, database development, or related technical roles
• 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 scripting languages such as Python or PowerShell for automation and workflow optimization
• Familiarity with JavaScript in the context of tagging, tracking, or 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 and effectively to cross-functional stakeholders

Nice to Have

• Experience modernizing or refactoring legacy SSIS-based workflows
• Exposure to cloud platforms such as Azure or AWS
• Experience with SSAS, SSIS, or SSRS
• Understanding of digital media data, attribution, and analytics ecosystems
• Experience supporting machine learning or advanced analytics workflows
• Familiarity with tag management systems, CDNs, or marketing pixel infrastructure
• Relevant technical certifications such as MCSE or MCSA

Capabilities

• Strong analytical thinking and structured problem-solving skills
• Ability to balance technical precision with practical business impact
• Effective communication and documentation skills
• Collaborative mindset with strong cross-functional partnership abilities
• Strong organizational skills and attention to detail
• Curiosity and willingness to continuously learn and explore emerging technologies

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, 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 tech-enabled.

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 $75,000 – $90,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. We’re committed to making sure everyone at Attention Arc has what they need to thrive, not just professionally, but personally.

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, 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 Irvington, New York three days a 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.