Data Engineer - II

Summary:

Client is looking for a Data Engineer to join the Quality, Technology and Strategy organization. Hard work, a passion for innovation, and zealous advocacy for the needs of our customers have made Company’s Earth's most customer-centric company. This would not be possible without the tools and expertise we use to understand customer behavior. The Data Engineer II occupies a unique role at the intersection of technology, marketing, finance, statistics, data mining, and social science. We provide the key insight into customer behavior necessary to guide the evolution of business strategy. At Company’s Robotics (AR), we are looking for a data engineer to extract, transform, clean and load AR financial data into a data lake and make it available to software and business intelligence engineers for serving finance, leadership, compliance and other stakeholders.

Responsibilities:

Work on complex finance and supply chain data sources from Oracle EBS (E-Business Suite) and Agile PLM(Product Lifecycle Management) systems along with secondary sources like Coupa.
Define the database architecture for a scalable data lake and make clean, validated and readily usable financial data available for mandatory financial reporting, cost tracking and near real time organizational finance health
Develop pipelines with Client’s native technology on AWS and build repeatable and scalable processes
Design and build operationally excellent data pipelines by striking the right balance between infrastructure cost, system complexity and customer use cases.

Required Skills & Experience

3-6 years of related experience.
Excellent knowledge of database concepts - Defining schemas, relational table structures, SQL querying
Proficient with AWS Big data services (Glue, Athena, Redshift, Lake formation, Lambda)
Proficient in writing Python code for data pipelines, AWS CDK and data processing logic
A standout candidate has working experience with Oracle EBS and Agile PLM data

Preferred skills:

Prior work experience at Company as a full-time employee or a contractor
Experience working with NoSQL data sources at scale (In Terabytes) - Understanding of shards, partitions etc.
Understanding of Financial reporting in Oracle EBS
Will be exposed to Data Lake, Glue, Lambda and Infrastructure as code. If have that experience is a plus