Description

You will manage data extraction, transformation, and loading processes for client-facing projects involving BisTrack environments, migrations, and upgrades.

Responsibilities

• Coordinate data extracts and transform legacy customer data into BisTrack accepted formats.
• Import, manipulate, and transform data using updates and inserts within SQL tables.
• Collaborate with internal and external customers to map legacy data to desired BisTrack structures.
• Build and execute complex SQL queries to manage data integrity during migrations.
• Work a flexible schedule, including nights and weekends, to meet project deadlines.

Required Skills

• 5+ years of experience in data transformation.
• Advanced T-SQL coding and programming, including writing stored procedures and functions from scratch.
• Deep understanding of relational databases, including the ability to map relationships across 1000+ tables.
• Expertise in SQL Server administration, performance tuning of stored procedures, and managing SQL Agent, SQL Mail, and SQL jobs.
• Proficiency with cursors, CTEs, and complex inserts/updates.
• Experience handling diverse file types including XML, .csv, .txt, .xls, and .xlsx for SQL ingestion.
• Ability to use FTP/SFTP and write SQL code to manage file transfers.
• Extensive knowledge of the LBM industry, including day-to-day business operations and board foot calculations.

Preferred Skills

• Familiarity with BisTrack Schema, Data Imports, Data Configuration (UOM/UOM Rules), System Options, and eBusiness agent.
• Experience with BisTrack Business Intelligence (Smart Views, Smart Objects, Dashboards).
• 3+ years of consulting experience.

Key Skills

Education

Any Graduate