Salesforce Data Engineer

Novalink Solutions LLC • Phoenix, AZ

4d • Hybrid

About The Position

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.

Requirements

• Senior Salesforce Integration & Data Engineer skills
• Experience with digital transformation projects
• Experience decommissioning legacy SQL database intermediate layers
• Experience replacing intermediate layers with direct integration paths between core source systems and Salesforce
• Ability to bridge the gap between traditional database architecture and modern cloud ecosystems
• Experience designing, building, and maintaining highly scalable real-time and batch integration streams
• Experience ensuring data integrity, minimal latency, and optimal API footprint management
• Experience with API development (REST/SOAP)
• Experience with event-driven patterns
• Experience with integration platforms or middleware (e.g., MuleSoft, Dell Boomi, Celigo, or Azure Data Factory)
• Experience with data mapping and transformation
• Experience rewriting SQL stored procedures, views, and ETL logic
• Experience with Apex, middleware logic, or declarative Salesforce flows
• Experience designing data models within Salesforce for high volumes
• Experience with indexing and custom skinning in Salesforce
• Experience building end-to-end exception logging and data reconciliation mechanisms
• Experience writing Apex code, Triggers, and Lightning Web Components (LWC)
• Experience with asynchronous programming
• Experience with governor limits optimization in Salesforce
• Experience with batching and queuing strategies

Responsibilities

• Decommission 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.
• 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.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed