Senior Data 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

Duration: 6 months temp to perm for the right person

Top 3 technical

Communication, written and oral

System model understand and translation

Snowflake

Job Summary

The Senior Business Analyst is the Director of Data Strategy & Analytics' primary partner for technical data infrastructure owning data mapping, supporting data integrations, and providing direct assistance on Salesforce data model design and system configuration. This role operates at the intersection of business requirements and technical execution, translating the data needs of University Advancement into clearly documented specifications, integration support, and system structure that enables clean, reliable, and well-organized data. Working closely with the Director, the Senior Business Analyst manages the documentation and lifecycle of data flows across Advancement systems, supports integration monitoring and issue resolution, and contributes to the ongoing design and maintenance of the ascend CRM data model. This role serves as a key liaison between Advancement business units and technical partners in ITS and Advancement Technology. The Senior Business Analyst does not own data governance policy or data quality analysis those responsibilities sit with the Senior Data Strategy Analyst. This role partners with the SDSA where data structure and governance standards intersect, particularly on migration and integration projects.

Minimum & Preferred Qualifications

• Preferred Qualifications Bachelor's degree required; education or experience in information systems, computer science, data management, or a related field required.
• Minimum four (4) years of experience with two (2) or more years in a data analyst, business analyst, or systems analyst role.
• Demonstrated experience in data mapping, including field-level documentation and source-to-target mapping specifications.
• Experience supporting or monitoring data integrations; ability to identify, document, and elevate integration issues effectively.
• Salesforce experience required; object configuration, schema understanding, and data model familiarity strongly preferred.
• Advanced SQL skills and proficiency with Excel required; experience with data integration tools or ETL processes a plus.
• Demonstrated ability to write clear functional specifications, user stories, and technical documentation for non-technical and technical audiences.
• Strong project management and organizational skills; ability to manage multiple projects simultaneously across the data lifecycle.
• Excellent written and verbal communication skills; strong interpersonal skills and ability to work cross-functionally.
• Higher education or fundraising experience a plus.

Key Responsibilities & Accountabilities Percent of Time

• 1. DATA MAPPING 25%
• 2. DATA INTEGRATION SUPPORT 35%
• 3. SALESFORCE DATA MODEL SUPPORT 25%
• 4. CROSS-FUNCTIONAL COLLABORATION & OTHER DUTIES 20%