Sr. Data Quality Analyst (Informatica CDQ) - Contract - Hybrid

Resource 1 is in need of a Sr. Data Quality Analyst for a long-term contract in downtown Chicago. Individual must be local to Illinois to 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 over 200 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. This is a person who needs to have a strong focus on complex data/ ecosystems. Experience working on a large ERP implementation/ migration is required, with D365 implementation/ migration experience 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 business, 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 working on D365 data migration projects.
• 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.