Data Modeler
Decatur, IL - Illinois, United States
Job Description
NOTICE OF FILING UNDER THE U.S. DEPARTMENT OF LABOR’S
PERMANENT LABOR CERTIFICATION PROGRAM
Data Modeler (Multiple Positions), Archer Daniels Midland Company, Decatur, IL.
Develop logical and physical data models across all enterprise data platforms. Govern the expansion of existing data architecture and the optimization of data query performance via best practices. Implement business and IT data requirements through new data strategies and designs across all data platforms. Implement data strategies, build data flows, and develop logical/physical data models. Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models. Address project requirements and articulate issues to reduce project delivery risks.
40 hrs/week, Mon-Fri, 8:30 a.m. - 5:30 p.m. $144,810.00 - $154,810/yr. Standard company benefits
MINIMUM REQUIREMENTS:
Bachelor’s degree or foreign equivalent degree in Computer Science, Engineering, Engineering Management, Data Science, or a related field, and five (5) years of post-bachelor’s, progressive, related work experience. In the alternative, the employer will accept a Master’s degree or foreign equivalent degree in Computer Science, Engineering, Engineering Management, Data Science, or a related field, and three (3) years of related work experience.
Must have three (3) years of experience with/in:
- Relational, dimensional, or analytic experience;
- Using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols;
- Data warehouse, Data Lake, and enterprise big data platforms in multi-data-center contexts;
- Metadata management, data modeling, and related tools such as Erwin or ER Studio;
- Implementing data strategies, creating logical and physical data models using best practices to ensure high data quality and reduced redundancy;
- Performing reverse engineering of physical data models from databases and SQL scripts; and
- Evaluating data models and physical databases for variances and discrepancies.
Employer will accept any suitable combination of education, training, or experience.
Up to 10% domestic travel required.
100% telecommuting permitted.
To apply, mail resume to: Christina Hetzer, ADM; PO BOX 1470, Decatur, IL 62525 (reference: IL0158).
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:
$144,810.00 - $154,810/yr
ApplyJob Profile
100% telecommuting Standard company benefits Telecommuting
Tasks- Address project requirements
- Define data standards
- Develop data models
- Govern data architecture
- Implement data strategies
Big Data Data Architecture Data ingestion Data Lake Data Modeling Data query optimization Data Warehouse ER Studio Erwin ETL Metadata Management NoSQL RDBMS Reverse Engineering SQL
Experience5 years
EducationBachelor's degree Engineering Foreign equivalent degree Master's degree
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9