Sr. Data Analyst (ERP Migration)

  • Chicago, IL
  • Posted 2 days ago | Updated 1 day ago

Overview

Hybrid
$85 - $100
Contract - W2
Contract - Independent
Contract - 6 Month(s)
No Travel Required

Skills

ADO
Data Cleansing
Data Migration
Data Profiling
Data Quality
Data Validation
IBM InfoSphere
Informatica
SQL
Microsoft Dynamics
Talend
IBM DB2
Supply Chain Management
Manufacturing
Migration
Data Analysis

Job Details

Resource 1 is in need of a Sr. Data Analyst (ERP Migration) for a long-term contract in downtown Chicago. Individual must be local to Illinois and able to work onsite 2-3 days per week (Tues-Thurs) in downtown Chicago. Our client is undergoing a multi-year (estimated 3-5) financial transformation initiative, which includes the implementation of Microsoft Dynamics to replace hundreds of legacy applications. The Data Analyst will play a vital role in ensuring the quality, accuracy, and integrity of key data elements during the migration. This is an exciting opportunity for someone experienced in data migrations from data discovery, data cleansing, ETL, and post migration validations. This person needs to have a strong focus on complex data/ ecosystems. Experience working on a large ERP implementation/ migration is strongly preferred.

Responsibilities:

  • Analyze and document current-state legacy/ source systems and data architecture to help inform future state.
  • Create and maintain detailed source-to-target mappings to guide the migration process and ensure correct data transformation.
  • Work closely with cross-functional teams to understand data requirements and ensure accurate mapping and transformation across systems.
  • Write complex SQL queries to extract and validate data across large datasets.
  • Use Informatica CDQ to cleanse and profile data, ensuring data is accurate, consistent, and complete.
  • Conduct data validation and reconciliation before, during, and after migration to ensure consistency across systems.
  • Collaborate with the Data Analysts, Business Analysts, ERP team, and reporting and legacy system SMEs to ensure data readiness for the new platform.
  • Provide ongoing support to consulting partner performing migrations before, during and after the migration, addressing any data-related requests or issues that arise.

Requirements:

  • 8+ years of experience as a Data Analyst.
  • Proven experience in data migration projects, specifically with ERP systems, preferably Dynamics 365.
  • Experience creating source-to-target mappings.
  • Proficiency in SQL, with experience in data extraction, transformation, and validation.
  • Hands-on experience in data cleansing and data profiling.
  • Experience working with Informatica CDQ or other similar data quality tools (such as IBM InfoSphere, Talend, etc.).
  • Proven experience working with complex data sets and ecosystems.
  • Ability to work independently, driven to take on tasks, supporting team members and as part of a team in a fast-paced environment.

Preferred Qualifications:

  • Experience with Informatica CDQ.
  • Experience in rail, manufacturing, or supply chain industries.
  • Familiarity with Microsoft Azure DevOps (ADO) for tracking and documentation.
  • Experience mapping data from various databases, including IBM DB2.

 

Medical insurance and a 401(k) plan is offered to all eligible W2 employees.

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.