About the role
Primary Function:
The Junior Data Analyst supports the organization by transforming raw data into actionable insights across departments—ranging from Supply Chain to Sales and Production. Working closely with the Senior Data Analyst, this role is responsible for maintaining data integrity, 1assisting with the development of reports and dashboards, and contributing to process improvements through data analysis.
This is a position suited for an individual who is curious, detail-oriented, and eager to grow their technical and business skills through hands-on experience.
Qualifications and Educational Requirements:
- Bachelor’s degree in Data Analytics, Statistics, Computer Science, Business, or related field and/or equivalent experience
- 1–2 years of experience in a data-focused role preferred (including internships)
- Strong proficiency in Excel (pivot tables, VLOOKUP/XLOOKUP, conditional formatting, charting) – Intermediate Excel Skills preferred
- Basic SQL skills (able to write simple queries)
- Familiarity with BI tools (e.g., Tableau, Power BI, or Apache Superset) is a plus
- Understanding of ERP systems and data flows across business operations
- Strong attention to detail and organizational skills
- Effective written and verbal communication skills
- Experience in manufacturing, aptitude for understanding processes an asset
- Computer aptitude and MS Office skills
- Clear Background Checks - Criminal
Responsibilities, Skills, and Competencies:
- Collect, clean, and validate large data sets from multiple sources (ERP, CRM, Excel files, etc.).
- Assist with building and maintaining Excel-based reports and tools for all departments (e.g., operations, sales, inventory).
- Support senior analysts in investigating trends, variances, and data anomalies.
- Identify and document process gaps or inconsistencies in data flow.
- Participate in monthly KPI reporting and dashboard updates.
- Maintaining and updating internal dashboards used in the office building, such as KPI screens on factory monitors.
- Collaborate with cross-functional teams to provide ad hoc data support.
- Maintain detail documentation of reports, dashboards, and analysis procedures.
- Assist in developing templates and automated solutions using Excel or SQL.
- Contribute to analytics projects such as forecasting, inventory optimization, or cost analysis.
- Promote a culture of data accuracy, consistency, and continuous improvement.
- Other tasks as assigned.
- Able to lift up to 25lbs; may work in hot areas 5%, noise 5%.
- Ensure adherence to Health and Safety as well as active participation in 5S activities in work area.
About MAD Elevator Inc
MAD Elevator manufactures elevator fixtures, interiors and digital products - including our code compliant VMS emergency communication system and hands-free / touchless elevator fixtures to reduce passenger germ transfer. Contact us to learn more at: sales@madelevator.com
MAD is a joint venture between DMG - an Italian elevator fixture leader in Europe - and Mainline Elevator - a Canadian custom cab interior manufacturer. The companies initially came together in 2005 as MAD Fixtures to advance fixture modernization in North America. The partnership grew in 2016 forming MAD Elevator Inc., manufacturing high quality elevator fixtures and interiors under one roof.
In 2019, MAD partnered with Elevator Cab Renovations Inc. (ECR) to expand our elevator interiors product offering and reach. Together we provide even greater expertise to the elevator industry, architects, designers and property managers.
In 2020, MAD partnered with Vantage Elevation to form Vantage Fixtures Designed & Made by MAD, a powerful partnership bringing together the expertise, convenience, and product solutions of Vantage with the industry-leading fixtures and manufacturing capabilities of MAD.
Headquartered in Mississauga Canada, our 80,000 sq. foot facility focuses on the efficient production of industry-leading fixtures and high quality elevator car interiors.
At MAD, one of the cornerstones of our success is our talent; our employees bring the richness of their education, experience, backgrounds, and culture to work each and every day. MAD has been ranked among Canada's top 500 fastest growing companies for the last 9 years, and among Best Employers for Recent Graduates for the last 3 years.
Get in touch: sales@madelevator.com 1 (866) 967-8500
About the role
Primary Function:
The Junior Data Analyst supports the organization by transforming raw data into actionable insights across departments—ranging from Supply Chain to Sales and Production. Working closely with the Senior Data Analyst, this role is responsible for maintaining data integrity, 1assisting with the development of reports and dashboards, and contributing to process improvements through data analysis.
This is a position suited for an individual who is curious, detail-oriented, and eager to grow their technical and business skills through hands-on experience.
Qualifications and Educational Requirements:
- Bachelor’s degree in Data Analytics, Statistics, Computer Science, Business, or related field and/or equivalent experience
- 1–2 years of experience in a data-focused role preferred (including internships)
- Strong proficiency in Excel (pivot tables, VLOOKUP/XLOOKUP, conditional formatting, charting) – Intermediate Excel Skills preferred
- Basic SQL skills (able to write simple queries)
- Familiarity with BI tools (e.g., Tableau, Power BI, or Apache Superset) is a plus
- Understanding of ERP systems and data flows across business operations
- Strong attention to detail and organizational skills
- Effective written and verbal communication skills
- Experience in manufacturing, aptitude for understanding processes an asset
- Computer aptitude and MS Office skills
- Clear Background Checks - Criminal
Responsibilities, Skills, and Competencies:
- Collect, clean, and validate large data sets from multiple sources (ERP, CRM, Excel files, etc.).
- Assist with building and maintaining Excel-based reports and tools for all departments (e.g., operations, sales, inventory).
- Support senior analysts in investigating trends, variances, and data anomalies.
- Identify and document process gaps or inconsistencies in data flow.
- Participate in monthly KPI reporting and dashboard updates.
- Maintaining and updating internal dashboards used in the office building, such as KPI screens on factory monitors.
- Collaborate with cross-functional teams to provide ad hoc data support.
- Maintain detail documentation of reports, dashboards, and analysis procedures.
- Assist in developing templates and automated solutions using Excel or SQL.
- Contribute to analytics projects such as forecasting, inventory optimization, or cost analysis.
- Promote a culture of data accuracy, consistency, and continuous improvement.
- Other tasks as assigned.
- Able to lift up to 25lbs; may work in hot areas 5%, noise 5%.
- Ensure adherence to Health and Safety as well as active participation in 5S activities in work area.
About MAD Elevator Inc
MAD Elevator manufactures elevator fixtures, interiors and digital products - including our code compliant VMS emergency communication system and hands-free / touchless elevator fixtures to reduce passenger germ transfer. Contact us to learn more at: sales@madelevator.com
MAD is a joint venture between DMG - an Italian elevator fixture leader in Europe - and Mainline Elevator - a Canadian custom cab interior manufacturer. The companies initially came together in 2005 as MAD Fixtures to advance fixture modernization in North America. The partnership grew in 2016 forming MAD Elevator Inc., manufacturing high quality elevator fixtures and interiors under one roof.
In 2019, MAD partnered with Elevator Cab Renovations Inc. (ECR) to expand our elevator interiors product offering and reach. Together we provide even greater expertise to the elevator industry, architects, designers and property managers.
In 2020, MAD partnered with Vantage Elevation to form Vantage Fixtures Designed & Made by MAD, a powerful partnership bringing together the expertise, convenience, and product solutions of Vantage with the industry-leading fixtures and manufacturing capabilities of MAD.
Headquartered in Mississauga Canada, our 80,000 sq. foot facility focuses on the efficient production of industry-leading fixtures and high quality elevator car interiors.
At MAD, one of the cornerstones of our success is our talent; our employees bring the richness of their education, experience, backgrounds, and culture to work each and every day. MAD has been ranked among Canada's top 500 fastest growing companies for the last 9 years, and among Best Employers for Recent Graduates for the last 3 years.
Get in touch: sales@madelevator.com 1 (866) 967-8500