Business Analyst (SQL, Salesforce, Snowflake)

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 escalate 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

Key Responsibilities & Accountabilities Percent of Time

1. DATA MAPPING

• Own field-level data mapping documentation across Advancement systems,

including source-to-target mappings, data flow diagrams, and field

relationship documentation for the ascend CRM and integrated data

sources.

• Translate business and reporting requirements into clear, detailed mapping

specifications executable by technical teams and usable as the authoritative

reference for integration and migration projects.

• Maintain mapping documentation as a living resource, updating it to reflect

system changes, new integrations, and field-level modifications as they

occur.

• Partner with the Senior Data Strategy Analyst to ensure mapping

documentation reflects current governance standards and data definitions.

• Support Advancement Technology and ITS partners by providing mapping

specifications during integration builds, system upgrades, and migration

efforts. 25%

2. DATA INTEGRATION SUPPORT

• Serve as the Director's primary support resource for data integrations into

the ascend CRM from various data sources, assisting with monitoring, issue

identification, and resolution of integration errors.

• Write and develop user stories and use case scenarios to facilitate

integration design and end-to-end testing across Advancement systems.

• Partner with ITS and Advancement Technology to diagnose and resolve

data migration errors, field mapping failures, and integration flow issues.

• Maintain accurate and up-to-date project documentation throughout

integration and data migration lifecycles, including requirements, decisions,

issue logs, and testing outcomes.

• Work closely with business stakeholders to understand how integration

decisions impact end users across Advancement, translating those needs

into functional specifications for technical teams.

• Coordinate with the Senior Data Strategy Analyst on integration timelines

and technical constraints relevant to large-scale data cleansing and

migration preparation. 35%

3. SALESFORCE DATA MODEL SUPPORT

• Provide direct support to the Director on Salesforce data model design,

including object configuration, field schema documentation, and data

structure decisions for the ascend CRM. 25%

• Document current-state data model configuration and maintain schema documentation as the authoritative reference for the team. • Assist in evaluating the impact of system changes, new object builds, or field additions on existing data relationships, integrations, and reporting. • Translate business requirements into data model specifications for the Director's implementation decisions. • Conduct analysis to identify areas of data model optimization and present findings with supporting documentation to the Director.

4. CROSS-FUNCTIONAL COLLABORATION & OTHER DUTIES

• Build and maintain relationships across Advancement units to develop a

deep understanding of business priorities and how data structure decisions

affect end users.

• Partner with the Senior Data Strategy Analyst on projects where data

mapping, integration, or system structure intersects with governance policy

or data quality standards.

• Participate in requirements gathering sessions, business process reviews,

and system planning discussions as a data infrastructure subject matter

expert.

• Assist with organizing and documenting policies and procedures across

Advancement units as they relate to data flows and system usage.

• Assist with Advancement events and other duties as assigned by the

Founded in 2015 and backed by two decades of hands-on experience, our strong insight on the enterprise ecosystem and its dynamics helps to offer a complete end-to-end solution. We automate recruitment processes with intelligent solutions to save time and money. Synkriom leads the industry with experience authentication of candidates.