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 organizations 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
Notice Period: Immediate to 20 days
Location: Remote
Required Skills:
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 organizations 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 Notice Period: Immediate to 20 days Location: Remote
Required Education:
Graduate
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 unde...
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 organizations 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
Notice Period: Immediate to 20 days
Location: Remote
Required Skills:
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 organizations 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 Notice Period: Immediate to 20 days Location: Remote
Required Education:
Graduate
View more
View less
Job Location:
Monthly Salary:
Posted on:
6 hours ago
Vacancies:
1 Vacancy
