Job Information
ADM Data Engineer II in Erlanger, Kentucky
80887BR
Job Title:
Data Engineer II
Department/Function:
Information Technology
Job Description:
Data Engineer II – (SAP)
This is an exempt level position.
Summary:
Data Engineer/Analyst will work on designing, building, and implementing a data foundation to support a strategic analytics project 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 Python, AzureAI and RAG 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
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 SAP Datasphere analytical model and Azure integrations like ADF, Synapse and AI 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, Vector database 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 science 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, SAP Datasphere, ETL data replication, and data warehouse automation tools such as Microsoft Azure Data Factory, Databricks and BEX.
5 years of recent experience in data processing using SQL, PySpark, Python.
Strong working knowledge of Data Modeling & Data Transformation in Datasphere.
Extensive experience in Multiple Remote Tables with Semantic usage of (Relational Dataset, Fact, Dimension, Text, Hierarchy tables)
Hands on knowledge on creation of remote tables to consume data from S4 using the CDS views & S4 Tables.
Experience in dynamic filters in remote tables to optimize data retrieval from S4 CDS views and S4 tables, ensuring efficient and targeted data access.
Experience in Analyzing business requirements to identify and decide which data should be stored in Datasphere.
Experience in creating complex data modelling using Graphical Views (Relational Dataset/Fact/Dimension) based on the Functional design document and leveraging S4 & Non-SAP as a data source.
Experience working in DevOps / CICD framework
High accountability with a demonstrated ability to deliver
Strong communication skills including design documentation
Strong collaboration skills working with architecture, design and development teams
“AJCIND” REF: 80887BR
Req/Job ID:
80887BR
City:
Erlanger
State:
KY - Kentucky
Ref ID:
#LI-SU1
:
#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.
ADM
-
- ADM Jobs