Data Architect at RSM leading AI-driven data migration initiatives within Salesforce ecosystem. Implementing data governance and optimizing performance across complex datasets.
Responsibilities
Lead and execute AI-driven data migration initiatives within the Salesforce ecosystem
Design, develop, and implement end-to-end data migration strategies for Salesforce and Data Cloud implementations using AI-powered tools and frameworks
Build and optimize ETL/ELT pipelines to ingest, transform, and load data from diverse source systems (ERP, CRM, data warehouses, legacy systems) into Salesforce Data Cloud
Apply AI techniques for data quality assessment, automated mapping, deduplication, entity resolution, and anomaly detection during migration processes
Architect data models within Salesforce Data Cloud, including Data Model Objects (DMOs), data streams, and calculated insights to support unified customer profiles
Collaborate with Salesforce architects, business analysts, and stakeholders to define data migration requirements, mapping specifications, and transformation rules
Develop and maintain automated testing frameworks to validate data accuracy, completeness, and consistency across migration phases
Implement data governance standards, lineage tracking, and compliance controls throughout the migration lifecycle
Monitor and optimize migration performance, troubleshoot data pipeline failures, and ensure SLA adherence
Create comprehensive technical documentation including data dictionaries, migration runbooks, and architecture diagrams
Requirements
Bachelor’s or Master’s degree in Computer Science, Data Science, Information Technology, or a related field
5+ years of professional experience in data architecture, with at least 2 years focused on Salesforce data migrations or Salesforce Data Cloud implementations
Strong proficiency in SQL, Python, and data pipeline frameworks across Snowflake, Azure (Data Factory, Synapse), AWS (Glue, Redshift, Step Functions), and GCP (BigQuery, Dataflow, Cloud Composer)
Hands-on experience with Salesforce Data Cloud and the Salesforce data model (standard/custom objects, relationships, metadata)
Demonstrated experience applying AI tools for data quality, entity matching, or intelligent data transformation (e.g., OpenAI APIs, Google Vertex AI, or custom models)
Experience with MuleSoft, Workato, or other integration platforms for enterprise-scale data connectivity
Solid understanding of cloud platforms (AWS, Azure, or GCP) and their data services
Knowledge of data governance, data privacy regulations (GDPR, India’s DPDP Act), and data security best practices
Salesforce certifications such as Data Cloud Consultant, Platform Developer, or MuleSoft Developer (preferred)
Benefits
flexibility in your schedule
total rewards available at https://rsmus.com/careers/india.html
Specialist, Data Engineering at CoverMyMeds enhancing and expanding data platforms for commercial data products. Collaborating with multiple teams to design scalable data solutions from various sources.
Team Lead in Data Engineering at Avanquest mentoring data engineering team and ensuring efficient data management across platforms. Collaborating with departments to align solutions and optimize workflows.
Senior Data Engineer at Capgemini designing and optimizing scalable data architectures on Databricks and GCP. Collaborating across teams to transform business needs into reliable technical solutions.
Data Engineer transforming legacy on - premises systems to cloud - native architectures for advanced data analytics. Collaborating with teams to build efficient data solutions using Python and AWS.
Data Engineering Academy focused on Snowflake and Databricks for professionals interested in expanding their technical capabilities. Fully remote with future office work in Monterrey or Saltillo after completion.
Senior Data Engineer at Intent HQ designing and scaling data platforms. Building high - impact intelligence from millions of customer insights with a focus on performance and reliability.
SAP Data Engineer supporting MERKUR GROUP's evolution into a data - driven company. Responsible for data integration, modeling, and collaboration with various departments in Group Finance.
Data Engineer at Booz Allen Hamilton organizing data and developing advanced technology solutions. Leading data engineering activities for mission - driven projects and mentoring multidisciplinary teams.
Senior Data Engineer at Bristol Myers Squibb developing scalable data pipelines for foundational products. Collaborating with data scientists and IT professionals to ensure data quality and accessibility.