Distribution Data Analyst

Purpose & Overall Relevance for the Organization:

• This role focuses on efficiently managing an Oracle reporting sandbox and associated data structures, including stored procedures, ETL processes, and tables. Must possess expertise in SQL, database design, and collaborative problem-solving. Other responsibilities include standard analyst functions such as providing analysis, reporting, and tracking KPIs to improve team communication, visibility, and operational efficiencies.

Key Responsibilities:

• Design, maintain, normalize, and optimize Oracle database for supply chain analytics.
• Develop and manage stored procedures and ETL processes for automated data collection and processing.
• Create and update a comprehensive data dictionary for clear documentation.
• Collaborate with the analytics team to understand data requirements.
• Identify and resolve technical issues related to data collection.
• Analyze and interpret data from several sources such as WMS (Manhattan) and SAP.
• Provide data analysis and develop automated reporting/dashboards.
• Develop, design, and execute a variety of reports using SQL, BI Tools, and various other methods.
• Assist with any ad hoc requests or special projects that require data analysis.
• Contribute to NAM Supply Chain data initiatives with the other SCM Reporting & Analytics Teams.

Key Relationships:

• Global IT (Including WMS Business Consultants and support)
• NAM DNA/RNA Teams
• Industrial Engineering Teams
• 3PLs and Global Logistics
• Supply Chain Management: Distribution Operations, Inventory Control, Logistics, Productivity Planning, and Purchasing

Knowledge, Skills and Abilities:

• Analytical skills with strong database level expertise.
• Advanced querying and data analysis techniques (SQL is required-Python, R, etc. are a plus).
• Problem solving skills and ability to think algorithmically.
• Willingness to learn new skills and stay updated on related technologies and best practices.
• Design and manage Oracle database structures.
• Strong problem-solving skills for addressing data discrepancies and performance issues.
• Ability to design solutions for complex problems.
• Meticulous approach to ensure data accuracy and quality.
• Ability to adapt to changing requirements and technologies.

Requisite Education and Experience / Minimum Qualifications:

• B.S. degree in a computer discipline or relevant certification/experience is a plus.
• One to two years related experience in the field of supply chain and logistics and/or data analytics.
• Fluent in English, both oral and written.

Though our teammates hail from all corners of the world, our working language is English.

Diversity and Inclusion at adidas means champioining indvidual uniqueness and cultivatinga a culture of belonging in which everyone can create at their best. We embrace DIVERSE backgrounds, experiences, and perspectives and seek to create a workforce that REFLECTS our consumers and commuinities.