Information Analyst II at Butler/Till | Rochester, NY | $54K/yr – $76K/yr

Butler/Till

Information Analyst II

Rochester, NY (Hybrid)

$54K/yr – $76K/yrMid Level2+ years expFull time

Posted 2 months ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Drive data-driven marketing measurement by owning end-to-end data workflows and Power BI reporting.

Own data collection, transformation, validation, and dashboard delivery for campaigns
Must-have: 2+ years in data management/visualization and Power BI
Standout: 100% employee-owned ESOP culture and DEIB commitment

Job Description

Responsibilities

Identify, collect, prepare, transform, and validate data.
Understand and maintain data models, mappings, and relationships.
Complete data transformations
Perform data quality audits.
Act as a subject matter expert in data use for measuring and improving marketing campaigns.
Establish business objectives and define KPIs and metrics.
Assist in developing solutions to achieve client measurement goals.
Create visualizations to effectively communicate performance.
Build, update, and maintain Power BI dashboards for internal and external stakeholders.
Documents observations resulting from Power BI dashboard reporting.

Requirements

Bachelor’s degree in Marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics, or a related field
2+ years of relevant experience in data management, data visualization and/or campaign measurement.
Developing or intermediate ability to code in SQL
Deep experience in Microsoft Excel, including DAX, complex formulas, pivot tables, Power Pivot
Experience in BI tools, preferably Power BI
Strong written and verbal communication skills

Preferred

Experience with digital media platforms.
Experience analyzing media data.
Experience in the Healthcare vertical.
Experience using project management software.

Benefits

full benefits package
paid time off benefits
100% paid parental leave

Butler/Till

As an independent, women-owned/led, 100% employee-owned, B Corporation, we create award-winning campaigns that deliver measurable business impact. Free from holding company constraints, our agile and accountable approach genuinely serves our clients' best interests. With 25+ years of experience, we specialize in media, campaign analytics, marketing science, creative services, and healthcare marketing, connecting brands with audiences in meaningful ways. Looking for localized marketing solutions? We have that covered too. Endless spreadsheets, logins, tabs open, and emails. We know how complex local marketing can be, so we built the technology to make it easier, BetterLocal.

Founded in 1998

Rochester, New York, USA

434 employees (125 in marketing)

www.butlertill.com