How Remoteville checks and expires listings
Product- Data Analyst
Skills
Data AnalysisEnterprise Resource PlanningJDE Enterprise OneMicrosoft AccessMicrosoft ExcelMicrosoft Excel MacrosProduct Service
What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- BS / BA in Engineering / Accounting / Finance related field or window industry experience in Customer Service Field Service Manufacturing
- Strong modelling techniques and analytical skills with demonstrated ability to find solutions without specific step-by-step instructions
- Ability to manage multiple tasks and projects while delivering results in a timely manner
- Entrepreneurial team player willing and able to work long hours and contribute in multiple ways within the company
- Effectively communicates and engages with all levels of the organization verbally and in writing with the ability to build effective partnerships across teams
- Experience manipulating complex and large data sources and ability to adapt to new systems and applications quickly
- Experience with ERP software (JDE Oracle or OneStream) and/or DB tools (Access / SQL) and Microsoft Office suite (Excel PowerPoint Word)
Nice to have
- Excel macro skillset
- SQL
Day to day
- Work as the liaison between Engineering technology and procurement teams on development and optimization of product data across multiple systems processes with focus on data quality integrity and governance
- Lead the efforts for creation of direct items (parts) during the Genesis analysis and implementation
- Manage the creation of corporate part numbers in appropriate systems and support enrichment for JDE Cantor and other relevant systems set up
- Support migration of data - item master data - from legacy systems to new systems
- Implement data governance processes for item master data maintenance
- Support team in item master related needs and requirements
- Collaborate with team members and management on business needs
- Gather information across the organization analyze it and prepare data for reporting
- Identify trends patterns and potential item data discrepancies
- Maintain item data integrity quality control and governance of items in appropriate systems and tools
- Innovate and improve upon current processes data quality standards and reporting
- Create and maintain documentation for item creation and maintenance
- Perform reconciliation between legacy and newer systems and troubleshoot data inconsistencies and anomalies
- Identify opportunities to leverage technology to improve ability to compile analyze and report item creation and data (e.g. smartsheet access excel JDE Cantor AQ etc.)
- Support the business with ad-hoc analysis and reporting