Job Description
Hourly Pay Range:
$30.46 - $45.69 - The hourly pay rate offered is determined by a candidate's
expertise and years of experience, among other factors.
Philanthropy Data and Reporting Analyst
Endeavor Health foundations seek a detail-oriented and positive team member to
prepare and analyze donor, prospect, and patient data and prepare email segments
to drive the identification, qualification, cultivation and solicitation of
donors and develop market strategies for the segmentation of donors and
prospective donors across all giving levels. The supply of data driven analytics
will facilitate strategic outreach and fundraising efforts to engage and retain
donors across the foundations’ teams.
The candidate will work with other members of the Philanthropy Operations,
Prospect Development & Research, Communications and frontline fundraising teams,
under the direction of the Philanthropy Database & Reporting Director and in
partnership with the Philanthropy Analytics & Donor Services Director, to
prepare and evaluate data insights to inform appeal segments, identify key
trends in donor data, and drive analysis and reporting to inform cultivation and
solicitation strategies. They will work collaboratively with foundations’ teams
to build standard reports, actionable analytics dashboards, and complete custom
reporting and analytics requests to achieve fundraising goals.
Position Highlights:
- Position: Philanthropy Data and Reporting Analyst
- Location: Evanston, IL
- Full Time/Part Time: Full time
- Hours: Monday-Friday, 8:30am-5pm
- Required Travel: travel to other Endeavor Health locations may be required
What you will do:
* Implement, document, and monitor segmentation strategies, processes, and
automation of classification and interests of donors and prospects to support
donor acquisition, renewal, and upgrade activity.
* Pull queries and reports to build donor segmentation and analysis by
developing predictive models, spearheading analysis, and advising on
campaigns to drive donors through the giving pipeline.
* Utilize data analytics to advance segmentation, prospect identification, and
donor retention/upgrades.
* Ensure data handing is completed with discretion and aligns with best
practices, regulatory requirements, PCI standards, HIPAA and privacy laws.
* Develop new data models and data driven pipeline analysis to inform portfolio
assignments and strategic segmentation, serving as the subject matter expert
for predictive modeling and market strategy across Endeavor Health’s
foundations.
* Provide data analysis to support prospect development and donor segmentation
plans, working collaboratively with fellow Philanthropy Operations team and
foundations’ teams, including frontline fundraisers, to inform strategic
moves management through donor acquisition, renewal, and upgrade activity,
including spearheading analysis and advising on campaigns to drive donors
through the giving pipeline, from annual giving donor to mid-level donor and
beyond.
* Provide support for Salesforce Marketing Cloud email platform by developing
data extensions, assisting with production of outreach for advanced system
usage, and providing support for the Philanthropy Communications team
utilizing the product.
* Develop strategies for and assist in executing annual and mid-level giving
A/B testing.
* Evaluate giving performance, trends, and opportunities within specific
constituencies, segments, projects, and programs to make actionable and
evidence-based recommendations. Maintain a proactive data hygiene plan, with
routine audits and updates to the system.
* Create reports, dashboards, and data analysis to support the foundations’
teams in their work, following and developing best practices for efficiency,
processing, and data visualization.
* Proactively maintain and update Standard Operating Procedures to document
consistent data workflows to ensure reliable outputs; train teams with
ongoing updates.
* Maintain and advise on scalable processes that ensure best practices in data
integrity and cross-functional team data management to achieve targeted donor
journeys such as mid-level giving, first time donors and messaging tracks.
* Identify and make recommendations on how the teams can improve data accuracy,
streamlining, and analysis.
What you will need:
- Education: Bachelor’s degree, required
- Certification: Preferred certifications in Salesforce, Marketing Cloud,
and/or Tableau including but not limited to 1 or more of the following -
Salesforce Certified Platform Administrator, Salesforce Certified CRM
Analytics and Einstein Discovery Consultant, Salesforce Certified Business
Analyst, Salesforce Marketing Cloud Certifications, Salesforce Tableau
Certifications
* Experience:
* 3-5+ years’ experience working with data and using analytics tools like
Tableau, SQL or SAS to develop reports, dashboards, and provide data
analysis in a consumer or donor centric setting is required.
* 3-5+ years’ experience with Salesforce and Salesforce Marketing Cloud or
other CRMs is required.
* Unique or Preferred Skills:
* Proficiency with MS Office is strongly preferred, advanced Excel is a
bonus.
* The candidate must be tech-savvy and be an avid learner with a keen
interest in data, fundraising, nonprofit management, and donor relations.
* Experience in market segmentation strategy, techniques, and practices
including data augmentation, segregation, and market analysis.
* Experience with data and/or statistical analytics tools, like Tableau, SQL
or SAS is required.
* Experience or exposure to data modeling tools and techniques is preferred,
specifically the ability to identify, analyze, and interpret trends or
patterns in complex data sets.
* Able to handle sensitive and confidential information appropriately and
with discretion.
* Excels in project management: multi-tasking, goal setting, accountability,
attention to detail and workload prioritization.
* Strong written, verbal, organizational, and interpersonal and communication
skills; demonstrated ability to relate well to individuals from diverse
backgrounds.
* Must be flexible and adaptable to changing priorities and proactively
address challenges in a fast-paced, emerging and changing environment with
ongoing deadlines.
* Ability to constructively accept and process feedback and a collaborative
working style.
* Continuously seek ways to improve processes, increase efficiencies and
actively pursue professional development opportunities.
- Full suite of Microsoft Office applications
- Salesforce Nonprofit Cloud, or similar CRM experience
- CRM Analytics or Tableau Reporting
- Salesforce Marketing Cloud, or similar complex email marketing experience
- Project planning tools
Benefits (For full time or part time positions):
- Opportunity for annual increases based on performance
- Career Pathways to Promote Professional Growth and Development
- Various Medical, Dental, Pet and Vision options
- Tuition Reimbursement
- Free Parking
- Wellness Program Savings Plan
- Health Savings Account Options
- Retirement Options with Company Match
- Paid Time Off and Holiday Pay
- Community Involvement Opportunities
Endeavor Health is a fully integrated healthcare delivery system committed to
providing access to quality, vibrant, community-connected care, serving an area
of more than 4.2 million residents across six northeast Illinois counties. Our
more than 25,000 team members and more than 6,000 physicians aim to deliver
transformative patient experiences and expert care close to home across more
than 300 ambulatory locations and eight acute care hospitals – Edward
(Naperville), Elmhurst, Evanston, Glenbrook (Glenview), Highland Park, Northwest
Community (Arlington Heights) Skokie and Swedish (Chicago) – all recognized as
Magnet hospitals for nursing excellence. For more information, visit
[
When you work for Endeavor Health, you will be part of an organization that
encourages its employees to achieve career goals and maximize their professional
potential.
Please explore our website (
[ to better understand how Endeavor Health
delivers on its mission to “help everyone in our communities be their best”.
Endeavor Health is committed to working with and providing reasonable
accommodation to individuals with disabilities. Please refer to the main career
page for more information.
At Endeavor Health, we are united by a shared commitment to working together to
create a culture of connection and belonging—each of us bringing different
skills and experiences as we deliver safe, seamless, and personal care. Every
person, every time. We are committed to fostering an environment where all team
members can be their best, learn, and pursue excellence together.
EOE: Race/Color/Sex/Sexual Orientation/ Gender Identity/Religion/National
Origin/Disability/Vets, VEVRRA Federal Contractor.
Job Tags
Hourly pay, Full time, Part time, For contractors, Monday to Friday, Flexible hours