Senior Advancement Analytics Lead — BI & Dashboards

Medical College of Wisconsin; Wauwatosa (WI); Presencial; USD 110.000 - 140.000; Jornada completa

Descripción de la vacante

The Senior Enterprise BI and Analytics Analyst at Medical College of Wisconsin serves as the primary analytics partner across advancement leadership, frontline fundraisers, Alumni Relations, Prospect Management and Research, and IT. The role translates fundraising questions into data requirements and builds dashboards and data products to guide strategy.

Responsibilities include Grateful Patient program metrics, donor pipeline, HIPAA-compliant data flows, and collaboration to expand analytics

Formación

• Experience designing dashboards and reports for fundraising or enterprise analytics.
• Ability to translate business questions into data requirements and specifications.
• Knowledge of HIPAA-compliant data flows and data governance basics.
• Strong SQL skills and experience with data models and data warehouses.

Responsabilidades

• Designs, builds, and maintains dashboards and reports for advancement leadership and campus partners.
• Leads metrics for Grateful Patient program, campaign progress, and donor pipeline.
• Partners to define secure, HIPAA-compliant data flows supporting screening and reporting.
• Develops reports for gift/pledge counting, soft credit, and CASE-aligned year-end reporting.
• Collaborates to deliver reporting on corporate/foundation relationships and partnerships.
• Accelerates prospect identification and pipeline analytics with quality data checks.
• Develops planned giving analytics and donor lifecycle modeling.
• Delivers engagement scoring and retention trend analysis with Alumni Relations.
• Produces analytics for board meetings and executive requests.
• Trains end users on self-service reporting and supports analytics adoption.

Conocimientos

Data analysis

Data modeling

Dashboard design

SQL scripting

Stakeholder collaboration

HIPAA compliance awareness

Herramientas

Tableau

Power BI

SQL

Descripción del empleo

The Senior Enterprise BI and Analytics Analyst at Medical College of Wisconsin serves as the primary analytics partner across advancement leadership, frontline fundraisers, Alumni Relations, Prospect Management and Research, and IT. The role translates fundraising questions into data requirements and builds dashboards and data products to guide strategy.

Responsibilities include Grateful Patient program metrics, donor pipeline, HIPAA-compliant data flows, and collaboration to expand analytics