Data Analyst

3 weeks ago

Mississauga, Canada Ceridian HCM, Inc. Full time

Thursday, November 7, 2024

Since launching in 2009, Independent Mechanical Supply (IMS) has become GTA contractors’ preferred distributor of plumbing, hydronics, and PVF products. We’re proud to have one of the largest product selections in the industry. Our customers love both our selection and working with our team.

This position requires a unique combination of database management, data science, and business analysis skills and focuses on extracting, transforming, and loading data. The successful candidate will be responsible for ensuring that data used for analyzing and interpreting sales, inventory, and vendor insights is clean, valid, reliable, and has integrity. Additionally, they will perform various tasks such as product master updates, inventory and sales report extraction, individual product maintenance, commodity item cherry picking, customer quote database maintenance, and data audits to ensure alignment with internal data governance principles.

Responsibilities:

Data Analysis:

  1. Collect, clean, and analyze data related to inventory and sales.
  2. Utilize data visualization tools to present complex information in a clear and intuitive manner.
  3. Ensure that ERP database does not have missing data from key fields in accordance with data governance principles.
  4. Ensure that mandatory fields are filled more than 95% of the time for active products/customers/vendors.

Business Intelligence and Reporting:

  1. Extract, transform, and load data to create reports on inventory levels for branches and product lines.
  2. Extract sales history and create reports on sales data by branch, product line, and customer.
  3. Utilize PowerQuery, PowerApps, PowerAutomate, and PowerBI to facilitate reporting and automation needs.

Process Optimization:

  1. Implement and monitor key metrics to evaluate the success of process improvements.
  2. Adhere to data-driven decision-making processes across the organization.

Systems and Data Management:

  1. Collaborate with IT teams to ensure data integrity, quality, and security.
  2. Assist in the integration and maintenance of systems and tools related to inventory and sales.
  3. Support data governance initiatives and ensure compliance with data regulations.
  4. Ensure quarterly audits of mandatory data fields are completed and followed up on.
  5. Identify opportunities for system enhancements and contribute to system implementation projects.
  6. Maintain and update underlying database mapping to ensure data integrity and accuracy.

System Maintenance Support:

  1. Perform product master updates, including pricing and descriptions.
  2. Perform full product line updates, ensuring accuracy and completeness.
  3. Ensure 100% of products from top vendors are listed in detail in our product master.
  4. Perform vendor master and customer master checks and updates to ensure data is complete.
  5. Maintain the Customer Quote Database by formatting excel sheets, cross-referencing customer product numbers, and performing data uploads.
  6. Find and validate cross-reference data between our product data and vendor product data to ensure smoother interchange of data between IMS and our partners.

Other:

  1. Other duties as assigned.

Mandatory Requirements:

  1. 5-7 years proven experience as a Data Scientist or Business Analyst, preferably in the plumbing and heating wholesale industry.
  2. Strong analytical skills with expertise in data interpretation, statistical analysis, and predictive modeling.
  3. Proficiency with AS400 ERP platforms.
  4. Proficiency in data visualization tools (Power BI).
  5. Proficiency with Microsoft’s data and automation tools (Fabric, PowerQuery).
  6. Familiarity with Microsoft’s full suite of apps (PowerAutomate, PowerApps, SharePoint).
  7. Familiarity with SQL and database management.
  8. Knowledge of inventory management, sales operations, and pricing strategies.
  9. Experience in demand forecasting, inventory optimization, and sales performance analysis.
  10. Excellent problem-solving abilities and attention to detail.
  11. Strong communication and interpersonal skills.
  12. Ability to work independently and manage multiple projects simultaneously.

IMS is a mid-sized company with a small-company feel. We’re professional, but relaxed, and strive to maintain an open work environment with an accessible senior leadership team. We also value giving our people opportunities to advance. If you’re interested in learning and growing, this is the place for you. Independent Mechanical Supply is committed to accommodating applicants with disabilities throughout the hiring process, in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). Please let us know if you require accommodation at any stage of the hiring process.

#J-18808-Ljbffr

  • Analyst Data Visualization

    2 months ago

    Mississauga, Canada Data Privacy Full time

    Chartwell Retirement Residences is looking for a Data Visualization Analyst to convert complex data into actionable insights aiding strategic planning, finance, and operations. Collaborating with the Data & Analytics team, the role aims to create impactful dashboards that drive decision-making across the organization.In this role you can expect to have the...

  • Analyste Data

    2 months ago

    Mississauga, Canada Data Privacy Full time

    Chartwell Retirement Residences is looking for a Data Visualization Analyst to convert complex data into actionable insights aiding strategic planning, finance, and operations. Collaborating with the Data & Analytics team, the role aims to create impactful dashboards that drive decision-making across the organization.In this role you can expect to have the...

  • Data Analyst

    4 weeks ago

    Mississauga, Ontario, Canada Exioms Canada Full time

    At Exioms Canada, we are seeking a Data Analyst to join our team and contribute to the development and operation of our database systems.Key ResponsibilitiesAs a Data Analyst, you will be responsible for designing and developing databases, operating database management systems to analyze data, and researching and documenting data requirements, data...

  • Data Analyst

    3 months ago

    Mississauga, Canada Atlantis IT group Full time

    **ROLE**: DATA ANALYST **LOCATION**: MISSISSAUGE **JOB DESCRIPTION**: : Managing Data Analyst role, Compare data and match against the requirement. Analyzing various source of data and compare with target data. Responsible & accountable for doing requirement gathering and creation of high level and detailed technical design. **Competencies**: Digital :...

  • Data Analyst

    3 weeks ago

    Mississauga, Canada Atlantis IT group Full time

    **Role name: Data Analyst** **Location: Mississauga, ON | Hybrid** **Duration: 12 Months** Role Description: Managing Data Analyst role, Compare data and match against the requirement. Analyzing various source of data and compare with target data. Responsible & accountable for doing requirement gathering and creation of high level and detailed technical...

  • Data Analyst

    6 months ago

    Mississauga, Canada LTIMindtree Full time

    Senior Data analyst**.** **Position: Senior Data analyst** **Locations: Canada-Missisauga** **Duration: Full Time** Data Analyst/Capital Markets (DDA Checking and Cash& Due ) "Job Description: Domain: Fair understanding of Wholesale lending risk Program, In-depth knowledge on capital markets domain with clear understanding on trade flow,...

  • Data Analyst

    5 months ago

    Mississauga, Canada SnapPay Full time

    **Job Summary**: We are seeking a skilled Data Analyst to join our team. The Data Analyst will play a crucial role in interpreting data, analyzing results, and providing insights to support business decisions. **Responsibilities**: - Analyze complex datasets to uncover trends and patterns - Develop and implement databases, data collection systems, data...

  • Data Analyst

    3 weeks ago

    Mississauga, Ontario, Canada Snappay Inc. Full time

    Snappay Inc. is seeking a skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for extracting insights from complex data sets, developing and implementing data administration policy, and operating database management systems to analyze data. Key responsibilities include:Develop and implement data administration policy, standards...

  • Data Analyst

    6 months ago

    Mississauga, Canada Proshred Security Full time

    Job Description**:Data Analyst** **Our Company** Redishred Capital Corp. (TSXV:KUT) is one of the largest providers of document destruction, scanning and electronic waste recycling services in the US with presence in 40 US major markets. Redishred manages and operates the _**PRO**_SHRED®_ Security, _**PRO**_SCAN_® _Solutions_ and [JO1] **Secure e-Cycle**...

  • Data Analyst

    2 weeks ago

    Mississauga, Ontario, Canada Astra North Infoteck Inc. Full time

    Job Title: Data Analyst - InsightsJob Summary:At Astra North Infoteck Inc., we are seeking an experienced Data Analyst - Insights to join our team. The successful candidate will be responsible for managing data, analyzing various sources, and comparing data to target requirements. This role requires strong expertise in Google Cloud Services, particularly...

  • Data Analyst

    6 months ago

    Mississauga, Canada Plaxonic Full time

    **Role: Data Analyst** **Location: Mississauga, Canada(Onsite)** **Job Type: Full Time Role** Data Analyst/Capital Markets (DDA Checking and Cash & Due ) **"Job Description**: **Domain**: - Fair understanding of Wholesale lending risk Program, - In-depth knowledge on capital markets domain with clear understanding on trade flow, products - Exposure to...

  • Data Analyst

    1 month ago

    Mississauga, Ontario, Canada Randstad Canada Full time

    Job SummaryWe are seeking a skilled Data Analyst to join our team at Randstad Canada. As a Data Analyst, you will work closely with our Data Scientists, Product management, and Business teams to collect project requirements, identify data, build queries, develop ML models, and present findings.Key Responsibilities- Coordinate data conversations with...

  • Data Analyst

    2 months ago

    Mississauga, Canada Randstad Canada Full time

    Are you a Data Analyst looking for a new opportunity?Are you looking for a new contract opportunity?We are pleased to offer you a new contract opportunity for you to consider: Data Analyst-Start: ASAP-Estimated length: 9 months-Location: Mississauga-Onsite roleActively seeking for candidates with below requirements.AdvantagesYou will have an opportunity to...

  • Data Analyst

    6 months ago

    Mississauga, Canada Teamware Solutions (quantum leap consulting). Full time

    **Role: Data Analyst** **Location: Mississauga, ON- Onsite** **Annual Salary: $110k to $114k+ benefits** **Must Have: Hive, Impala** 1. 7+ years of experience in IT and data base/data warehouse domain 2. Experience in writing sqls in Hive, Impala 3. Strong SQL skills are essential; experience writing complex queries spanning multiple tables is...

  • Data Analyst Instructor

    5 months ago

    Mississauga, Canada Pragra Full time

    Data Analyst **Position Overview**: We are seeking a skilled and knowledgeable Data Analyst Instructor to join our team. As a Data Analyst Instructor, you will be responsible for designing and delivering comprehensive training programs focused on data analytics, visualization, machine learning, and data engineering. Your expertise in a wide range of tools,...

  • Restaurant Data Analyst

    6 months ago

    Mississauga, Canada Foodtastic Full time

    **About us**: Founded in 2016, Foodtastic is already one of the largest restaurant companies in Canada. We have increased system sales in the last five years from less than $50mm to over $1B. Our current portfolio of 23 brands includes Milestones Grill & Bar, Second Cup Café, Pita Pit, Quesada, La Belle et La Boeuf, and Rôtisseries Benny. **Restaurant...

  • Data Analyst

    3 months ago

    Mississauga, Canada goeasy Ltd Full time

    Embark on a journey with one of Canada's fastest growing companies – welcome to goeasy! We have been honored with recognitions such as Waterstone Canada’s Most Admired Corporate Cultures, the 2022 Report on Business Women Lead Here, Report on Business for Canada’s Top Growing Companies and TSX30 as one of the best performing companies on the TSX. We've...

  • Business/Data Analyst

    7 months ago

    Mississauga, Canada InterSources Full time

    Job Description : Business Analyst Summary : The Business Analyst will play a key role in analyzing, combining, and interpreting data from various sources to provide valuable insights and drive informed decision-making. This role will primarily focus on weaving an end-to-end table in Google Sheets using data from different systems. Additionally, the...

  • Data Analyst

    2 months ago

    Mississauga, Canada Bayshore HealthCare Full time

    Bayshore HealthCare is one of the Canada’s leading providers of home and community health care services and is a privately owned company. Bayshore HealthCare is proud to showcase its achievement as a Platinum member of Canada’s Best Managed Companies Program every year since 2006. Bayshore Healthcare is also recognized as Canada’s Best Employers in...

  • Data Analyst

    4 weeks ago

    Mississauga, Canada goeasy Full time

    Embark on a journey with one of Canada's fastest growing companies – welcome to goeasy! We have been honored with recognitions such as Waterstone Canada’s Most Admired Corporate Cultures, the 2022 Report on Business Women Lead Here, Report on Business for Canada’s Top Growing Companies and TSX30 as one of the best performing companies on the TSX. We've...