This position in Global Parts Supply (GPS) Aftermarket Data Analytics team (ADA) will be responsible to define, develop & maintain standard reports for a wider supply base through collaboration using safe source of data. This in turn help the management to visualize daily/weekly/monthly positions and trends of key business driving functionalities like Past Due, Backorder, Supplier Shipping Performance, etc.
Gather user requirements, collect, and document existing Secure Source data (tables / flat files), Identify Safe Source to establish & maintain Fact & Dimension tables for Business with TACCSS (Transactional, Accurate, Clean, Complete, Safe source & Standardized) data and establish dataflow diagrams.
Eager to learn & improve, continuously hones their skills.
Robust solution-oriented analytic skills and shows creativity in their problem-solving.
Has excellent attention to detail without losing sight of the big picture.
Has great communication skills - Is able to represent the architect team, address their needs & requirements in meetings with process partners (inside & outside of the greater team).
Must be willing to work in different shifts to have enough overlap with global team.
Desired Qualifications:
APICS CPIM or CSCP certification.
Python, R, SnowSQL.
Experience with data mining and data analytics in large data sets.
Power BI report development.
Ability to automate programs / processes.
SnowFlake what we want:
Strong knowledge in SQL - Joins, Subqueries, CTEs.
Developing Stored Procedures & User defined functions.
Understanding of SnowFlake features.
Understanding of SnowFlake functions like - Window functions, Aggregate functions, Data & time functions, String functions.
Troubleshooting existing SQL Queries.
Creating Fact & Dimension Views.