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.

Qualifications :

• 5 years of experience as a Technical Business Analyst or Data Analyst in ETL/Data Migration projects.
• Expert-level proficiency in Excel and Lucid Chart for creating comprehensive data dictionaries and mapping sheets.
• Deep understanding of the Salesforce data model (Standard Objects Custom Objects API names Schema Builder).
• Admin certification is a plus.
• Strong proficiency in SQL (joins aggregations data profiling) and familiarity with Cloud Data Warehouses (Snowflake AWS Redshift).
• Experience working with legacy data sources (Mainframe DB2 IMS) is highly preferred.

Additional Information :

Disclaimer: Nagarro is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will be afforded equal employment opportunities without discrimination based on race creed color national origin sex age disability or marital status.

Remote Work :

No

Employment Type :

Full-time