Data Analyst Mississauga, Hybrid Job Description Role Summary The Data Analyst will be responsible for translating raw data into actionable insights, providing data-driven recommendations to support business strategy and decision-making. This role involves collecting, cleaning, analyzing, and visualizing data to identify trends, patterns, and opportunities for process and performance improvement.

• Collect clean and analyze operational data and generate dashboards and reports tracking KPIs (e.g. order ingestion volumes, error rates , SLA adherence)
• Conduct trend analysis and performance monitoring
• Provide recommendations for process improvements based on data insights
• Collaborate with Operational Analyst and Operation Managers for data validation Key Responsibilities and Duties
• Data Acquisition and Preparation: o Extract, Transform, and Load (ETL) data from various primary and secondary data sources (e.g., internal databases, cloud platforms, external APIs). o Clean and preprocess raw data to ensure accuracy, consistency, and completeness, including identifying and correcting errors, managing missing data, and transforming formats. o Design and maintain databases (e.g., data warehouse models) and data systems to optimize data access and quality.
• Data Analysis and Interpretation: o Apply statistical methods and data analysis techniques to perform exploratory and diagnostic analysis to uncover trends, anomalies, and relationships within complex datasets. o Conduct hypothesis testing and develop models (e.g., regression analysis) to support business questions and predict outcomes. o Define, track, and report on Key Performance Indicators (KPIs) and metrics across various business functions (e.g., Marketing, Sales, Operations).
• Reporting and Visualization: o Design, develop, and maintain interactive dashboards and reports using visualization tools to present data in a clear, digestible format for both technical and non-technical audiences 
• Collaboration and Improvement: o Collaborate with cross-functional teams (e.g., Data Engineering, Product, IT) to understand data requirements and deliver targeted, timely insights. o Proactively identify and recommend process improvements, system modifications, and operational changes based on data analysis.

Required Qualifications and Skills Essential Technical Skills (Hard Skills)

• SQL (Structured Query Language): Advanced proficiency in writing complex queries, stored procedures, and managing relational databases.
• Statistical Programming: Expertise in at least one statistical programming language (Python or R) for complex data analysis, statistical modeling, and automation (e.g., using libraries like Pandas, NumPy, Scikit-learn).
• Data Visualization Tools: High proficiency in industry-standard tools like Tableau, Power BI, or Google Looker Studio for creating interactive dashboards.
• Spreadsheet Tools: Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUPs, functions, modeling).
• Statistical Analysis: Strong foundation in descriptive and inferential statistics. Essential Workplace Skills (Soft Skills)
• Critical Thinking and Problem-Solving: The ability to approach a business problem logically, ask the right questions, and find meaningful patterns in data.
• Communication and Presentation: Excellent verbal and written communication skills to clearly articulate complex technical information and its business implications.
• Attention to Detail: Meticulous approach to data cleaning and quality assurance to ensure the highest level of data integrity and reporting accuracy. Business Acumen: Understanding of business processes and the industry to ensure data analysis is relevant and actionable.