Description :

Data Engineer with 3-6 years of experience specializing in SQL, Salesforce objects, data cleaning, and loading external data (SQL server, data feeds etc) at integrating CRM data with analytics pipelines. To ensure high-quality data flows from Salesforce to warehouses, supporting insurance and business intelligence needs.

Job Summary :

Data Engineer (Salesforce Focus) with 3-6 years of experience in ETL processes, SQL querying, and Salesforce data management. Key role involves designing data pipelines for Salesforce objects, performing cleaning/validation, bulk loads, and enabling analytics/reporting in enterprise CRM environments.

Key Responsibilities :

- Extract, clean, and transform data from Salesforce objects (e.g., Accounts, Contacts, Opportunities, custom objects) using SOQL queries and tools like Data Loader or Workbench.

- Build and optimize ETL pipelines for data loading into warehouses (e.g., Snowflake, SQL Server), handling deduplication, validation, and error resolution to maintain data integrity.

- Write complex SQL/SOQL scripts for data modeling, performance tuning, and ad-hoc analysis while collaborating with analysts on reports and dashboards.

- Implement automation for data migration, governance, and quality checks, including integration with third-party systems via APIs.

- Troubleshoot production issues, monitor pipelines, and document processes to support scalable Salesforce data operations.

Required Skills :

- Proficiency in SQL/SOQL for querying Salesforce data, joins, aggregations, and optimization across large datasets.

- Hands-on expertise with Salesforce data tools (Data Loader, ETL processes) and data cleaning techniques (deduping, standardization).

- Experience in data loading/migration, ETL frameworks, and basic scripting (Python preferred) for automation.

- Strong analytical skills, familiarity with data warehousing, and ability to work with BI tools like Tableau or Power BI.

Education and Experience :

- Bachelors degree in computer science, Data Science, IT, or related field.

- 3-6 years in data engineering or Salesforce data roles, with proven projects in data cleaning, loading, and CRM integration.

- Salesforce Administrator certification or equivalent (e.g., Data Management knowledge) highly preferred.