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.
Wauwatosa, WI
Live, first seen by us 33 days agoAbility 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
Employment type in the employer’s posting: Full timeFrom the employer’s 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
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
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
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
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
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.
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.
1 open job
Open jobs by the week we first saw them, last 12 weeks.
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.
- 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
Complete your application on mcw.wd503.myworkdayjobs.com. The employer’s form will show what is required.
Already applied? Track this application
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.
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.
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
Work requires occasionally lifting moderate weight materials, standing, or walking continuously.
Occasional exposure to dust, noise, temperature changes, or contact with water or other liquids. Work is performed in an environmentally controlled environment.
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.
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.
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.
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
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.
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.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
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?
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
- 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.