Data Architect (Salesforce)

Data Architect (Salesforce)

Posted 1 week ago by 1752302489

Apply
Negotiable
Outside
Remote
USA
Apply
Agile Methodology Application Programming Interface (API) Bank Reconciliations Cloud Computing Cloud Technology Data Engineering Data Flow Diagram Data Mapping Data Migration Datamodel Data Modeling Data Processing Data Quality Data Validation Extract Transform Load (ETL) Mapping Software MuleSoft Object Model Profiling (Computer Programming) Reconciliation Salesforce Software Development SQL (Programming Language) Test Data Verification And Validation

Summary: We are seeking a Data Developer with over 12 years of experience in Data Engineering and ETL development, specifically for Salesforce migration projects. The role focuses on building and testing ETL pipelines to facilitate data migration and integration between legacy and new Salesforce systems. The candidate will be responsible for data quality validation and resolving data-related issues using SSIS. Collaboration with Salesforce developers and analysts is essential to ensure accurate data mapping and transformation.

Key Responsibilities:

  • Build, configure, and maintain data pipelines using SSIS for migrating data from the old Salesforce org to the new Health Cloud org.
  • Implement data mapping, transformation logic, and business rules as defined by the Data Architect.
  • Collaborate with Salesforce developers and analysts to understand the data model and field-level requirements.
  • Extract, transform, and load (ETL) structured data from Salesforce and external systems.
  • Perform data validation and reconciliation between source and target systems.
  • Write complex SQL queries and stored procedures for data processing and audits.
  • Monitor and troubleshoot data jobs, ensure performance optimization and log generation.
  • Support test data setup, mock data creation, and migration dry runs.
  • Maintain clear documentation for ETL processes and data flow logic.

Key Skills:

  • Strong hands-on experience with ETL tools like SSIS and optionally MuleSoft.
  • Proficiency in writing SQL scripts, views, joins, and stored procedures.
  • Working knowledge of Salesforce object model (standard and custom).
  • Experience in data validation, profiling, and cleansing.
  • Familiarity with data migration strategies in cloud environments.
  • Knowledge of healthcare data (patients, providers, encounters) is a plus.
  • Ability to work in agile, cross-functional teams.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Description:

Experience:

  • 12+ years in Data Engineering or ETL development, Salesforce Migration
  • Tools: SSIS, SQL, Salesforce, APIs, MuleSoft(Optional)

Job Summary:

We are looking for a hands-on Data Developer to support the data migration and integration between a legacy Salesforce Service Cloud org and a new Salesforce Health Cloud org. The role involves building and testing ETL pipelines, performing data transformations, validating data quality, and resolving data-related issues using SSIS.

Key Responsibilities:

  • Build, configure, and maintain data pipelines using SSIS for migrating data from the old Salesforce org to the new Health Cloud org.
  • Implement data mapping, transformation logic, and business rules as defined by the Data Architect.
  • Collaborate with Salesforce developers and analysts to understand the data model and field-level requirements.
  • Extract, transform, and load (ETL) structured data from Salesforce and external systems.
  • Perform data validation and reconciliation between source and target systems.
  • Write complex SQL queries and stored procedures for data processing and audits.
  • Monitor and troubleshoot data jobs, ensure performance optimization and log generation.
  • Support test data setup, mock data creation, and migration dry runs.
  • Maintain clear documentation for ETL processes and data flow logic.

Required Skills and Experience:

  • Strong hands-on experience with ETL tools like SSIS and optionally MuleSoft.
  • Proficiency in writing SQL scripts, views, joins, and stored procedures.
  • Working knowledge of Salesforce object model (standard and custom).
  • Experience in data validation, profiling, and cleansing.
  • Familiarity with data migration strategies in cloud environments.
  • Knowledge of healthcare data (patients, providers, encounters) is a plus.
  • Ability to work in agile, cross-functional teams
Apply
Similar Jobs
Loading data...