Software Engineer - SnowFlake(Pool Hire)

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 Safe 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.
• Strong solution-oriented analytic skills and shows creativity in their problem-solving.
• Has great 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.