<h1>Senior Full-Stack Developer (FastAPI + PostgreSQL + Multi-Tenant SaaS)</h1>
<h2>Project: TaxNGOHealth Cloud Platform</h2>
<p>
We are building a <strong>multi-tenant SaaS platform</strong> called
<strong>TaxNGOHealth Cloud Platform</strong> that serves three verticals:
</p>
<ul>
<li><strong>Tax Practice Management (USA)</strong></li>
<li><strong>Healthcare / Revenue Cycle Management (RCM)</strong></li>
<li><strong>NGO / Fund Accounting (Global)</strong></li>
</ul>
<p>
A full backend scaffold already exists using <strong>FastAPI + PostgreSQL + SQLAlchemy + Alembic</strong>,
with multi-tenant support, authentication, and vertical-specific CRUD modules.
We now need an experienced developer or small team to take the platform from
<strong>scaffold → MVP</strong> across three phases.
</p>
<hr />
<h2>✅ What Is Already Completed</h2>
<h3>1. Platform Backbone</h3>
<ul>
<li>Multi-tenant architecture with <code>tenant_id</code> on all core models</li>
<li>JWT authentication via <code>AuthContext</code> and dependency injection</li>
<li>FastAPI application structured under <code>/api/v1/...</code></li>
<li>PostgreSQL + SQLAlchemy ORM configuration</li>
<li>Alembic migrations configured and initial schema applied</li>
<li>Core tables: tenants, users, audit logs</li>
<li>OpenAPI (JSON + YAML) and Postman collection generated</li>
<li>Repo-level docs: <code>DEV_STATUS.md</code>, vertical READMEs</li>
</ul>
<h3>2. Tax Vertical (USA)</h3>
<ul>
<li>Models: <code>tax_clients</code>, <code>tax_returns</code></li>
<li>Full CRUD endpoints with filtering & pagination</li>
<li>Vertical documentation & flows</li>
<li>Multi-tenant aware (scoped by <code>tenant_id</code>)</li>
</ul>
<h3>3. Healthcare / RCM Vertical</h3>
<ul>
<li>Models: <code>Claim</code>, <code>Denial</code></li>
<li>Full CRUD endpoints with filters (insurer, status, date range)</li>
<li>Reporting endpoints (implemented as stubs with real SQL templates in comments):</li>
<ul>
<li><strong>Claims Aging Report</strong></li>
<li><strong>Denial Root-Cause Analysis Report</strong></li>
</ul>
<li>“Denials & Reconciliation Command Center” design documented</li>
</ul>
<h3>4. NGO / Fund Accounting Vertical</h3>
<ul>
<li>Models: <code>Fund</code>, <code>Project</code></li>
<li>Full CRUD endpoints with filtering (status, fund, grant)</li>
<li>Reporting endpoint (stubbed) for <strong>Fund Utilization</strong> with SQL CTE template</li>
</ul>
<h3>5. Tooling & Management</h3>
<ul>
<li>Initial test structure (<code>backend/tests/...</code>)</li>
<li>GitHub Issues / sprint list and Excel tracker</li>
<li>Jira import CSV for epics & stories</li>
<li>Docs for security and JWT auth</li>
</ul>
<p><em>All of this code and documentation lives in a GitHub repository that will be shared after the contract is awarded.</em></p>
<hr />
<h2>🚧 Remaining Work (You Will Implement)</h2>
<h3>Phase 1 – RCM Reporting (Highest Priority)</h3>
<ul>
<li>Convert SQL CTE templates into working SQL queries for:</li>
<ul>
<li>Claims Aging Report</li>
<li>Denial Root-Cause Analysis Report</li>
</ul>
<li>Wire filters: insurer, department, provider</li>
<li>Optimize indexes for RCM tables (composite indexes on <code>tenant_id</code> + insurer/status)</li>
<li>Add pytest coverage for these reporting endpoints</li>
<li>Update OpenAPI & Postman with real response examples</li>
</ul>
<h3>Phase 2 – NGO Foundation</h3>
<ul>
<li>Create <code>fund_transactions</code> table (Alembic migration + SQLAlchemy model)</li>
<li>Implement real SQL for Fund Utilization report (funds → projects → transactions)</li>
<li>Add <strong>Donor</strong> and <strong>Grant</strong> entities + CRUD APIs</li>
<li>Build NGO reporting endpoints (burn rate, utilization, restricted vs unrestricted)</li>
<li>Update documentation, tests, and Postman collection</li>
</ul>
<h3>Phase 3 – Tax Analytics (USA)</h3>
<ul>
<li>Implement PDF / ProSeries ingestion to extract tax return fields</li>
<li>Map extracted data into <code>tax_returns</code> and related models</li>
<li>Build a Year-over-Year (YOY) comparison engine (income, credits, refunds, AGI changes)</li>
<li>Create Tax Analytics API endpoints for dashboards</li>
<li>Add test coverage and documentation</li>
</ul>
<hr />
<h2>🛠 Technology Stack</h2>
<ul>
<li>Language: <strong>Python 3.11</strong></li>
<li>Framework: <strong>FastAPI</strong></li>
<li>Database: <strong>PostgreSQL</strong> + <strong>SQLAlchemy</strong></li>
<li>Migrations: <strong>Alembic</strong></li>
<li>Auth: <strong>JWT</strong>, multi-tenant (<code>tenant_id</code>)</li>
<li>Docs: OpenAPI, Postman</li>
<li>Hosting: AWS (dev / staging environment)</li>
</ul>
<hr />
<h2>🎯 Required Skills</h2>
<ul>
<li>Strong experience with <strong>FastAPI</strong> and modern Python</li>
<li>Deep knowledge of <strong>SQL</strong>, query optimization, and PostgreSQL</li>
<li>Hands-on experience with <strong>multi-tenant SaaS</strong> systems</li>
<li>Comfortable with Alembic migrations and schema evolution</li>
<li>Ability to work inside an existing codebase and extend it cleanly</li>
<li>Familiar with GitHub pull requests, branching, and code review</li>
</ul>
<p><strong>Bonus experience:</strong></p>
<ul>
<li>Healthcare / RCM, insurance claims, or medical billing</li>
<li>NGO / fund accounting / restricted funds</li>
<li>Tax preparation software, PDF data extraction (e.g., ProSeries, Lacerte, etc.)</li>
</ul>
<hr />
<h2>📁 What You’ll Receive</h2>
<p>After awarding the job, you will receive:</p>
<ul>
<li>GitHub repository link with full code scaffold</li>
<li>OpenAPI spec (JSON/YAML)</li>
<li>Postman collection for all endpoints</li>
<li>Excel sprint/issue tracker</li>
<li>Jira epics/stories CSV (if you use Jira)</li>
<li>Statement of Work (SOW) document</li>
</ul>
<hr />
<h2>📌 How to Apply</h2>
<p>Please include the following in your proposal:</p>
<ol>
<li>Links to FastAPI / Python / SaaS projects you have built (GitHub or portfolio).</li>
<li>A short description of your experience with <strong>multi-tenant</strong> systems.</li>
<li>Confirmation that you can handle all three phases (Phase 1 → Phase 3).</li>
<li>Your preferred engagement model (milestone-based) and your rate(per Phase).</li>
<li>Your approximate availability per week and estimated timeline.</li>
</ol>
<p>
We are looking for a long-term partner who can grow with this platform.
Strong performance on Phase 1 can lead to continued work on future features,
AI modules, and potentially frontend/dashboard development.
</p>
<hr />
<h2>👤 About the Client</h2>
<p>
You will be working directly with the founder, who is a U.S.-based tax and financial services professional
with ongoing clients in the USA and active healthcare and NGO initiatives across Africa.
The codebase is organized, documented, and designed for serious long-term growth.
</p>
... Show more