What are the responsibilities and job description for the Data Analyst Foundations Operations position at Connecticut Children's?
Job Description
The Data Analyst, Foundation Operations plays a critical role in supporting the Foundation's fundraising and operational success through data management, reporting, prospect research, and gift administration. This position is responsible for maintaining the integrity of constituent and donor data within Salesforce, managing operational workflows, supporting prospect identification efforts, and producing reports that inform fundraising strategy and decision-making.
The Data Analyst serves as a key resource for internal stakeholders by ensuring accurate data management, timely completion of requests, and adherence to established policies and procedures. This role requires strong analytical skills, attention to detail, and the ability to manage multiple priorities in a collaborative and mission-driven environment.
Responsibilities
Research & Prospect Identification-50%
Qualifications
Education and/or Experience Required:
N/A
Knowledge, Skills and Abilities:
Knowledge:
Connecticut Children’s is the only health system in Connecticut that is 100% dedicated to children. Established on a legacy that spans more than 100 years, Connecticut Children’s offers personalized medical care in more than 30 pediatric specialties across Connecticut and in two other states. Our transformational growth establishes us as a destination for specialized medicine and enables us to reach more children in locations that are closer to home. Our breakthrough research, superior education and training, innovative community partnerships, and commitment to diversity, equity and inclusion provide a welcoming and inspiring environment for our patients, families and team members.
At Connecticut Children’s, treating children isn’t just our job – it’s our passion. As a leading children’s health system experiencing steady growth, we’re excited to expand our team with exceptional team members who share our vision of transforming children’s health and well-being as one team.
The Data Analyst, Foundation Operations plays a critical role in supporting the Foundation's fundraising and operational success through data management, reporting, prospect research, and gift administration. This position is responsible for maintaining the integrity of constituent and donor data within Salesforce, managing operational workflows, supporting prospect identification efforts, and producing reports that inform fundraising strategy and decision-making.
The Data Analyst serves as a key resource for internal stakeholders by ensuring accurate data management, timely completion of requests, and adherence to established policies and procedures. This role requires strong analytical skills, attention to detail, and the ability to manage multiple priorities in a collaborative and mission-driven environment.
Responsibilities
Research & Prospect Identification-50%
- Manage the monthly patient screening process, including data preparation, review, and distribution of results.
- Create, maintain, and monitor research-related Cases within Salesforce.
- Conduct prospect research, wealth screening reviews, and basic analysis to support fundraising strategies and portfolio development.
- Assist in identifying new major gift prospects and opportunities for donor engagement.
- Prepare prospect profiles, briefing materials, and research summaries for Foundation leadership and fundraising staff.
- Maintain research records and documentation in accordance with Foundation standards and best practices.
- Salesforce Data & Case Management
- Manage incoming data requests and constituent record updates, ensuring accuracy and completeness within Salesforce.
- Create, assign, monitor, and resolve Salesforce Cases in a timely manner.
- Perform routine data maintenance, audits, and quality assurance activities to ensure data integrity.
- Maintain documentation of processes, procedures, and data governance standards.
- Collaborate with Operations Data team to resolve data issues and improve workflow efficiency.
- Support system enhancements, testing, and process improvement initiatives as assigned.
- Develop, maintain, and distribute recurring and ad hoc reports for fundraising, operations, and leadership teams.
- Support campaign, event, and donor engagement efforts through list generation, segmentation, and data analysis.
- Monitor reporting accuracy and consistency across systems and reports.
- Assist in identifying trends and opportunities through data analysis and reporting insights.
- Provide gift entry and gift processing support during periods of high volume or staff coverage needs.
- Assist with gift reconciliation activities and documentation.
- Ensure compliance with Foundation policies, accounting standards, and audit requirements.
- Support recordkeeping and reporting related to charitable contributions and donor transactions.
- Coordinate agendas, meeting materials, and scheduling for Foundation Operations meetings.
- Document action items and follow-up activities to support project execution and team accountability.
- Participate in and support cross-functional projects related to data management, reporting, prospect research, and gift administration.
- Provide flexible support for departmental priorities and special initiatives as needed.
Qualifications
Education and/or Experience Required:
- Education: Associate’s Degree.
- Experience: Minimum of one-year previous administrative experience, including data entry and report creation.
- Education: Bachelor’s degree.
- Experience: Salesforce or compatible CRM experience preferred.
N/A
Knowledge, Skills and Abilities:
Knowledge:
- Knowledge of constituent relationship management (CRM) systems, preferably Salesforce.
- Understanding of fundraising operations, donor databases, prospect research, and gift administration practices.
- Knowledge of data management principles, including data quality, governance, and reporting standards.
- Familiarity with nonprofit fundraising metrics, donor lifecycle management, and prospect development practices preferred.
- Basic understanding of accounting principles related to charitable gift processing and reconciliation preferred.
- Strong analytical and problem-solving skills with the ability to interpret and present data effectively.
- Advanced attention to detail and commitment to maintaining data accuracy and integrity.
- Proficiency in Microsoft Excel, including data manipulation, reporting, and analysis functions.
- Strong organizational and time-management skills with the ability to manage multiple priorities and deadlines.
- Effective written and verbal communication skills.
- Ability to prepare concise reports, summaries, and presentations for diverse audiences.
- Strong project coordination and administrative skills.
- Ability to learn new technologies, systems, and processes quickly.
- Ability to manage confidential and sensitive information with discretion and professionalism.
- Ability to work independently while contributing effectively within a collaborative team environment.
- Ability to identify process improvement opportunities and recommend practical solutions.
- Ability to prioritize competing demands in a fast-paced environment.
- Ability to maintain accuracy while handling large volumes of data and transactions.
- Ability to build positive working relationships with internal stakeholders and provide exceptional customer service.
- Ability to adapt to changing priorities and departmental needs.
Connecticut Children’s is the only health system in Connecticut that is 100% dedicated to children. Established on a legacy that spans more than 100 years, Connecticut Children’s offers personalized medical care in more than 30 pediatric specialties across Connecticut and in two other states. Our transformational growth establishes us as a destination for specialized medicine and enables us to reach more children in locations that are closer to home. Our breakthrough research, superior education and training, innovative community partnerships, and commitment to diversity, equity and inclusion provide a welcoming and inspiring environment for our patients, families and team members.
At Connecticut Children’s, treating children isn’t just our job – it’s our passion. As a leading children’s health system experiencing steady growth, we’re excited to expand our team with exceptional team members who share our vision of transforming children’s health and well-being as one team.