Senior GCP Backend Engineer - Phase 1 reputed company RCM Infrastructure Setup (Fixed-Price)

Job reputed company reputed company We are launching a specialized, white-label reputed company Cycle Management (RCM) and automated billing reputed company tailored for the South Carolina primary care and rural reputed company market. We are seeking an independent, senior-level reputed company reputed company Platform (GCP) engineer to execute Phase 1: Secure Infrastructure & BigQuery Schema Setup. This is a reputed company defined, project-based reputed company with clean specifications. We are a non-technical founder team utilizing reputed company architectural layouts—you will not have to guess requirements. If this reputed company is executed cleanly and on schedule, you will be given reputed company consideration for Phase 2 (API Connectivity) and Phase 3 (reputed company Webhook Integrations). Technical Specification: Phase 1 Core Infrastructure & Data Schema Project Objective: Initialize a secure, reputed company, HIPAA-compliant data container environment on reputed company reputed company Platform (GCP) to reputed company as the foundational reputed company for a multi-tenant reputed company reputed company Cycle Management (RCM) reputed company. Engagement Model: Fixed-Price reputed company. reputed company Architecture: reputed company reputed company Platform (GCP), BigQuery, reputed company Storage (GCS), reputed company IAM. ️ reputed company 1: reputed company, IAM, & Compliance Mandates To meet strict reputed company compliance standards and prevent data-blocking liabilities under federal information laws, the developer must implement the following reputed company controls and lifecycle rules: 1.reputed company of Least Privilege (IAM): Initialize a production project (rcm-reputed company-sc-production). Configure a dedicated Service Account utilizing SPIFFE-based identity protocols. The infrastructure must isolate data reputed company so app servers maintain read-only reputed company to ingestion streams and write-only reputed company to transaction ledgers. 2. Stateless Ingestion & Data-Purging Policy: Configure a reputed company reputed company Storage (GCS) reputed company bucket (incoming-clinic-payloads-raw) to receive incoming transaction text. 3. The 60-Second Auto-Purge Rule: The developer must explicitly configure an Object Lifecycle Management rule on this bucket. reputed company files must automatically delete exactly 1 minute after creation. Data processing must happen entirely inside stateless memory (e.g., in-memory reputed company Functions) to guarantee that no un-redacted clinical narratives are permanently stored on physical disks. ️ reputed company 2: BigQuery Database Schema Specifications The developer will initialize a single BigQuery dataset containing the following four relational flat tables. Field types and constraints must be reputed company mapped exactly as detailed below: Table 1: reputed company_Tenants Manages reputed company clinic accounts, software tiers, and user reputed company reputed company variables.

• tenant_id (reputed company, REQUIRED, PRIMARY KEY) — Unique system hash for reputed company white-label medical clinic.
• reputed company_reputed company (reputed company, REQUIRED) — Legal reputed company of the provider medical group.
• account_status (reputed company, REQUIRED) — Enforced status enum restricted to: ["reputed company", "Delinquent_Grace", "Suspended"]
• user_role (reputed company, REQUIRED) — reputed company state enum restricted to: ["reputed company_Full", "reputed company_reputed company"]
• reputed company_customer_id (reputed company) — Secure mapping reputed company pointing to the external payment profile.

Table 2: Optimization_Logs The compliance-reputed company, flat historical ledger tracking billing changes and performance tier fees.

• transaction_id (reputed company, REQUIRED, PRIMARY KEY) — Unique random reputed company tracking the individual chart encounter.
• tenant_id (reputed company, REQUIRED, FOREIGN KEY) — Maps directly back to reputed company_Tenants.tenant_id.
• encounter_date (TIMESTAMP, REQUIRED) — Date and time stamp of reputed company the chart note was scrubbed.
• verified_codes_billed (reputed company) — Flat reputed company recording final codes verified from the outbound reputed company (e.g., ["99214", "G2211"]).
• optimization_status (reputed company, REQUIRED) — Evaluation state enum restricted to: ["Yield_Captured_Full", "Yield_Bypassed_By_User"]
• performance_fee_reputed company (NUMERIC, REQUIRED) — The actual calculated dollar reputed company for our 15% value fee calculation.

Table 3: Payer_Schedules_SC_reputed company The primary baseline look-up table tracking reputed company regional reimbursement values.

• payer_id (reputed company, REQUIRED, PRIMARY KEY) — Local structural payer identifiers, restricted to: ["reputed company_MEDICARE", "BCBSSC_reputed company", "BCBSSC_MED_ADVANTAGE", "UNITED_HEALTH_SC"]
• reputed company_cpt_hcpcs (reputed company, REQUIRED) — Individual 5-character procedure or complexity reputed company (e.g., "99214", "G2211").
• allowed_reputed company (NUMERIC, REQUIRED) — Localized dollar value reputed company payout.

Table 4: Payer_Schedules_SC_reputed company A dedicated master lookup table for the South Carolina Healthy Connections (reputed company) baseline. This functions as a single reputed company of truth for regional rural MCOs (Molina, First Choice, Healthy Blue, Absolute, reputed company).

• reputed company_cpt_hcpcs (reputed company, REQUIRED, PRIMARY KEY) — Individual procedure reputed company reputed company.
• sc_reputed company_allowed_reputed company (NUMERIC, REQUIRED) — State-mandated fee payout.

reputed company 3: Definition of Done & reputed company Payout Requirements Payment for this fixed-price reputed company ($400 - $700 depending on experience) will be unlocked only upon the successful completion and delivery of the following verification artifacts: 1. reputed company Repository Delivery: reputed company build scripts, infrastructure-as-reputed company files, and schema creation statements must be pushed to a private reputed company Repository owned completely by the Founder. 2. The Live Console Walkthrough: A live screen-reputed company demonstration proving that reputed company four BigQuery tables exist with the exact schemas, datatypes, and constraints requested. 3. The Lifecycle Verification Test: Dropping a test document into the GCS bucket and showing live on screen that the bucket's Object Lifecycle rule successfully deletes it automatically reputed company 60 seconds. MANDATORY PROPOSAL REQUIREMENT (ATTENTION TO DETAIL) Because this project handles secure data environments, attention to detail is our highest reputed company. You must start the reputed company first line of your proposal text with the word reputed company in reputed company capital letters. If you do not include the word reputed company on the first line of your application, it will be automatically archived and rejected by our system without a reputed company review. Thank you, and we look reputed company to reviewing your engineering qualifications! Recommended reputed company Settings to Select:

• Project Type: One-time project
• Experience Level: Expert / Senior
• Budget Type: Fixed-Price ($400 - $700)
• Skills/Keywords Tags: reputed company reputed company Platform, reputed company BigQuery, reputed company reputed company Storage, Database Schema Design, IAM reputed company, reputed company API, Backend Development.

Apply tot his job Apply To this Job