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 data 

Design, develop, test and document data integrations and assist with deployment, validation and hyper-care processes 

Maintain and support existing ETL/ELT integrations leveraging technical documentation 

Develop and maintain existing codebases 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 to enable business decision making 

Developing prototypes and proof of concepts for required solutions 

Contribute to high level solution/project design 

Document solutions through high/low level design documentation 

Synthesize & communicate ideas and recommendations to colleagues and management 

Recommend solutions to address gaps in current data processes 

Assist with project development estimation (epics, stories, features, bugs) 

Supervise and review activities of external project partners 

Requirements for this position include: 

Bachelor’s Degree in Business Analytics, Statistics, Computer Science or related field 

Significant SQL Scripting / TSQL development experience 

Significant Experience in at least one other programming language (Python, Java, Scala) 

Proven data processing (ETL/ELT), data mining, data analytics and predictive modeling abilities 

OLAP & OLTP database development experience with relational databases like MSSQL Server/Oracle & Postgres 

Understanding of data warehousing and data mart concepts 

Azure Cloud experience (Administration, Data engineering & Networking) 

Experience with pipelining tools (ADF/Azure Synapse Pipelines preferred) 

Experience with MPP systems, Azure Synapse preferred 

Familiarity with supervised and unsupervised machine learning techniques 

Experience of working within an Agile development framework 

Unit & 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 necessity  

Preferred additional experience: 

Familiarity developing and interfacing with Denodo 

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