[Hiring] Salesforce/SQL Data Reconciliation Specialist @Agama Solutions

Role Description

We are seeking an experienced Salesforce Data Reconciliation Specialist to join our team. The position is 100% fully remote and can be located anywhere in the United States. In this role, you will be responsible for managing, optimizing, and executing the movement of large data volumes within Salesforce and SQL Server. You will collaborate with cross-functional teams to ensure seamless data migration, integration, and synchronization using various tools and platforms. This is very much a hands-on position.

Qualifications

• Proficiency in using tools like Salesforce Bulk API, Data Loader, and SSIS (SQL Server Integration Services) for bulk data movement.
• Familiarity with integration platforms such as MuleSoft, Informatica, or Talend.
• Ability to optimize data transfer processes for minimal downtime and maximum efficiency.
• Expertise in creating, managing, and migrating custom objects within Salesforce.
• Understanding of data schema, relationships, and dependencies for accurate data import/export.
• Proficiency in using Salesforce tools like Data Import Wizard and Data Loader.
• Strong ability to write complex queries in SOQL.
• Deep understanding of Salesforce object relationships (e.g., master-detail, lookup).
• Extensive experience in designing, developing, and deploying SSIS packages for data integration and ETL processes.
• Ability to transform data between different formats and systems using SSIS.
• Proficiency in implementing robust error handling and logging mechanisms within SSIS packages.
• Salesforce certifications such as Salesforce Certified Data Architecture and Management Designer or Salesforce Certified Platform Developer I (nice to have).
• Strong analytical skills and attention to detail.
• Ability to work collaboratively in a team environment.
• Practical experience with real-world projects involving data migration, integration, and management within Salesforce.

Requirements

• Proficiency in Salesforce Bulk API, Data Loader, and SSIS.
• Experience with integration platforms like MuleSoft, Informatica, or Talend.
• Strong skills in SOQL and understanding of object relationships.
• Extensive experience with SSIS and data transformation.

Benefits

• Fully remote work environment.
• Opportunity to work with cross-functional teams.
• Hands-on experience with data migration and integration.