JobCubby JobCubby
Sign up
Novalink Solutions LLC

Salesforce Data Engineer

Novalink Solutions LLC Phoenix, Arizona, United States

IT Services and IT Consulting · 51-200 employees

20 h ago
data-engineer Senior (5-10 yrs) Contractor United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The role involves decommissioning legacy SQL database layers and replacing them with direct, modern integration paths between source systems and Salesforce. You will design and maintain scalable real-time and batch integration streams while ensuring data integrity and optimal API performance.

What they look for

Salesforce Data Engineering SQL Apex MuleSoft Dell Boomi Celigo Azure Data Factory REST SOAP ETL Lightning Web Components Data Modeling API Management Cloud Ecosystems

Requirements

The candidate must be a senior-level engineer with expertise in Salesforce integration, middleware management, and custom development using Apex and LWC. Strong proficiency in database architecture, ETL logic, and managing large data volumes within the Salesforce ecosystem is required.

Full description

LOCAL ONLY TO PHOENIX, Hybrid 3 days in the office. Possibility of extension beyond 12/31.

We are seeking a highly skilled Senior Salesforce Integration & Data Engineer to lead a critical digital transformation project. In this role, you will be responsible for decommissioning our legacy SQL database intermediate layer and replacing it with direct, modern integration paths between our core source systems and Salesforce. The ideal candidate will bridge the gap between traditional database architecture and modern cloud ecosystems. You will design, build, and maintain highly scalable real-time and batch integration streams, ensuring data integrity, minimal latency, and optimal API footprint management.

Core Responsibilities1. Integration & Pipeline Re-architectingDecommission Legacy SQL Layers: Analyze and phase out existing intermediate SQL relational databases currently functioning as staging layers between source systems and Salesforce.Establish Direct Connections: Architect, develop, and deploy robust direct APIs (REST/SOAP) and event-driven patterns to connect upstream source systems directly to Salesforce. Middleware Management: Configure and maintain integration platforms or middleware (e.g., MuleSoft, Dell Boomi, Celigo, or Azure Data Factory) to manage traffic, data orchestration, and transformation rules.2. Data Governance & Architecture Data Mapping & Transformation: Rewrite complex SQL stored procedures, views, and ETL logic into scalable Apex, middleware logic, or declarative Salesforce flows. Large Data Volume (LDV) Strategy: Design data models within Salesforce that handle high volumes without degrading system performance, incorporating indexing and custom skinning where necessary. Error Handling & Reconciliation: Build end-to-end exception logging and data reconciliation mechanisms to identify and resolve synchronization failures automatically.3. Platform Development & Optimization Custom Development: Write clean, asynchronous, and well-tested Apex code, Triggers, and Lightning Web Components (LWC) when custom programmatic solutions are needed for data intake. Governor Limits Optimization: Guard the Salesforce environment against API throttling, row-locking issues, and governor limit breaches by implementing optimal batching and queuing strategies.

Similar roles