Manager of Data, Analysis & Impact

YMCA of Greater Rochester; City of Rochester (NY); On-site; USD 33,000 - 39,000; Full time

Benefits offered by this job

Free family YMCA membership

Generous benefits

Job summary

YMCA of Greater Rochester is seeking a Manager of Data, Analysis & Impact to build and deliver the data capabilities that inform member insights, performance evaluation, and strategic decisions.

You will oversee data quality, develop data flows from core systems, and publish reliable dashboards using SQL, Power BI, Excel and AI-enabled tools. This role blends hands-on data work with cross-functional collaboration across YMCA branches and leadership.

Qualifications

• Bachelor’s degree in data science, information systems, CS, statistics or related analytical field
• 3-5 years’ experience with structured data systems like CRM platforms, POS systems or data warehouses
• Strong analytical and problem-solving skills
• Proficient with SQL, Power Query, Power Automate, Power BI, Excel and emerging AI-enabled tools
• Proficient with Power BI or Tableau for data exploration and reporting
• Ability to travel between local YMCA branches
• Ability to communicate technical information clearly to staff at various levels

Responsibilities

• Develop and optimize integrated data flows for quality and reporting
• Collaborate with leaders to define KPIs and prioritize reporting needs
• Conduct recurring and ad hoc analyses to identify patterns and inform decisions
• Build and maintain dashboards tracking membership, participation, attendance, programs, revenue and customer behavior
• Advance data governance, definitions, and reporting standards
• Establish data validation and reconciliation processes
• Document data processes, transformations and metrics for broad understanding
• Support staff to use analyses and reports for high impact
• Attend required meetings and trainings
• Perform other duties in support of department operations and YMCA mission

Skills

SQL

Power BI

Power Automate

Power Query

Excel

Tableau

Data analysis

Education

Bachelor's degree in data science or related analytical field

Tools

CRM platforms

POS systems

Data warehouses

Job description

Description

$24/hr. to $28/hr. with Generous Benefits Including a Free Family YMCA Membership

Not a Remote Position

The Manager of Data, Analysis & Impact builds and delivers the data and analytical capabilities to help the YMCA of Greater Rochester better understand its members, evaluate performance and make informed decisions.

This position oversees data quality and integrity, develops and maintains data flows from key business systems and prepares data for analysis and reporting. The Manager uses SQL, Power Automate, Power BI, Excel and embedded AI capabilities to combine data sources, automate recurring reports, create impactful analyses and publish reliable dashboards.

This position serves as both a hands-on data practitioner and an Association-wide resource. The Manager collaborates with functional leaders, process owners and system owners to understand business needs and deliver reliable, documented and sustainable data solutions. This position requires a commitment to delivering excellent service in alignment with the YMCA’s mission and core values.

ESSENTIAL FUNCTIONS:

• Develop and optimize integrated data flows to extract, transform and combine data for quality and integrity assurance, analysis and reporting.
• Partner with leaders, system owners and report users to define business questions and KPIs, prioritize reporting needs, improve data literacy and ensure reports are useful, understandable and appropriately applied in decision-making.
• Conduct recurring and ad hoc analysis using frequencies, trends, comparisons, cross-tabulations and other analytical methods to identify patterns, investigate business questions and diagnose the “why” behind the numbers in order to inform decisions.
• Build and maintain reports and dashboards that provide clear metric tracking and visibility into actionable information about membership, participation, attendance, programs, revenue and customer behavior.
• Advance data governance, including documentation, data definitions, reporting standards, and process improvements
• Establish validation and reconciliation processes that identify data quality issues, investigate discrepancies and build confidence in organizational reporting.
• Support organizational data readiness by documenting data processes, transformations and metrics so solutions are broadly understandable,
• Build organizational data capabilities by helping leaders and staff understand metrics, interpret reports and supporting staff to use analyses and reports for high impact.
• Support Association objectives and goals by demonstrating the YMCA mission and core values.
• Attend all required meetings, trainings, and professional development opportunities.
• Perform other duties as assigned in support of department operations and the YMCA mission.

Requirements

• Bachelor's degree in data science, information systems, computer science, statistics, mathematics, business, accounting or a related analytical field, or an equivalent combination of education and relevant experience.
• 3-5 years’ experience working with structured data systems like CRM platforms, POS systems or data warehouses.
• Seeks best practices, guidelines and industry standards to guide performance.
• Possess exceptional technical knowledge and organizational skills to do the job at a high level of accomplishment.
• Strong analytical and problem-solving skills.
• Uses SQL, Power Query, Power Automate, Power BI, Excel and emerging AI-enabled tools to integrate data, automate recurring work, perform analysis and publish reliable reporting.
• Proficient using data exploration, visualization and reporting tools such as Power BI or Tableau.
• Highly attentive to detail, follow through and problem solving.
• Capable of managing multiple tasks and projects concurrently to meet deadlines in a fast-paced environment.
• Ability to work in a self-directed manner and also bring in others to collaborate.
• Ability to communicate technical information clearly to various levels of staff.
• Ability to travel between local YMCA branches
• Ability to represent the YMCA in a mature and professional manner.

PHYSICAL REQUIREMENTS:

• Must be able to sit or stand for the duration of the shift
• Must be able to bend and stoop occasionally
• Must be able to lift at least 25 pounds occasionally