Job 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:
- D ata 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.
Job Tags
Long term contract, Contract work, 2 days per week,