Data Insights Analyst II — Power BI & ESOP

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

Job summary

Butler/Till in Rochester, NY is seeking an Information Analyst to distill raw data into actionable insights for campaign optimization. This role requires collaboration with senior team members and strong communication, with emphasis on data modeling, visualization, and reporting.

Responsibilities include building Power BI dashboards, validating data, maintaining data relationships, and delivering timely reports while supporting continuous process improvements in a fast-paced environment.

Qualifications

• 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
• Experience with digital media platforms
• Experience analyzing media data
• Experience in the Healthcare vertical
• Experience using project management software

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
• Responsible for timely and accurate reporting delivery
• Proactively support agency improvement/innovation initiatives

Skills

Data management

Data visualization

Campaign measurement

Communication skills

Project management

Education

Bachelor’s degree in marketing, Computer Science, Information Technology, Statistics, Mathematics, Finance, Economics, or related field

Tools

Power BI

SQL

Excel (DAX, pivot tables, Power Pivot)

Job description

Butler/Till in Rochester, NY is seeking an Information Analyst to distill raw data into actionable insights for campaign optimization. This role requires collaboration with senior team members and strong communication, with emphasis on data modeling, visualization, and reporting.

Responsibilities include building Power BI dashboards, validating data, maintaining data relationships, and delivering timely reports while supporting continuous process improvements in a fast-paced environment.