Data Specialist

People To Go
Job LocationHamilton, Ontario
Job TagCanada


Title: Microsoft Excel Specialist
Location: Woodstock/Hamilton/Hybrid/Remote
Type: 6 months (possibility of extension/perm)
Starts: ASAP
Ends: 6 months from start date


As a Microsoft Excel Specialist in an ERP context, you will be responsible for leveraging your expertise in Microsoft Excel to support and optimize ERP-related processes and data management. You will collaborate with various teams to ensure accurate data entry, efficient reporting, and effective analysis within the ERP system. Your role will play a critical part in enhancing data integrity and streamlining workflows within the organization.


  1. Data Entry and Validation: Accurately enter data into the ERP system using Microsoft Excel, ensuring completeness and adherence to predefined standards. Validate data integrity and resolve any discrepancies or errors.
  2. Reporting and Analysis: Develop and maintain Excel-based reports and dashboards that provide valuable insights into ERP data. Analyze trends, identify anomalies, and present findings to stakeholders in a clear and concise manner.
  3. Data Cleansing and Standardization: Identify and correct data inconsistencies, duplicates, and formatting issues within the ERP system. Implement data cleansing and standardization techniques in Excel to improve data quality.
  4. Data Manipulation and Transformation: Utilize advanced Excel functions, and formulas to manipulate and transform ERP data as per business requirements. Automate repetitive tasks to improve efficiency.
  5. Data Import and Export: Collaborate with IT teams to import and export data between Excel and the ERP system. Ensure data accuracy and compatibility during the transfer process.
  6. Process Improvement: Continuously evaluate existing data management processes and identify opportunities for improvement. Propose and implement enhancements to streamline workflows and optimize data entry and reporting processes.
  7. User Training and Support: Provide training and support to end-users on Excel functionalities and best practices within the ERP context. Assist users in troubleshooting Excel-related issues and provide guidance on data manipulation techniques.


  1. Proficiency in Microsoft Excel: In-depth knowledge and expertise in Microsoft Excel, including advanced functions, formulas, pivot tables, and data manipulation techniques.
  2. ERP System Familiarity: Familiarity with ERP systems and their data structures. Experience working with ERP data within an Excel environment is highly desirable.
  3. Must have experience specifically with in fore implementation
  4. Data Analysis Skills: Ability to analyze complex data sets, identify trends, and present insights effectively using Excel charts, graphs, and pivot tables.
  5. Attention to Detail: Strong attention to detail and accuracy when working with data, ensuring data integrity and reliability.
  6. Problem-solving Skills: Ability to identify data-related issues, troubleshoot problems, and propose effective solutions.
  7. Communication and Collaboration: Excellent communication skills to collaborate effectively with cross-functional teams and end-users. Ability to explain complex concepts in a clear and concise manner.
  8. Adaptability: Willingness to adapt to changing ERP requirements and learn new tools and techniques as needed.

Courage, Compassion, Conviction: Five Women Fight the Good Fight

Darlene Holland, Toshe Ayo-Ariyo, Sonal Patel, Danielle Ho, and Taylor Campbell are five remarkable graduates of 2U, Inc. programs applying their skills and talents to drive—and become—the change they want to see in the world.

Related Industries: All Industries, Data Analytics, Healthcare, Web Development

Top 10 Coding Projects for Beginners

The best way to begin to learn to code is to simply start coding! When you gain experience developing challenging projects from inception to completion, you establish a strong work ethic that will benefit you throughout your career. 

Related Industries: Computer Science, Data Analytics, Data Science, Web Development
A woman works at a laptop.

Understanding Data Science Roles: Who Does What?

Looking to leverage your data boot camp knowledge or jumpstart a career in data science? With data becoming increasingly important to companies’ bottom lines, data scientists are some of the most valuable individuals in the professional world today.

Related Industries: Data Analytics, Data Science
An image shows a student working on a graph.