Database Administrator and Analyst at aipconnect

Our client a leading edge digital hospital is is looking to hire a Database Administrator and Analyst.   Reporting to the Director, Data & Donor Systems, the Database Administrator & Analyst is responsible for the day-to-day administration, configuration, and maintenance of the Foundation’s donor database systems, including Raiser’s Edge. This role focuses on executing database operations, maintaining data integrity, managing system configurations, and supporting data processes across fundraising and finance functions. The role ensures that data is accurate, consistent, and aligned with established data governance standards. Working closely with Gift Administration, Finance, and Development teams, this role plays a key operational function in maintaining the reliability and effectiveness of the Foundation’s data environment. Database Administration & Configuration • Administer and maintain Raiser’s Edge and related fundraising systems on a day-to-day basis • Maintain configuration of code tables, attributes, campaigns, appeals, and fund structures, ensuring consistency and alignment with established data standards • Manage user access, permissions, and security groups in alignment with established policies • Monitor system performance and support ongoing database stability and reliability • Perform routine system updates and assist with troubleshooting system and data issues Data Operations & Processing • Execute imports, exports, and bulk data updates within Raiser’s Edge • Perform global changes and mass updates in accordance with defined business rules • Prepare and manage data files for campaigns, vendors, and operational needs • Execute and support all data entry activities, including manual entry where required • Oversee and monitor automated data entry processes, ensuring accuracy, completeness, and alignment with established data governance standards • Support ongoing data processing activities across fundraising operations Data Integrity & Quality Control • Perform regular data audits, validation checks, and clean-up activities • Support scheduled data quality reviews and audit processes to ensure ongoing integrity of donor and campaign data • Identify and correct data inconsistencies and errors • Ensure adherence to data governance standards and coding structures • Escalate complex data issues to the Senior Manager as required Security & Access Management • Maintain user access controls and permissions within the database • Support enforcement of data security and access policies • Ensure appropriate handling and protection of donor data Reporting & Data Support • Develop and execute queries, lists, and reports as requested • Support data extraction for campaigns and operational reporting • Ensure accuracy and consistency of all data outputs Integration & System Support • Assist in monitoring data flow between Raiser’s Edge and integrated systems • Support troubleshooting of data discrepancies across platforms • Work with vendors and internal teams to support system functionality User Support & Documentation • Provide day-to-day support to users for database-related requests • Assist staff with queries, reports, and system usage • Maintain documentation for data processes and system workflows Collaboration & Cross-Functional Support • Work closely with Gift Administration to support accurate data entry and record maintenance • Collaborate with Finance to support reconciliation processes by ensuring donor database records are accurate and aligned with financial data • Support Development teams with campaign data preparation and execution Qualifications • Post-secondary education in Information Systems, Business, or related field • 4–6 years of experience working with CRM systems (Raiser’s Edge preferred) • Experience working with Raiser’s Edge and familiarity with Financial Edge or similar financial systems, with an understanding of how donor data aligns with financial records • Knowledge of charitable gift administration and nonprofit financial practices considered an asset • Strong attention to detail and commitment to data accuracy Skills & Competencies • Working knowledge of CRM systems (Raiser’s Edge and Financial Edge preferred) • Experience with queries, data extraction, and database operations • Strong attention to detail and data accuracy • Ability to execute repetitive and detailed tasks with high accuracy • Strong problem-solving and troubleshooting skills • Ability to manage multiple requests and deadlines • Strong communication and collaboration skills • Commitment to confidentiality and data integrity Working Conditions • Hybrid Working Environment: 3 days/week in-office – Tues/Wed/Thurs • Occasional extended in-office hours (Mon/Fri) during month-end, audits, database integrations or campaign launches AIP Connect believes in equal opportunity. Our recruitment consultants are committed to inclusive recruitment and selection practices and will not discriminate based on age, colour, ability, national origin, race, religion, sex, or sexual orientation. Accessibility:  If you need any accommodations during the interview process, please let us know. Posted Salary: Actual compensation within this range will be determined based on job-related skills, relevant experience, education, and training. This range reflects base salary only and does not include eligibility for bonus program or other benefits. For the most accurate and up-to-date details on this role, please refer directly to AIP Connect’s careers page, as third-party sites may not reflect current information.