• Partner with managers and internal and external stakeholders to capture requirements and architect, standardize, scope, and document Butler/Till data frameworks.

• Design, build, and automate scalable, standardized, and client-specific data marts to support consistent reporting and analytics delivery.

• Collaborate cross-functionally to develop data solutions that streamline workflows and improve operational efficiency.

• Work closely with Analytics, Media, and Account teams to understand client data needs and drive standardized campaign and ad naming conventions.

• Maintain comprehensive documentation for data policies, data dictionaries, metadata, and ETL processes to ensure transparency, consistency, and continuity.

Key Outcome: Increased Reliability: Deliver trusted, accurate, and well-governed data through consistent processes and quality controls, enabling teams to make confident decisions and quickly respond to performance insights and evolving business needs.

Key Responsibilities:

• Serve as the first line of defense for data integrity by executing and continuously improving quality assurance and validation processes.

• Partner with Analytics teams to resolve data-related tickets, troubleshoot issues, and ensure timely, accurate file processing.

• Maintain and optimize third-party monitoring tools that detect data inconsistencies, gaps, and failures, triggering rapid corrective action.

• Act as a subject matter expert on Butler/Till data marts and key marketing platforms (e.g., Google, Meta), ensuring data is correctly interpreted and applied across Campaign Analytics and Marketing Science.

• Mentor junior Analytics Data Engineers on QA standards and best practices through structured code reviews and ongoing technical guidance.

• Maintain working knowledge of applicable data privacy and protection regulations (e.g., CCPA, GDPR) and incorporate requirements into daily data practices.

• Consistently follow and help enforce organizational policies, security standards, and governance frameworks across all supported data processes.

• Review, analyze, and troubleshoot data pipelines, processes, and database code to identify vulnerabilities, mitigate risks, and strengthen security controls.

Key Outcome: Scalability: Enable efficient growth by building standardized, repeatable data processes that reduce operational overhead and support expanding client and business needs.

Key Responsibilities:

• Prepare data for reporting, analysis, and modeling by building repeatable, client-specific data marts in partnership with Information Analysts and Data Scientists.

• Leverage SQL and Python to design and maintain scalable, end-to-end data solutions that support evolving business needs.

• Identify and research opportunities to enhance the analytics technology stack, and develop clear, well-documented requirements for implementation.

• Test and evaluate new internal and external tools, collaborating with Analytics Data Engineering peers to recommend solutions that support long-term growth and platform sustainability.

• Partner with internal stakeholders to anticipate future data and reporting needs and translate them into scalable engineering roadmaps.

• REQUIRED –

• PREFERRED –

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 $70,000 - $111,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.