Data Architect

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

SSIS
SQL
Salesforce
API
Health cloud

Job Details

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.