DATA AND AGENTIC AI PLATFORM ENGINEER (REMOTE)

ProspectEngage® is an economic development technology and business intelligence company providing software, data, artificial intelligence, and digital tools for economic development organizations and government agencies. The Data and Agentic AI Platform Engineer will strengthen the platform’s data and application foundation by improving data quality, building ingestion and synchronization pipelines, developing secure agentic AI workflows, and supporting backend, API, frontend, integration, testing, and deployment activities.

Responsibilities:

• Design and improve relational data models across PostgreSQL and Dataverse, including entities, relationships, constraints, indexes, migrations, and lifecycle rules
• Build repeatable ingestion, transformation, enrichment, entity-resolution, deduplication, and synchronization workflows for company, contact, project, activity, survey, and market-intelligence data
• Establish practical data-quality controls, validation rules, provenance, lineage, audit logs, rollback paths, and exception-review workflows
• Develop and maintain Python/FastAPI services, REST APIs, webhooks, background jobs, and third-party integrations with strong authentication, error handling, observability, retries, rate-limit handling, and idempotency
• Build secure agentic AI workflows using structured outputs, retrieval, tool/function calling, workflow state, memory, human approvals, and clear permission boundaries
• Create evaluation datasets and automated checks for retrieval quality, extraction accuracy, hallucination risk, tool selection, data writeback, cost, latency, and regression testing
• Implement private knowledge and retrieval services that combine client-authorized data with external intelligence while preserving tenant isolation, access controls, source citations, and data-retention requirements
• Develop React interfaces for data review, exception handling, approvals, dashboards, configuration, and agent activity/audit trails
• Integrate ProspectEngage® with Microsoft Dynamics 365/Dataverse, Power Platform, Microsoft 365, and external data providers using OAuth 2.0, OData, REST APIs, and webhooks
• Contribute to testing, CI/CD, deployment, monitoring, incident troubleshooting, technical documentation, and code review
• Translate real economic-development workflows into maintainable product requirements and explain technical tradeoffs to non-technical teammates

Requirements:

• Exceptional early-career candidates with strong demonstrated work may be considered
• Strong SQL and relational data-modeling skills, including joins, constraints, indexing, query tuning, transactions, schema migrations, and debugging data integrity issues
• Experience building or maintaining ETL/ELT or API-based pipelines, with practical approaches to deduplication, entity matching, data validation, provenance, and reconciliation
• A disciplined approach to production data changes: staging, backups or rollback plans, idempotent operations, auditability, and readback verification
• Strong Python fundamentals and experience working in an existing production codebase
• Experience building or maintaining REST APIs
• Working knowledge of authentication and authorization, OAuth 2.0, JSON, webhooks, pagination, rate limits, asynchronous work, background jobs, logging, and error handling
• Hands-on experience integrating LLM APIs into software using structured outputs and tool/function calling
• Understanding of retrieval-augmented generation (RAG), embeddings or hybrid search, chunking and metadata strategies, workflow state, agent memory, and model/provider abstraction
• Ability to design human-in-the-loop approvals, guardrails, permissions, citations, evaluation harnesses, and monitoring for agent behavior
• Ability to identify and mitigate prompt injection, data leakage, over-permissioned tools, hallucinated actions, and unsafe or unverified writebacks
• Working experience with Git/GitHub, pull requests, code review, automated testing, environment management, and basic Linux/cloud operations
• Ability to trace failures across frontend, backend, database, authentication, external APIs, configuration, and infrastructure
• Comfort using AI coding tools such as Codex, Claude, or similar systems while independently reviewing, testing, and taking responsibility for the resulting code
• Ability to turn ambiguous operational needs into scoped technical requirements and incremental releases
• Clear written documentation and the ability to explain decisions, risks, and tradeoffs to technical and non-technical colleagues
• Curiosity, independence, and sound judgment about when automation should act, when it should ask for approval, and when it should stop
• We expect the strongest candidates to have approximately 3+ years of relevant software, data, or platform engineering experience, or an equivalent portfolio demonstrating production-quality work
• A specific degree is not required
• You do not need to be an expert in every technology on day one, but you must have strong fundamentals, learn quickly, and be able to own work through design, implementation, testing, deployment, and documentation
• Applicants must be authorized to work in the United States
• We are unable to sponsor employment visas
• FastAPI or a similar framework is strongly preferred
• Microsoft Dynamics 365/Dataverse, including tables, lookups, custom fields, OData/Web API, app registrations, security roles, and solution-aware development
• Microsoft Power Platform, Microsoft Graph, Power Automate, or Power Apps
• React/JavaScript or TypeScript, including components, hooks, forms, tables, filtering, pagination, and API integration
• PostgreSQL extensions or search technologies such as pgvector, full-text search, hybrid retrieval, or a comparable vector/search platform
• Multi-tenant SaaS architecture, role-based access control, secrets management, encryption, privacy, and secure handling of client or government data
• Containers, cloud hosting, CI/CD, queues or schedulers, application monitoring, and deployment troubleshooting
• CRM systems, master data management, business intelligence, data enrichment, or economic development workflows