Data Analyst (D365 Migration) - Contract - Hybrid - Chicago, IL.

Resource 1 is in need of a Sr. Data Analyst for a long-term contract in downtown Chicago. Individual must be able to attend an onsite interview and work onsite 2 days per week (Tues/Wed or 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 multiple on-prem 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. Experience working on a large ERP implementation/ migration is required.

Responsibilities:

• Analyze/ 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 CDQ tool to cleanse/ 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:

• 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 data quality tools (such as CDQ, InfoSphere, Talend).
• Proven experience working with complex data sets and ecosystems.

Preferred Qualifications:

• Experience working on D365 data migration projects.
• Experience with Informatica CDQ is a plus.
• Experience in manufacturing, or supply chain industries.
• Familiarity with Microsoft Azure DevOps (ADO) for tracking and documentation.