Dematic is looking for a Senior Data Analyst to support an ERP migration by developing tools for data translation, updating model-based product costing, and building statistical cost models to improve data integrity and reliability throughout their quoting platforms.
Requirements
- Experience with SQL
- Strong knowledge of BI tools and platforms – PowerQuery and Power BI most useful
- Excellent skills with MS Excel
- 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.
- Collaborate internationally with multi-functional teams to improve data integrity and reliability throughout our quoting platforms.
- 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
- Support the Product Costing team with their annual Cost Book refresh efforts
Other
- tactical expertise in data validation, workflow automation, quality control methods to ensure accuracy, and ability to mentor junior colleagues.
- Proven ability presenting data findings in simple and easy to understand ways
- Outstanding team interaction and communication skills
- Ability to work with global colleagues
- Ability to set and meet deadlines
