Business Data Analyst

Martin Brower•Mississauga, ON

About The Position

As a Business Data Analyst, you will play a key role in analyzing and interpreting data from multiple sources, leverage data driven insights and automation solutions to guide strategic business decisions, streamline data workflows, and improve operational efficiency. This role requires strong technical skills, with a focus on data automation and process optimization. The ideal candidate possesses a strong analytical mindset and a strong problem-solving abilities, and can translate complex datasets into scalable, automated solutions and actionable business recommendations.

Requirements

Bachelor’s degree in computer science, data science or a related field.
2-4+ years of experience data automation and process optimization.
Experience building Extract, Transform & Load (ETL) processes and managing data pipelines across multiple data sources and warehouses
Willingness to understand business operations and identify automation opportunities
Experience of scripting languages (like Python, R, SQL) and data process workflow automation tools
Strong analytical and problem-solving skills with attention to detail and commitment to data accuracy
Excellent communication skills with the ability to explain complex data topics to non-technical stakeholders.
Eagerness to explore alternative solutions that support data automation and process optimization insight delivery
Collaborative mindset with a passion for innovation and continuous improvement
This position must pass a post-offer background check

Nice To Haves

Master’s degree preferred

Responsibilities

Extract, clean, and analyze large datasets from multiple data sources (JDE, KOMPASS, MBSYNC, Samsara, Paragon, among others) and data warehouse (Snowflake) to enable automated insights into business performance
Design and maintain automated workflows and data pipelines to reduce manual reporting and improve data accuracy.
Conduct deep-dive analyses to identify patterns, trends, and relationships that inform business decisions
Assist in the design and deployment of analytics analysis to support process optimization and data insights
Perform root cause analysis of business challenges and recommend automated, data-driven solutions
Identify opportunities for process improvements, cost reductions, and efficiency gains using data and automation
Ensure data quality and accuracy through proper validation techniques, best practices and governance processes
Design, develop, and maintain automated reports, dashboards, and visualizations
Collaborate with department heads to define and track Key Performance Indicators (KPIs) relevant to the company’s strategic goals
Translate business questions into data requirements and provide concise answers through self-service reporting and automation
Work with the global team to identify opportunities for alternative solutions
Assist and support in the deployment of models that support operational decision-making
Evaluate results and continuously improve automated solutions to align with business objectives
Stay updated on emerging technologies and integrate modern automation techniques into business workflows
Maintain data integrity, ensure consistency across automated processes. Collaborate with data ingestion and IT teams to close data gaps and improve automation readiness
Ensure compliance with data privacy and internal governance standards
Work closely with various business units (Operations & Transportation, Finance, Supply Chain, ROP, REX, Centralized Routing) to understand their business needs and develop tailored automation or reporting solutions.
Present automated data insights and recommendations to senior leadership
Serve as a liaison between technical teams (data ingestion, engineering) and business stakeholders to align automation efforts with priorities
Lead or contribute to cross-functional projects focused on data automation, insight generation, and continuous improvement.
Track project milestones and ensure timely delivery of automation initiatives
Other projects or duties as assigned