Information Analyst II
Rochester, NY (On-site)
Posted 6 days ago
Job Summary
Own end-to-end data measurement and reporting for marketing campaigns, driving data collection, transformation, quality, and visualization to support client measurement goals.
- Lead data modeling, transformations, and KPI definition
- Build Power BI dashboards and communicate insights
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
- ESOP (employee stock ownership plan)
- an annual bonus
- a full benefits package
- paid time off benefits, including 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.
Salaries
Posted range
$48K/yr – $76K/yr
Taken straight from the job posting.
Marketing Team
People
Marketing Leadership
Traffic Signals
Headcount Trend
News about Butler/Till
Links
This role is listed on SalaryGuide for informational purposes. SalaryGuide is not the employer, recruitment agency, or hiring representative for this position. Hiring decisions and the application process are managed by the employer. SalaryGuide will never ask candidates to pay to apply for a job or request bank details or identification documents as part of an application.
