Search

Business Analyst (SQL, Salesforce, Snowflake)

PublishedPublished: 6/14/2022
Technology

Job Description

Job Description

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

\nCompany Description

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.

Company Description

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.

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...