Data Operations Analyst

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

Job summary

Butler/Till in Rochester, NY seeks a Data Operations Analyst to work with Account Service, Channel Activation, Product, Operations and Creative teams. You will develop and manage data deliverables for client campaigns and translate needs into actionable software directives.

The role requires data accuracy, database management, and proactive problem solving in a fast-paced environment with strong communication. This position offers full-time, non-exempt employment and comprehensive benefits.

Qualifications

• Required: Bachelor’s degree in a relevant field and 2+ years of experience managing large data projects.
• Proficient in Microsoft Excel (pivot tables, Power Pivot) and data management.
• Experience with project management software (Wrike) and strong communication skills.

Responsibilities

• Maintain and manage account databases, ensuring data accuracy for stakeholders.
• Develop and distribute documents/templates for media buying, creative ordering, traffic, and billing.
• Manage document versioning and history of updates for agency documents.
• Identify risks and dependencies across deliverables to anticipate issues.

Skills

Microsoft Excel

Pivot tables

Power Pivot

Communication

Project management

Data analysis

Education

Bachelor’s degree in Business Administration, Marketing, Computer Science, Information Technology, Statistics, Mathematics, or related field

Tools

Wrike

Power Automate

Excel macros

Job description

• Base Pay $47,000.00 - $74,000.00 / Year
• Job Category Mid
• Employee Type Full-Time Non-Exempt

SUMMARY

The Data Operations Analyst is responsible for interfacing with various departments, including Account Service, Channel Activation, Product, Operations, and Creative/Production, to develop and manage all data deliverables necessary to execute client campaigns. This role ensures data accuracy, manages account databases, creates and maintains documents, and oversees the routing of information across the agency. This role also involves translating client and agency needs into clear directives for software development. The Data Operations Analyst is a proactive problem solver with strong communication skills, thriving in a fast-paced, deadline-driven environment, and contributing significantly to client-facing deliverables.

KEY OUTCOMES & RESPONSIBILITIES

Key Outcome: Ensure Accurate and Timely Data Management

Key Responsibilities:

• Maintain and manage account databases, ensuring the accuracy and availability of data for various stakeholders.
• Develop and distribute documents and templates to facilitate media buying, creative ordering, traffic, billing, and campaign pacing.
• Manage document versioning and maintain a history of updates for agency working documents.
• Identify risks and dependencies across deliverables to anticipate and mitigate potential issues.

Key Outcome: Optimize Workflow and Project Management

Key Responsibilities:

• Work with stakeholder groups to define project scopes, reporting metrics, and data sources, providing solutions and recommendations.
• Serve as the subject matter expert on marketing programs, agency software, reporting tools, and workflow processes.
• Develop formal processes and maintain accurate documentation, championing continuous improvement efforts. Partner with cross-functional teams, gathering requirements and enhancing workflows through automation.
• Manage multiple projects simultaneously, ensuring deadlines are met in a fast-paced environment.

Key Outcome: Facilitate Cross-Departmental Communication and Collaboration

Key Responsibilities:

• Act as a liaison between centralized and decentralized groups, promoting the use of data across departments.
• Collaborate with Product team to translate client and agency needs into clear, actionable directions for software and website development.
• Demonstrate subject matter expertise of the internal data ecosystem to effectively transform and repurpose data for various agency functions, including media buying, creative ordering, billing, and reporting.

QUALIFICATIONS

• REQUIRED o Bachelor’s degree in Business Administration, Marketing, Computer Science, Information Technology, Statistics, Mathematics, or a related field. o 2+ years of experience managing large projects with a focus on data management. o Extensive use of Microsoft Excel, including pivot tables and Power Pivot. o Experience with project management software, such as Wrike. o Intermediate project management skills, detail-oriented, and capable of multitasking in a fast-paced environment. o Excellent communication skills, with the ability to present to clients and internal stakeholders.
• PREFERRED: o Experience in marketing, digital marketing, and/or customer data management. o Experience writing Excel macros and/or Power Automate o Agency and/or media experience. o A combination of education and relevant experience will be considered

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

WORK ENVIORNMENT & 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 $47,000- $74,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.