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