79873BR

　　Job Title:

　　Data Engineer

　　Department/Function:

　　Information Technology

　　Job Description:

　　Data Engineer – Data Analyst

　　Summary:

　　Data Engineer/Analyst will work on designing, building, and implementing a data foundation to support a strategic analytics project with JMP that drives strategic growth for ADM. This involves liaising with functional teams that build or acquire the underlying data, application owners to understand raw or source data structures, and end users to accurately design strategic data marts. Finally, designing and building data pipelines, ETL/ELT integrations, constructing and modifying data marts, preparing (cleaning, transforming) data, and collaborating with extended team members to design impactful business solutions. Data Engineer needs to have specifically expert technical knowledge of JMP and platforms and software technology (ETL/ELT, SQL, PySpark,Power BI, Python), deep expertise in data management techniques, ability to drive effective support of data analysis and model management, and experience with IT project management practices

　　The term IoT, or Internet of Things, refers to the collective network of connected devices and the technology that facilitates communication between devices and the cloud, as well as between the devices themselves.

　　Responsibilities:

　　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 using technical documentation

　　Participate in designing overall logical & physical data warehouse and data mart models and architectures to support business requirements

　　Develop and maintain SQL, PL/SQL, PySpark, Python code as needed

　　Assist with review to confirm technical feasibility of integration development objects based on integration principles and best practices

　　Understand and navigate a wide array of source data systems (enterprise data warehouses, relational databases, IT systems, in house and COTS applications, documents, APIs, unstructured data, big data, NoSQL databases, etc.)

　　Analyze data and assist with developing insights (e.g., via data visualization tools like Power BI / SAC) to enable business decision making

　　Propose new methodologies to demonstrate data to improve existing methodologies

　　Developing prototypes and proof of concepts for required solutions

　　Implementing information security standards in enterprise data warehouse

　　Prepare and present ideas and recommendations to colleagues and management

　　Document solutions through high/low level design documentation

　　Learn new groundbreaking data engineering and analytic tools as needed

　　Contribute to development of the overall solution approach

　　Recommend solutions to address gaps

　　Assist with development estimation

　　Supervise and review activities of consultants

　　Requirements:

　　4-year Bachelor’s degree or equivalent in IT, Computer Science, Science, Engineering, Statistics, Programming, Business Analytics, Mathematical or related field

　　At least 6 years of enterprise BI and Analytics technical experience implementing data warehouse and data marts in an Agile environment

　　5 years of recent experience using data integration, ETL, ELT, data replication, and data warehouse automation tools such as Qlik Replicate, Qlik Compose, Microsoft Azure Data Factory, Databricks or Microsoft SQL Server Integration Services

　　5 years of recent experience in data processing using SQL, PySpark, Python

　　Experience sourcing data from ERP data sources, e.g., SAP, JD Edwards, PeopleSoft, Oracle EBS in support of analytic product development and business transformation projects

　　Experience with MPP systems, Azure Synapse preferred

　　Experience with databases like Microsoft SQL Server, Oracle

　　Experience delivering Cloud based Data Solutions in Azure

　　Experience with Data Virtualization technologies and tools, Denodo preferred

　　Working knowledge of BI architecture, dimensional modeling, data warehousing best practices, and data integration standard methodologies

　　Experience in delivering solutions using iterative development methodologies like Agile, KanBan, DevOps

　　Experience working with Big Data technologies such as Spark, Kafka, DataBricks, Hive, or equivalent

　　Experience with visualization technologies and services including Microsoft Power BI, SAP Analytics Cloud, Oracle Business Intelligence is a plus

　　Working knowledge of Python ML libraries like Scikit-learn/PyTorch or Azure ML

　　Experience working in DevOps / CICD framework is a plus

　　Experience with metadata management discipline and practices using Information Steward is a plus

　　High accountability with a demonstrated ability to deliver

　　Strong communication skills including design documentation

　　Strong collaboration skills working with architecture, design and development teams REQ: 79873BR "AJCIND" #Latinasintech #wit #womenintech #womenimpacttechnology

　　City:

　　Erlanger

　　State:

　　KY - Kentucky

　　Ref ID:

　　#LI-SU1

　　About ADM::

　　ADM unlocks the power of nature to enrich the quality of life. We're a premier global human and animal nutrition company, delivering solutions today with an eye to the future. We're blazing new trails in health and well-being as our scientists develop groundbreaking products to support healthier living. We're a cutting-edge innovator leading the way to a new future of plant-based consumer and industrial solutions to replace petroleum-based products. We're an unmatched agricultural supply chain manager and processor, providing food security by connecting local needs with global capabilities. And we're a leader in sustainability, scaling across entire value chains to help decarbonize our industry and safeguard our planet. From the seed of the idea to the outcome of the solution, we give customers an edge in solving the nutritional and sustainability challenges of today and tomorrow. 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 offer a comprehensive total rewards package to support your well-being, including:

　　Physical wellness – medical/Rx, dental, vision and life insurance; on-site wellness center access or gym reimbursement (as applicable)

　　Financial wellness – flexible spending accounts, 401(k) with matching contributions and cash balance plan, discounted employee stock purchasing program, disability, workers’ compensation, legal assistance, identity theft protection

　　Mental and social wellness – Employee Assistance Program (EAP) and Employee Resource Groups (ERGs)

　　Additional benefits include:

　　Paid vacation time, plus 11 paid holidays and one paid personal day

　　Adoption assistance and paid parental leave

　　Tuition assistance

　　Company-sponsored training and development resources, such as LinkedIn Learning, language training and mentoring programs