Dematic is looking to solve the problem of ensuring accuracy and data integrity in their systems, particularly in the context of an ERP migration, by hiring a Senior Data Analyst with expertise in data validation, workflow automation, and quality control methods.
Requirements
- Experience with SQL
- Strong knowledge of BI tools and platforms – PowerQuery and Power BI most useful
- Excellent skills with MS Excel
- Experience in the supply chain solutions industry, or a related field
- Ability to read complex product drawings and assess product Bills of Material
- Experience with Knime Analytics
Responsibilities
- Support ERP migration by developing tools to translate project cost estimates from our legacy WBS (Work Breakdown Structure) to the new system.
- Update model-based product costing by refreshing material cost data used in statistical linear regression models.
- Build function-based statistical cost models to support estimating across a wide range of solution types.
- Apply company resources to investigate, understand, and report data mapping from legacy to new WBS
- Develop tools to be used by multiple business units for translating artifacts to reflect the new WBS, such as quoting and costing database files, Maestro drawing cost options, and project cost reports
- Publish a Scenario Book transparency report, similar to the existing Service Book transparency report
- Establish a function-based Cost Book utilizing statistical material and project costs
Other
- Bachelor’s degree in Engineering, Computer Science, Information Systems, Business, Supply Chain Management, or a related field.
- Equivalent work experience may be considered in place of one of the listed degrees.
- Strong written/verbal communication skills
- Proven ability presenting data findings in simple and easy to understand ways
- Outstanding team interaction and communication skills
