SQL Data Engineer
Apply NowCompany: Work Life Limbo
Location: Chesterfield, MO 63017
Description:
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