Contract Salesforce Solution Architect (Marketing, RevOps & Data Integration Focus) 

Request For Proposal Note: This is a term-limited and project-specific contractor position. You will need to complete an RFP (Request for Proposal to be considered). This is a fully remote position but must reside inside of the United States. 

About the Role 

We are seeking an experienced Salesforce Solution Architect to lead a full-scale cleanup, redesign, and enablement of our Salesforce environment to support Growth Marketing, Sales alignment, and executive-level reporting. 

This is a high-impact, project-based engagement (~6 months) focused on transforming Salesforce into a single source of truth for marketing-driven pipeline and revenue, with strong integrations across HubSpot and paid media platforms. 

You will partner closely with Growth Marketing, Sales, and RevOps stakeholders to stabilize our current environment and implement scalable architecture for long-term growth. 

What You’ll Deliver 

This role will lead three core initiatives, supported by a foundational audit and remediation effort: 

1) Salesforce Audit & Cleanup 

• Audit current Salesforce architecture (objects, fields, automations, permissions) 

• Assess data integrity issues across multiple Salesforce instances 

• Evaluate current HubSpot ↔ Salesforce integration and sync logic 

• Identify technical debt and blockers to marketing and sales execution 

• Deliver audit findings report + prioritized remediation roadmap 

2) Lead Scoring + HubSpot Integration 

• Design and implement lead scoring across Lead, Contact, and Account levels 

• Enable bi-directional sync between HubSpot and Salesforce 

• Build automation for:  

• Lead routing 

• Territory and ownership assignment 

• Redesign page layouts to surface:  

• Lead score 

• Marketing engagement context 

• Ensure Sales has clear visibility and usability 

3) Account-Based Marketing (ABM) Enablement 

• Build Salesforce architecture to support:  

• ABM account segmentation and tiering 

• Target account tracking and engagement 

• Implement routing and workflows aligned to ABM programs 

• Surface marketing engagement on Contact/Account records 

• Build dashboards for:  

• Engagement → pipeline conversion 

• ABM performance 

4) Marketing Attribution + ROI Reporting 

• Standardize and remediate the Campaign object 

• Implement marketing attribution framework:  

• Marketing-sourced vs. influenced logic 

• Build executive dashboards showing:  

• Pipeline created 

• Conversion rates 

• ROI by campaign/channel 

5) Paid Media Integration & Cost Ingestion  

• Implement API integrations for:  

• LinkedIn Ads 

• Google Ads (+ Display) 

• Meta/Facebook Ads 

• Build data model to store:  

• Spend, impressions, clicks, campaign IDs 

• Ingest:  

• Campaign-level spend data 

• 2 months of historical data 

• Design system to connect: Spend → Campaign → Lead → Opportunity → Pipeline → ROI 

• Implement:  

• Data validation + reconciliation process 

• Monitoring for API failures and data issues 

Success Criteria 

This engagement is successful when: 

• Salesforce becomes the trusted system of record for marketing and pipeline 

• Sales can prioritize leads using visible lead scoring 

• ABM programs are operationalized inside Salesforce 

• Executives can clearly answer: “What pipeline and revenue did marketing generate?”  

• Reporting is reliable, defensible, and scalable 

What We’re Looking For 

Required Experience 

• 5–10+ years in Salesforce architecture / consulting roles 

• Proven experience cleaning up and restructuring complex / messy Salesforce environments 

• Deep experience with:  

• HubSpot ↔ Salesforce integration (bi-directional sync) 

• Lead scoring models (multi-object) 

• Campaign object design + campaign attribution 

• ABM architecture and reporting 

Must-Have Technical Expertise 

• Salesforce data architecture (objects, schema, automation, permissions) 

• Marketing attribution modeling inside Salesforce 

• Paid media integrations via API or middleware 

• Data modeling for marketing analytics (campaigns, spend, pipeline) 

• Dashboarding for executive-level reporting 

Engagement Details 

• Engagement Type: Contract / project-based (independent consultant or contractor, no firms or agencies) 

• Duration: ~6 months, optional for longer duration based on initial audit 

• Start Date: ASAP 

• Model: Fixed bid preferred (with option for additional hours) 

Deliverables 

You will be responsible for delivering: 

• Salesforce audit + remediation roadmap 

• End-state architecture diagrams (data flows, integrations) 

• Updated Salesforce configuration:  

• Fields, objects, automations, permissions, layouts 

• Lead scoring implementation 

• ABM segmentation + dashboards 

• Paid media integrations + cost ingestion system 

• Marketing attribution framework 

• Executive dashboards (pipeline, ROI, performance) 

• Data validation and reconciliation plan 

• Admin documentation + training / handoff 

We’re looking for candidates who demonstrate: 

• Strong architectural thinking and ability to simplify complexity 

• Experience delivering trusted reporting and attribution models 

• Ability to drive alignment between Marketing and Sales 

• Clear methodology for:  

• Cleaning up disorganized Salesforce instances 

• Preventing future technical debt 

• Proven outcomes (not just implementation experience)