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

Job Description

Overview We are launching a specialized, white-label reputed company Cycle Management (RCM) and automated billing utility 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 strictly defined, project-based milestone with clean specifications. We are a non-technical founder team utilizing professional architectural layouts—you will not have to guess requirements. If this milestone 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, scalable, HIPAA-compliant data container environment on reputed company reputed company Platform (GCP) to act as the foundational reputed company for a multi-tenant reputed company reputed company Cycle Management (RCM) utility. Engagement Model: Fixed-Price Milestone. 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.Principle 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 layers 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 strictly mapped exactly as detailed below: Table 1: Client_Tenants Manages active clinic accounts, software tiers, and user reputed company reputed company variables.

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

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

• transaction_id (STRING, REQUIRED, PRIMARY KEY) — Unique random string tracking the individual chart encounter.
• tenant_id (STRING, REQUIRED, FOREIGN KEY) — Maps directly back to Client_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 (STRING, 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_Standard The primary baseline look-up table tracking standard regional reimbursement values.

• payer_id (STRING, REQUIRED, PRIMARY KEY) — Local structural payer identifiers, restricted to: ["reputed company_MEDICARE", "BCBSSC_reputed company", "BCBSSC_MED_ADVANTAGE", "UNITED_HEALTH_SC"]
• code_cpt_hcpcs (STRING, REQUIRED) — Individual 5-character procedure or complexity string (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).

• code_cpt_hcpcs (STRING, REQUIRED, PRIMARY KEY) — Individual procedure code string.
• sc_reputed company_allowed_reputed company (NUMERIC, REQUIRED) — State-mandated fee payout.

reputed company 3: Definition of Done & Milestone Payout Requirements Payment for this fixed-price milestone ($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-code 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