Data Engineer II

Job Description

NOTICE OF FILING UNDER THE U.S. DEPARTMENT OF LABOR’S PERMANENT LABOR CERTIFICATION PROGRAM Data Engineer II (Multiple Positions), Archer Daniels Midland Company, Decatur, IL. Standardize data and reporting across businesses and teams to enable consistency and quality of key business data. Design and develop enterprise data warehouse platform that conforms to consistent methodologies, standards, and industry best practices. Design, develop, test and document data integrations and assist with deployment, validation, and hypercare. Maintain and support ETL/ELT integrations. Design overall logical and physical data warehouse, data mart models, and architectures to support business requirements. Develop and maintain SQL, PL/SQL, Python code as needed. Assist with review to confirm technical feasibility of integration development objects based on integration principles and best practices. Navigate a wide array of source data systems. Develop prototypes and proof of concepts for required solutions. Implement information security standards in enterprise data warehouse. Contribute to development of the overall solution approach. 40 hrs/week, Mon-Fri, 8:30 a.m. - 5:30 p.m. Salary: $94,968.00/yr - $104,968/yr. Standard benefits apply, see www.adm.com/en-us/culture-and-careers/ for more information. MINIMUM REQUIREMENTS: Bachelor’s degree or foreign equivalent degree in Information Technology, Computer Science, Computer Engineering, Statistics, Programming, Business Analytics, Mathematical or a related field, and two (2) years of related work experience. Must have two (2) years of experience with/in:
•Using data integration, ETL, ELT, data replication, and data warehouse automation tools such as Qlik Replicate, QlikCompose, Microsoft Azure Data Factory, Oracle Data Integrator, Informatica Power Center, or Microsoft SQL ServerIntegration Services;
•SQL or Python;
•BI architecture, dimensional modeling, data warehousing best practices, and data integration standard methodologies;
•Using iterative development methodologies like Agile, KanBan, or DevOps; and
•Big Data technologies such as Spark, Kafka, or DataBricks.
Must have one (1) year of experience with/in:
•Sourcing data from ERP data sources, like SAP, JD Edwards, PeopleSoft, or Oracle EBS; and
•Data Virtualization technologies and tools.
Must have knowledge or experience with/in:
•Enterprise BI and Analytics implementing data warehouse and data marts in an Agile environment.
100% telecommuting permitted.
To apply, mail resume to: Christina Hetzer, ADM; PO BOX 1470, Decatur, IL 62525 (reference: IL0160).
This notice is being provided as a result of the filing of a permanent alien labor certification application for this job opportunity, in compliance with 20 CFR 656.10(d). Any person may provide documentary evidence bearing on the application to the Certifying Officer of the U.S. Department of Labor holding jurisdiction over the location of the proposed employment. Contact information for these offices can be found on the internet at http://www.foreignlaborcert.doleta.gov/contacts.cfm#npc or by contacting:
U.S. Department of Labor
Employment and Training Administration
Office of Foreign Labor Certification
200 Constitution Avenue, NW, Room N-5311
Washington, DC 20210

City

Decatur

State

IL - Illinois

Location Country

United States

About ADM

At ADM, we unlock the power of nature to provide access to nutrition worldwide. With industry-advancing innovations, a complete portfolio of ingredients and solutions to meet any taste, and a commitment to sustainability, we give customers an edge in solving the nutritional challenges of today and tomorrow. We’re a global leader in human and animal nutrition and the world’s premier agricultural origination and processing company. Our breadth, depth, insights, facilities and logistical expertise give us unparalleled capabilities to meet needs for food, beverages, health and wellness, and more. From the seed of the idea to the outcome of the solution, we enrich the quality of life the world over. Learn more at www.adm.com.

Base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. Hourly and salaried non-exempt employees will also be paid overtime pay when working qualifying overtime hours.

If hired, employees will be in an “at-will position” and the Company reserves the right to modify base pay (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, Company or individual department/team performance, and market factors.

The pay range for this position is expected to be between:

$94,968.00/yr - $104,968/yr.