Full Time Employee opening for an experienced Data Engineer to join a growing organization optimizing its Business and IT. This role will work as part of a team, querying, extracting and parsing data, as well as being part of the strategy and execution of data automation projects.Review and standardize Item Master Data
o Analyze company product data across various categories and define structured hierarchy of relevant parameters by groups
o Work with product owners from the business to confirm defined attributes for product categories are comprehensive and accurate
o Compare data from multiple sources for comparison and updating
o Identify key information and patterns within text descriptions to assign attributes across defined parameters
o Create queries to extract and parse data to validate consistency of attribute mapping approach
o Perform iterative operations on existing data to complete item definitions with complete parameters
o Validate quality of updated datasets, address errors and refine process
o Provide recommendations regarding new item setup to ensure data is complete and aligned with defined standards.
· Streamline process with automation
o Develop programs (Python) to automate the analysis of text data and population of item parameters
o Validate results of processing and make programming adjustments to improve / extend iterative execution
o Leverage programming to identify exceptions in existing / new data that require incremental standardization
Required Qualifications
· 3+ years of experience analyzing/querying/parsing data
· Deep SQL query knowledge
· Expertise in SQL, Python, Excel and related tools
· Strong analytical and problem-solving skills
· Excellent communication skills
· Experience accessing ERP Item Master data (JDE preferred)
o Taking data out of Oracle db/JDE, and parsing it into SQL Server
o Oracle SQL developer or a python script running SQL
Desired Qualifications
· Experience with JDE Constructs
· Experience with JDE Data Sets
· EDI experienced