data engineer - Erlanger, United States - ADM

Description

Job Description Data Engineer Summary:

The Data Engineer role will work on designing, building, and implementing data solutions to support strategic analytics projects & initiatives that drive strategic growth for ADM.

This involves liaising with functional teams that generate or acquire data, with application owners to understand raw or source data structures, and end users to accurately design and build strategically significant Data centric projects.

Responsibilities:
Standardize data and reporting across businesses and teams to enhance the consistency and quality of dataDesign, develop, test and document data integrations and assist with deployment, validation and hyper-care processesMaintain and support existing ETL/ELT integrations leveraging technical documentationDevelop and maintain existing codebases as neededAssist with review to confirm technical feasibility of integration development objects based on integration principles and best practicesUnderstand 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 to enable business decision makingDeveloping prototypes and proof of concepts for required solutionsContribute to high level solution/project designDocument solutions through high/low level design documentationSynthesize & communicate ideas and recommendations to colleagues and managementRecommend solutions to address gaps in current data processesAssist with project development estimation (epics, stories, features, bugs)Supervise and review activities of external project partnersRequirements for this position include:
Bachelor's Degree in Business Analytics, Statistics, Computer Science or related fieldSignificant SQL Scripting / TSQL development experienceSignificant Experience in at least one other programming language (Python, Java, Scala)

Proven data processing (ETL/ELT), data mining, data analytics and predictive modeling abilitiesOLAP & OLTP database development experience with relational databases like MSSQL Server/Oracle & PostgresUnderstanding of data warehousing and data mart conceptsAzure Cloud experience (Administration, Data engineering & Networking)Experience with pipelining tools (ADF/Azure Synapse Pipelines preferred)Experience with MPP systems, Azure Synapse preferredFamiliarity with supervised and unsupervised machine learning techniquesExperience of working within an Agile development frameworkUnit & Integration testing experience (concepts such as TDD) and experience of frameworks (such as SSDT, Pytest)DevOps implementation/execution experience (source control, CI/CD, release environment management)Ability to develop and solution both independently and collaboratively a necessityPreferred additional experience:
Familiarity developing and interfacing with DenodoSpecific SAP S4 Hana integration experience (schema, modules)Salesforce Integration experience (e.g. adf salesforce bulk api)PowerShell Core development.
Understanding of GenAI fundamentals (i.e. Retrieval Augmented Generation, embeddings, direct and indirect search methods)