Bus Mtrcs/Analytics Analyst 3

• Running mass data reports within SAP
• Use BI Reporting within SAP Everest to pull up-to-date sales data for all active customers in QlikView (~4K Contracts)
• Shortfall calculations
• Work alongside team to create shortfall calculator documents for top ~100 customers (whatever target list is for FY24 + more)
• Pull customer agreement from Salesforce
• Enter data into new shortfall calculator template spreadsheet
• Pull purchases in from batch reporting
• Analyze purchasing patterns (pivot)
• Data validation and documentation
• Validate shortfall calculations against Qlik compliance calculations
• Ensure customer’s commitments in dashboard align with what is on the contract
• Keep running list of discrepancies between Qlik and manual analysis

• Experience in lieu of education: At least 2 years of working experience inclusive of Commercial Management, Internal Audit, Finance, Marketing or Sales
• Operations experience
• Analytical skills: ability to manage & understand large amount of data and identify purchase patterns
• Interpersonal skills including ability to communicate data and information challenges
• Logic, piecing gaps together
• Attention to detail, clear documentation

Basic knowledge of dashboarding tools e.g. Qlik or Power BI a plus