Senior Data Engineer

Senior Data Engineer1

We are looking for a highly skilled Senior Data Engineer / Analytics Engineer to support a strategic Salesforce data migration initiative. The role will focus on designing and implementing scalable data pipelines using Snowflake and DBT to extract, transform, standardize, validate, and prepare data for successful migration into the target Salesforce ecosystem.

Key Responsibilities

Design and implement end-to-end data migration workflows for Salesforce consolidation initiatives

Extract large-scale data from Salesforce source systems (SF A) into Snowflake staging environments

Build Robust DBT Models For

Data cleansing

Standardization

Deduplication

Mapping and transformation

Business rule implementation

Develop reusable and scalable transformation frameworks in DBT

Collaborate With Business Stakeholders And Salesforce Teams To Understand

Source-to-target mappings

Object relationships

Data quality expectations

Validation requirements

Perform data reconciliation and validation between source and target systems

Optimize Snowflake performance for large-volume data processing

Create audit, error handling, and migration tracking mechanisms

Support deployment and migration activities across environments

Troubleshoot pipeline failures, transformation issues, and data inconsistencies

Ensure data governance, security, and compliance standards are followed throughout the migration lifecycle

Document migration logic, transformation rules, and operational procedures

Required Skills & Experience

Technical Skills

Strong hands-on experience with Snowflake and DBT

Experience building complex SQL-based transformation pipelines

Strong understanding of data warehousing concepts and dimensional modeling

Experience working with Salesforce data models and CRM objects

Expertise in data migration, ETL/ELT, and data integration patterns

Knowledge of incremental loading, CDC, and reconciliation techniques

Experience handling large-scale data transformation and validation

Strong debugging and performance optimization skills in Snowflake

Familiarity with Git/version control and CI/CD practices

Preferred Skills

Experience with Salesforce APIs, connectors, or bulk data loading utilities

Exposure to enterprise acquisition/integration projects

Knowledge of master data management and data quality frameworks

Experience working in Agile delivery environments

Qualifications

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field

5+ years of experience in data engineering, analytics engineering, or data migration projects

Prior experience in Salesforce migration or consolidation projects is highly preferred

Nice to Have

Snowflake certifications

DBT certification

Experience with cloud platforms such as AWS, Azure, or GCP

Exposure to ERP/CRM integration programs