Data Engineer II
Apply NowCompany: ADM
Location: Decatur, IL 62521
Description:
Job Description
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 asQlik Replicate, Qlik Compose, Microsoft Azure Data Factory, Oracle Data Integrator, InformaticaPower Center, or Microsoft SQL Server Integration Services;
SQL or Python;
BI architecture, dimensional modeling, data warehousing best practices, and data integrationstandard 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 Agileenvironment.
100% telecommuting permitted.
To apply, mail resume to: Christina Hetzer, ADM; PO BOX 1470, Decatur, IL 62525 (reference: IL0160).
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.
#IncludingYou
Diversity, equity, inclusion and belonging are cornerstones of ADM's efforts to continue innovating, driving growth, and delivering outstanding performance. We are committed to attracting and retaining a diverse workforce and create welcoming, truly inclusive work environments - environments that enable every ADM colleague to feel comfortable on the job, make meaningful contributions to our success, and grow their career. We respect and value the unique backgrounds and experiences that each person can bring to ADM because we know that diversity of perspectives makes us better, together.
We are committed to ensuring all qualified applicants receive consideration for employment regardless of race, color, ethnicity, disability, religion, national origin, gender, gender identity, gender expression, marital status, sexual orientation, age, protected veteran status, or any other characteristic protected by law.
We welcome everyone to apply, especially those individuals who are underrepresented in our industry, as we strive to ensure our workforce represents the world that we help to feed: people of color, women, gender non-conforming, LGBTQIA+, veterans and persons with disabilities. For more information regarding our efforts to advance Diversity, Equity, Inclusion & Belonging, please visit our website here: Diversity, Equity and Inclusion ADM.
Benefits and Perks
Enriching the quality of life for the world begins by taking care of our colleagues. In addition to competitive pay, we support your diverse needs with a comprehensive total rewards package to enhance your well-being, including:
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:
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 asQlik Replicate, Qlik Compose, Microsoft Azure Data Factory, Oracle Data Integrator, InformaticaPower Center, or Microsoft SQL Server Integration Services;
SQL or Python;
BI architecture, dimensional modeling, data warehousing best practices, and data integrationstandard 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 Agileenvironment.
100% telecommuting permitted.
To apply, mail resume to: Christina Hetzer, ADM; PO BOX 1470, Decatur, IL 62525 (reference: IL0160).
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.
#IncludingYou
Diversity, equity, inclusion and belonging are cornerstones of ADM's efforts to continue innovating, driving growth, and delivering outstanding performance. We are committed to attracting and retaining a diverse workforce and create welcoming, truly inclusive work environments - environments that enable every ADM colleague to feel comfortable on the job, make meaningful contributions to our success, and grow their career. We respect and value the unique backgrounds and experiences that each person can bring to ADM because we know that diversity of perspectives makes us better, together.
We are committed to ensuring all qualified applicants receive consideration for employment regardless of race, color, ethnicity, disability, religion, national origin, gender, gender identity, gender expression, marital status, sexual orientation, age, protected veteran status, or any other characteristic protected by law.
We welcome everyone to apply, especially those individuals who are underrepresented in our industry, as we strive to ensure our workforce represents the world that we help to feed: people of color, women, gender non-conforming, LGBTQIA+, veterans and persons with disabilities. For more information regarding our efforts to advance Diversity, Equity, Inclusion & Belonging, please visit our website here: Diversity, Equity and Inclusion ADM.
Benefits and Perks
Enriching the quality of life for the world begins by taking care of our colleagues. In addition to competitive pay, we support your diverse needs with a comprehensive total rewards package to enhance your well-being, including:
- Physical wellness - medical/Rx, dental, vision and on-site wellness center access or gym reimbursement (as applicable).
- Financial wellness - 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.
- Mental and social wellness - Employee Assistance Program (EAP), Employee Resource Groups (ERGs) and Colleague Giving Programs (ADM Cares).
- Paid time off including paid holidays.
- Adoption assistance and paid maternity and parental leave.
- Tuition assistance.
- Company-sponsored training and development resources, such as LinkedIn Learning, language training and mentoring programs.
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: