<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>