[Remote] Deltek Vantagepoint Implementation Analyst

Note: The job is a remote job and is open to candidates in USA. Trilon is an infrastructure consulting firm focused on delivering practical and sustainable infrastructure solutions across North America. The company is seeking a remote Deltek Vantagepoint Implementation Analyst to lead ERP data migration and system integration efforts, including ETL pipelines, data validation, import utility management, and troubleshooting.

Responsibilities

• Develop and deliver end-to-end data extraction, transformation, and loading (ETL) pipelines from legacy environments into Deltek Vantagepoint
• Own the configuration, mapping, and execution of data loads using the native Vantagepoint Data Import Utility
• Audit, clean, and reconcile complex relational datasets. Develop validation scripts to verify post-migration financial balances and project histories
• Map legacy system workflows to optimal Vantagepoint architectures, maintaining data governance and security controls
• Diagnose and resolve reconciliation issues, data truncation errors, mapping failures, orphaned data, and schema mismatches during staging and production runs

Skills

• 2+ years of direct experience with Deltek Vantagepoint (or advanced Deltek Vision) backend architecture and data schemas is REQUIRED
• Advanced proficiency in Microsoft SQL Server Management (SSMS, Profiler, SSRS), Excel, ODBC, and reading & writing complex SQL scripts
• Proven experience executing and delivering at least one full-lifecycle ERP data migration using the Vantagepoint/Vision Data Import Utility
• Solid understanding of project-based accounting, work breakdown structures (WBS), billing, revenue, accounts receivable (AR) and accounts payable (AP)
• Demonstrated ability to execute and deliver large-scale data projects independently in a fully remote environment with strong communication skills
• 1+ years of experience with Axium, Sage or QuickBooks datasets and/or application/reporting
• 1+ years of direct experience report writing (design, development & publishing) with Business Intelligence Design Studio (BIDS)

Benefits

• Fully remote work arrangement
• A multitude of career paths spanning technical, project management, business management, business development, and operations
• Investment in developing and elevating talent across the family of companies

Company Overview