Data Readiness Analyst II

Archer Daniels Midland • Erlanger, KY

1d • Hybrid

About The Position

Partner with Solution Delivery and Data Readiness teams to ensure data design and implementation align with business requirements. Oversee functional data migration activities to SAP S/4HANA, collaborating with Data Developers who utilize SAP Business Objects Data Services (BODS) to design and execute extraction, transformation, and loading (ETL) workflows. Review and validate BODS jobs developed by Data Developers for data cleansing, enrichment, and validation. Create and maintain validation scripts to be used during mock conversion cycles. Monitor the progress of data cleansing activities, using SAP Information Steward to track data quality metrics, identify gaps, and ensure cleansing aligns with project timelines. Use SAP HANA for data modeling, staging, and validation adhering to the Solution Delivery team’s target system specifications. Coordinate pre- and post-load data validation, leveraging validation scripts, securing approvals, documenting results and defects for SAP S/4HANA go-live. Develop and document functional data migration plan, validation scripts, and data construction plans. Actively engage Business data validators/approvers, systems analysts, data readiness functional analysts, and related work streams. Validate and monitor data quality, ensuring compliance with business requirements and data governance standards.

Requirements

• Bachelor’s degree or foreign equivalent degree in Information Technology, Computer Science, Business or a related field, and two (2) years of related work experience.
• Two (2) years of experience with/in: SAP ECC/S/4HANA for data modeling, staging, validation, and quality monitoring in migration and data quality projects.
• Two (2) years of experience with/in: Data Migration processes, collaborating with Data Developers and the Solution Delivery team to define ETL requirements for business-driven data migration.
• Two (2) years of experience with/in: Creating and maintaining validation scripts for data migration, particularly for mock conversion cycles in SAP S/4HANA projects.
• Two (2) years of experience with/in: Collaborating with Data Cleansers and business stakeholders to ensure constructed data is completed and approved for mock conversion cycles.
• Two (2) years of experience with/in: SAP Information Steward or other Data Quality tools for defining data quality rules, monitoring data quality, and overseeing data cleansing activities to support SAP S/4HANA implementations.
• One (1) year of experience with/in: SAP.

Responsibilities

• Partner with Solution Delivery and Data Readiness teams to ensure data design and implementation align with business requirements.
• Oversee functional data migration activities to SAP S/4HANA, collaborating with Data Developers who utilize SAP Business Objects Data Services (BODS) to design and execute extraction, transformation, and loading (ETL) workflows.
• Review and validate BODS jobs developed by Data Developers for data cleansing, enrichment, and validation.
• Create and maintain validation scripts to be used during mock conversion cycles.
• Monitor the progress of data cleansing activities, using SAP Information Steward to track data quality metrics, identify gaps, and ensure cleansing aligns with project timelines.
• Use SAP HANA for data modeling, staging, and validation adhering to the Solution Delivery team’s target system specifications.
• Coordinate pre- and post-load data validation, leveraging validation scripts, securing approvals, documenting results and defects for SAP S/4HANA go-live.
• Develop and document functional data migration plan, validation scripts, and data construction plans.
• Actively engage Business data validators/approvers, systems analysts, data readiness functional analysts, and related work streams.
• Validate and monitor data quality, ensuring compliance with business requirements and data governance standards.

Benefits

• medical/Rx
• dental
• vision
• on-site wellness center access or gym reimbursement
• flexible spending accounts
• health savings account
• 401(k) with matching contributions and cash balance plan
• discounted employee stock purchasing program
• life insurance
• disability
• workers’ compensation
• legal assistance
• identity theft protection
• Employee Assistance Program (EAP)
• Employee Resource Groups (ERGs)
• Colleague Giving Programs (ADM Cares)
• Paid time off
• paid holidays
• Adoption assistance
• paid maternity and parental leave
• Tuition assistance
• Company-sponsored training and development resources
• LinkedIn Learning
• language training
• mentoring programs

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level