Proficiency in writing complex SQL queries for data extraction, transformation, and loading into Deltek Vision/Vantagepoint.
Extensive experience with relational databases (Tables, Views, T-SQL, and stored procedures) and developing advanced queries and stored procedures for workflows and custom reporting.
In-depth knowledge and hands-on experience with Deltek Vision/Vantagepoint and a minimum of 5 years of Microsoft SQL Server development experience.
Experience in data mapping and transformation between legacy systems and Deltek Vantagepoint, including data extraction, cleansing, and validation.
Requirements:
Collaborate with project teams to define and document data migration requirements.
Analyze and map data structures between legacy systems and Deltek Vantagepoint; develop, test, and implement SQL-based ETL scripts and procedures.
Validate migration outcomes through rigorous testing and reconciliation; identify, troubleshoot, and resolve data inconsistencies and anomalies.
Execute data migration activities in production environments with minimal disruption and design, build, and customize reports and workflows within Deltek Vantagepoint.
Job description
This is a remote position.
Summary:
The SQL Data Migration Specialist plays a critical role in ensuring the seamless and secure transition of data from legacy ERP systems into Deltek Vantagepoint. This position demands a high level of technical expertise in Microsoft SQL Server and a deep understanding of data architecture, migration strategies, and ERP system functionality. The specialist will lead data analysis, mapping, and transformation efforts, working closely with cross-functional teams to design, execute, and validate migration processes. By maintaining data integrity and accuracy throughout the lifecycle, the specialist ensures that the organization’s financial and operational data is reliable, compliant, and ready for use in the new environment. This role also involves ongoing support, process improvement, and innovation in data management practices.
Experience: 8-12 years
Responsibilities:
Collaborate with project teams to define and document data migration requirements.
Analyze and map data structures between legacy systems and Deltek VantagePoint.
Perform comprehensive data analysis and cleansing on source systems.
Develop, test, and implement SQL-based ETL scripts and procedures.
Validate migration outcomes through rigorous testing and reconciliation.
Identify, troubleshoot, and resolve data inconsistencies and anomalies.
Execute data migration activities in production environments with minimal disruption.
Partner with Operations to design, build, and customize reports using Microsoft Visual Studio.
Create and configure workflows within Deltek Vantagepoint to support business processes.
Research, evaluate, and implement emerging tools and technologies related to Deltek Vantagepoint.
Provide technical support, guidance, and troubleshooting for data-related issues.
Serve as a subject matter expert on Deltek Vantagepoint data structures and migration best practices.
Requirements
Proficiency in writing complex SQL queries for data extraction, transformation, and loading into Deltek Vision/Vantagepoint.
Demonstrated experience with relational databases, including tables, views, T-SQL, and stored procedures.
Proven ability to develop advanced queries and stored procedures for workflows and custom reporting.
Strong understanding of database systems, data modeling, and migration methodologies.
Excellent analytical, problem-solving, and troubleshooting skills.
close attention to detail and a commitment to data accuracy and integrity.
Ability to work independently and collaboratively within cross-functional teams.
Experience in data mapping and transformation between legacy systems and Deltek VantagePoint.
Hands-on experience with data extraction, cleansing, and validation processes.
Minimum 5 years of professional development experience with Microsoft SQL Server.
Required: In-depth knowledge and hands-on experience with Deltek Vision/Vantagepoint.
Preferred: Experience in professional services or consulting environments.
Understanding of accounting principles and financial data structures.
Additional Details
Total Experience: 8-12 years
Relevant Experience: 5 years in SQL and Data Migration
Skills: Proficiency in writing complex SQL queries for data extraction, transformation, and loading into Deltek Vision/Vantagepoint
