General information

Office (s)
Remote, Canada
Date Published
Wednesday, March 20, 2024
Job ID
Professional Services
Olagbaju, Tola

Description & Requirements

Data Conversion Specialist | BisTrack

The Data Conversion Specialist plays a crucial role in client-facing projects, focusing on data extraction, transformation, and loading. The primary responsibilities encompass BisTrack environment builds, migrations, upgrades, and various technical team assignments.

What you will be doing:

  • Coordinate data extracts as well as transform customer legacy data into Bistrack accept formats. 
  • Import data, manipulate, transform data though updates and inserts in SQL tables. You must have an exceptional level of knowledge on relationships between tables and be able to perform complex SQL queries. 
  • Work with internal and external customers to understand changes from legacy data into desired BisTrack data.
  • Work a flexible schedule, including overtime, nights and weekends to meet deadlines.

What you will likely bring:

  • Strong familiarity with BisTrack, specifically with BisTrack’s Schema, Data Imports, Data Configuration including UOM’s and UOM Rules, System Options, Business Intelligence (Smart Views, Smart Objects, Dashboards), eBusiness agent, and settings is preferred.
  • Extensive knowledge of the LBM industry, including knowledge of how customers operate their day-to-day business, as well as knowledge of LBM products, including board foot calculations.
  • Advanced-level T-SQL coding and programming experience (used for almost all integrations), including SQL Agent, SQL Mail, SQL jobs, SQL Server administration knowledge as well as performance tuning of SQL stored procedures and functions.
  • Solid understanding of cursors, CTE’s, inserts and update into SQL tables
  • Able to work with multiple file types and bring into a SQL environment for querying. Including multi-header .txt files, XML’s, .csv, .xls and .xlsx. ability to transform these into workable SQL tables
  • Ability to start coding from scratch including stored procedures and functions.
  • Ability to look at large relational databases (>1000 tables) and find and understand relations from one table to other(s).
  • Ability to work with ftp/sftp and code from SQL to put/get files.


  • Extensive knowledge of the LBM industry, including knowledge of how customers operate their day-to-day business, as well as knowledge of LBM products, including board foot calculations is required
  • 3+ years of related experience with data transformation. 
  • 3+ years consulting experience preferred                                                                                                                 
  • Familiarity with BisTrack, specifically with BisTrack’s Schema, Business Intelligence (Smart Views, Smart Objects, Dashboards), and eBusiness agent and settings is preferred.
  • Bachelors degree preferred; equivalent years of experience in lieu of a degree will be considered.

The Professional Services Team 

Professional Services play an instrumental role in the growth of Epicor. You will be working with our customers to implement our products and ensure that we continuously provide an exceptional customer experience. Almost every position is customer-facing—therefore, it’s important to have energy, drive, and determination to ensure Epicor gives the best possible experience to all clients. This passion will contribute to the success of your career and the company. If you are looking for a global, innovative company with strong roots and exciting growth, Epicor is ready to hear from you!

About Epicor 

At Epicor we know that success comes from working together. Everyone has a role to play, and it’s the essential partnerships across our company that are crucial to our customers’ success and our growth as a business. 

We’re truly a team. Working in close partnership, we bring wide-ranging talents together in powerful collaborations. We think innovatively, share our knowledge generously, and constantly learn from our colleagues. We’re proud of the success we achieve every day, but we never stop challenging ourselves and encouraging each other. Together, we go further and imagine an even brighter future. 

Whatever your career journey, we’ll help you find the right path. Through our training courses, mentorship, and continuous support, you’ll get everything you need to thrive. At Epicor, your success is our success. And that success really matters, because we’re the essential partners for the world’s most essential businesses—the hardworking companies who make, move, and sell the things the world needs.

Equal Opportunities and Accommodations Statement 

Epicor is committed to creating a workplace and global community where inclusion is valued; where you bring the whole and real you—that’s who we’re interested in. If you have interest in this or any role- but your experience doesn’t match every qualification of the job description, that’s okay- consider applying regardless. 

We are an equal-opportunity employer.