Healthcare Salesforce Integration Project Needing an Architect
A healthcare Salesforce integration project connects Salesforce to an existing Azure platform and an AWS SFTP feed. The client wants the design, and optionally the build, of patient data flows, and this brief covers what a strong bid shows.
- Open ยท checked 12 Nov 2026
- Azure
Is the budget fair? The rate from $50 per hour looks workable for an architecture design with a clear first phase. It looks tight if the work grows into a full build across Salesforce, AWS and Azure.
What the client needs
- Design how patient data flows between the partner, AWS, Salesforce and Azure.
- Keep HITRUST r2 controls in every data path.
- Leave the existing platform working while new links are added.
- Optionally build the integrations once the design is agreed.
Skills the client asked for: Azure, AWS Lambda, Data Integration, Data Governance, Cloud Security, Data Modeling, Power Automate, EHR Integration.
Project background
A healthcare services organisation running a patient outreach and scheduling programme for a health plan partner is moving its call-centre workflow to Salesforce. It needs an experienced integration architect to design, and optionally build, how patient data flows between the partner, AWS, Salesforce and its existing Azure platform, all supporting its HITRUST r2 certification effort.
Current and planned setup
- Today the health plan sends a monthly patient file to an Azure SFTP, loaded into Azure SQL via Azure Data Factory (ADF)
- Azure SQL feeds the scheduling list through Power Automate, sends a daily status file back and reconciles appointments from the EHR (athenahealth via Snowflake)
- Planned: the file arrives on an AWS Transfer Family SFTP (HITRUST r2 in scope), ADF pulls it from S3 into the existing pipeline, and Azure SQL remains system of record
- ADF would replace two Power Automate flows: upserting members into Salesforce by member ID, and syncing CSR call attempts back to Azure SQL
Phase 1: design, about 2 to 4 weeks
Phase 2 is optional and a separate contract: build and test the ADF pipelines and Salesforce Flows, finish the AWS SFTP setup and go live after a parallel run.
- Validate or improve the design while preserving existing Azure pipelines
- Design the S3 to ADF handoff: credentials, triggering and HITRUST controls
- Map Salesforce fields and call outcomes to existing contact-attempt tables
- Recommend the Salesforce data model (Lead/Contact vs Person Account, Health Cloud fit) and CSR routing (queues, tasks or Omni-Channel)
- Design monitoring so a failed sync is caught the same day
- Plan a parallel-run cutover and map security decisions to HITRUST control areas
- Deliverables: architecture diagram, field mapping, integration and error-handling design, HITRUST control mapping, Phase 2 build plan with estimate
Skills and access conditions
- Required: Azure Data Factory with the Salesforce connector, Azure SQL, Salesforce integration architecture (Integration Architect certification preferred), AWS Transfer Family, S3, IAM, KMS, CloudTrail, PHI handling under HIPAA, batch integration with retries and reconciliation
- Nice to have: Health Cloud, Flow and Omni-Channel, payer eligibility files with PGP encryption, athenahealth
- NDA and Business Associate Agreement before seeing architecture documents
- Company-provisioned accounts with MFA only, no PHI on personal devices
- Phase 1 has no PHI access, Phase 2 uses dummy data until go-live, and a background check may apply to Phase 2
What applicants should include
- A Salesforce and cloud integration they designed and their role
- How they would keep one source of truth across AWS, Salesforce and Azure SQL
- How they would ensure the daily status report never silently misses data after a failed sync
- HIPAA or HITRUST r2 experience
- Availability and estimated fixed price for Phase 1
How to win this project
- Show a past integration design for a regulated healthcare system, since the client needs HITRUST r2 experience.
- Name the Azure Data Factory and AWS pieces you would use and why, so the design is concrete.
- Ask for the current architecture diagrams and data flow documents before you quote.
Questions to ask the client
A specific question in your first message shows you read the brief. Pick one or two:
- Which systems are in scope for the first phase?
- Who manages access to the AWS SFTP feed?
- Is this a design-only engagement, or should the integrations also be built?
Common questions
How much does a healthcare Salesforce integration project cost?
This brief lists from $50 per hour USD. The hours needed depend on whether the job is design only or design plus build.
What should a healthcare Salesforce integration project proposal include?
A data flow design, your HITRUST r2 approach, and how you would keep the existing Azure platform stable.
Is this project still open?
We checked this project on 10 November 2026. Projects get awarded, so apply soon; we take a brief down when it closes.
This page is our own summary of a project posted online, written to help you decide and to write a better bid. Projects get awarded or closed, so apply soon; we take a brief down when it closes. No job or income is guaranteed.