Operations Analyst
Current• Standardize and integrate diverse monthly sales reports using Python,transforming disparate file formats into a cohesive dataset optimized for analysis. Apply advanced data wrangling techniques to streamline revenue, cost, and profit calculations, followed by in-depth trend analysis and statistical outlier detection to extract actionable insights for high-level strategic decision-making. • Manage and maintain critical datasets for customers and products, including data cleaning, updates, and integration of key information such as pricing and rebates.• Generate and automate monthly sales reports by sales representative, utilizing Python for advanced calculations tailored to individual reps, customers, and provincial data.• Collaborate cross-departmentally to develop inventory reports, employing Python to streamline data processing and enhance reporting accuracy.• Support the sales analysis dashboard in PowerBI by maintaining and updating data visualizations and underlying datasets.• Design and maintain data pipelines to import customer data from external sources into company databases, improving data accessibility and accuracy for business operations.