SAP Data Analyst
Denver, NC
Full Time
Mid Level
Position Overview
The SAP Data Analyst, working under the supervision of the VP of IT, will be responsible for leading data preparation, cleanup, and transfer of data from our existing ERP system to our SAP S4 HANA implementation. Creating schemas from existing data to the new ERP structure will be a key activity of this role. Additionally, working with the various functions to verify data, propose new structures and be involved in the load and testing of transported data is a critical activity for the Data Analyst. This role will be vital in providing feedback and guidance to our integration partners during our migration. Post Go Live, the role will continue to manage and own ERP data and requests from the business. Additional activities will be in developing delivery of important data to the business through other tolls such as PowerBI.
Company and Opportunity Overview
Wanzl North America’s (WNA) vision is to be a leading entrepreneurial player in terms of market share, agility, and game-changing solutions. WNA is a solution provider, creating value along the supply chain of our customers, from the online purchase to the delivery to their customers.
WNA, which includes the Technibilt and Cari-All brands, headquartered in Newton, North Carolina. With nearly 500 employees and 175 MUSD of sales, WNA focuses on the retail and distribution market segments with marquee customers such as Walmart, Amazon, and the majority of large grocers and retailers.
In addition to being the largest manufacturer of shopping carts in North America, WNA has three (3) additional main product segments as well as a Service business, providing turnkey solutions for customer guidance (Access Systems) and Shelving & Fixtures, as well as Material Handling/Rolling Stock products. Additionally, WNA is active in building a “digital” business line with products for shopping cart containment, smart exit gate technology, and solutions for autonomous and/or semi-autonomous retail stores.
WNA is part of the Wanzl group, headquartered in Germany, and has 12 plants in 8 countries, providing comprehensive, solutions-driven service and expert knowledge of local markets for customers across the globe through their 360° service.
Duties and Responsibilities:
Skills/Education Preferred:
The SAP Data Analyst, working under the supervision of the VP of IT, will be responsible for leading data preparation, cleanup, and transfer of data from our existing ERP system to our SAP S4 HANA implementation. Creating schemas from existing data to the new ERP structure will be a key activity of this role. Additionally, working with the various functions to verify data, propose new structures and be involved in the load and testing of transported data is a critical activity for the Data Analyst. This role will be vital in providing feedback and guidance to our integration partners during our migration. Post Go Live, the role will continue to manage and own ERP data and requests from the business. Additional activities will be in developing delivery of important data to the business through other tolls such as PowerBI.
Company and Opportunity Overview
Wanzl North America’s (WNA) vision is to be a leading entrepreneurial player in terms of market share, agility, and game-changing solutions. WNA is a solution provider, creating value along the supply chain of our customers, from the online purchase to the delivery to their customers.
WNA, which includes the Technibilt and Cari-All brands, headquartered in Newton, North Carolina. With nearly 500 employees and 175 MUSD of sales, WNA focuses on the retail and distribution market segments with marquee customers such as Walmart, Amazon, and the majority of large grocers and retailers.
In addition to being the largest manufacturer of shopping carts in North America, WNA has three (3) additional main product segments as well as a Service business, providing turnkey solutions for customer guidance (Access Systems) and Shelving & Fixtures, as well as Material Handling/Rolling Stock products. Additionally, WNA is active in building a “digital” business line with products for shopping cart containment, smart exit gate technology, and solutions for autonomous and/or semi-autonomous retail stores.
WNA is part of the Wanzl group, headquartered in Germany, and has 12 plants in 8 countries, providing comprehensive, solutions-driven service and expert knowledge of local markets for customers across the globe through their 360° service.
Duties and Responsibilities:
- Key member of system implementation teams (ERP, Fixed Asset, Document Retention, etc.)
- Lead the ETL (export, transform and load) portions of ERP migration.
- Work closely with stakeholders from various departments to understand their business requirements and translate them into functional specifications for ERP system.
- Direct and actively participate in activity workstreams.
- Analyze the business domain, document processes and systems and outline business requirements.
- Gather extracts from existing Oracle based ERP system.
- Analyze data extract to:
- Understand what parts of extracts need to be prepared and cleaned for import into new environment.
- Develop system data schemas to data support import processes.
- Map out and develop necessary schemas to support development of data extract structure to be imported into ERP environment.
- Engage with userbase to lead data review and cleanup activities.
- Familiarity with ERP systems, preferably SAP
- Requirements Gathering and Analysis: Collaborate with business stakeholders to elicit, document, and analyze their requirements for the project and systems. Involves conducting interviews, workshops and analyzing existing business processes to identify opportunities for improvement.
- Business Process Modeling: Creating visual representations, process flows and diagrams to illustrate current and future state business processes. Identify areas of optimization and define system requirements.
- Stakeholder Management: Build and maintain strong relationships with business stakeholders, IT teams, and vendors.
- Liaison: Act as a liaison between different functions and teams, ensuring clear communication, manage expectations and facilitate consensus on project deliverables.
- Change Management: Assist with change management efforts by analyzing the impact of proposed system changes on business processes, training needs and organizational structure. Collaborate with stakeholders to develop change management strategies and communication plans to facilitate transitions.
- Quality Assurance and Testing: Collaborate with testing teams to define test plans, scenarios and test cases based on the documented requirements. Review and validate test results to ensure the solution meets business needs and performs as expected.
- Strong communication and active listening skills
- Strong time management and organization skills with ability to multitask and prioritize.
Skills/Education Preferred:
- Intermediate to Advanced abilities in SQL, Access and Excel
- Understanding of data profiling and analysis concepts, including data anomalies, data mapping activities
- Design and develop reliable, scalable, and testable applications, ETL (Extract, Transform and Load) tools, scheduled jobs and database components
- Understanding of data modeling concepts
- Adept at creating queries.
- Bachelor of Science in Computer Science, Computer Information Systems, Management Information Systems, Information Technology, Applied Statistics, or closely related degree.
Apply for this position
Required*