Enterprise Data Integration & Migration Senior Associate

You will work within the Enterprise Data Integration & Migration (EDIM) practice - a national team delivering scalable, repeatable data migration and integration solutions across ERP, CRM, and other enterprise platforms. The team operates across the full project lifecycle: from pre-sales and discovery through design, build, testing, and go-live support.

The team is committed to building reusable delivery frameworks, expanding capabilities in business applications like D365 F&SC, Oracle NetSuite, Salesforce and other applications, and developing our people through certifications, innovation programs, and a culture of continuous learning. We serve clients across the United States and collaborate with global delivery partners.

Work you'll do:

Data Migration & Integration Delivery

• Support end-to-end data migration and integration workstreams as a hands-on technical contributor
• Execute ETL/ELT processes using tools such as Boomi, Azure Data Factory, SSIS, Informatica, or others
• Perform data profiling, metadata mapping, and source-to-target mapping
• Develop and execute data cleansing, transformation, and load scripts in SQL/Python
• Support inbound data loads into target systems including Salesforce, NetSuite, and Microsoft Dynamics
• Participate in migration rehearsals, cutover planning, and go-live support

Technical Solution Development

• Design and develop data pipelines and integration patterns aligned to project requirements
• Work with data in relational (3NF, Star/Snowflake schema) and non-relational formats
• Develop and maintain technical documentation: data mapping specifications, transformation rules, and data dictionaries
• Support architecture and solution design reviews under the guidance of senior team members

Quality Assurance & Testing

• Build and execute test plans including unit, integration, and user acceptance testing (UAT) phases
• Triage and resolve data defects and bugs throughout the project lifecycle
• Validate data integrity post-load, reconciling record counts and exception reports

Client Engagement & Collaboration

• Participate in client discovery sessions, interviews, and workshops
• Communicate findings, risks, and project status clearly to client and internal stakeholders
• Support the drafting of Statements of Work (SOWs) and project estimates under senior direction

Practice & Team Development

• Contribute to internal tools, templates, accelerators, and delivery playbooks
• Pursue certifications in relevant technologies and methodologies
• Support the onboarding and mentoring of associate-level team members
• Travel to client sites as needed

An experienced data integration and migration professional with hands-on experience executing complex data projects within a team setting. You have held roles such as Data Engineer, ETL Developer, Data Migration Specialist, or Integration Specialist, and you thrive on translating raw data challenges into clean, structured solutions.

You have contributed to mid-to-large-scale data migration or integration engagements - from discovery and data profiling through extraction, transformation, load (ETL), and post-migration validation. You are proficient in SQL and have working knowledge of Python or an equivalent scripting language, with hands-on experience using at least one major ETL/ELT platform.

People around you consider you a reliable, technically strong contributor who is growing toward subject matter expert. You are an excellent communicator, comfortable facilitating client working sessions, and looking to grow within a collaborative, high-performing national team., Minimum 3 years of experience in data migration and/or integration roles

• Hands-on experience with Azure Data Factory, Boomi, Informatica, Alteryx or another ETL/ELT tool
• Strong understanding of ERP, CRM, or other business application data structures
• Experience in consulting or client-facing environments
• Bachelor's degree in Computer Science, Management Information Systems, Business Analytics or related field

We'd like you to have:

• Familiarity with cloud platforms: Azure (ADF, Azure SQL, Synapse), AWS, or GCP
• Familiarity with BI tools such as Power BI or Tableau
• Familiarity with Agile/Scrum delivery methodologies
• Relevant certifications: Microsoft, Snowflake, or equivalent
• Experience supporting pre-sales activities, proposals, or SOW development, 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.

At RSM, we offer a competitive benefits and compensation package for all our people. 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.

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, 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.