Account Coordinator, Retail Media (Programmatic)

WHY DEPT®?

We are a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, we create what is next by pioneering ideas, acting fast, and moving further because standing still just is not in our DNA.

We are drawn to people who stay curious, move with intent, and never stop inventing. Our culture runs on three values: better together, relentlessly curious, and get sh*t done. It is how we work, how we grow, and how we make things that matter.

At DEPT®, you will find the freedom to explore, the space to collaborate, and the trust to make a real impact for our clients, for each other, and for the world we are helping to build.

THE ROLE

The Account Coordinator, Retail Media (Programmatic) will be responsible for supporting the Programmatic team with campaigns across Amazon DSP and Walmart DSP. Day-to-day responsibilities include but are not limited to running and formatting performance reports, implementing account tasks and optimizations, building and uploading campaigns, trafficking creative assets, and participating in and taking notes during internal syncs, client meetings, and presentations. 

The Account Coordinator, Retail Media (Programmatic) will learn DEPT®’s best practices for Programmatic Buying while gaining the foundational skills necessary to progress into more advanced roles that will expand on the breadth and depth of knowledge.

QUALIFICATIONS   

• A minimum of 6 months of programmatic marketing experience (ideally with Amazon DSP)
• Strong analytical and reporting skills and knowledge of Microsoft Excel / Google Sheets
• Strong time-management skills and the ability to prioritize to deliver multiple tasks on time
• Strong written and verbal communication skills

Additional things that will impress us: 

• You are an energetic and creative marketing enthusiast; eager to roll up your sleeves and be hands on, learn, and grow in the marketing space
• You are entrepreneurial spirited and a self-starter; able to work both independently and in a team environment
• A desire to stay current with the latest marketing trends

PROFICIENCY EXPECTATIONS

We expect Account Coordinators to develop a solid foundation of programmatic analytical and technical expertise and be proficient in the following:

Proficiency in Programmatic:

Ability to:

• Pull reports at various levels along with the desired columns/metrics and understand the data/results.
• Leverage The Trade Desk, DV360 or another DSP to pull and schedule reports for analysis; identifying trends and developing client reporting summaries  
• Update, monitor, and communicate daily budget pacing and high level performance, including flagging variations or anomalies. Leverages Qontrol (DEPT®’s proprietary automated reporting suite) to create efficiencies and set up live alerts. 
• Organize large volumes of data for insights and strategic storytelling in Excel and/or Google Sheets. Comfort with functions and formulas include but are not limited to; sorting, filters, vlookup, concatenate, pivot tables, text to columns, and conditional formatting.
• Understand relevant media metrics, how to calculate them, and articulate their relationship to each other. Possess a high level understan

Proficiency in Excel/Sheets:

Demonstrate proficiency in using essential spreadsheet functions and formulas including, but not limited to:

• sorting
• filters
• vlookup
• concatenate
• pivot tables
• text to columns
• conditional formatting

Demonstrate an understanding of how to take advantage of these functions and formulas when performing tasks (ex: ad customization uses concatenation and length formulas) with limited oversight needed. Accuracy is critical, and Account Coordinators will need to QA their work to ensure accurate data is being relayed to the rest of the team and clients.

GROWTH EXPECTATIONS

Over time in the role, we expect Account Coordinators to be responsible for learning and understanding higher-level concepts as below: 

• Independently own reporting, pacing, and client performance summaries
• Identify troubleshooting and optimization levers to course correct trends, confidently managing and updating an optimization log
• Consistently provide campaign recommendations to improve activation and testing strategy
• Ability to plan audiences natively within the UI
• Create and edit campaigns and audiences with minimal oversight
• Demonstrate consistent time management skills, nam