Salesforce Business Analyst – Data Specialist

Role Overview

• Engage customer stakeholders to understand data-related business outcomes, reporting needs, and define measurable success criteria for data quality, completeness, and accessibility
• Articulate the value of data-driven Salesforce solutions, including data governance, migration strategies, and analytics capabilities
• Lead discovery and data assessment sessions to inventory legacy systems, data sources, data quality issues, and transformation requirements
• Analyze, profile, and map source data to Salesforce data models, identifying relationships, dependencies, and data integrity constraints
• Perform detailed data mapping, transformation logic definition, and reconciliation planning between source and target systems
• Conduct fit-gap analysis between existing data structures and Salesforce standard/custom objects and recommend optimal data model design
• Define and document data migration strategies, including data cleansing, deduplication, enrichment, and validation processes
• Develop and maintain data migration artifacts such as data dictionaries, mapping documents, conversion plans, and reconciliation reports
• Collaborate with technical teams to execute data migrations using tools such as Data Loader, Data Import Wizard, ETL platforms, and integration frameworks
• Design and validate test scenarios for data migration, including unit, system integration, and user acceptance testing (UAT)
• Monitor and resolve data migration issues, ensuring accuracy, completeness, and compliance with business rules
• Support the development of reporting, dashboards, and analytics solutions to enable business insights and performance tracking
• Collaborate with Product Owners and stakeholders in an Agile or Hybrid-Agile environment to iteratively refine data requirements and deliverables
• Develop data governance frameworks, including data stewardship roles, data quality standards, and ongoing data maintenance processes
• Deliver training and documentation to enable end users to effectively manage and utilize migrated data within Salesforce
• Work with the Guidehouse Project Manager to manage data migration activities within scope, budget, and timeline expectations

Requirements

• BA/BS degree
• A minimum of FIVE (5) years of work experience, with a strong focus on data analysis and migration projects
• Experience leveraging AI-enabled tools and accelerators to automate data profiling, mapping, cleansing, and validation, and to enhance data quality insights and migration outcomes
• Minimum of ONE (1) current Salesforce Certification (Admin, App Builder, or relevant Cloud certification) is preferred
• Hands-on experience with Salesforce data management tools (Data Loader, Data Import Wizard, Workbench)
• Experience with data migration methodologies, including profiling, cleansing, mapping, validation, and reconciliation
• Experience working with large datasets, multiple legacy systems, and complex data transformations
• Strong understanding of Salesforce data model, including standard and custom objects, relationships, and data architecture principles
• Experience with ETL/ELT tools (e.g., Informatica, MuleSoft, Talend, SSIS, or equivalent) and integration patterns
• Experience performing data quality analysis, including deduplication, normalization, and enrichment strategies
• Experience writing data mapping documents, migration plans, and reconciliation reports
• Familiarity with data governance frameworks and best practices
• Experience supporting testing cycles (SIT, UAT) with a focus on data validation
• Strong analytical, problem-solving, and troubleshooting skills
• Excellent written and oral communication skills
• Experience working in Agile or Hybrid-Agile environments
• US Citizenship is contractually required for this role
• Ability to work in a hybrid environment

Tech Stack

• Cloud
• ETL
• Informatica
• SSIS

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend