The Role
Lead a Salesforce integration modernization project by replacing legacy SQL staging layers with direct API and event-driven connections. Design scalable real-time and batch pipelines, manage middleware, translate SQL and ETL logic into Apex and Salesforce flows, and develop data governance, reconciliation, error handling, and large-data-volume strategies. Optimize Apex, triggers, LWC, batching, queuing, API usage, and Salesforce governor-limit performance.
Summary Generated by Built In
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.
Skills Required
- Advanced Salesforce integration and data engineering experience
- Experience designing REST, SOAP, and event-driven integrations
- Experience with integration middleware such as MuleSoft, Dell Boomi, Celigo, or Azure Data Factory
- Strong SQL, stored procedure, view, and ETL experience
- Apex development, triggers, and Lightning Web Components experience
- Experience with Salesforce data modeling, large data volumes, indexing, and governor-limit optimization
- Experience implementing error handling, exception logging, and data reconciliation
- Ability to work locally in Phoenix in a hybrid schedule three days per week
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Novalink Solutions LLC is a global consulting, engineering, and AI product development company specializing in information technology and telecommunications. They provide AI-powered products, automation platforms, intelligent workflow systems, IT consulting, managed engineering, and staff augmentation services.
