Data Insights Analyst II — Power BI & ESOP

Kids for the Future

City of Rochester (NY)

On-site

USD 48,000 - 76,000

Full time

14 days+
Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Insights Analyst II - Power BI, SQL, ESOP
Data Insights Analyst II - Power BI, SQL, ESOP

Butler/Till • City of Rochester (NY)

On-site
USD 48,000 - 76,000
ESOP (employee stock ownership plan)
Annual bonus
Full benefits package
+1
Data Insights Analyst — SQL + Power BI Expert
Data Insights Analyst — SQL + Power BI Expert

Persistent Systems, LLC • New York (NY)

On-site
USD 133,000 - 166,000
Medical insurance
Dental insurance
Vision insurance
+8
Power BI & Analytics Lead: Enterprise Insights
Power BI & Analytics Lead: Enterprise Insights

Essent Guaranty, Inc. • Radnor

On-site
USD 120,000 - 170,000
Competitive salary
Medical benefits
Dental & vision
+1
Power BI Data Analyst II - Insightful Reporting
Power BI Data Analyst II - Insightful Reporting

Alterman, Inc. • Town of Texas (WI)

On-site
USD 60,000 - 90,000
Data Insights & Visualization Analyst
Data Insights & Visualization Analyst

Aquent • New York (NY)

On-site
USD 85,000 - 115,000
BI Data Analyst: Power BI & SQL Insights Leader
BI Data Analyst: Power BI & SQL Insights Leader

ImpetusIT • New York (NY)

On-site
USD 55,000 - 75,000
Remote Data Analyst: Power BI & SQL Insights
Remote Data Analyst: Power BI & SQL Insights

Signature Performance • Oklahoma City (OK)

Remote
USD 90,000 - 110,000
Remote BI Analyst: Power BI & Data Visualization
Remote BI Analyst: Power BI & Data Visualization

Experior events • Northern (KY)

Hybrid
USD 100,000 - 130,000
401(K) program
Health, vision, dental benefits
Remote opportunities
+2
Senior Power BI Data Architect & Analytics Leader
Senior Power BI Data Architect & Analytics Leader

Essent Guaranty, Inc. • Radnor

On-site
USD 140,000 - 190,000
Benefits package including medical,牙 d
401(k) and disability benefits
Data Analyst 2
Data Analyst 2

Alterman, Inc. • Town of Texas (WI)

On-site
USD 60,000 - 90,000