DirectJobHub
Jobs · Information Technology · Pennsylvania

Enterprise Data Integration & Migration Senior Associate

RSM US LLP · Philadelphia, PA · 1 mo ago
Information Technology$89k–$168k/yrFull-time

About the role

We are seeking an experienced data integration and migration professional to join our dynamic team. You will be part of a national team delivering scalable, repeatable data migration and integration solutions across ERP, CRM, and other enterprise platforms.

Responsibilities

  • Data Migration & Integration Delivery Support: End-to-end data migration and integration workstreams as a hands-on technical contributor.
  • ETL/ELT Processes: Execute ETL/ELT processes using tools such as Boomi, Azure Data Factory, SSIS, Informatica, or others.
  • Data Profiling, Metadata Mapping, Source-to-Target Mapping: Perform data profiling, metadata mapping, and source-to-target mapping.
  • Data Cleansing, Transformation, Load Scripts: Develop and execute data cleansing, transformation, and load scripts in SQL/Python.
  • Inbound Data Loads: Support inbound data loads into target systems including Salesforce, NetSuite, and Microsoft Dynamics.
  • Migration Rehearsals, Cutover Planning, Go-Live Support: 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.
  • Data Formats: Work with data in relational (3NF, Star/Snowflake schema) and non-relational formats.
  • Documentation: Develop and maintain technical documentation: data mapping specifications, transformation rules, and data dictionaries.
  • Quality Assurance & Testing: Build and execute test plans including unit, integration, and user acceptance testing (UAT) phases; triage and resolve data defects and bugs; validate data integrity post-load.
  • 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.
  • 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: Travel to client sites as needed.

Requirements

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

Qualifications

  • Hands-on experience with Python or an equivalent scripting language.
  • Proficient in SQL.
  • Reliable, technically strong contributor who is growing toward subject matter expert.
  • Excellent communicator, comfortable facilitating client working sessions.

Skills

  • SQL
  • Python
  • ETL/ELT Tools: Boomi, Azure Data Factory, SSIS, Informatica, Alteryx
  • Cloud Platforms: Azure (ADF, Azure SQL, Synapse), AWS, GCP
  • BI Tools: Power BI, Tableau
  • Agile/Scrum Delivery Methodologies
  • Relevant Certifications: Microsoft, Snowflake, etc.

Benefits

At RSM, we offer a competitive benefits and compensation package for all our people. We provide flexibility in your schedule, empowering you to balance life's demands while maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

Pay

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. Compensation Range: $88,900 - $168,300.

Schedule

Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.

Similar jobs