**Job Description**:
**Job Description**:
Point of Sales Data conditioning in Legacy system to provide PowerBI reports and dashboards to the business channel team.
In a monthly basis receive distributor´s data, process it using Excel tools for conditioning and cleansing, load information in AS400 and visualize reports in PowerBI meeting defined SLAs and business requirements.
Ensure reports & dashboard's data is accurate and meet policy standards.
Job Duties (include but are not limited to):
- Receive, validate and store original distributor's files
- Monthly follow up on files reception and tracking
- Receive and ensure the sent data is correct and complies requirements
- Track weekly KPIs: files received on time, processing cycle, sell out
- Store original files in server
- Data Conditioning
- Validate number of POS received files and ensure the data is consistent based on previous months
- Data cleansing: end customers and products
- Data enrichments
- Prices assignment
- POS Calculation: validate and calculate quantities and amounts sent by distributors
- Ensure KPIs and validations between 3M and distributor's data match
- Reporting
- Data load to AS400
- Update distributor's reports
- Consolidate BG dashboards for business usage
Skills And Expertise:
- Ability to handle large quantities of data
- Able to produce analysis
- Complex problem solving and analytical skills
- Sense of Service
- The ability to proactively take action on problems and opportunities.
- Results and Performance Driven
- The ability to deliver business results and keep the focus on driving customer value. The willingness to assume personal ownership and accountability. Focus on meeting SLAs and improve process steps
- Talent Development
Basic Requirements:
- Technical degree or higher in business administration, engineering, Data Science or related careers, or 1+ year of experience on Data Analysis, Data mining.
- 1+ years of experience on Power BI, Advance Excel, AS400, and SQL Server
- Advance English Level: B2+
Supporting Your Well-being
3M offers many programs to help you live your best life - both physically and financially. To ensure competitive pay and benefits, 3M regularly benchmarks with other companies that are comparable in size and scope.
Imagine your future in 3M
3M es un empleador que ofrece las mismas oportunidades. 3M no discriminará a ningún solicitante de empleo por razones de raza, color, edad, religión, sexo, orientación sexual, identidad o expresión de género, origen nacional, discapacidad o estado de veterano.
Our approach to flexibility is called Work Your Way, which puts employees first and drives well-being in ways that enable 3M's business and performance goals. You have flexibility in where and when work gets done. It all depends on where and when you can do your best work.
3M Global Terms of Use and Privacy Statement
