Resource 1, Inc. ยท 3 days ago
Data Analyst (D365 Migration) - Contract - Hybrid - Chicago, IL.
Resource 1, Inc. is seeking a Senior Data Analyst for a long-term contract in downtown Chicago. The role involves ensuring the quality, accuracy, and integrity of key data elements during a multi-year financial transformation initiative, specifically focusing on the implementation of Microsoft Dynamics and data migration processes.
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
Qualification
Required
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
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
Company
Resource 1, Inc.
Resource 1 is a privately held national consulting firm established in 1982 with Corporate Headquarters and Technology Center in Oak Brook, Illinois.