Merchant McIntyre & Associates (MM) is a Washington, DC–based federal grants and government relations firm supporting nonprofit institutions and organizations in advancing their federal funding and legislative advocacy goals.
We are seeking a hands-on consultant to strengthen our internal technology systems, improve existing AI tools, and develop new workflows that support our client work. This engagement combines database development, systems integration, applied AI, and practical staff support.
The engagement will initially be short-term, with the potential for additional work based on the firm’s needs. We welcome remote consultants, with a preference for someone in the greater Washington, DC area.
PROPOSED SCOPE
I. CMS Database and Back End Development
- Maintain and extend the firm’s CMS database, including schema changes, new fields and supporting functionality, migrations, data cleanup, and bug fixes.
- Improve performance, reliability, and stability as the firm adds users and expands system use.
- Diagnose underlying issues and implement durable fixes.
II. Systems Integration
- Build and maintain integrations among the CMS, Microsoft SharePoint, Salesforce, and QuickBooks.
- Establish reliable data synchronization, including clear rules for record ownership, field mapping, duplicate handling, and updates.
- Implement monitoring and error handling so failed syncs and data discrepancies can be identified and resolved.
III. AI Agents and Workflows
- Maintain and improve existing AI agents, skills, and workflows, including developing an SOP for creating additional agents and skills.
- Develop new tools for activities such as backgrounder preparation, grant-fit scanning, and grant writing.
- Build workflows that use appropriate source material, produce consistent outputs, and incorporate human review where needed.
IV. Support and Knowledge Transfer
- Serve as the primary technical resource for issues involving the tools and workflows covered by the engagement.
- Document how each tool and integration works, including dependencies, configuration, access requirements, routine maintenance, and troubleshooting.
- Help staff use AI tools effectively, recognize limitations, and review outputs.
- Support practical implementation of the firm’s AI policy, including approved tools, confidential data handling, access controls, and review expectations.
Future Objectives:
State Grant Tracking Application Development
- Improve application reliability and accuracy in tracking state grants using MM’s state grant tracking tool.
- Maintain and improve efficiency of Claude Console APIs and back-end database infrastructure.
- Diagnose underlying issues and implement durable fixes.
- Hands-on database experience, including SQL, schema design, migrations, and data cleanup.
- Experience building applications or agents using LLM APIs, such as Anthropic or OpenAI, including tool use, structured outputs, and accuracy evaluation.
- Proficiency in Python and/or JavaScript for scripting, automation, and integration work using REST APIs and webhooks.
- Experience with Salesforce’s data model and APIs.
- Comfort working within Microsoft 365 and SharePoint, where much of the firm’s legacy data resides.
- Strong judgment when handling confidential client and business information, including appropriate access controls, preventing sensitive data from entering unapproved public tools, and secure knowledge transfer.
- Ability to troubleshoot existing systems, communicate clearly with nontechnical staff, and deliver practical solutions independently.
PREFERRED QUALIFICATIONS
- Experience with Supabase.
- Experience integrating QuickBooks and working with Microsoft Graph or SharePoint APIs.
- Experience improving inherited systems and AI workflows.
- Familiarity with professional services, government relations, grants, or nonprofit organizations.
- Availability in the greater Washington, DC area for occasional in-person collaboration.
Target compensation: $70–$120 per hour, depending on experience and qualifications.