Resource 1, Inc.

Compensation

Full Description

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.