We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You'll find an environment that inspires and empowers you to thrive both personally and professionally. There's no one like you and that's why there's nowhere like RSM.

Position Overview:

As a Data Migration Specialist in the Nonprofit Relationship Management (NRM) Solutions practice, you will play a crucial role in ensuring the smooth and accurate transfer of data from legacy systems to modern platforms, including the iMIS Engagement Management System, Salesforce Nimble AMS, and Salesforce Nonprofit Cloud. You will collaborate with cross-functional teams to plan, execute, and validate data migration projects, ensuring data integrity and minimizing downtime. If you are detail-oriented, possess strong analytical skills, and have a passion for data management, this role is perfect for you.

Key Responsibilities:

Data Analysis: Assess and analyze existing data structures, quality, and compatibility to determine migration requirements and potential risks. Data Mapping: Develop data mapping strategies and document data transformation rules for migrating data between systems. This includes leading data mapping meetings to ensure a final map is approved before proceeding with the next migration phases. Migration Planning: Collaborate with project stakeholders to create comprehensive data migration plans, including timelines, resource allocation, and risk mitigation strategies. Data Extraction and Transformation: Execute data extraction, transformation, and loading (ETL) processes to migrate data from source systems to target systems. Data Validation: Perform thorough data validation and quality assurance checks to ensure data accuracy and completeness post-migration. Troubleshooting: Identify and resolve data migration issues and discrepancies and escalate to appropriate teams when necessary. Documentation: Maintain detailed documentation of data migration processes, procedures, and outcomes. Performance Optimization: Optimize data migration processes for efficiency and minimal downtime of client data freeze and migration window, specifically at go-live. Collaboration: Work closely with IT teams, data analysts, and business stakeholders to ensure alignment with project goals and objectives.

Qualifications:

• Bachelor's degree in computer science, information technology, or a related field.
• Proven experience as a Data Migration Specialist or similar role in data management and migration projects; relevant certifications are advantageous.
• Proficiency in data extraction, transformation, and loading (ETL) tools and methodologies.
• Strong knowledge of databases, SQL, and data modeling.
• Excellent analytical and problem-solving skills.
• Attention to detail and a high level of accuracy.
• Effective communication skills, both written and verbal.
• Ability to work collaboratively in cross-functional teams and meet deadlines.
• Familiarity with data privacy and security best practices.
• Beneficial to have previous association or nonprofit industry experience.

At RSM, we offer a competitive benefits and compensation package for all our people. We support and inspire you to prioritize your wellbeing by delivering personalized, holistic programming for your physical, emotional, financial and community wellbeing. RSM has a generous time off policy with at least 14 paid holidays, wellbeing days and associate and above access to self-managed time off. We offer flexibility in your schedule, empowering you to balance life's demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

RSM is proud to be an Affirmative Action and Equal Employment Opportunity employer. We are proud to provide our employees with tools to assist them in being successful in achieving both personal and professional goals. We welcome and support all our employees to thrive in an environment free of discrimination and harassment. As an Affirmative Action and Equal Opportunity Employer all applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law.

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at careers@rsmus.com.

RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.