Deltek Vantagepoint Implementation Analyst

Mannik Smith Group; Northern (KY); On-site; USD 90,000 - 110,000; Full time

Job summary

Trilon is seeking a full-time, remote Deltek Vantagepoint Implementation Analyst to migrate historical financial, project, and CRM data from legacy systems into our Deltek Vantagepoint ERP environment.

You will serve as the SME using the Vantagepoint Data Import Utility, ensuring data integrity and minimal downtime while configuring system settings for optimal performance.

Qualifications

• Deltek Vantagepoint experience (2+ years) required.
• Advanced SQL skills with SSMS/SSRS and Excel.
• Proven track record delivering full ERP data migrations.

Responsibilities

• Data Migration Execution: ETL pipelines from legacy to Deltek Vantagepoint.
• Data Import Utility Management: configure, map, and execute data loads.
• Data Cleansing & Validation: audit, clean, and reconcile datasets; validate post-migration balances.
• System Optimization: map legacy workflows to Deltek Vantagepoint architectures.
• Troubleshooting: resolve data issues during staging and production runs.

Skills

Deltek Expertise

SQL + SSMS

SQL Scripts

Data Migration

Remote Communication

Tools

SSMS

SSRS

Excel

ODBC

SQL Scripts

Job description

Deltek Vantagepoint Implementation Analyst

Department: Corporate/Administrative

Employment Type: Full Time

Location: Remote- USA

Compensation: $90,000 - $110,000 / year

Description

We are seeking a full-time, remote Deltek Vantagepoint Implementation Analyst with specialized expertise in data migration and system integration. In this role, you will migrate historical financial, project, and CRM data from legacy systems into our Deltek Vantagepoint ERP environment. You will serve as the primary subject matter expert utilizing the Vantagepoint Data Import Utility, ensuring data integrity, minimal operational downtime, and optimal system configuration.

Key Responsibilities:

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

Skills, Knowledge and Expertise:

• Deltek Expertise: 2+ years of direct experience with Deltek Vantagepoint (or advanced Deltek Vision) backend architecture and data schemas is REQUIRED.
• Technical Toolkit: Advanced proficiency in Microsoft SQL Server Management (SSMS, Profiler, SSRS), Excel, ODBC, and reading & writing complex SQL scripts.
• Migration Track Record: Proven experience executing and delivering at least one full-lifecycle ERP data migration using the Vantagepoint/Vision Data Import Utility.
• Domain Knowledge: Solid understanding of project-based accounting, work breakdown structures (WBS), billing, revenue, accounts receivable (AR) and accounts payable (AP).
• Remote Proficiency: Demonstrated ability to execute and deliver large-scale data projects independently in a fully remote environment with strong communication skills.

Preferred 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)

About Trilon:

Trilon was formed with the vision of building the next Top 20 infrastructure consulting firm in North America by bringing together some of the nation’s best infrastructure consulting firms, focused on delivering practical and sustainable infrastructure solutions. Trilon is backed by Alpine Investors, a PeopleFirst Private Equity Firm. Trilon currently comprises 5,500+ staff across the US. For more information, visit www.trilon.com.

Pay Transparency

The base salary range for this role is indicated in the posting. This range reflects the company’s good faith estimate of the compensation for this position at the time of posting. Final compensation will be determined based on factors such as experience, skills, qualifications, internal equity, and geographic location.