Associate Principal Engineer - Technical Business Analyst (Salesforce & Snowflake Data Migration)

Role Summary

A highly technical Business Analyst to lead the data mapping efforts for a critical migration program. The ideal candidate is a “Data BA” who is comfortable digging into the Salesforce backend and legacy databases (DB2/IMS) to define precise transformation logic for our engineering team.

You will not just be gathering requirements; you will be authoring the technical blueprints (STTMS) that drive the migration to Snowflake.

Key Responsibilities

Data Mapping & STTMS

• Author detailed Source-to-Target Mapping Specifications (STTMS) mapping Legacy and Salesforce fields to Snowflake.
• Documentation must include precise transformation logic, data type conversions, and handling of nulls/edge cases.

Gap Analysis

• Identify structural differences between the source (e.g., hierarchical legacy data) and target (Salesforce/Snowflake relational models) and propose technical solutions to bridge them.

Collaboration

• Act as the translator between business stakeholders and Data Engineers, ensuring mapping logic is technically feasible and business-compliant.

Salesforce Analysis

• Independently navigate the Salesforce Object Model (Object Manager) to identify custom objects, API field names, and hidden relationships without relying solely on developers.