Senior Data Analyst — Salesforce & MDM Reconciliation

Archer; Sausalito (CA); Hybrid; USD 148,000 - 195,000; Full time

Benefits offered by this job

Healthcare

Leave benefits

Retirement benefits

Job summary

Archer, in collaboration with BlackRock, seeks a Senior SMA Data Analyst to safeguard data integrity across Salesforce and Master Data Management platforms. You will tackle data reconciliation, onboarding, and client servicing workflows, driving quality improvements and scalable solutions.

You'll combine SQL, SOQL, Excel, and analytics to investigate issues, develop automation, and collaborate with Data Operations, Salesforce Engineering, and IT teams to ensure accurate, reliable data for

Qualifications

• Bachelor's degree or equivalent in data analytics, information systems, computer science, finance, or related field.
• Strong SQL, SOQL, Excel skills and data analysis techniques.
• Experience with Salesforce or similar CRM and enterprise data platforms.
• Familiarity with Snowflake, Power BI, Python or similar tools.
• Understanding of data governance, data quality, and reconciliation processes.
• Ability to investigate data issues, perform root cause analysis, and implement scalable solutions.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

Responsibilities

• Perform manual reconciliation of data discrepancies between CRM and Master Data Management across client objects.
• Resolve data breaks impacting onboarding and sync failures.
• Develop automated reconciliation capabilities as part of the data quality roadmap.
• Investigate recurring data issues and conduct root cause analysis.
• Track data issues and create reports on volume, trends, and impact.
• Escalate issues to Salesforce Engineering, Data Engineering, or Data Operations.
• Query using SQL, SOQL, and Excel across Salesforce and MDM datasets.
• Validate and reconcile across Snowflake where applicable.
• Maintain documentation and build playbooks and onboarding materials.
• Partner with cross-functional teams to drive resolution of data issues.

Skills

SQL

SOQL

Excel

Salesforce

Snowflake

Power BI

Python

Data governance

Root cause analysis

Data quality

Stakeholder management

Communication

Education

Bachelor's degree or equivalent

Tools

MDM platforms

Job description

Archer, in collaboration with BlackRock, seeks a Senior SMA Data Analyst to safeguard data integrity across Salesforce and Master Data Management platforms. You will tackle data reconciliation, onboarding, and client servicing workflows, driving quality improvements and scalable solutions.

You'll combine SQL, SOQL, Excel, and analytics to investigate issues, develop automation, and collaborate with Data Operations, Salesforce Engineering, and IT teams to ensure accurate, reliable data for