Rsm
Enterprise Data Integration & Migration Senior Associate
Philadelphia · Senior
Sponsorship not specified$89k-$168kDetected 1 day ago
PythonData StructuresSQLSnowflakeAWSGCPAzureCloud PlatformsData EngineeringData VisualizationAgileSalesforceCRMERPCollaborationMentoringNetSuite
About the role
- 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.
Requirements
- Our exceptional people are the key to our unrivaled, culture and talent experience and our ability to be compelling to our clients.
- 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.
- You are an excellent communicator, comfortable facilitating client working sessions, and looking to grow within a collaborative, high-performing national team.
- 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
Skills
- 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
- Work with data in relational (3NF, Star/Snowflake schema) and non-relational formats
- Triage and resolve data defects and bugs throughout the project lifecycle
- Participate in client discovery sessions, interviews, and workshops
- Communicate findings, risks, and project status clearly to client and internal stakeholders
- Contribute to internal tools, templates, accelerators, and delivery playbooks
- Pursue certifications in relevant technologies and methodologies
- Travel to client sites as needed
Compensation
- Range: $88,900 - $168,300
Benefits
- Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.
Company info
- 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
- 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
- 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
- Validate data integrity post-load, reconciling record counts and exception reports
- Client Engagement & Collaboration
- Support the drafting of Statements of Work (SOWs) and project estimates under senior direction
- Practice & Team Development
- Support the onboarding and mentoring of associate-level team members
Visa & Work Authorization
- RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders).
This listing is sourced directly from Rsm's careers page and normalized into a canonical job model.