Associate Programmatic Trader

Kids for the Future; City of Rochester (NY); On-site; USD 45,000 - 60,000; Full time

Job summary

Butler/Till is seeking an Associate Programmatic Trader in Rochester, NY. You will support campaign planning, strategy, and programmatic execution across display, video, and audio, working with senior staff to optimize outcomes.

Strong Excel skills and programmatic experience are required, with familiarity in PMP/PG platforms and PowerBI. This role emphasizes data accuracy, reporting, and cross-functional collaboration in a dynamic agency setting.

Qualifications

• Bachelor's degree in Marketing, Advertising, Communications, Business or equivalent work experience.
• High level of proficiency in Excel, being able to create &/or utilize formulas, VLookups, concatenate and other functions.

Responsibilities

• Support the planning process with senior resources to provide guidance.
• Partner with cross-functional teams to gather data and identify optimizations.
• Continuously analyze key metrics to measure campaign effectiveness.
• Assist in creating POVs and thought leadership for stakeholders.
• Stay updated on paid programmatic tools, applications, and strategies.

Skills

Excel proficiency

Campaign management

Programmatic advertising

Data analysis

Education

Bachelor's degree in Marketing/Advertising/Communications/Business

Tools

PowerBI

Excel

Private Marketplace (PMP)

Programmatic Guaranteed (PG)

Job description

• Base Pay $45,000.00 - $60,000.00 / Year
• Job Category Entry
• Employee Type Full-Time Non-Exempt
• Required Degree 4 Year Degree

SUMMARY

The Associate Programmatic Trader is responsible for supporting channel strategy, execution and stewardship of effective programmatic campaigns on behalf of a major, high-profile advertiser. This individual will have experience with campaign management, programmatic execution, and has hands-on experience in self-serve advertising platforms. Experience executing various campaign types including online display, video, and audio, in an agency environment is preferred. This Associate Programmatic Trader will have a firm grasp and ability to navigate intricacies of hyper targeted, complex campaigns as well as an understanding of basic digital metrics and calculations, media measurement, terminology, and how these impact delivery and performance. The nature of this role requires extreme attention to detail and above average data management skills, heavily leveraging Microsoft Excel, to ensure correct application of a large amount of campaign parameters.

KEY OUTCOMES & RESPONSIBILITIES

Key Outcome: Planning, Strategy, and Programmatic Expertise Development

Key Responsibilities:

• Support the planning process by working closely with senior resources to provide guidance and answer questions.
• Partner with cross-functional team members to gather data and learn how to identify optimizations that improve campaign results.
• Continuously analyze key performance metrics to measure effectiveness of campaign initiatives.
• Demonstrate growing expertise by supporting senior resources in establishing materials like POVs and other thought leadership to educate internal and client stakeholders on strategy shifts, account restructuring etc.
• Stay updated on the latest paid programmatic tools, applications, and strategies.

Key Outcome: Effective Campaign Management and Performance Optimization

Key Responsibilities:

• Manage and execute programmatic campaigns across display, audio, video, and digital out of home ensuring adherence to budgets and timelines.
• QA campaigns to ensure accuracy.
• Optimize campaign delivery through precise pacing, bid management, audience and placement analysis, and performance tracking.
• Conduct ongoing delivery pacing checks and provide comprehensive weekly, monthly, and campaign wrap-up reports.
• Develop and maintain positive relationships with digital media partners, ensuring effective collaboration and communication.
• Assist senior resources in the communication, evaluation, and implementation of programmatic media partners, technology, and platforms, including Private Marketplace (PMP) and Programmatic Guaranteed (PG) deals.

Key Outcome: Data-driven Insights and Reporting

Key Responsibilities:

• Leverage advanced Excel functions (Pivot Tables, VLookups, Concatenates, and IF statements) to gather, analyze, and articulate mid-level insights on campaign performance.
• Accurate QA of all data including PowerBI models.
• Support internal client-facing teams by explaining campaign performance and addressing any questions.
• Ability to articulate tactical performance analysis to internal and external parties via detailed written and verbal summaries.
• Maintain accurate documentation of changes and learnings to inform future campaigns.

Other Responsibilities:

• Additional accountabilities and tasks may be assigned by leader/management, to contribute to overall team and agency success.

QUALIFICATIONS

REQUIRED

• Bachelor's degree in Marketing, Advertising, Communications, Business, or equivalent work experience
• High level of proficiency in Excel, being able to create &/or utilize formulas, VLookups, concatenate and other functions

PREFERRED

• Minimum 1-2 years of experience managing campaigns in the digital marketing ecosystem
• Experience in hands on execution of advertising within biddable platforms (programmatic, paid search, paid social, media operations, ad operations, etc.).
• Experience involving heavy utilization of MS Excel (or similar tools) to manage large amounts of data with precision and accuracy.
• Proven track record in operating with a high-level of integrity, commitment, and enthusiasm to take on a challenging role with cross-functional commitments.

CORE COMPETENCIES

• CUSTOMER FOCUS/CLIENT INTIMACY: seeking to understand client business challenges/needs and delivering continuous value to our clients
• COLLABORATIVE: working with teams and across the organization with ease
• OWNER AGILITY: able to continuously learn and quickly adapt to changing circumstance
• RESULTS DRIVEN: accepts accountability to deliver business outcomes, even under changing circumstances. Delivers on commitments
• DISCIPLINED: Thinks, plans, and prioritizes work on an ongoing basis, plans and aligns with key team members before acting

TRAVEL REQUIREMENTS

All employees, regardless of role or geographic location, are required to travel to Rochester during their initial onboarding period (ideally within the first 4 weeks of employment) and annually for the Shareholder’s Summit held in June.

WORK ENVIRONMENT & PHYSICAL DEMANDS

The work environment and physical demands characteristics described here are representative of those an employee encounters while performing the essential functions of this job, typically in an office setting or in a home office. An employee in this role may be in a stationary position, often standing or sitting for prolonged periods and using office equipment and computers. The noise level in the office environment is usually moderate. (I.e., business office with computers and printers, light foot traffic, etc.). Reasonable accommodation may be requested to enable individuals to perform the essential functions.

COMMITMENT TO DIVERSITY, EQUITY, INCLUSION AND BELONGING

Our dedication to Diversity, Equity, Inclusion, and Belonging (DEIB) is a cornerstone of our culture. We believe that the diversity and inclusivity of our workforce are sources of strength. As you become part of our community, you'll discover that we are dedicated to creating a positive impact, not only for our clients but also for the communities where we live and work.

EEO DISCLAIMER

Butler/Till is an Equal Opportunity Employer to all employees and applicants and prohibits discrimination and harassment of any kind without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

COMPENSATION

Butler/Till is committed to providing pay transparency of our compensation philosophy and ensuring equitable pay practices for our employee owners. The compensation range for this position is $45,000- $60,000 and represents the annual salary range in Rochester, NY. Base pay offered may vary depending on multiple individualized factors, including location, skills, and experience.

This is just one component of Butler/Till's total compensation package for employee owners. The total compensation package for this position may also include other elements, including ESOP (employee stock ownership plan), an annual bonus, in addition to a full benefits package, and paid time off benefits, including 100% paid parental leave. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.