Programmatic Media Coordinator

Programmatic Media Coordinator Denver CO; San Diego CA; Los Angeles CA; San Francisco CA; Salt Lake City UT; Portland OR; Seattle WA; Chicago IL US - Remote Why Dept? We are pioneers at heart. What this means, is that we are always leaning forward, thinking of what we can create tomorrow that does not exist today. We were born digital and we are a new model of agency, with a deep skillset in tech and marketing. That's why we hire curious, self-driven, talented people who never stop innovating. Our culture is big enough to cope and small enough to care. Meaning, that with people across 20+ countries, we're big enough to provide you with the best tools, global opportunities, and benefits that help you thrive. While acting small by investing in you, your growth, your team, and giving you the autonomy to solve our clients' problems, no matter where you are in the world. About You As an Account Coordinator, Programmatic, your primary function will be to provide vital production support for your account team. Day-to-day responsibilities include but are not limited to running and formatting performance reports, creative trafficking and tagging, building and uploading campaigns, QA support for campaign builds and optimizations and participating in and taking notes during internal syncs, client meetings, and presentations. Account Coordinator, Programmatic will become responsible for an enterprise level account and 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. 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 Excel/Sheets: Demonstrate proficiency in using essential spreadsheet functions and formulas including, but not limited to: sorting filters xlookup 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. Proficiency in Programmatic: Ability to: Pull reports at various levels along with the desired columns/metrics and understand the data/results. Creative trafficking and tagging Leverage The Trade Desk, Walmart, TTD, Criteo and Roundel DSPs 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 Pacvue or other automation tools 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 understanding of the different optimization levers to pull to surpass benchmark KPI Growth Expectations Develop suggestions on activation strategy around campaign builds, overall themes, hierarchy, audiences, parameters, and ads Create and edit campaigns and audiences in DSPs with oversight and mentorship Implement scheduled and ad hoc tasks delegated by direct manager and/or colleagues Follow mandatory QA process to completionGrow a thorough understanding of programmatic, constantly embodying a "forever student" mentality. Participate in programmatic trainings by asking questions, contributing ideas, and leaning into relationship with agency partners Qualifications 0 - 6 months of programmatic marketing experience 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 What Do We Offer? We are a collaborative, open-door, best-idea-wins environment that fosters personal and company growth and has fun doing it. Here is a snapshot of our benefits package: Healthcare, Dental, and Vision coverage 401k plan, plus matching PTO Paid Company Holidays Parental Leave The anticipated salary range for this position is $60,000 - $70,000 . Salary is based on a range of factors that include relevant experience, expertise, physical location, and organizational impact. This is based on a 40-hour workweek and leveling. Keep in mind, we're flexible. We Support You Being You: DEPT is an equal opportunity employer (EOE). We believe our work is its best when our people feel safe and free to be themselves. We're committed to an inclusive and barrier-free recruitment and selection process and workplace, regardless of anyone's identity, background, beliefs, lifestyle or disabilities. So tell us about any accommodations you need. It's totally confidential and only used to make sure you feel fully supported at every step. DEPT participates in E-Verify, meaning your Form I-9 information will be sent to the federal government to confirm you are authorized to work in the U.S. #J-18808-Ljbffr DEPT