Archer Daniels Midland

83434BR

Job Title:

DATA MODELER

Department/Function:

Information Technology

Job Description:

Data Modeler

Company Introduction

ADM is seeking a Data Modeler who can partner with Solution Leads and Global Process Owners to understand comprehensive business processes, strategy, standards and source systems in order to develop their data and analytical solutions. Communicate Data and Analytics (DnA) capabilities with DNA Leadership, Portfolio Office and Transformation Office to ensure requests are captured and treated in accordance with the IT operating model, demand management processes and delivered in alignment to DNA’s data and application strategies

Job Description

The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

The successful candidate will:

1. Be responsible for the development of logical and physical data models across all enterprise data platforms.

2. Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.

3. Demonstrated success in an Agile environment.

4. The candidate must be able to work independently and collaboratively.

Responsibilities

• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL). Work with solution teams and Data Architects to implement data strategies, build data flows, and develop logical/physical data models

• Work with Data Architects to define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.

• Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.

• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

Skills

• Bachelor degree in computer/data science technical or related experience.

• 5+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).

• Experience with data warehouse, Data Lake and enterprise big data platforms in multi-data-center contexts required.

• Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.

• Preferred experience working with services in Azure (Azure Data Factory, Azure Data Lake Storage & Synapse). Experience working on Azure Databricks is a plus.

• Experience in team management, communication, and presentation.

• Understand agile delivery methodology and experience working in scrum environment.

• Understand and translate business needs into data vault and dimensional data models supporting long-term solutions.

• Work with the Application Development team to implement data strategies, create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

• Optimize and update logical and physical data models to support new and existing projects.

• Maintain logical and physical data models along with corresponding metadata.

• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.

• Recommend opportunities for reuse of data models in new environments.

• Perform reverse engineering of physical data models from databases and SQL scripts.

• Evaluate data models and physical databases for variances and discrepancies.

• Validate business data objects for accuracy and completeness.

• Analyze data-related system integration challenges and propose appropriate solutions.

• Develop data models according to company standards.

• Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.

• Review modifications to existing data models to improve efficiency and performance.

• Examine new application design and recommend corrections if required.

Req/Job ID:

83434BR

City:

Erlanger

State:

KY - Kentucky

Ref ID:

#LI-SU1

:

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.

:

#LI-Onsite

\t:

#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. (https://www.adm.com/en-us/culture-and-careers/diversity-equity-inclusion/)

:

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).

Additional benefits include:

• 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.

*Benefits may vary for bargained locations, confirm benefit eligibility with your recruiter.