• Responsible for the research, development and maintenance of the Power BI Reporting Platform for Trillium. • Configuration, implementation, design, and proactive support and management of the organization’s Power BI Platform. • Assists with assessing the organization's reporting needs and helping in the development of a long-term strategy for reporting. • Leading, planning, coordinating, and administering activities relating to reporting systems development, documentation, and implementation. • Provide technical support around systems capabilities to Information Technology projects. • Provides training for IT and Trillium staff, as needed and directed. • Design, build, test, deploy, document, and maintain Power BI reporting solutions and semantic models, including the SQL queries, data pipelines, and dependent systems that power them. • Work with IT Leadership, Informatics - Data Management, IT Operations and IT - Business Systems on researching, developing, testing, deploying and documenting new methods and tools for ingestion, processing, sending and sharing of data. • Plan, coordinate and implement security measures (including regular audits) to safeguard information in reporting platforms.

• Own the architecture and evolution of the shared components • Design and build the CI/CD patterns, deployment pipelines, observability tooling • Lead the team on AI tooling adoption • Carry work from requirements shaping and solution design through deployment • Articulate a clear engineering direction to your team and to stakeholders • Actively grow the engineers around you

Description Work Location: Eugene or remote position available for ideal/qualified candidate. DEPARTMENT SUMMARY: Holt’s Information Technology department delivers timely and effective technology services to staff, families, and constituents, ensuring high integrity and efficiency in Holt’s work. The IT department is committed to providing reliable and secure systems to support staff productivity. POSITION SUMMARY: The Business Systems Analyst (BSA) combines aspects of both data analysis and systems analysis. This role will analyze business processes, gather requirements, and support the design, implementation, and optimization of information systems that enable program delivery, fundraising, monitoring and evaluation. The role will leverage and provide data to identify areas for improvement, efficiency gains, and better business decisions. Duties will include helping the organization decide how best to use its existing technology or integrate new ones into existing systems. ESSENTIAL JOB FUNCTIONS: - Requirement Gathering and Analysis: - Gather and document detailed business requirements from stakeholders, translating them into clear, concise, and actionable technical specifications. - Conduct process mapping to identify gaps, inefficiencies, and opportunities for improvement. - System Design and Development: - Support the development, customization, and deployment of systems (CRM, ERP, M&E platforms, grants management, etc.). - Partner with vendors to ensure solutions align with user needs and organizational policies. - Testing and Implementation: - Participate in testing new systems or system updates to ensure they meet requirements and function as intended, and they support the implementation process. - Assist in facilitating user acceptance testing (UAT) and coordination of rollouts. - Communication and Collaboration: - Communicate effectively with various stakeholders, including business users, technical teams, and management, ensuring a clear understanding and alignment on project goals. - Troubleshooting and Support: - Troubleshoot system issues, provide support to users, provide enhancements and work to optimize system performance. - Develop user guides, training materials, and process & design documentation. - Project Management: - May lead or participate in projects, ensuring they are completed on time, within scope, and within budget. - Database administration and Analytics: - Maintain Holt’s databases, assist in data migration and mapping during system implementation, build reports and visualizations that highlight KPIs that support the decision-making process. COMPETENCIES: - Strong organizational, time management, and verbal and written communication skills. - Ability to manage multiple projects simultaneously and adapt to changing priorities. - Ability to work collaboratively in a team environment. - Proficiency in data analysis, including compiling and analyzing data from various sources. - Proficiency in Power BI, SQL, and Power Automate preferred. - Knowledge of data integration and reporting. - Prioritize workload daily, weekly, and monthly. - Knowledge of CRM and database systems. - Technical support skills. SUCCESS FACTORS: The successful Business Systems Analyst will be detail-oriented, capable of managing a multi-faceted workload in a fast-paced environment. They must have strong problem-solving and analytical skills, with the ability to perform multiple tasks concurrently. Proficiency in utilizing various IT platforms and sound judgment in decision-making are essential. Requirements KNOWLEDGE (MINIMUM REQUIREMENTS): - Bachelor’s degree in a related field and three (3) years of experience, or combination of education and experience. - Relevant experience and strong analytical, communication, and problem-solving skills are crucial. - Demonstrated proficiency and/or ability to master IT Systems including: Blackbaud CRM, Luminate Online, MS Dynamics, Power BI, MS Office, ManageEngine. SCOPE OF RESPONSIBILITY: Assists in-person and remote users at Holt International HQ in Eugene, OR, out-of-state branch office staff in addition to assisting staff while traveling out of country. Occasionally provide basic IT services to international staff. INTERPERSONAL COMMUNICATION: Ability to communicate clearly with other staff to obtain cooperation and actions needed to ensure successful project outcomes. Establishes and maintains positive relationships with commercial vendors. Must possess the ability to communicate clearly with stakeholders, facilitators and partners. Communicates respectfully and is sensitive to cross-cultural issues. IMPACT OF RESULTS: Assesses requirements, procedures and problems to create or improve systems and processes. Improving infrastructure and team capacity will lead directly and indirectly to increased donor retention, donor engagement, and donor pipeline growth. REPORTS DIRECTLY TO: IT Management, who reviews work for effectiveness and results obtained. WORKS DIRECTLY WITH: Philanthropy & Communications Department, Finance & Administration, International Programs, and Adoption Services staff. Works with external consultants, vendors and at times international staff.

• Administer our Salesforce org: object model, data architecture, user configuration, and platform health. • Build and maintain automations via Salesforce Flows, Apex, and custom services that power our GTM processes end to end. • Develop and maintain Salesforce MCP servers and AI tooling that extend CRM functionality into AI-powered workflows. • Design and maintain SQL-based data pipelines that feed dashboards and revenue reporting across the org. • Translate ambiguous business problems into clean technical scope, from stakeholder conversation to implemented solution.