Jobs and Careers

Senior CRM & Data Migration Specialist (CEMI)

Weill Cornell Medicine

New York City, United StatesRemotefull_timeVerifiedPosted 20 Aug 2026

About the role

Title: Senior CRM & Data Migration Specialist (CEMI)

Location: Midtown

Org Unit: Advancement Services Information Systems

Work Days:

Weekly Hours: 35.00

Exemption Status: Exempt

Salary Range: $156,100.00 - $174,100.00

*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices

Position Summary

The Senior CRM & Data Migration Specialist serves a dual-purpose role within the Office of External Affairs at Weill Cornell Medicine, providing critical operational support for the Blackbaud CRM environment while playing a key role in the university-wide transition to Salesforce/Kindsight Ascend. This hybrid position combines hands-on system administration, reporting, and user support with strategic contributions to a complex enterprise CRM migration.

Reporting to the Senior Database Administrator, this role will partner closely with internal stakeholders, technical teams, and external vendors to ensure continuity of current operations and successful implementation of future-state systems. The position is instrumental in maintaining data integrity, optimizing workflows, and enabling advancement, fundraising, and engagement functions through technology.

This role serves as a key technical resource across Blackbaud CRM, Salesforce, and Kindsight Ascend, supporting CRM operations, enterprise integrations, data migrations, reporting strategy, and project delivery through active participation in project epics, Azure DevOps workstreams, and cross-functional implementation initiatives.

Job Responsibilities

Develop, maintain, and deliver reports, queries, and dashboards to support fundraising, events, and communications. Create automation scripts, templates, and workflows to improve data processes and operational efficiency.
Monitor and manage CRM-related support requests via the IT ticketing system, ensuring timely resolution. Perform data validation, cleansing, and ongoing data quality management activities.
Support pre-migration planning, including data readiness and system assessments. Document and define current-state workflows and business processes.
Inventory and document current-state Blackbaud CRM data structures, reports, queries, export definitions, integrations, customizations, and business-critical data dependencies.
Identify, document, and assess existing automation processes, including SQL Agent jobs, stored procedures, SSRS reports, scheduled exports, workflows, templates, and externally maintained scripts.
Evaluate current automations and data processes for migration impact, identifying items to retain, replace, redesign, or retire as part of the transition to Kindsight Ascend.
Analyze code tables, reference data, classifications, and controlled values to support standardized future-state configuration and conversion.
Participate in Salesforce and Kindsight Ascend implementation activities, including solution design reviews, data migration planning, reporting requirements, integration discussions, and business process alignment.
Gather, analyze, and document business and functional requirements for CRM migration. Map legacy data structures, fields, and business rules from Blackbaud CRM to Kindsight Ascend.
Conduct gap analyses to identify differences in functionality and workflows. Translate requirements into functional specifications, user stories, and acceptance criteria.
Support data migration activities including transformation logic, validation, reconciliation, and testing.
Collaborate with vendors, Salesforce administrators, developers, and internal technology teams on CRM configuration, solution design, implementation strategy, and deployment activities.
Participate in integration design, development, testing, and implementation across Salesforce, Epic EMR, Salesforce Marketing Cloud, Data 360/data warehouse, finance systems, and other enterprise applications.
Develop and execute user acceptance testing (UAT) plans and coordinate stakeholder participation. Document new workflows, data standards, and operating procedures for the future-state system.
Create and deliver training materials and end-user training sessions. Monitor project risks, dependencies, and change requests; support mitigation planning. Facilitate cross-functional meetings and stakeholder working sessions.
Define and implement governance structures including data standards and decision-making processes. Support role-based access design and security configuration aligned with compliance and least-privilege principles.
Assist in post-implementation optimization through continuous feedback and system enhancements.
Perform data migration reconciliation activities, incl