General information

Office (s)
Remote, US

Date Published
Friday, January 27, 2023

Country
United States

Job ID
22070

Function
Professional Services

Salary Range
50,000 - 140,000

Description & Requirements

About Us:
We’re here for the hard-working businesses that keep the world turning. They’re the companies who make, deliver, and sell the things we all need. They trust Epicor to help them do business better. Their industries are our industries, and we understand them better than anyone. By working hand-in-hand with our customers, we get to know their business almost as well as they do. Our innovative solution sets are carefully curated to fit their needs and built to respond flexibly to their fast-changing reality. We accelerate every customer’s ambitions, whether to grow and transform or simply become more productive and effective. That’s what makes us the essential partners for the world’s most essential businesses.

Job Summary:
Epicor is currently seeking a Data Conversion Specialist to join our BisTrack Professional Services team. Responsibilities will include migrating data from customers legacy enterprise system to BisTrack ERP, working with internal and external stakeholders on custom integration projects, as well as other ad hoc data transformation requests. This position is SQL intense, with advanced knowledge of the lumber industry and Bistrack or be able to get up to industry standards very quickly.

Duties & Responsibilities:

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

Knowledge, Skills & Abilities:

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

Qualification:

• 3+ years consulting experience preferred.
• Minimum of 6 years of related experience with data transformation.
• 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.
• 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

With almost five decades of industry experience, Epicor is the leader in Enterprise Resource Planning. Now is an exciting moment of transformation for our teams as we are well on our way to becoming the cloud vendor of choice. As we work to enable a world of better business through the power of collaboration, you will have all new opportunities for internal mobility, to develop and sharpen your skills, and to work interdepartmentally on a global level.
FOLLOW US ON LINKEDIN - http://www.linkedin.com/company/epicor-software-corp

At Epicor, we strive to create a welcoming, inclusive, and diverse workplace every day. Bring the whole and real you—that’s who we’re interested in. If you’re interested in this role but your experience and current skillset don’t match every qualification of the job description, that’s okay! We encourage you to apply anyway. Learning and sharing our knowledge keeps us all moving forward. You just might be the right fit and gain new skills new along the way.
Salary Range: $ 50,000 - 140,000

#LI-CP1 #LI-REMOTE

Job Type: Full-time

Pay: $50,000.00 - $140,000.00 per year

Please Note :
bankofmontserrat.ms is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, bankofmontserrat.ms provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.