Mercy Medical Center Clinton Senior Donor Data Analyst in Livonia, Michigan
The Senior Donor Data Analyst reports to the Manager of Philanthropy Data Operations and functions as a lead analyst and Subject Matter Expert (SME) for the Trinity Health standard Donor Data Management application and associated business processes and business intelligence report writing functions. The Senior Donor Data Analyst is also responsible for conducting application and/or business intelligence application and reports training with RHM Foundation and Development Office colleagues. The Senior Donor Data Analyst functions as a liaison between the RHM and vendor of the Donor Data Management application.
Knows, understands, incorporates and demonstrates the Trinity Health Mission, Vision and Values in behaviors, practices and decisions.
Consults with RHM Colleagues and Project Teams to gather information about application or reporting issues, application training needs and/or new report requests. The Senior Donor Analyst will coordinate and prioritize all reporting issues & requests.
Gathers business requirements from RHM Colleagues for new business intelligence reporting requests or donor data management application enhancements.
Troubleshoots donor data management application issues and works with customer and vendor to provide resolution.
Proactively assists users in determining more efficient ways to utilize and interpret fundraising data.
The Senior Donor Data Analyst will assist in coordinating workload for other Donor Data Analysts on the team.
Supports the testing of the donor data management application software, business intelligence, reports and associated integration with other Trinity Health applications. Develops testing plan and test scripts needed to test new functionality.
The Senior Donor Data Analyst will lead all aspects of Design, Development, Documentation, Testing and Deployment of custom reports, database smart queries, data exports and Key Performance Indicator (KPI) Dashboards within the Donor Data Management application. Utilize advanced knowledge and skills in working with the following report writing tools: Microsoft SQL & SQL Server Reporting Services (SSRS), Microsoft Excel, Tableau, Data Warehousing and Online Analytical Processing (OLAP) business intelligence technology.
The Senior Donor Data Analyst will manage the onsite Report Server environment and will be responsible for ensuring a copy of the production database is downloaded to the server regularly and work with TIS to ensure the server is maintained and performing properly.
Extensive training in the Donor Data Management Application, Business Intelligence and Fundraising Operations will be essential to being successful in this role.
Assures the adherence to donor data quality standards.
Maintains a working knowledge of applicable Federal, State and local laws and regulations, the Trinity Health Integrity and Compliance Program and Code of Conduct, as well as other policies and procedures in order to ensure adherence in a manner that reflects honest, ethical and professional behavior.
- College degree and/or certification in Information Technology, Business Administration, and/or an
equivalent combination of educational and work experience is required.
- 3-5 years of experience with database structures, application support and/or report writing skills
required. Fundraising/Donor Data Management application support experience in a Healthcare or
Higher Education setting preferred.
- Advanced knowledge and experience in the following Report Writing Tools is preferred: Microsoft
SQL & SQL Server Reporting Services (SSRS), Software Development Kit (SDK), Object Oriented
Programming (OOP), Microsoft Excel, Tableau, Data Warehousing and Online Analytical Processing
(OLAP) business intelligence technology.
- Previous Donor database application support is preferred. Strong analytical & problem solving skills
are required. Experience in an application support/customer support role is preferred.
- Must possess excellent written and verbal communication skills to be able to develop and deliver
training to RHM Colleagues and define business requirements.
Must be able to operate effectively in a collaborative, shared leadership environment.
Must possess a personal presence that is characterized by a sense of honesty, integrity and caring
with the ability to inspire and motivate others to promote the philosophy, mission, vision, goals and
values of Trinity Health.
PHYSICAL AND MENTAL REQUIREMENTS AND WORKING CONDITIONS
- Must be able to adapt to frequently changing work priorities, and be able to prioritize and
balance the requirements of working with the System Office and Regional Health Ministries
- Must be able to travel to various Trinity Health sites as needed.
The above statements are intended to describe the general nature and level of work being performed by persons assigned to
this classification. They are not to be construed as an exhaustive list of duties so assigned.
Trinity Health's Commitment to Diversity and Inclusion
Trinity Health employs about 133,000 colleagues at dozens of hospitals and hundreds of health centers in 22 states. Because we serve diverse populations, our colleagues are trained to recognize the cultural beliefs, values, traditions, language preferences, and health practices of the communities that we serve and to apply that knowledge to produce positive health outcomes. We also recognize that each of us has a different way of thinking and perceiving our world and that these differences often lead to innovative solutions.
Trinity Health's dedication to diversity includes a unified workforce (through training and education, recruitment, retention and development), commitment and accountability, communication, community partnerships, and supplier diversity.
Trinity Health is one of the largest multi-institutional Catholic health care delivery systems in the nation, serving diverse communities that include more than 30 million people across 22 states. Trinity Health includes 94 hospitals, as well as 109 continuing care locations that include PACE programs, senior living facilities, and home care and hospice services. Its continuing care programs provide nearly 2.5 million visits annually.
Based in Livonia, Mich., and with annual operating revenues of $17.6 billion and assets of $24.7 billion, the organization returns $1.1 billion to its communities annually in the form of charity care and other community benefit programs. Trinity Health employs about 133,000 colleagues, including 7,800 employed physicians and clinicians.
Committed to those who are poor and underserved in its communities, Trinity Health is known for its focus on the country's aging population. As a single, unified ministry, the organization is the innovator of Senior Emergency Departments, the largest not-for-profit provider of home health care services — ranked by number of visits — in the nation, as well as the nation’s leading provider of PACE (Program of All Inclusive Care for the Elderly) based on the number of available programs. For more information, visit www.trinity-health.org (http://www.trinity-health.org/) . You can also follow @TrinityHealthMI on Twitter.