Logo
Jobs via Dice

Senior Data Analyst Salesforce

Jobs via Dice, Denver, Colorado, United States, 80285

Save Job

1 day ago Be among the first 25 applicants Dice is the leading career destination for tech experts at every stage of their careers. Our client, SSTech LLC, is seeking the following. Apply via Dice today!

Title: Senior Data Analyst Salesforce -

Location: Denver, CO - 5 days a week onsite

Role Summary:

The Sr. Data Analyst will play a critical role in a Salesforce org consolidation project, migrating data from the Source Salesforce Org to the Target Salesforce Org while preserving custom processes and relationships. This role is responsible for ensuring data integrity and accuracy throughout the migration process. The analyst will profile and map data, perform manual transformations in Excel, and prepare migration-ready datasets. The role ensures minimal data loss, compliance with business rules, and seamless post-migration functionality.

Responsibilities:

Data Domain Analysis: Work across all Salesforce CRM data domains (Accounts, Contacts, Opportunities, Cases, Leads, and Custom Objects) to understand current data structures in both orgs, including parent-child relationships and reference fields. Conduct thorough data profiling to identify data quality issues (e.g., duplicates, inconsistencies, outdated records) and contribute to data cleansing strategies prior to migration.

Data Mapping & Transformation: Develop detailed field-to-field data mapping for migrating records from the Digital Org to the Global Component Org. Document and maintain a detailed mapping dictionary across multiple business units to define how each source field translates to the target org s fields. Handle ID remapping for lookups and master-detail relationships; ensure transformations account for Salesforce-specific constraints (e.g., record types, validation rules). Perform manual data transformations and cleanup in Excel (using formulas, pivot tables, etc.) to align data with the target structure/schema.

Collaboration with Development Team: Work closely with Salesforce developers and technical teams responsible for data extraction and loading. Collaborate on ETL processes using tools like Salesforce Data Loader or third-party integrators. Provide clear requirements and mapping logic to developers, verify that extracted data meets expected criteria, and assist in troubleshooting data issues.

CSV Preparation: Prepare final migration-ready CSV files for each Salesforce object and each business unit, based on the field mapping and transformation rules. This includes cleansed data, verifying field mappings, and ensuring the CSVs meet the format for import. Sequence CSVs for phased migration (e.g., load parent records before children) to maintain data integrity. Ensure that all necessary data (including lookup/reference IDs) is correctly prepared for a smooth upload process.

Post-Migration Validation: After data is loaded into the target org, perform data validation. Compare source and target datasets to ensure all records have migrated successfully and no discrepancies or missing records exist. Use SOQL queries or reports to reconcile data; validate against business rules (e.g., compliance with GDPR for personal data). Identify and document any data variances, and work with the team to resolve issues.

Documentation & Reporting: Create and update documentation for all data migration activities, including data mapping documents, transformation rules, reconciliation reports, migration runbooks, and error logs for auditability.

Risk Assessment: Identify potential migration risks (e.g., data volume limits, API quotas) and recommend mitigation strategies.

Requirements:

Experience: 5+ years of experience in data analysis, data quality, or data management roles, with hands-on experience in Salesforce org migrations or consolidations (e.g., merging sandboxes or production orgs) and a significant focus on Salesforce or CRM data.

Salesforce Data Knowledge: Good understanding of the Salesforce data model and CRM concepts including standard objects (Accounts, Contacts, Opportunities, Cases, Leads) and custom objects. Familiarity with Salesforce APIs (e.g., Bulk API), SOQL, and data loading tools like Data Loader or Jitterbit. Ability to quickly learn and understand the data schemas of both source and target Salesforce orgs.

Excel Proficiency: Advanced skills in Microsoft Excel for data profiling and transformation (e.g., using VLOOKUP/XLOOKUP, pivot tables, text functions, conditional formulas).

Data Profiling & Cleansing: Hands-on experience analyzing data quality and identifying anomalies. Able to profile datasets to find duplicate entries, inconsistent values, and missing information, and devise strategies to standardize and clean the data prior to migration. Experience with Salesforce duplicate rules and matching logic.

Data Mapping & Documentation: Demonstrated ability to perform field-by-field data mapping between systems. Experience creating clear mapping documents or data dictionaries that outline how source fields correspond to target fields, including transformation rules or lookup tables.

Technical Tools: Experienced using various tools for data analysis. Proficiency with data-handling tools (e.g., SQL for queries, Python/Pandas for scripting, or ETL software like Talend); experience with Salesforce Data Loader required.

Soft Skills: Strong communication for collaborating with business stakeholders (e.g., validating custom processes) and problem-solving under deadlines.

Compliance Knowledge: Understanding of data privacy regulations (e.g., GDPR) in CRM migrations. Seniority level

Seniority level

Mid-Senior level Employment type

Employment type

Full-time Job function

Job function

Information Technology Industries

Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Get notified about new Senior Data Analyst jobs in

Denver, CO . Senior Data Analyst Operations & Supply Chain

Senior Analyst, Business and Market Intelligence

Denver, CO $90,000.00-$120,000.00 2 weeks ago Business Analyst Associate, Product Go-To-Market

Boulder, CO $96,000.00-$138,000.00 1 day ago Senior Analyst, Business Intelligence & Financial Systems

Denver, CO $100,000.00-$140,000.00 1 day ago Specialist, IT Business Systems Analysis (Philadelphia, Denver or Cedar Rapids)

Denver, CO $125,000.00-$138,000.00 6 days ago (USA) Senior Analyst, Business Development

Denver, CO $77,000.00-$143,000.00 5 days ago Now Hiring: Senior Business Analyst Help Shape the Future of Enterprise Platforms (Hybrid in Denver)

Business Analyst (Operational Analytics)

Denver, CO $100,000.00-$125,000.00 3 weeks ago Englewood, CO $82,000.00-$93,000.00 1 week ago Business Analyst, Software Implementations

Manager, Financial Analytics and Strategy

Denver, CO $91,000.00-$133,000.00 1 day ago Senior Associate, CFO/F&A Technology Business Analyst

Business Analyst, application via RippleMatch

Senior Technical Business Analyst - Energy, Sustainability & Mobility

Denver, CO $98,000.00-$140,000.00 2 weeks ago Lakewood, CO $110,000.00-$130,000.00 1 week ago Senior Business Analyst/Governance Analyst

Lakewood, CO $80,000.00-$100,000.00 1 week ago Englewood, CO $75,000.00-$85,000.00 2 months ago Denver, CO $97,500.00-$156,000.00 5 hours ago Accela Business Analyst; Hybrid Long Term Project

Denver, CO $150,000.00-$185,000.00 1 month ago Senior Associate, CFO/F&A Technology Business Analyst

Senior Business Tax Analyst - Work From Home

Senior Business Analyst/Governance Analyst

Lakewood, CO $80,000.00-$100,000.00 1 week ago Greenwood Village, CO $106,200.00-$132,800.00 1 month ago Business Analyst Associate, Product Go-To-Market

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr