Business Systems Analyst & Administrator

Arouet is a Phoenix-based nonprofit dedicated to expanding opportunity for women impacted by the justice system. The Business Systems Analyst & Administrator plays a critical role in ensuring data systems effectively support participant services and program operations, while also managing user accounts and providing training.

Responsibilities:

• Understand Existing Systems: Develop a deep understanding of Arouet's existing Apricot implementation, current workflows, data architecture, and reporting strategy to ensure enhancements and changes align with organizational goals and long-term system sustainability
• Requirements Gathering: Partner with program staff and leadership to understand the participant experience, workflows, business processes, and operational needs
• Process Improvement: Identify opportunities to improve efficiency, participant tracking, and reporting through system enhancements
• Solution Design: Translate program requirements into practical Apricot solutions that align with organizational goals and best practices for database design and user experience
• System Testing: Partner with program staff using testing best practices to confirm solutions built map to program requirements
• Project Management: Maintain and prioritize a portfolio of Apricot enhancement requests and system improvements
• Form & Database Development: Create and modify forms, records, relationships, and workflows within Apricot
• System Administration: Manage user accounts, permissions, security settings, and configuration for both Sandbox and Production environments
• Platform Optimization: Continuously enhance usability, user experience, and functionality
• System Expertise: Stay current on Apricot updates, product enhancements, and industry best practices through ongoing training and professional development
• Outcome Tracking: Configure systems to track participant journeys, outcomes, performance measures, and funder requirements
• Dashboard Development: Design and maintain operational dashboards, reports, and performance monitoring tools to understand trends, potential challenges, and supporting solutions
• Data Analysis: Analyze program data to support organizational learning, decision-making, and impact measurement
• Data Governance: Develop and maintain data standards, governance practices, and documentation to support consistent and reliable reporting
• Data Quality Assurance: Conduct audits, quality checks, and cleanup activities to ensure data accuracy, integrity, and consistency
• End User Training: Provide ongoing training and technical support to Apricot users across the organization
• Documentation: Develop and maintain user guides, policies, procedures, and training materials
• Change Management: Help the team and participants confidently adopt new processes, enhancements, and system improvements
• User Acceptance Testing: Facilitate testing activities and ensure solutions meet business requirements before implementation

Requirements:

• Minimum two years of experience administering, configuring, or supporting Apricot, Salesforce, Microsoft Dynamics, ETO, Efforts to Outcomes (ETO), Bonterra products, or similar case management/CRM platforms
• Experience facilitating discovery sessions, gathering requirements, testing, and translating business needs into technical solutions
• Experience performing business systems analysis and process improvement
• Experience building forms, reports, dashboards, and database structures
• Knowledge of data governance, data privacy, and quality assurance practices
• Experience with dashboard development, performance metrics, and outcome reporting
• Strong analytical, troubleshooting, and problem-solving skills
• Experience supporting user adoption, training, and change management initiatives
• Proficiency with Microsoft Office applications, particularly Excel
• Excellent communication, collaboration, and relationship-building skills
• Experience supporting nonprofit organizations, social service agencies, or grant-funded programs
• Experience with data visualization and reporting tools such as Power BI, Tableau, Bonterra Impact Hub, or similar platforms preferred
• Experience managing technology or software development projects from concept through implementation
• Knowledge of data security and compliance standards
• Bachelor's degree in Business Information Systems, Information Technology, Data Analytics, or a related field, or 5+ years of experience in the field
• Familiarity with software development methodologies and best practices