Enterprise Data Integration & Migration Senior Associate

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. Youll find an environment that inspires and empowers you to thrive both personally and professionally. Theres no one like you and thats why theres nowhere like RSM.

You are:

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.

The team:

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

Wed expect you to have:

-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
- Bachelors degree in Computer Science Management Information Systems Business Analytics or related field

Wed 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

At RSM we offer a competitive benefits and compensation package for all our offer flexibility in your schedule empowering you to balance lifes demands while also maintaining your ability to serve more about our total rewards at 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; 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; US Military/Veteran status; 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/ 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 or send us an email at .

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.

RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California please click here for additional information.

At RSM an employees pay at any point in their career is intended to reflect their experiences performance and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including but not limited to education skills work experience certifications location etc. As such pay for the successful candidate(s) could fall anywhere within the stated range.