Senior Data & Salesforce Integration Analyst

ACL Digital; Boston (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

ACL Digital seeks a Senior Business Analyst to translate business data needs into technical specifications and manage data flows across Advancement systems. You will partner with ITS and Advancement Technology to support Salesforce data model design and system configuration, focusing on clean, well-organized data and reliable integrations.

With 4+ years in data/business analysis and strong SQL/Excel skills, you will document requirements, create user stories, and coordinate multiple projects

Qualifications

• Bachelor's degree required; education or experience in information systems, computer science, data management, or related field.
• Minimum four+ years in data or systems analyst roles (4+ years total, with 2+ years in analyst roles).
• Experience in data mapping with field-level documentation and source-to-target specifications.
• Experience supporting monitoring data integrations and issue resolution.
• Salesforce experience with object configuration, schema understanding, and data model familiarity.
• Advanced SQL skills and proficiency with Excel; ETL tools experience a plus.
• Ability to write clear functional specs, user stories, and technical docs for both non-technical and technical audiences.
• Strong project management and multi-project coordination across data lifecycle.
• Excellent written and verbal communication; cross-functional collaboration.
• Higher education or fundraising experience is a plus.

Responsibilities

• DATA MAPPING: document mappings and ensure accuracy (25%).
• DATA INTEGRATION SUPPORT: monitor and resolve integration issues (35%).
• SALESFORCE DATA MODEL SUPPORT: assist with Salesforce data model and configuration (25%).
• CROSS-FUNCTIONAL COLLABORATION & OTHER DUTIES: support ITS and Advancement teams (20%).

Skills

Data mapping

Data integration

Salesforce

SQL

Excel

Technical documentation

Project management

Education

Bachelor's degree in Information Systems or related field

Tools

ETL tools

Data modeling tools

Job description

ACL Digital seeks a Senior Business Analyst to translate business data needs into technical specifications and manage data flows across Advancement systems. You will partner with ITS and Advancement Technology to support Salesforce data model design and system configuration, focusing on clean, well-organized data and reliable integrations.

With 4+ years in data/business analysis and strong SQL/Excel skills, you will document requirements, create user stories, and coordinate multiple projects