
Closed
Posted
Harmony Health is hiring a Salesforce integration architect to connect Salesforce and a HITRUST r2 AWS SFTP to the existing PCE platform on Azure, without breaking anything already built. Title: Salesforce Integration Architect (Azure Data Factory + AWS, Healthcare/HITRUST r2): Patient File Intake & CSR Workflow About the project We're a healthcare services organization that runs a patient outreach and scheduling program for a health plan partner. We're moving our call-center workflow to Salesforce. We need an experienced integration architect to design, and optionally build, how patient data flows between our partner, AWS, Salesforce and our existing Azure platform. All of it must support our HITRUST r2 certification effort. Current state The health plan sends a monthly patient file. Today it lands on Azure SFTP and loads into Azure SQL through Azure Data Factory (ADF). Azure SQL feeds our current scheduling list through Power Automate, sends a daily status file back to the health plan, and reconciles appointments from our EHR (athenahealth, via Snowflake). Planned future state (our preferred design, open to expert review) The health plan delivers the monthly file to a Harmony-branded SFTP on AWS Transfer Family, a HITRUST r2 in-scope service. ADF pulls the file from S3 into our existing ingestion pipeline. Azure SQL stays the system of record. ADF replaces our two Power Automate flows: (1) upsert members from Azure SQL into Salesforce on member ID, (2) sync CSR call attempts from Salesforce back into the existing Azure SQL tables. Downstream reporting and EHR reconciliation stay unchanged. Phase 1: architecture and design, about 2 to 4 weeks Validate or improve this design. Our priority is preserving the existing Azure pipelines. Design the S3 to ADF handoff: credentials, triggering and HITRUST controls. Map Salesforce fields and call outcomes to our existing contact-attempt tables. Recommend the Salesforce data model (Lead/Contact vs. Person Account, Health Cloud fit) and the CSR routing approach (queues, tasks or Omni-Channel). Design monitoring and alerting so a failed sync is caught the same day. Plan a parallel-run cutover from the current scheduling list to Salesforce. Map security decisions to HITRUST control areas across Azure, AWS and Salesforce. Deliverables: future-state architecture diagram, field mapping, integration and error-handling design, HITRUST control mapping, and a Phase 2 build plan with estimate. Phase 2 (optional, separate contract): build and test the ADF pipelines and Salesforce Flows, complete the AWS SFTP setup, and go live after a parallel run with test files from the health plan. Required Azure Data Factory, including the Salesforce connector, and Azure SQL. Salesforce integration architecture. Integration Architect certification preferred. AWS: Transfer Family/S3, IAM, KMS and CloudTrail. Experience handling PHI under HIPAA. HITRUST r2 experience strongly preferred. Batch integration: file intake, upsets, retries and reconciliation. Nice to have Salesforce Health Cloud Salesforce Flow and Omni-Channel for call center routing Payer eligibility files and PGP-encrypted file exchange athenahealth integration Requirements before you get access (HITRUST) Sign an NDA and a Business Associate Agreement (BAA) before you see architecture documents. Work only through company-provisioned accounts with MFA. No PHI on personal devices. Phase 1 is design-only with no PHI access. Phase 2 uses dummy data until go-live. A background check may be required for Phase 2. To apply, please include An integration you've designed spanning Salesforce and a cloud platform (Azure or AWS), and your role in it. How you'd keep one source of truth when the file lands in AWS, CSRs work in Salesforce and reporting runs from Azure SQL. How you'd make sure a daily status report never silently misses data when a sync fails. Your experience in HIPAA or HITRUST r2 environments. Your availability and estimated fixed price for Phase 1.
Project ID: 40803213
74 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
74 freelancers are bidding on average $51 USD/hour for this job

My 14 years of system and IT administration, combined with hands-on AWS, Azure and cloud-security expertise, make me well suited to design a secure cross-cloud foundation for Harmony Health’s Salesforce integration. I work with AWS S3, Azure services, storage, databases, networking and security, giving me the infrastructure perspective needed to preserve your existing Azure platform while introducing the AWS intake layer. My experience includes AWS Lambda, Azure and cloud security, as well as Python, Terraform, Ansible, Jenkins and Kubernetes. These skills support a practical architecture for controlled file movement, IAM-based access, encryption, monitoring, automation and reliable recovery across AWS and Azure. I can also document integration boundaries, data ownership, error handling, retries and reconciliation so Azure SQL remains the authoritative reporting source while Salesforce supports CSR operations. I am available daily, including weekends, and can work within your NDA, BAA, MFA and company-account requirements. I would welcome the opportunity to deliver a clear Phase 1 architecture and build plan, with an estimated fixed price agreed around the final scope.
$50 USD in 40 days
6.1
6.1

Hi — Puru here from ErgoSphere. You're essentially building a robust integration between Salesforce, AWS, and Azure for healthcare data, all while maintaining HITRUST r2 compliance. What usually matters most here is ensuring data integrity during the integration and maintaining the system's security and compliance with HITRUST standards. I'd recommend using Azure Data Factory for the integration pipeline, leveraging its Salesforce connector for seamless data flow. AWS Transfer Family can handle SFTP needs while maintaining HITRUST compliance. Consider using Azure Key Vault for credential management to enhance security. I've worked on AI integrations, secure cloud architectures, and healthcare data projects, aligning well with your needs. A few questions to better understand the scope: Q1 – How are you currently handling data reconciliation between Azure and Salesforce? Q2 – What criteria will define a successful parallel-run cutover? Q3 – Are there any specific Salesforce Health Cloud features you plan to leverage? A working prototype could reasonably be targeted within 4–6 weeks, followed by a polished release in roughly 8 weeks depending on design validation and testing outcomes. Looking forward to hearing from you.
$60 USD in 40 days
5.8
5.8

Hi there, Your Salesforce–Azure–AWS integration needs an architect who can preserve an existing production data path while introducing secure, reliable cloud connectivity. As a Senior Software Architect with 20+ years of experience, I design scalable cloud-native systems across Azure and AWS, including high-volume data migration, transformation pipelines, REST APIs, microservices, and strict data-integrity requirements. My Azure expertise aligns directly with your existing ADF and Azure SQL environment, while my AWS and cloud architecture experience supports the Transfer Family/S3 handoff, IAM, encryption, monitoring, and controlled access model. I can define Azure SQL as the operational source of truth, establish clear ownership for Salesforce CSR activity, and design reconciliation, retry, validation, and alerting controls so failed or incomplete status processing cannot remain unnoticed. My background in secure enterprise systems and cloud migration also supports your HIPAA/HITRUST-focused design, NDA/BAA requirements, MFA controls, and PHI minimization. I can deliver the Phase 1 architecture, field mappings, integration and error-handling design, security/control mapping, parallel-run cutover plan, and a practical Phase 2 build estimate. I would be pleased to bring this architecture discipline to Harmony Health and help you modernize the workflow without disrupting the Azure pipelines already in place. Regards V
$50 USD in 40 days
5.5
5.5

My AWS-certified architecture and security background aligns strongly with Harmony Health’s cross-cloud integration and HITRUST-focused design needs. With over 5 years in backend development, DevOps, and Kubernetes, I design scalable AWS and Azure infrastructures using Terraform, CloudFormation, and secure deployment practices. I can contribute practical expertise across AWS S3, IAM, monitoring, serverless integration, and Azure environments, while applying knowledge of HIPAA, PCI-DSS, GDPR, and ISO compliance frameworks to PHI-sensitive architecture. My experience with Python, Node.js, AWS Lambda, CI/CD, Docker, and observability tools such as Prometheus, Grafana, and New Relic supports reliable batch processing, retry handling, auditability, and alerting when integrations fail. I would preserve Azure as the system of record while designing controlled synchronization boundaries for AWS intake and downstream Salesforce workflows. I would be pleased to provide a clear Phase 1 architecture, security and control mapping, error-handling design, and build plan using company-provisioned accounts and MFA. Choose me to help create a secure, resilient integration foundation for Harmony Health.
$50 USD in 40 days
5.1
5.1

⭐⭐⭐⭐⭐ Salesforce Integration Architect for Healthcare Data Flow (Azure & AWS) ❇️ Hi My Friend, I hope you are doing well. I checked all of your project requirements and I can see you are looking for a Salesforce integration architect. You have no need to look any further as Zohaib is here to help you! My team is already doing 50+ similar projects for healthcare integration. I will build a secure ADF‑Salesforce flow that pulls the monthly file from AWS S3, maps it to Azure SQL and updates Salesforce, with full HITRUST controls and daily alerting. I will also give a detailed architecture diagram and cut‑over plan in the same budget. ➡️ Why Me? I can easily do your integration as I have 5 years of experience in Azure Data Factory, Salesforce integration, AWS Transfer Family, and HIPAA compliance. Not only this, I have a strong grip on Health Cloud, Power Automate, and data security standards. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ Azure Data Factory ✅ Salesforce Connector ✅ AWS Transfer Family ✅ S3 & IAM ✅ HITRUST r2 ✅ HIPAA Compliance ✅ Health Cloud ✅ Salesforce Flow ✅ Omni‑Channel ✅ Azure SQL ✅ Power Automate ✅ Data Mapping Waiting for your response! Best Regards, Zohaib
$50 USD in 40 days
4.5
4.5

Designing a safe Salesforce–Azure integration requires protecting the existing Azure SQL and ADF workflows first, and Azure is the strongest match in my background. I work as a Principal AI, Automation & DevOps Full Stack Engineer with experience across Azure, AWS, cloud deployments, workflow automation, API integrations, and scalable enterprise applications. I can contribute to the Phase 1 architecture by evaluating the AWS S3/Transfer Family handoff into ADF, preserving Azure SQL as the system of record, and defining reliable Salesforce synchronization and reconciliation patterns. My background in REST APIs, Node.js, Python, Docker, CI/CD, and automation supports robust batch processing, retries, monitoring, and error handling rather than fragile point-to-point flows. I will also keep security, access control, and operational traceability central across the Azure and AWS components. While my profile does not specifically claim HITRUST r2 or Salesforce Health Cloud experience, I am accustomed to designing production-ready systems with a focus on security, maintainability, and scalability. I would be glad to support Harmony Health with a clear future-state architecture, field and integration mapping, failure-handling design, and a practical Phase 2 build plan.
$50 USD in 2 days
0.0
0.0

Hi there! You need accurate product information extracted from multiple PDFs, with every name, code, and price matching the original source. Even small errors in product codes or price formatting can create problems later. I can carefully review each PDF and organize all product details into a clean Excel or Google Sheets file. I will use separate columns for Product Name, Product Code, and Price, keeping codes and original price formats exactly as shown. I will also cross-check the entered records against the source PDFs to reduce mistakes and make your random spot-checks easy. Accuracy and clear formatting will be my priority. check our work https://www.freelancer.com/u/ayesha86664 Approximately how many PDF files or product entries do you need processed? Let me know if you’re interested & we can discuss it. Best Regards Ayesha
$50 USD in 40 days
0.0
0.0

The biggest risk in this integration is disrupting a working healthcare data pipeline while introducing Salesforce. The goal should be to modernize the CSR workflow without compromising Azure SQL as the system of record or weakening PHI security. NETPACE would begin by validating your proposed architecture, focusing on the AWS Transfer Family/S3-to-ADF handoff, reliable Salesforce upserts, CSR call-attempt synchronization, and preservation of existing reporting and athenahealth reconciliation. For reliability, we'd design idempotent processing, retry and reconciliation mechanisms, audit trails, and same-day failure alerts. We'd also evaluate the Salesforce data model and CSR routing options, map security controls across AWS, Azure, and Salesforce, and plan a parallel-run cutover before retiring the existing workflows. Phase 1 would deliver the architecture diagram, field mappings, error-handling design, HITRUST control mapping, and a scoped Phase 2 implementation plan. Could we schedule a quick CALL to review your current architecture and align on Phase 1? We'd confirm availability and a fixed price after validating the scope and deliverables. Best, Netpace
$50 USD in 40 days
0.0
0.0

Hi, I’d keep Azure SQL as the authoritative member record. AWS would receive the partner file, and Salesforce would manage CSR work. I’d define field ownership and map call attempts back to Azure SQL using stable identifiers so retries don’t create duplicates. Before the daily status file is released, the pipeline would check that the required loads and Salesforce syncs completed through the reporting cutoff. If reconciliation fails, it would alert the owner and hold the report for investigation. My Phase 1 quote is $3,600 over three weeks. I’d deliver the architecture, field mappings, error handling, HITRUST control mapping, parallel-run plan and Phase 2 estimate. What reporting cutoff and reconciliation checks does the health plan require today?
$50 USD in 40 days
0.0
0.0

I can design a secure, resilient integration spanning AWS Transfer Family/S3, Azure Data Factory, Azure SQL, and Salesforce while preserving your existing PCE pipelines. For Phase 1, I would validate the proposed architecture and document the AWS-to-ADF handoff, IAM/KMS/CloudTrail controls, Salesforce data model, field mappings, CSR routing, retry and reconciliation behavior, monitoring, and parallel-run cutover. Azure SQL would remain the authoritative system of record, with explicit ownership rules preventing conflicting updates between Salesforce, ingestion, reporting, and EHR reconciliation. To prevent silent status-file failures, I would define correlation IDs, control totals, idempotent upserts, checkpointing, retry/dead-letter handling, freshness SLAs, reconciliation reports, and same-day alert escalation for missing, partial, duplicate, or rejected records. The deliverables would include the future-state architecture diagram, detailed mappings, integration/error-handling design, HITRUST control alignment across AWS, Azure, and Salesforce, and a practical Phase 2 build plan with estimates. I’m comfortable working under NDA/BAA, company-managed MFA accounts, and no-PHI design constraints, with dummy-data validation before go-live. I can provide a focused 2-4 week architecture engagement and coordinate closely with your healthcare, security, and Salesforce stakeholders. Best regards
$50 USD in 21 days
0.0
0.0

Hi, I'm a full-stack and integration developer with good Salesforce experience, plus Azure and AWS. Your design is sound. Here's how I'd answer your questions. One source of truth: Azure SQL stays the master. S3 (Transfer Family, KMS, CloudTrail) is only a landing zone, and Salesforce is the CSR workspace. ADF upserts members on the member ID external ID. Call attempts flow back from Salesforce to Azure SQL on the Salesforce record ID plus a watermark (LastModifiedDate), and Salesforce never writes member demographics. Every file gets a batch ID carried through each hop. No silent misses: a control table per run tracks rows received, loaded, upserted, rejected and synced back. The daily status file is generated only when every count reconciles. Otherwise the run fails loudly with Azure Monitor and email alerts the same day, and a manifest check confirms the S3 file is complete before ingestion. Phase 1 design: - Validate the S3-to-ADF handoff (scoped IAM role, KMS, event-triggered pull). - Field mapping and call-outcome mapping. - Data model: Person Account and Health Cloud versus Lead/Contact, with the trade-offs. - Routing: queues and tasks versus Omni-Channel. - Monitoring, parallel-run cutover, and a HITRUST control mapping for review with your compliance lead. Phase 1 fixed price: about USD 2,500 over 3 weeks. I'm happy to sign the NDA and BAA and work only in your MFA accounts. Stefan
$55 USD in 20 days
0.0
0.0

Salesforce-cloud integration: I can share my closest relevant work in chat. Source of truth: Azure SQL stays the record, with S3 and Salesforce holding copies keyed on member ID. Status report: each run reconciles row counts, and a mismatch blocks the file and raises an alert. HIPAA/HITRUST r2: no direct experience. My security background is in banking production systems. Availability: I can start now, and I'll confirm Phase 1 pricing in chat. You need Salesforce and a HITRUST r2 AWS SFTP connected to Azure without breaking the existing ADF pipelines. The part that matters most here is replacing both Power Automate flows. A missed upsert leaves the health plan's status file silently wrong. Here's how I'd approach it: 1. Design the S3 to ADF handoff with IAM, KMS and triggering. 2. Map Salesforce call outcomes to the contact-attempt tables. 3. Review the deliverables together and hand over the Phase 2 plan. Relevant experience: I've worked on software projects in the banking sector, where security and thorough testing come as standard. First milestone: the architecture diagram and handoff design in 7 days, so you can judge the work before committing further. Quick question: Is the monthly file PGP-encrypted today? Kind regards, Sonny Dube
$50 USD in 28 days
0.0
0.0

Naperville, United States
Payment method verified
Member since Oct 9, 2021
min $50 USD / hour
$25-50 USD / hour
min $50 USD / hour
$10-30 USD
min $50 USD / hour
$30-250 USD
€250-750 EUR
$10-30 USD
₹600-1500 INR
$30-250 USD
$2-8 USD / hour
$2-8 USD / hour
£250-750 GBP
min $50 USD / hour
$30-250 USD
$250-750 USD
$2-8 USD / hour
$30-250 USD
$10-30 USD
₹400-750 INR / hour
$30-250 AUD
₹100-400 INR / hour
₹12500-37500 INR