What are the responsibilities and job description for the Salesforce Data Engineer position at Idealforce LLC?
Idealforce has contract position available immediately for a Salesforce Data Engineer to join our customer in Phoenix,AZ. This is Hybrid Position.Please find below additional details about this job.Local Candidates.
Local to Phoenix Only. Strictly no out of state candidates.
Job Description:
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 Responsibilities
1. Integration & Pipeline Re-architecting 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.
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.
Required Skills
4 Years of Salesforce Data Engineer experience
Migration from SQL DB to Salesforce (Please make sure its on the resume)
Decommissioning SQL DB
Preferred Skills
The Salesforce Admin Certification/Platform Developer 1
Disclaimer :The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.