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.