Senior Equipment Technician

Top Prospect Group LLC; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

Top Prospect Group LLC in Mississauga, ON or Boisbriand, QC seeks a Business Analyst to maximize operational efficiency by turning data into actionable insights across marketing, sales, service, and finance.

You will design BI solutions using Excel, Power BI, SQL, and SSIS, contribute to ERP transition from MS Dynamics GP to SAP S4/HANA, and support multi-department reporting with strong communication.

Qualifications

• 5-7 years B2B experience including commercial-operations, inside-sales or process-engineering.
• Proficient in Power BI, SQL, SSIS and Access; ERP systems experience essential (SAP, Dynamics GP).
• Excellent written and verbal communication for reporting and proposals.
• Strong data collection, analysis and dashboard development capabilities.

Responsibilities

• Collect and aggregate data from ERP, CRM, HR, Kanban and external sources.
• Design and maintain BI tools, dashboards and related databases (Excel, Power BI, SQL, SSIS, Access).
• Generate standard reports and dashboards for executives and stakeholders.
• Automate KPI collection and support data-driven decision making across departments.
• Support ERP transition planning and data mapping for SAP S/4HANA implementation.

Skills

Data analysis

Project planning

ERP knowledge

Communication

Excel

Business intelligence

Education

Undergraduate business or industrial-engineering, CMA

Tools

Power BI

SQL

SSIS

Access

SAP S/4HANA

MS Dynamics GP

Job description

Business Analyst

Location: Mississauga, ON or Boisbriand, QC (Must be French/English speaking if in Boisbriand, QC)

Industry: Manufacturing, Industrial Companies.

Full Time Permanent Position

This position provides multi department support, for the purpose of maximizing operational efficiency and thus lowest cost and highest margin. Typical support would range from Marketing “Spending-effectiveness” and Sales “Lead conversion/price-excellent” to Service/Systems “Workflow, capacity-management, parts-logistics/costing” and finance “Special business case prep”.

You are:

Business process enthusiast. You use software Tools (Excel, SQL). You understand 5S, Kaizan and LEAN. You are meticulous with detail analysis and excellent project planning skills using GANT(T) charts.

3-5 years of industrial and/or B2B commercial environment is ideal. Mid-Late career and Excellent ERP Knowledge and ideally suited to contribute to large scale implementation of SAP-ERP early in their tenure.

Some of your Job Responsibilities will include:

• Collection and aggregation of business data from various sources (ERP, CRM, HR, Kanban, Board) and external sources (industry reports and databases)
• Create Business Intelligence tools or systems, including design of related databases, spreadsheets or outputs (Excel, PowerBI, SQL, SSIS, Access etc.)
• Create Business Intelligence tools or systems, including design of related databases, spreadsheets or outputs (Excel, PowerBI, SQL, SSIS, Access etc.)
• Maintain , update and improve existing business intelligence tools, databases, dashboards, systems or methods (Based on SQL Databases, SSIS jobs and connected Excel Dashboards.
• Maintain , update and improve existing business intelligence tools, databases, dashboards, systems or methods (Based on SQL Databases, SSIS jobs and connected Excel Dashboards.
• Generate standard reports, data extracts and dashboards summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
• Support the use of data (ie. Contribute to analysis and solution development) for all company departments (eg. business development, sales, service, systems, finance)
• Automate collection, aggregation and display of performance KPIs for all business processes and departments.
• Coordinate the data analysis and mapping in preparation for our ERP Transition from MS Dynamics GP to SAP S4/HANA in 2024.

Requirements

• Undergraduate business or industrial-engineering, or working on CMA
• 5-7 years B2B combined : commercial-operations, inside-sales, process-engineering
• Data Business Tools : PowerBI, SQL, SSIS, Access, ERP (Ex SAP, GP)
• Excellent communication skills, written and verbal, in support of reporting and proposals