Adults Data Analyst

1 month 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
  • Adults Data Analyst

    2 months ago


    Mississauga, Canada goeasy Full time

    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. p> We are looking for a passionate Data Analyst and Data Modeler. The successful candidate will...

  • Analyste Data

    3 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 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

    1 month 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 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

    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

    7 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

    3 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...


  • 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,...

  • Data Analyst

    2 weeks ago


    Mississauga, Canada Metro Supply Chain Full time

    JOIN OUR TEAM Metro Supply Chain is a strategic supply chain solutions partner to some of the world’s fastest growing and most reputable organizations. For 50 years, it has excelled at tailoring integrated, data-driven solutions, fueled by advanced systems and technology, that fulfill complex and challenging distribution needs. Managing 19 million square...


  • 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...

  • 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

    6 months ago


    Mississauga, Canada AtkinsRéalis Full time

    **Data Analyst** **Come join us in reshaping the future with AtkinsRéalis. AtkinsRéalis is dedicated in engineering a better future for our planet and its people.** Success in the role requires the ability to plan and prioritise activities and coordinate with multiple stakeholders across alliance organizations. Location - **Mississauga, ON** **Your...

  • Data Analyst

    4 months ago


    Mississauga, Canada AstraNorth Full time

    **Essential Skills**: - Hands on and atleast 3 years work experience working with Google Cloud Services like BigQuery, Dataflow, DataProc, Cloud Functions, Cloud Data Fusion, Cloud Composer etc. - Responsible & accountable for doing requirement gathering and creation of high level and detailed technical design - Developing data ingestion framework for...

  • Data Analyst

    6 months ago


    Mississauga, Canada Primesoftinc Full time

    **Role**: Data Analyst (**Derivatives, Reference Data**) **Exp**: 10+ Years **Location**: Mississauga, ON Independents only **Skills Required**: - **Work closely with the trading, risk management, and compliance teams to provide data that supports derivatives trading and reporting.**: - **Minimum of 10+ years of experience is required.**: - **Proven...

  • Business/data Analyst

    4 weeks ago


    Mississauga, Canada Capgemini Full time

    Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of...

  • Business/data Analyst

    3 weeks ago


    Mississauga, Canada Capgemini Full time

    **Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of...


  • Mississauga, Canada Upper Canada Forest Products Full time

    **What We Offer**: Comprehensive benefit package that includes health, dental, life and disability insurance, retirement savings plan and paid vacation. We also offer competitive pay and a sales incentive program. You will be provided with a company paid car and up to date technology. We have our own UCS university and we offer extensive training to ensure...


  • Mississauga, Ontario, Canada Insurance Maine Full time

    Insurance Data Analyst OpportunityRBC's Insurance Data Management Office (IDMO) is seeking a skilled Data Analyst to assist in reviewing and updating data classification for Insurance applications and systems.This role plays a crucial part in ensuring alignment with Enterprise Data Security Standards, involving collaboration with IT and business...