Back to jobs

Senior Advancement BI Analyst - Office of Institutional Advancement

Pay
$87,100–111,500/year — pay source
Ability to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects. #LI-NK1 Target salary range for this position is between $87,100 and $111,500 annually. The final offered salary will depend on the applicant’s education, experience, skills, and knowledge, as well as considerations of internal equity and market alignment. Why MCW?
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design and maintain Tableau or Power BI dashboards on giving, pipeline and campaign progress

  • Lead Grateful Patient program metrics, from patient identification through first gift

  • Write SQL for data extraction, transformation and validation from CRM and warehouse

  • Translate advancement questions into requirements and functional specifications

  • Map legacy reports and data to the new CRM platform and validate accuracy

From the employer’s posting
Designs, builds, and maintains dashboards and reports in Tableau or Power BI
Leads the design and ongoing development of Grateful Patient program metrics
Writes SQL scripts for data acquisition, transformation, and validation from the CRM, data warehouse, and related advancement and institutional sources.
translates advancement business questions into requirements, transformation logic, and functional specifications
mapping legacy reports and data structures to the new environment and validating data accuracy

Before you apply

Sponsorship
Visa sponsorship not confirmed — sponsorship source
Partners with enterprise units including Business Development and Government Relations to deliver reporting on corporate and foundation relationships, industry partnership pipeline, and sponsorship revenue, along with analysis that connects donors, board members, and community partners to elected officials and government stakeholders in support of advocacy and relationship strategy.
Read the full posting

What you’ll bring

All qualifications

Core experience

  • Experience with predictive modeling, RFM segmentation, or donor lifecycle modeling and with CRM data migration or conversion.
  • Ability to detect and translate speech or other communication required.
Qualification wording
Preferred Experience: 3 or more years of experience in higher education, healthcare, or nonprofit advancement, including analytics supporting prospect research, planned giving, alumni relations, business development, government relations or grateful patient programs. Experience with predictive modeling, RFM segmentation, or donor lifecycle modeling and with CRM data migration or conversion.
Ability to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects. #LI-NK1
Apply at Mcw

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 19, 202633 days ago
Recorded sightings
47
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$87.1K–$112K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 33

Similar jobs usually come down between day 5 and day 43.

At Mcw, jobs usually come down by about day 32.

From 16,008 similar postings that came down, and 12 of Mcw’s. Coming down is not always a hire.

Mcw is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring at a steady pace
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Power BI
  • Qlik
  • Tableau
Where the posting names them
- Develops requirement analysis, functional specifications, and solution designs for analytics and data visualization in partnership with the Business Analyst and advancement stakeholders. - Writes SQL scripts for data acquisition, transformation, and validation from the CRM, data warehouse, and related advancement and institutional sources. - Builds and maintains data models supporting fundraiser performance metrics, prospect and moves management, events, and constituent engagement reporting, and applies predictive modeling, RFM analysis, and donor lifecycle modeling to segment constituents from acquisition through retention, upgrade, and lapse.
- Advanced proficiency in a business intelligence platform such as Power BI, Tableau, or Qlik, including data modeling, predictive modeling, calculated measures, and dashboard design for executive and operational audiences. - Advanced SQL skills and experience working with relational databases and data warehouses. - Experience working with a CRM or constituent database, such as Raiser's Edge NXT, Blackbaud CRM, Salesforce, Slate, Ellucian CRM Advance, or a comparable system.
Minimum Required Education: Bachelor's degree Minimum Required Experience: 5 years of experience in data analysis, business intelligence, or reporting, including SQL development, data modeling, and dashboard design in Power BI, Tableau, or a comparable tool. Preferred Education: Bachelor's Degree or Master's degree in data analytics, information systems, statistics, business, or a related field
Primary Responsibilities - Designs, builds, and maintains dashboards and reports in Tableau or Power BI for advancement leadership, gift officers, and campus partners covering fundraising production, campaign progress, pipeline health, donor retention, and portfolio performance. - Leads the design and ongoing development of Grateful Patient program metrics, including patient identification and referral volume, physician and clinician engagement, conversion from identification to solicitation, time to first gift, and revenue attributed to clinical relationships.
- Knowledge of fundraising operations in higher education, healthcare, or nonprofit settings, including gift and pledge accounting principles and advancement reporting standards. - Advanced proficiency in a business intelligence platform such as Power BI, Tableau, or Qlik, including data modeling, predictive modeling, calculated measures, and dashboard design for executive and operational audiences. - Advanced SQL skills and experience working with relational databases and data warehouses.
Preferred Experience: 3 or more years of experience in higher education, healthcare, or nonprofit advancement, including analytics supporting prospect research, planned giving, alumni relations, business development, government relations or grateful patient programs. Experience with predictive modeling, RFM segmentation, or donor lifecycle modeling and with CRM data migration or conversion. Preferred Certification/Licensure(s): Microsoft Certified Power BI Data Analyst Associate, Tableau Certified Data Analyst, or comparable analytics certification Physical Requirements

Your next step

Complete your application on mcw.wd503.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

Summary

The Senior Enterprise BI and Analytics Analyst serves as the lead analytics partner between advancement leadership, frontline fundraisers, Alumni Relations, Prospect Management and Research, Data Information Services, and MCW enterprise IT. This position combines knowledge of fundraising and advancement operations with advanced skills in data analysis, data modeling, and visualization. The analyst translates advancement business questions into requirements, transformation logic, and functional specifications, then designs and builds dashboards, metrics, and data products that guide fundraising strategy.


The role owns reporting for the Grateful Patient program, fundraiser performance, campaign progress, and donor pipeline, and ensures advancement data is accurate, trusted, and aligned with institutional and industry reporting standards. The analyst collaborates with units across MCW and the clinical enterprise to expand the advancement analytics footprint and supports the transition to a modern CRM platform.


Primary Responsibilities

  • Designs, builds, and maintains dashboards and reports in Tableau or Power BI for advancement leadership, gift officers, and campus partners covering fundraising production, campaign progress, pipeline health, donor retention, and portfolio performance.
  • Leads the design and ongoing development of Grateful Patient program metrics, including patient identification and referral volume, physician and clinician engagement, conversion from identification to solicitation, time to first gift, and revenue attributed to clinical relationships.
  • Partners with clinical enterprise units and compliance staff to define secure, HIPAA compliant data flows that support Grateful Patient screening, referral tracking, and reporting.
  • Builds and implements reports to support fundraising metrics and business rules for gift and pledge counting, soft credit, campaign counting, and fiscal year reporting consistent with CASE Global Reporting Standards.
  • Partners with enterprise units including Business Development and Government Relations to deliver reporting on corporate and foundation relationships, industry partnership pipeline, and sponsorship revenue, along with analysis that connects donors, board members, and community partners to elected officials and government stakeholders in support of advocacy and relationship strategy.
  • Partners with Prospect Management and Research to accelerate prospect identification through reporting and metrics, including identification queues that surface constituents with strong capacity and affinity, pipeline and portfolio coverage analysis, and data quality checks that ensure wealth screening results, research ratings, and relationship data are accurately associated with constituent records.
  • Develops planned giving analytics, including identification models for bequest and legacy prospects, tracking of expectancies and realized gifts, and reporting on legacy society growth.
  • Partners with Alumni Relations to deliver engagement scoring, participation and retention trends, reunion and event performance, and analysis of how alumni engagement converts to giving.
  • Formulates calculations, transformation logic, data analysis, and rapid prototypes for advancement analytics applications, dashboards, and data products.
  • Develops requirement analysis, functional specifications, and solution designs for analytics and data visualization in partnership with the Business Analyst and advancement stakeholders.
  • Writes SQL scripts for data acquisition, transformation, and validation from the CRM, data warehouse, and related advancement and institutional sources.
  • Builds and maintains data models supporting fundraiser performance metrics, prospect and moves management, events, and constituent engagement reporting, and applies predictive modeling, RFM analysis, and donor lifecycle modeling to segment constituents from acquisition through retention, upgrade, and lapse.
  • Serves as the analytics subject matter expert during any advancement platform changes by mapping legacy reports and data structures to the new environment and validating data accuracy.
  • Coordinates quality control and accuracy of information by identifying data issues, recommending corrective action to be in line with data governance and stewardship standards.
  • Produces analysis for board and leadership presentations, annual reporting and executive ad hoc requests.
  • Supports and improves the advancement analytics intake and triage process to increase efficiency and responsiveness.
  • Trains and supports end users to expand adoption of self-service reporting across the Office of Institutional Advancement.
  • Provides guidance and peer mentoring to reporting analysts and data staff.
  • Provides technical and functional documentation on project requirements and deliverables.
  • Performs other duties as assigned.

Knowledge, Skills, Abilities

  • Knowledge of fundraising operations in higher education, healthcare, or nonprofit settings, including gift and pledge accounting principles and advancement reporting standards.
  • Advanced proficiency in a business intelligence platform such as Power BI, Tableau, or Qlik, including data modeling, predictive modeling, calculated measures, and dashboard design for executive and operational audiences.
  • Advanced SQL skills and experience working with relational databases and data warehouses.
  • Experience working with a CRM or constituent database, such as Raiser's Edge NXT, Blackbaud CRM, Salesforce, Slate, Ellucian CRM Advance, or a comparable system.
  • Familiarity with grateful patient fundraising and HIPAA requirements governing the fundraising use of protected health information, or the ability to develop that knowledge quickly.
  • Ability to translate complex data into clear, actionable insight for fundraisers and senior leadership.
  • Excellent oral and written communication, strong critical thinking and problem solving, and close attention to detail.
  • Ability to manage multiple priorities and work independently.

All remote work must be performed within one of the MCW registered payroll states, which currently includes: WI, AZ, DE, FL, GA, IL, IN, MD, MI, MN, MO, NC, TN, TX, and UT.


Qualifications

Appropriate experience may be substituted for education on an equivalent basis.


Minimum Required Education:  Bachelor's degree

Minimum Required Experience:  5 years of experience in data analysis, business intelligence, or reporting, including SQL development, data modeling, and dashboard design in Power BI, Tableau, or a comparable tool.

Preferred Education: Bachelor's Degree or Master's degree in data analytics, information systems, statistics, business, or a related field

Preferred Experience:  3 or more years of experience in higher education, healthcare, or nonprofit advancement, including analytics supporting prospect research, planned giving, alumni relations, business development, government relations or grateful patient programs. Experience with predictive modeling, RFM segmentation, or donor lifecycle modeling and with CRM data migration or conversion.

Preferred Certification/Licensure(s):  Microsoft Certified Power BI Data Analyst Associate, Tableau Certified Data Analyst, or comparable analytics certification


Physical Requirements

Work requires occasionally lifting moderate weight materials, standing, or walking continuously.


Work Environment

Occasional exposure to dust, noise, temperature changes, or contact with water or other liquids. Work is performed in an environmentally controlled environment.


Sensory Acuity

Ability to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects. #LI-NK1


Target salary range for this position is between $87,100 and $111,500 annually. The final offered salary will depend on the applicant’s education, experience, skills, and knowledge, as well as considerations of internal equity and market alignment.



Why MCW?

  • Outstanding Healthcare Coverage, including but not limited to Health, Vision, and Dental. Along with Flexible Spending options
  • 403B Retirement Package
  • Competitive Vacation and Paid Holidays offered
  • Tuition Reimbursement
  • Paid Parental Leave
  • Employee & Family Assistance Program (EFAP)
  • Pet Insurance
  • On campus Fitness Facility, offering onsite classes
  • Additional discounted rates on items such as: Select cell phone plans, local fitness facilities, Milwaukee recreation and entertainment etc.

For a brief overview of our benefits see: Benefits Overview


For a full list of positions see: MCW Careers

At MCW all of our endeavors, from our internal operations to our interactions with our partners, are driven by our shared organizational values: Caring – Collaborative – Curiosity – Inclusive – Integrity – Respect. We are committed to fostering an inclusive environment that values diversity in backgrounds, experiences, and perspectives through merit-based processes and in alignment with all applicable laws. We believe that embracing human differences is critical to realize our vision of a healthier world, and we recognize that a healthy and thriving community starts from within. Our values define who we are, what we stand for and how we conduct ourselves at MCW. If you believe in embracing individuality and working together according to these principles to improve health for all, then MCW is the place for you. For more information, please visit our institutional website.


MCW as an Equal Opportunity Employer and Commitment to Non-Discrimination:


The Medical College of Wisconsin (MCW) is an Equal Opportunity Employer. We are committed to fostering an inclusive community of outstanding faculty, staff, and students, as well as ensuring equal educational opportunity, employment, and access to services, programs, and activities, without regard to an individual's race, color, national origin, religion, age, disability, sex, gender identity/expression, sexual orientation, marital status, pregnancy, predisposing genetic characteristic, or military status. Employees, students, applicants or other members of the MCW community (including but not limited to vendors, visitors, and guests) may not be subjected to harassment that is prohibited by law or treated adversely or retaliated against based upon a protected characteristic.


Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Ability to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects. #LI-NK1 Target salary range for this position is between $87,100 and $111,500 annually. The final offered salary will depend on the applicant’s education, experience, skills, and knowledge, as well as considerations of internal equity and market alignment. Why MCW?
Location & working pattern

Wauwatosa, WI

- Ability to manage multiple priorities and work independently. All remote work must be performed within one of the MCW registered payroll states, which currently includes: WI, AZ, DE, FL, GA, IL, IN, MD, MI, MN, MO, NC, TN, TX, and UT. Qualifications
Work authorization
- Builds and implements reports to support fundraising metrics and business rules for gift and pledge counting, soft credit, campaign counting, and fiscal year reporting consistent with CASE Global Reporting Standards. - Partners with enterprise units including Business Development and Government Relations to deliver reporting on corporate and foundation relationships, industry partnership pipeline, and sponsorship revenue, along with analysis that connects donors, board members, and community partners to elected officials and government stakeholders in support of advocacy and relationship strategy. - Partners with Prospect Management and Research to accelerate prospect identification through reporting and metrics, including identification queues that surface constituents with strong capacity and affinity, pipeline and portfolio coverage analysis, and data quality checks that ensure wealth screening results, research ratings, and relationship data are accurately associated with constituent records.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.