Timeless Technology Solutions
SQL Data Engineer
Timeless Technology Solutions - Chesterfield
Work at Timeless Technology Solutions
Overview
- View job
Overview
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
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