Sign upLog in
JobsJobs in OhioJobs in Columbus, OHIT JobsIT Architect Jobs

Salesforce Solution Architect

Main Sail LLC

Columbus, Ohio

Apply
JOB DETAILS
SALARY
$85–$90
SKILLS
Acceptance Testing, Apex Programming Language, Application Programming Interface (API), CPU (Central Processing Unit), Centers for Disease Control and Prevention (CDC), Channel Strategies, Cloud Architecture, Cloud Computing, Code Reviews, Community Cloud, Consulting, Corrective Action, Customer Relations, Data Analysis, Data Modeling, Data Processing, Data Sets, Data Structures, Database Administration, Decision Support, DevOps, Developmental Disabilities, Enterprise Architecture, Enterprise Data Integration, Error Handling, Government, Help Desk, IP (Internet Protocol), Information/Data Security (InfoSec), Internet Security, Internet Service Providers, Knowledge Transfer, Leadership, Licensing, Maintain Compliance, Mentoring, Metadata, Microsoft Windows Azure, People Management, Performance Analysis, Problem Solving Skills, Product Support, Production Support, Public Cloud, REST (Representational State Transfer), Regression Testing, Regulatory Compliance, Release Management/Engineering, Replication and Remote Mirroring, Risk, Risk Analysis, Risk Management, Root Cause Analysis, SOAP (Simple Object Access Protocol), SQL (Structured Query Language), Salesforce.com, Snowflake Schema, Software Development, Sprint Planning, Sustainability, System Operations, Tableau, Technical Delivery, Technical Leadership, Technical Strategy, Technical Support, Technical/Engineering Design, Unstructured Data
LOCATION
Columbus, Ohio
POSTED
1 day ago
The Salesforce Solutions Architect serves as a senior-level technical resource responsible for Salesforce architecture guidance, solution governance, security review, integration alignment, data governance, and enterprise modernization support across the State of Ohio - Department of Developmental Disabilities enterprise.

This position requires deep hands-on expertise across Salesforce GovCloud, Salesforce platform architecture, Experience Cloud, Public Sector Solutions, Apex, Lightning Web Components, Salesforce Flow, data modeling, sharing and visibility, DevOps, integrations, and enterprise data platforms. The consultant will operate as a strategic partner and technical authority, collaborating extensively with Enterprise Architecture, Application Development, Cybersecurity, Infrastructure, Database Administration, Integration, Product, and Production Support teams to ensure Salesforce solutions align with agency mission, security standards, compliance needs, and long-term platform sustainability.

The selected candidate will help the Enterprise Architecture team review solution designs, identify technical risks, recommend scalable patterns, prevent technical debt, and support complex initiatives such as Salesforce GovCloud implementation, Public Sector Solutions licensing impacts, data masking, Data 360 / Data Cloud planning, and cross-application dependency management.

ESSENTIAL FUNCTIONS & RESPONSIBILITIES

Salesforce Architecture, Platform Governance & Solution Design (40%)
  • Provide Salesforce architecture guidance for applications built on Salesforce GovCloud and related Salesforce platform capabilities.
  • Guide teams on the appropriate use of standard Salesforce objects, custom objects, shared objects, record types, permission sets, profiles, sharing rules, Salesforce Flow, Apex, Lightning Web Components, validation rules, custom metadata, custom settings, APIs, and Experience Cloud.
  • Review and recommend technical designs for new Salesforce applications, enhancements, integrations, automations, data flows, and cross-application dependencies.
  • Evaluate whether proposed solutions are scalable, secure, maintainable, supportable, and aligned with Department enterprise standards.
  • Help prevent unnecessary object proliferation and promote reuse of common enterprise objects, shared services, reusable patterns, and standard architecture practices.
  • Support technical decision-making around common Salesforce data structures such as Account, Contact, Account Contact Relationship, provider relationships, individual records, assessments, files, county board relationships, cases, and related data models.
  • Provide architecture support for modernization and transition initiatives, including OhioISP wind-down, Individual Summary Profile / ISP transition planning, assessment access, provider access, Client/individual access, and dependent application impacts.
  • Document architecture decisions, diagrams, risks, dependencies, assumptions, tradeoffs, and recommendations in a leadership-friendly format.
 Cross-Team Collaboration, Technical Leadership & Delivery Support (25%)
  • Participate in architecture reviews, refinement sessions, sprint planning, technical design discussions, production support discussions, and release readiness reviews.
  • Partner with Application Development, Cybersecurity, Infrastructure, Database Administration, Integration, Help Desk, Product, and Production Support teams to align Salesforce solutions with enterprise architecture direction.
  • Provide recommendations around DevOps, deployment sequencing, sandbox strategy, release management, regression testing, and post-deployment validation.
  • Support code review guidance for Apex, Lightning Web Components, Salesforce Flow, integrations, configuration, and shared services.
  • Help evaluate performance risks including governor limits, DML limits, heap size, CPU time, record locking, sharing recalculation, data volume, asynchronous processing, and batch processing constraints.
  • Research upcoming Salesforce platform, security, licensing, and enterprise architecture changes and communicate opportunities and risks through the enterprise.
  • Provide technical mentorship and knowledge transfer to ITS staff and vendor teams; present architecture strategies, risks, and project updates to leadership.
  • Perform other duties as assigned.
 Security, Access, Compliance & Risk Management (15%)
  • Review and recommend access models involving profiles, permission sets, permission set groups, sharing rules, role hierarchy, object permissions, field-level security, Experience Cloud users, delegated administration, and internal/external user access patterns.
  • Support design decisions around internal read-only access, external user access, Client and individual access, provider access, reviewer access, and business-specific role-based access requirements.
  • Support security controls for sensitive data, including PII, PHI, CPI, provider data, individual data, assessment data, files, and other regulated information.
  • Review and advise on security-related changes to page layouts, object permissions, field-level security, record visibility, user administration, community access, and shared object exposure.
  • Support Salesforce security mandate readiness including MFA, IP restrictions, device activation, transaction security policies, DKIM verification, high-risk IP enforcement, and related platform security changes.
  • Identify security and compliance risks caused by shared objects, legacy access patterns, production support changes, page layout changes, or reintroduction of functionality previously removed for PII/PHI risk reasons.
 Integration, Data Flow & Enterprise Data Architecture (10%)
  • Help teams design reliable upsert patterns using Salesforce IDs, external IDs, SQL identifiers, integration keys, and source-system identifiers.
  • Review data synchronization requirements to prevent duplicate records, stale records, mismatched source systems, unnecessary replication, and unclear source-of-truth ownership.
  • Support architecture decisions involving REST/SOAP APIs, MuleSoft APIs, batch processing, CDC, Platform Events, Event Streamer, event-driven architecture, integration monitoring, correlation IDs, and error handling.
  • Provide guidance on data movement across Salesforce and enterprise systems while balancing operational needs, reporting needs, performance, security, and maintainability.
  • Partner with production and integration teams to perform root cause analysis on complex issues, research solutions, and recommend corrective actions.
 Data Governance, Data Masking, Data 360 & Platform Optimization (10%)
  • Work with business, technical, and security teams to identify fields that must be masked, partially masked, tokenized, conditionally visible, or protected in lower environments.
  • Support governance around production data usage in sandboxes, UAT, SIT, training, reporting, and testing environments.
  • Help identify which Salesforce and enterprise data sources should be evaluated for Data 360 / Data Cloud ingestion.
  • Support mapping of person, provider, assessment, county board, case, document, file, and relationship data for future harmonization and identity resolution.
  • Review data catalog outputs and help determine which tables, fields, and datasets are appropriate for ingestion, reporting, segmentation, activation, and calculated insights.
  • Help manage credit-conscious design decisions for Data 360 batch ingestion, streaming ingestion, unstructured data processing, queries, segmentation, and activations.
  • Review Public Sector Solutions, Experience Cloud, Customer Community Plus, and related licensing implications for internal and external users.
 Requirements
  • Experience with Salesforce platforms - Required 7 Years
  • Experience with Microsoft Environments including Azure and Dynamics - Required 7 Years
  • Demonstrated hands-on experience with Salesforce platform capabilities including Apex, Lightning Web Components, Salesforce Flow, validation rules - Required 7 Years
  • Experience with Snowflake data platform - Required 7 Years
  • Experience with Tableau analytics integration - Required 7 Years
 Must live in Ohio

About the Company

M

Main Sail LLC

Resume Resources

Free Resume TemplatesFree Resume Builder

Similar Job Searches

Application Architect Jobs in Columbus, OHData Modeler Jobs in Columbus, OHEnterprise Architect Jobs in Columbus, OHSecurity Architect Jobs in Columbus, OHStructural Engineer Jobs in Columbus, OH